Acquire Customers
New customers equal channel marketing spend divided by each channel's CAC, then online and offline customers are added.
It is an editable five-year Excel model that converts channel marketing, CAC, repeat buying, units, product mix, and pricing into financial statements and scenarios.
Use it to plan customer acquisition, repeat orders, product-category sales, operating costs, cash needs, and financial outcomes from one linked forecast.
Editable assumptions flow through monthly calculations into annual projections, scenario comparisons, statements, dashboards, and decision reports shown in the workbook.
The model acquires customers by channel, carries repeat cohorts forward, converts orders into units, allocates those units by category mix, and prices each category.
New customers equal channel marketing spend divided by each channel's CAC, then online and offline customers are added.
A share of new customers becomes repeat buyers, with each cohort active for its stated lifetime.
Monthly orders combine first purchases with active repeat customers multiplied by average repeat orders per month.
Orders are multiplied by average units per order, then units are allocated across categories by sales mix.
Each category's allocated units are multiplied by its price, then category revenue is summed across months.
The Revenue Assumptions sheet organizes channel budgets, CAC, repeat-customer behavior, order frequency, units per order, sales mix, and category pricing.
REVENUE ASSUMPTIONS
The COGS & OPEX sheet separates direct production costs, variable expenses, and fixed operating costs across the forecast.
COGS & OPEX
The Scenario Analysis view compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA.
SCENARIO ANALYSIS
The Dashboard combines setup controls, scenario multipliers, key metrics, core financials, revenue mix, profitability, cash flow, and payback charts.
DASHBOARD
It fits businesses using channel acquisition, repeat buying, order-based unit sales, category mix, and pricing; different commercial logic may require custom modeling.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting for your requirements.
ORDER A CUSTOM FINANCIAL MODELAfter checkout, you receive an editable five-year financial model with monthly and annual projections, scenario analysis, financial statements, and management reporting.
Update the model's assumptions, operating inputs, and forecast drivers in Excel.
Review monthly and annual projections across the five-year planning horizon.
Compare Low, Base, and High cases through the workbook’s scenario views.
Review P&L, cash flow, balance sheet, summary, dashboard, and related reports.
The essential answers are visible in full, with no accordion clicks required.
It acquires customers from channel spend and CAC, adds repeat-cohort orders, converts orders to units, allocates units by product mix, and applies category prices.
You can change launch timing, channel marketing budgets and seasonality, CAC, repeat-buyer behavior, orders, units per order, category mix, and yearly prices.
You can compare revenue, gross margin, contribution margin, and EBITDA across the Low, Base, and High cases.
The workbook includes P&L, cash flow, balance sheet, summary, dashboard, scenario, break-even, valuation, ratios, charts, KPI, and related reports.
Yes. Financial Models Lab can build or adapt revenue logic, operating schedules, and financial reporting around agreed requirements.
It is a forecast driven by editable assumptions, not a guarantee of performance or business outcomes.
This downloadable financial model for a safety glow stick startup provides everything you need to build a robust financial plan, from initial cost analysis to a full five-year forecast.
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
This template showed me exactly where the margin was going and when break-even hit, so I stopped guessing. It saved me hours of spreadsheet work and gave me a cleaner view for pricing decisions.
I used this model to get my pitch into the right structure, and the investor call felt much easier to lead. We booked a follow-up meeting because the outputs were clear and matched what they wanted to see.
All my pricing, cost, and growth inputs finally lived in one place instead of scattered across tabs. I cleaned up the model in under an hour and could explain every assumption without digging around.