General eCommerce Financial Model: 3 Sales Channels (Excel XLSX)

VIDEO DEMO

DESCRIPTION

This product (General eCommerce Financial Model: 3 Sales Channels) is an Excel template (XLSX), which you can download immediately upon purchase.

Selling things online can be tricky. Often times there will be many distributions channels and depending on if it is a digital product or physical product, there are all sorts of financial nuances to account for. This template will help with your e-commerce financial planning.

Recently updated with a full set of monthly and annual financial statements that are connected to all assumptions. Also added a capitalization table and inventory purchasing logic if applicable.

The world of eCommerce can mean so many different things. This financial model was geared for the one-time selling of things over the internet to customers. Commonly this is called business to customer or B2C.

The most common types of businesses that fit into this template would be:

•  Boutique online stores (selling specific unique items)
•  Selling digital downloads or books or tools that are all one-time fees
•  Selling any product-line that can be simplified in up to 10 categories (defined by price/volume/sales channels)

The sales volumes are driven by up to three things on a per category basis:

•  Ad spend and cost per sale average
•  Selling partners (i.e. affiliates or sponsorships to influencers or what have you who take a percentage of every referred sale)
•  Organic sales (via word of mouth, organic search engine traffic, original content that cross sells to your online store)

One of the biggest uses of a financial model is to assert various assumptions about how much potential revenue can be made based on bottom-up drivers. This gives some sense of the amount of money being spent and what kind of revenues are needed to at least break even and then what can things look like if sales are higher / lower or key inputs end up being worse or better.

Final output reports include a monthly and annual pro forma and cash flow summary as well as a DCF Analysis and IRR / return calculations. 12 visualizations are included to make the financial forecast more digestible.

Source: Best Practices in Integrated Financial Model, Company Financial Model, Business Plan Financial Model, E-commerce Excel: General eCommerce Financial Model: 3 Sales Channels Excel (XLSX) Spreadsheet, Jason Varner | SmartHelping