Acquire Signups
Marketing spend ÷ CAC creates signups, split between free-trial and direct-paid starts.
It is an editable five-year workbook for modeling subscriber acquisition, trials, plan activation, churn, tier pricing, operating costs, scenarios, and financial statements.
Use the model to translate acquisition and subscriber assumptions into recurring revenue, operating costs, cash flow, profitability, and financial position over time.
Editable assumptions feed the monthly calculation engine, which rolls customer cohorts and operating schedules into annual summaries, scenarios, statements, and management reporting.
The model turns CAC-driven signups into lagged trial conversions and direct-paid activations, rolls subscribers by tier after churn, calculates MRR, and reports ARR as a run-rate KPI.
Marketing spend ÷ CAC creates signups, split between free-trial and direct-paid starts.
After the trial lag, earlier trial cohorts convert at the trial-to-paid rate and current direct-paid starts are added.
New paid activations are assigned across subscription tiers using the editable customer plan mix.
Active subscribers equal prior subscribers plus activations minus churn, entered directly or approximated from customer lifetime.
Tier MRR equals active subscribers × monthly prices; recognized revenue adds enabled usage, setup, box, and add-on layers, annual revenue sums monthly recognition, and ARR equals 12 × MRR.
The Revenue sheet organizes acquisition, trial conversion, paid activation, plan mix, churn, pricing, and enabled usage or setup-fee assumptions in one operating view.
REVENUE
The COGS & OPEX sheet separates direct costs, variable expenses, and fixed operating expenses across the five-year forecast for monthly planning.
COGS & OPEX
The Scenarios report compares Low, Base, and High cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
SCENARIOS
The Dashboard combines scenario controls, core financials, revenue mix, cash flow, profitability, and payback charts in a single management view.
DASHBOARD
The ready-made workbook fits subscription-cohort planning with editable acquisition, conversion, churn, plan, pricing, and cost drivers; materially different operating 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 from the ready-made structure.
ORDER A CUSTOM FINANCIAL MODELYou receive a fully editable financial model available for immediate download, with a five-year forecast, scenario analysis, and linked financial reporting.
Update the model’s revenue, cost, staffing, capital, financing, and other editable assumptions.
Review a five-year financial forecast with detailed monthly and annual reporting.
Compare Low, Base, and High cases through the workbook’s scenario view.
Review the Income Statement, Cash Flow Statement, Balance Sheet, dashboard, and summary views.
The essential answers are visible in full, with no accordion clicks required.
It links marketing spend and CAC to signups, converts trial cohorts after the trial lag, adds direct-paid activations, applies plan mix and churn, then recognizes subscription and enabled ancillary revenue.
You can change launch timing, marketing spend, CAC, trial and activation assumptions, plan mix, churn or lifetime, tier pricing, usage, setup fees, and enabled optional monetization inputs.
The Scenarios view compares alternative cases across revenue, gross margin, contribution margin, and EBITDA over the five-year forecast.
The current workbook shows an Income Statement, Cash Flow Statement, Balance Sheet, Dashboard, Summary, and additional analysis and reporting tabs.
Yes. Financial Models Lab offers custom financial modeling when you need different revenue logic, operating schedules, or reporting structure.
It is a forecast driven by editable assumptions, not a guarantee of business performance, funding, profitability, or returns.
You get a downloadable, pre-built financial model for an immersive technology venture, complete with a dynamic dashboard, 5-year projections, and detailed financial statements.
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 saved me from building every schedule and formula by hand. I finished the first pass in a couple of hours instead of losing a whole weekend.
I used to get stuck juggling low, base, and high cases in separate sheets. Here, the scenarios were already organized, and I had all three ready for a lender call the same day.
I wasn’t sure what outputs investors would expect, but this model laid it out clearly. I booked a meeting with a cleaner, more confident set of numbers and less second-guessing.