§ Resource — Financial Modelling
SaaS Financial Model — Template
A working Excel template built to the same standard we use inside client mandates: audit-grade, driver-based, no plug values, and a single-source-of-truth assumptions sheet. Suitable as a starting point for early-stage SaaS forecasts or a benchmark against an existing internal model.
Download .xlsx →235 KB · Excel workbook · 13 sheets
What's inside.
- 01READMEConventions, colour key, named ranges, version log.
- 02AssumptionsSingle source of truth — every driver lives here.
- 03Revenue BuildBookings → ARR → MRR, by plan and segment.
- 04Cohort RetentionLogo and net dollar retention by signing cohort.
- 05Headcount & PayrollHiring plan by function, fully-loaded cost.
- 06OpExS&M, R&D, G&A — driven from headcount and rate cards.
- 07P&LMonthly and annual roll-up, GAAP and non-GAAP views.
- 08Working CapitalDSO, deferred revenue, AP timing.
- 09Cash FlowIndirect method, reconciles to balance sheet.
- 10Balance SheetBalances every period, no plug.
- 11KPI DashboardARR, NRR, Rule of 40, CAC payback, Magic Number.
- 12ScenariosBase, upside, downside — toggled from one cell.
- 13SensitivityTwo-variable tables on growth, margin, and burn.
How it's structured.
- Colour key: blue = hard-coded input, black = formula, green = inter-sheet link, red = external.
- No hardcoded forecasts inside formulas — every driver is referenced from Assumptions.
- Monthly granularity, annual roll-up via SUMIFS on a date spine.
- Named ranges for the dozen most-referenced cells.
- Zero #REF!, #DIV/0!, or plug values. Balance sheet balances every period.
Provided as-is, without warranty. For institutional adaptation — carve-out modelling, board-grade decks, or live operating reviews — mandates are accepted by referral and partner review. See mandates or the doctrine.
Continue