Ecommerce Financial Model (Premium Version)
Originally published: 01/10/2020 07:51
Last version published: 03/06/2021 07:15
Publication number: ELQ-29137-6
View all versions & Certificate
certified

Ecommerce Financial Model (Premium Version)

Ecommerce Financial Model (Premium Version) + 1 Hour Video

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.

This Best Practice includes
1 Spreadsheet (xlsx. format), can be used with Excel or Google Sheets. Including a link to a 1 hour walkthrough video.

Acquire business license for $99.00

Add to cart

Add to bookmarks

Discuss

Further information

This model template is for entrepreneurs, startup founders or established businesses looking for a comprehensive and dynamic financial model with all variables, assumptions and metrics specific to Ecommerce.

It is a perfect tool for businesses looking for a rock-solid financial forecasts to use in their fundraising or budgeting efforts. IFRS compliant, it also includes all investor-friendly and industry-standard features such as 3 consolidated financial statements (P&L, balance sheet and cash flow statement), up to 5-year forecasts and charts and reports which can be re-used in investor or company presentations.

Are you looking for a simplified model template (e.g. without the 3 financial statements) to assess cash burn for instance? Our Basic version of the ecommerce financial model template available on Eloquens is made for you.

Reviews

  • Be the first to review this Downloadable Best Practice

    Write a review


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from Remi Goncalves

keyboard_arrow_leftkeyboard_arrow_right

Any questions on Ecommerce Financial Model (Premium Version)?

The user community and author are here to help. Go ahead!


0.0 / 5 (0 votes)

please wait...