Acquire Customers
Calculate new customers by channel marketing spend ÷ CAC, then add online and offline customers.
The editable workbook forecasts five years of e-commerce operations from acquisition, repeat buying, orders, units, pricing, and product mix into linked financial reports.
Use the model to turn channel marketing budgets, CAC, repeat-customer behavior, order frequency, units per order, sales mix, pricing, costs, staffing, and investment assumptions into a structured forecast.
Editable operating inputs feed the model’s calculations, while linked statements and management views show how those assumptions affect revenue, profitability, cash flow, and financial position.
The model converts channel marketing spend into new customers, builds repeat-buyer cohorts, forecasts orders and units, then prices the allocated product-category sales.
Calculate new customers by channel marketing spend ÷ CAC, then add online and offline customers.
Convert a percentage of new customers into repeat buyers active for their stated lifetime.
Add first-purchase orders to active repeat customers × average repeat orders per month.
Multiply total orders by units per order, then allocate units using product-category sales mix.
Multiply allocated category units by category prices and sum revenue across categories and months.
The Revenue worksheet organizes marketing budgets, CAC, repeat-customer behavior, order frequency, units per order, product mix, and category pricing that drive sales.
REVENUE
The COGS & OPEX worksheet separates direct product costs, revenue-linked operating expenses, and fixed expenses with timing assumptions that feed monthly projections.
COGS & OPEX
The Scenarios report compares Low, Base, and High outcomes across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
SCENARIOS
The Dashboard combines model setup, scenario controls, core financials, revenue mix, profitability, cash flow, and investment payback views in one management screen.
DASHBOARD
The ready-made model fits an own-product e-commerce business driven by acquisition and repeat purchases; different revenue logic or operating structures may call for custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your requirements need different revenue logic, operating schedules, or financial reporting.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an instantly downloadable, editable financial model for Excel or Google Sheets with five-year projections, scenarios, and linked reporting.
Change customer, marketing, repeat-purchase, product mix, pricing, cost, staffing, and other model assumptions.
Project monthly and annual e-commerce performance across the model’s 60-month planning horizon.
Compare Low, Base, and High cases through the dedicated scenario view.
Review linked income statement, cash flow, balance sheet, Dashboard, Summary, and analysis reports.
The essential answers are visible in full, with no accordion clicks required.
It converts channel marketing spend and CAC into new customers, builds repeat-buyer cohorts, forecasts orders and units, allocates units by product mix, and applies category prices.
You can edit launch date, marketing budgets and seasonality, CAC, repeat-customer rate and lifetime, repeat order frequency, units per order, product mix, and category prices.
The Scenarios report compares the three cases across revenue, gross margin, contribution margin, and EBITDA over the forecast horizon.
The workbook includes the income statement, cash flow statement, balance sheet, Dashboard, Scenarios, Summary, and additional analysis reports shown in the product gallery.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structures.
It is a planning forecast based on the assumptions entered into the workbook, not a guarantee of business performance.
This comprehensive e-commerce financial model includes everything you need to build a complete financial plan, from detailed assumptions and schedules to summary reports and visual dashboards.
Core inputs and core outputs
Three scenario analysis
Presentation ready
DuPont analysis
Researched revenue assumptions
Lender-friendly financial outputs
Revenue stream detailed view
Performance metrics benchmark
I’m not strong in Excel, so this template was a relief. The formulas and tabs were already laid out, and I could build a clean forecast without getting stuck in technical modeling work.
What would’ve taken me all weekend was done in a few hours. I had a full e-commerce forecast ready for planning calls instead of piecing it together by hand.
The pricing, cost, and growth inputs finally live in one place, so nothing feels scattered anymore. I cut my review time in half and could explain the numbers to my team without chasing down old notes.