Ecommerce Financial Model

Best for ecommerce and retail businesses looking to model customers, orders, products sold, inventory, revenues, and cost of goods sold, combined with consolidated financial statements, cash flow analysis, funding needs, cap table, and valuation. Instant download, use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.

New · 2017 Are you starting an ecommerce or retail business or have an ongoing business and need to forecast your operations and financials? Do you need to understand your costs, revenues and key metrics better for your own business planning or to present to investors? Build a cost budget, detailed customer and revenue projections, cashflow forecast, and full financial statements for your business in an hour using the Ecommerce Financial Model.
The model is built to forecast the potential operational and financial future of your ecommerce and/or physical retail business. The model helps to project traffic, customer acquisition, orders and customers, product SKUs sold, and inventory management. It uses the prices of products sold to forecast average order value, revenues, and cost of goods sold, aggregating automatically to consolidated financial statements and a cash flow analysis, forecast of funding needs, cap table, and valuation. Supports up to 10 unique products (SKUs), but can be extended for up to hundreds of SKUs. The forecast is done monthly, quarterly and annually over a 5 year period. You can use your past historical operations and financials, or start from scratch with a forecast for a new idea. And, it can all be modified to add in your own unique revenue calculations, as all formulas and cells are completely open and unlocked. Purchase one-time, customize however and whenever you want, and updates to the model are automatically distributed for free.

Who Should Use This

▾

Ecommerce or phyical retail companies.
Works for companies starting from scratch as well as companies with multiple years of historical operational and financial data that they want to use in reporting and forecasting.
Focuses on creating a monthly and quarterly forecast of revenues, costs and cashflows over a 5 year period.

Why I Built This

▾

I created the financial models behind Foresight so early-stage entrepreneurs can spend less time on finance and more time on their products. I built the Ecommerce Model because I’ve worked with many ecommerce companies on forecasting their revenues, costs and inventory needs, and wanted to provide a solid base to take their understanding of how people purchase their products to create solid financial projections. I’ve been building and helping entrepreneurs build financial models for startups since 1998. More about my story here.

Key Features

▾

Simple yet robust methodology for creating a 12-60 month forecast of operating expenses, while also automatically handling the accounting treatment of the expenses.
Assumptions are entered on the Settings sheet and the primary Costs and Revenues sheets and can be modified for any time period.
Start from scratch, or use historical operational and financial data for reporting or to ad in forecasting.
Provides a robust structure for forecasting users, customers, and revenues for commerce revenue models.
Cashflow analysis, including external funding forecasts, is integrated into the model with a capitalization table, forecasting out investment rounds, dilution and ownership (optional).
Robust functionality to use Actual financial data in the model, to analyze the forecast compared to the actual results, and to create rolling forecasts that seamlessly combine the projections with the actual results.
All formulas and sheets are open for editing, anything is open for editing. I don’t believe that models should be locked, everything should be open for you to edit so that you can model your business exactly as you want.

What’s Inside

▾

1. README. Description of model, layout, and how to use it.
2. Outline and How To. Two sheets that detail the model and how calculations flow, explaining how each sheet works. Assumptions are noted and explained throughout the model.
3. Key Reports. Charts and tables of costs, active users (optional), cash on hand, revenue and revenue growth rate, net income and cumulative net income, margins, sources and uses, and more.
4. Summary. Key operational and financial metrics organized in a clean summary, reported over 3 years, built to be easily customizable for your key metrics and timeframes.
5. Settings. Model-wide assumptions and settings for acquisition flow.
6. Costs. Cost budget, hiring plan.
7. Revenues. User acquisition and revenue calculations. Detailed forecast of users, customers, orders, products sold, revenues, costs, shipping (optional), discounts (optional), affiliates (optional), inventory purchasing (optional) and all changes in inventory levels.
8. Forecast. Consolidated financial statements, including income statement, balance sheet, and statement of cash flows. Includes a detailed cash flow forecast that automatically forecasts funding requirements based on a simple assumption of how many months epenses to raise money for. Use this sheet for forecasting only, or bring in your historical financials to show either a mix of the past and the future, or to compare budgets to forecasts.
9. Cap Table. The cap table in the Ecommerce Model is the Cap Table Model integrated into the cash flows of the business, mapping forecasted expenses and net burn to needed fundraising to estimated funding rounds by size and date.
10. Actuals. Optional sheet if you have past financial data you want to report in the model and use in forecasting.
11. Actuals + Forecast. Optional sheet that combines the Actual data with the Forecas to create rolling forecasts. Simply “roll over” the model by editing one cell each month after you input new Actual data into the Actuals sheet, and the combined forecast updates automatically.
12. Key Reports - Actuals + Forecast. The same key reports from the earlier sheet, but drawing on the Actuals + Forecast data.
13. Valuation. Automatic valuation of the company through either exit value or cashflows, using discounted cash flow (DCF), VC Method, and EBITDA multiples methodologies.
14. Changelog. Details of all edits to the model since release, by version number.

Model Inputs

▾

The model includes over 100 assumptions around user acquisition, revenues, costs, and funding.
Acquisition: Organic and Paid acquisition.
Retention: Monthly churn, if applicable.
Revenues: conversion rates, orders per user, products sold per order, revenue and cost of goods sold (COGS) per order, discounts, and chargebacks and refunds.
For ecommerce businesses that also have subscription revenues, use the SaaS Financial Model.
Hiring: staff hiring, salaries, roles, and when to hire, including an overall salary expense assumption to calculate team sizes automatically based on company growth.
Costs: flexible inputs to input all costs easily on a month by month basis. Expenses can be allocated to key expense areas and labled for accounting treatment as SG&A, COGS, or CAPEX.
Funding: equity fundraising forecasting, number of months to raise capital, % of the company sold in investment round (premoney valuation).

Payment, Terms and Conditions

▾

Instant Download - one .xlsx Excel file. Immediately after purchase you will receive a download link and an invoice for your records.
Updates to the model are free, and the model can be re-downloaded at any time.
Credit/Debt Cards and PayPal accepted; all transactions are SSL secured and no payment details are stored by Foresight (see here to understand the details behind our transaction provider, their security and how they never store payment details).
All inputs and formulas are clearly labled; all formulas are open for editing and can be changed by user (i.e. no locked cells).
Works for any currency; Foresight models have been used by entrepreneurs from over 98 countries.
Use in Microsoft Excel™, Google Docs™, and other spreadsheet programs.
If applicable, VAT is extra.
Bulk license purchases available, details here.
Purchase signifies acceptance of terms and privacy policy.

Ecommerce Financial Model

Packages

Need a custom model?

How it Works

Download Instantly

Input your most important assumptions

Refine your Projections

Understand your Forecasts

Need Help?

Screenshots

→