Acquire Signups
Divide marketing spend by CAC, then split signups between free trials and direct-paid starts.
This editable five-year workbook models subscription cohorts, trials, churn, pricing, usage, and setup fees into monthly forecasts, scenarios, and financial statements.
Use the workbook to plan how marketing creates signups, trials convert to paid customers, subscribers move through plan tiers, and recurring and usage revenue develop.
Editable operating assumptions feed monthly calculations, annual financial statements, Low/Base/High scenarios, and management views so customer economics stay connected to financial outcomes.
Marketing creates signups, trials convert after a lag, paid customers enter plan cohorts, and active subscribers generate subscription, usage, setup, and enabled add-on revenue.
Divide marketing spend by CAC, then split signups between free trials and direct-paid starts.
After the trial lag, convert the earlier trial cohort and add current direct-paid activations.
Allocate activations across plans and update active subscribers after explicit or lifetime-based churn.
Apply plan prices, usage charges, setup fees, and any enabled box or add-on revenue.
Sum monthly recognized revenue layers; annual revenue totals the months while ARR remains a run-rate KPI.
The Revenue Assumptions view connects acquisition, trials, activation, plan mix, subscriber lifetime, subscription pricing, setup fees, and usage charges to the forecast.
REVENUE ASSUMPTIONS
The COGS & OPEX view separates direct infrastructure costs, variable operating expenses, and recurring fixed overhead for the monthly forecast.
COGS & OPEX
The Scenarios view compares Low, Base, and High paths for revenue, gross margin, contribution margin, and EBITDA across the five-year forecast.
SCENARIOS
The Dashboard brings model setup, scenario outputs, revenue mix, profitability, core financials, cash flow, and investment payback into one management view.
DASHBOARD
It fits subscription businesses with trial conversion, tiered paid plans, churn, usage, and setup fees; materially different revenue structures may need 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 from the ready-made template.
ORDER A CUSTOM FINANCIAL MODELYou receive an editable five-year financial model for instant download, with monthly forecasting, Low/Base/High scenarios, financial statements, and management reporting.
Change acquisition, trial, conversion, pricing, churn, usage, cost, staffing, and financing assumptions.
Review monthly calculations and annual projections across the model’s five-year horizon.
Compare Low, Base, and High cases across revenue and profitability measures.
Review P&L, cash flow, balance sheet, dashboard, summary, and supporting analysis views.
The essential answers are visible in full, with no accordion clicks required.
It calculates signups from marketing spend and CAC, converts trial cohorts after the trial lag, adds direct-paid activations, and updates active subscribers after churn. Revenue then combines plan subscriptions with usage, setup fees, and any enabled add-on layers.
You can change launch timing, marketing budgets and seasonality, CAC, trial and direct-paid shares, trial duration and conversion, plan mix, starting subscribers, lifetime or churn, subscription prices, usage, setup fees, and enabled add-on inputs.
You can compare Low, Base, and High revenue, gross margin, contribution margin, and EBITDA paths across the five-year forecast.
The product gallery confirms P&L, cash flow, balance sheet, Dashboard, Scenarios, Summary, break-even, ROIC, Charts, KPIs, Ratios, Valuation, Top Revenue, Top Expenses, Sources & Uses, and DuPont views.
Yes. Financial Models Lab can build or adapt a model when you need different revenue logic, operating schedules, or reporting.
It is a planning forecast driven by editable assumptions, not a guarantee of business performance or financial results.
This downloadable financial model for an SSI startup provides everything you need to build a robust financial plan, secure funding, and steer your company toward profitability.
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
The low, base, and high cases were laid out cleanly, so I stopped wasting time comparing versions by hand. I got a meeting-ready forecast in under an hour.
I could finally see margins and break-even in one place without digging through formulas. That made it much easier to explain our pricing assumptions and get approval on the next planning call.
Building the financials manually used to eat my week, but this template cut it down to an afternoon. The pre-built structure let me focus on the assumptions instead of the spreadsheet work.