Ecommerce Financial Model (Premium Version)

Description
Ecommerce financial model template for any ecommerce businesses (digital, physical inventory & dropshipping, consignment & outright). Fully editable. Updated September 2020.

Looking for the Basic version ($39) instead? See link here:
https://www.eloquens.com/tool/YdQ2SmNL/startups/e-commerce/ecommerce-financial-model-basic-version

This is the premium version of our ecommerce model, it includes the 3 consolidated financial statements, valuation (DCF) and fundraising / cash burn assessment tools.

The Premium Ecommerce Financial Model is a comprehensive financial model with a clear and user-friendly structure which makes it easy for you to adapt to your own business, and amend as you wish to make your own financial projections. Here is the detailed list of tabs I included within this model and the link between them:

1/ Settings
List key assumptions that flow through the model. This is your a tab where you can modify key inputs such as corporate tax rate, first forecasted month, financing assumptions (debt, equity), etc. without modifying any other tab. P&L, cash flow statement, balance sheet, metrics and charts will automatically update accordingly in their respective tabs.

2/ Dashboard
Charts of the main metrics and their monthly evolution (GMV, cash burn, CAC, etc.) for ease of use. Charts can conveniently be copy pasted in a pitch deck.

3/ Metrics
Exhaustive list of metrics their monthly and yearly evolution. Essentially similar to the dashboard, but without the charts and much more exhaustive.

4/ Operating Model
Main tab which consolidates the 3 financial statements: profit-and-loss, cash flow and balance sheet. All the following tabs flow through this sheet. Also includes some additional calculations such as corporate taxes / taxes carryforward, net interest and working capital.

5/ Fundraising
This tab calculates for a given fundraising round the breakdown of your net cash burn so you can assess how much you should raise, and how the money will be spent across the key expenses segments.

6/ Valuation
This tab calculates the Enterprise Value of your business based on the Discounted Cash Flow valuation method, so you can back up a tangible valuation for your next fundraising round.

7/ Marketing Funnel
This tab is the very start of the revenue build model. It calculates number of orders from numbers of sessions and users and includes a comprehensive list of channels such as paid ads, organic, email and social media. The output (orders and users) flow through the Revenue Build & COGS and Customers Cohort tabs.

8/ Revenue Build & COGS
Follow up with Marketing Funnel, this tab calculates key metrics such as number of items sold, Gross Merchandise Value, returns, cancellations and associated COGS. Flows through the Operating Model.

9/ Customers Cohort
Follow up with Marketing Funnel, this tab returns the number of New and Returning Paid Customers, as per an industry standard cohort model based on churn assumptions. Flows through the Operating Model.

10/ SG&A
Exhaustive list of Selling, General and Administrative expenses of a typical Ecommerce business from Payment costs, Handling, Warehouse rent to Photography, Hosting, Fraud among others. Flows through the Operating Model.

11/ Hiring Plan
Detailed list of all FTEs per team (Management, Engineering, Marketing, etc.) and salary costs. Includes salary indexation and salary increases assumptions. Flows through the Operating Model.

12/ Capex & D&A
Capex (equipment, material, etc.) and the associated straight-line depreciation schedule which flows through the 3 financial statements.

Thank you!

Remi G.