SaaS Financial Model — Professional Edition | MRR Waterfall, LTV:CAC, Churn Cohorts & Fundraising Runway
The financial model your investors will actually want to see. Most SaaS founders go into their first investor meeting with a basic spreadsheet. This isn't that. This is a professional-grade, 36-month SaaS financial model built by a Senior Financial Analyst using the same modeling standards found in VC-backed startups and growth-stage SaaS companies. It handles everything investors ask for in due diligence — MRR waterfall, NRR, churn cohorts, LTV:CAC over time, tier-level gross margin, and a runway forecast that shows how long each funding round buys you. Set it up in under an hour. Present it the same day. --- WHAT'S INCLUDED: 9 TABS --- Read Me First — 10 live model health checks (green = pass, red = fail). Know the model is set up correctly before you share it. Assumptions — Every input in one place. Blue cells only. Switch Base/Optimistic/Downside with one cell. Everything updates instantly. MRR/ARR Waterfall — 36-month customer waterfall across 3 pricing tiers. Tracks New MRR, Churned MRR, and Expansion MRR separately. NRR and GRR calculated automatically every month. Blended Churn Cohorts — Monthly customers churn monthly. Annual customers churn at renewal — modeled separately, not averaged. The way institutional investors actually model churn. 36-Month P&L — Full SaaS income statement with tier-level gross margin breakdown. See which pricing tier makes you money and which one doesn't. Unit Economics — LTV:CAC tracked at Month 6, 12, 24, and 36 for all three tiers. Full 36-month monthly time series. LTV:CAC turns green above 3x, red below 1x automatically. Cash Flow & Runway — Monthly burn and cash balance for 36 months. Runway milestone summary shows cash before/after each funding round. Quarterly Review — 12-quarter business review with QoQ MRR growth, ARPU, NRR, and a quarterly MRR chart. Dashboard — Six KPI cards + four auto-updating charts. Share this tab directly with investors. --- 3-SCENARIO PLANNING --- One cell. Three futures. Every input — pricing, customer growth, churn, expansion, COGS, OpEx — switches with the scenario selector across all 36 months and 9 tabs. --- FILE DETAILS --- Format: Microsoft Excel (.xlsx)Compatible with Excel 2016+, Microsoft 365, and Google Sheets9 tabs · 36 months · 3 scenariosFully unlocked — rename tiers, adjust to your business modelModel health checks built in — investor-ready before you shareInstant download after purchaseBuyer FAQQ: I'm not a finance expert — can I still use this?A: Yes. You only ever edit the blue cells in the Assumptions tab. The 10 health checks on the Read Me First tab tell you if something is wrong before you share it.Q: My SaaS has only one pricing tier — is this still useful?A: Yes. Set Tier 2 and Tier 3 starting customers to 0 and ignore those sections. Everything else works perfectly.Q: What's the difference from a basic MRR tracker?A: A tracker records what happened. This model projects 36 months under 3 scenarios, tracks whether unit economics improve over time, and shows investors what your runway looks like before and after each funding round.
Get it → furnish7.gumroad.com