Ecommerce Forecasting Tool
Financial model template for ecommerce businesses, using a cohort-based approach to model new and repeat customers and calculate revenues.
5.0(32)2,788 downloads
$20 suggested, but "0" is ok. All donations appreciated.
Instant Access
Highlights
The free Ecommerce Model is the simplest structure of the models for forecasting Ecommerce businesses. Creates a forecast of acquisitions, retentions, revenues, acquisition costs, cost of goods sold, CAC and LTV, and is easy to use for ecommerce or transaction-style businesses. I built this tool to help entrepreneurs understand the mechanics behind forecasting the growth and revenues of an ecommerce business, in a package that is easy to use, easy to edit, and easy to understand.
It intentionally simplifies the business down to key inputs, and by default does not include expenses and a calculation of net income.
Optional Historicals sheet allows you to drop in historical cohort retention data to automatically analyze past performance and use past retention to forecast future cohort performance.
For financial statements and full financial reporting, including full support for SaaS and subscription businesses, check out the Standard Financial Model.
What you'll do with it
Forecast an ecommerce or transaction-style business. Inputs for acquisitions, repeat behavior, prices, cost of goods sold, acquisition cost. Outputs revenues, retention curves, CAC, LTV, contribution per cohort.
Intentionally simple. No expenses, no income statement. Optional Historicals sheet, drop in historical cohort retention data to analyze past performance and project forward.
When to use this vs. the Standard Financial Model
This is a focused tool for forecasting ecommerce revenue mechanics. If you need full financial statements, expenses, inventory accounting, hiring plans, and cap table, use the Standard Financial Model, same ecommerce revenue logic plus everything else.
Edit with AI
Cells open. Inputs in blue, formulas in black. Built to be edited.
- Context primer, paste into Claude or ChatGPT before any change
- MCP server, connect Claude Desktop or Claude.ai