Overview

 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. 

Reviews Add a review
No reviews yet

More From smarthelping

Browse our top rated business templates. See All
SaaS Rolling Revenue Forecasting Template
117
0
 Performing regular revenue and customer count forecasts for a SaaS company can be difficult and chaotic. This is for a…
Gordon Growth Valuation Model
343
0
This template is designed for valuation. It uses DCF Analysis but without a terminal value. Oftentimes you will see a…
Account Executive Performance Driven Financial Model
352
0
 This is a full 5-year monthly, quarterly and annual financial model that uses unique quota attainment revenue logic to drive…
Driving Range: Startup Financial Model
401
0
 This is a bottom-up financial model that goes up to a period of 10 years. It is for anyone that…
DCF Analysis with Sensitivity Analysis
392
0
 DCF Analysis templates are very useful for those trying to figure out the present value of future cash flows, the…
Franchise Ramping Financial Model: Up to 12 Locations
306
0
 This template lets the user do some financial planning for opening up to 12 franchise locations. The model goes out…
See All