Acquire Signups
New signups equal marketing spend divided by CAC, then split between trials and direct-paid starts.
It is an editable five-year workbook for planning subscription cohorts, tier pricing, operating costs, scenarios, and linked statements, with monthly and annual P&L detail.
Use the model to translate marketing spend, subscriber conversion, churn, plan mix, pricing, and optional monetization into a structured financial forecast.
Editable assumptions feed the revenue and cost schedules, which then flow into scenario comparisons, management reporting, and the core financial statements.
The model converts marketing-driven signups into paid subscriber cohorts, carries active customers through churn, prices each plan, and adds enabled secondary revenue layers.
New signups equal marketing spend divided by CAC, then split between trials and direct-paid starts.
After the trial lag, converted trial cohorts are added to current direct-paid activations.
Paid activations are allocated across plans, while active subscribers roll forward net of churn.
Tier MRR equals active subscribers times monthly plan price; total MRR sums across tiers.
Monthly recognized revenue adds enabled usage, setup, box, and add-ons; annual revenue sums months while ARR remains run-rate.
The Revenue view connects acquisition, trial conversion, paid plan mix, churn, pricing, and optional monetization layers to subscriber-driven revenue.
REVENUE
The COGS & OPEX view organizes direct box costs, variable expenses, and fixed operating expenses across the forecast period.
COGS & OPEX
The Scenarios view compares Low, Base, and High cases for revenue, gross margin, contribution margin, and EBITDA across the forecast.
SCENARIOS
The Dashboard combines scenario controls, core financials, revenue mix, profitability, cash flow, payback, and key working-capital assumptions in one view.
DASHBOARD
It fits businesses using acquisition-to-subscriber cohort economics, while materially different revenue logic, operating schedules, or reporting may require a custom structure.
The template is a planning starting point, not a guarantee of performance.
Financial Models Lab can build or adapt a model when your business needs different revenue logic, operating schedules, or reporting.
ORDER A CUSTOM FINANCIAL MODELYou receive a fully editable financial model for Excel or Google Sheets with five-year forecasting, scenario analysis, linked statements, and management reports.
Open and edit the financial model in Excel or Google Sheets.
Plan across a five-year horizon with monthly and annual financial detail.
Compare Low, Base, and High cases across key financial outcomes.
Review linked income statement, cash flow, balance sheet, and management reporting.
The essential answers are visible in full, with no accordion clicks required.
It converts marketing spend into signups, splits trials and direct-paid starts, converts lagged trial cohorts, rolls subscribers through churn, prices plan tiers, and adds enabled secondary revenue.
You can change launch timing, online/offline marketing spend and seasonality, CAC, free-trial share, direct-paid share, trial and conversion inputs, plan mix, starting subscribers, churn or lifetime, tier pricing, usage, fees, shipment, add-on, and refund assumptions.
You can compare alternative revenue, gross margin, contribution margin, and EBITDA paths across the five-year scenario view.
The workbook includes an income statement, cash flow statement, balance sheet, Dashboard, Scenarios, Summary, and additional management reports.
Yes. Financial Models Lab offers custom financial modeling for different revenue logic, operating schedules, or reporting requirements.
It is a planning forecast, not a guarantee of business performance, funding, profitability, or returns.
This downloadable financial plan for gardening kit business includes everything you need to build a comprehensive financial forecast and business valuation.
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 stopped juggling separate low, base, and high sheets and finally had one clean view to compare them. It saved me hours and made the planning conversation much easier.
Pricing, costs, and growth were all scattered before; this template pulled them into one layout I could actually follow. I cut my setup time by half and could explain the numbers without backtracking.
One broken formula used to make me second-guess the whole model. This template made the links easier to trace, and I spotted issues faster before they spread through the forecast.