How to read this
Cells are referenced by R<row>/<column><row> notation. R9/E9 means column E, row 9. R38–R45 is a block of inputs spanning those rows. Multi-column ranges like D39–J39 mean the same row across several columns. Types: INPUT = user-edited, FORMULA = calculated, DROPDOWN = select from list.
Standard Financial Model — Sheet Map
Sheets (19)
README, License, Disclaimer, Get Started, Summary, Snapshot, Key Metrics, Key Reports, Revenues, Forecast, Hiring Plan, Statements, Sources & Uses, Unit Economics, Budget, Breakdown, Model Comparison, Glossary, Changelog
Model Structure (R6-R14)
| Row |
Label |
Type |
Default |
| R9/D9 |
Company Name |
INPUT |
"Company" |
| R10/D10 |
Base Timescale |
DROPDOWN |
"monthly" |
| R11/D11 |
# of periods |
INPUT |
72 (6 years) |
| R12/D12 |
Date of first period |
INPUT |
Jan 2026 |
| R13/D13 |
Fiscal year end |
FORMULA |
Dec 2026 |
| R14/D14 |
Relative/absolute dates |
DROPDOWN |
"absolute" |
Revenue Assumptions (R17-R58) — THE KEY SECTION
| Row |
Label |
Type |
Default |
| R20/D20 |
Growth metric name |
INPUT |
"Growth Units" |
| R21/D21 |
Revenue metric name |
INPUT |
"Revenue Units" |
| R22/D22 |
Revenue model type |
DROPDOWN |
"recurring" |
| R26/D26 |
New Growth Units month 1 |
INPUT (#) |
100 |
| R27/D27 |
Growth start date |
INPUT |
=D12 |
| R28/D28 |
Initial growth rate |
INPUT (%) |
10% |
| R29/D29 |
Growth rate deceleration |
INPUT (%) |
-5% |
| R30/D30 |
Use seasonality |
DROPDOWN |
"yes" |
| R31/D31 |
Viral coefficient (K) |
INPUT (#) |
1.2 |
| R34/D34 |
CPA per paid Growth Unit |
INPUT ($) |
0 |
| R35/D35 |
% acquired through paid |
INPUT (%) |
0 |
| R36/D36 |
Use Outbound Sales |
DROPDOWN |
"no" |
| R40/D40 |
Conversion rate |
INPUT (%) |
10% |
| R41/D41 |
Conversion lag months |
INPUT (#) |
0 |
| R44/D44-E44 |
Segment names |
INPUT |
"Segment 1", "Segment 2" |
| R45/D45-E45 |
% to each segment |
INPUT (%) |
50%/50% |
| R46/D46-E46 |
Churn rate |
INPUT (%) |
-10% each |
| R47/D47-E47 |
Churn period months |
INPUT (#) |
1 (monthly) |
| R53/D53-E53 |
Starting Revenue Units |
INPUT (#) |
0 |
| R54/D54-E54 |
Avg Revenue per Unit |
INPUT ($) |
$10 |
| R55/D55-E55 |
Billing period months |
INPUT (#) |
1 |
| R56/D56-E56 |
% billed upfront |
INPUT (%) |
100% |
Revenue Model Types (R61-R70)
D22 selects from: recurring, ecommerce, marketplace, advertising, financial services, top down, not applicable
Balance Sheet (R73-R97)
| Row |
Label |
Type |
Default |
| R76/D76 |
Cash on hand beginning |
INPUT ($) |
0 |
| R76/C76 |
Currency symbol |
INPUT |
"$" |
| R79/D79 |
Auto revenue recognition |
DROPDOWN |
"yes" |
| R83/D83 |
Auto cash collection |
DROPDOWN |
"yes" |
| R84/D84 |
Days AR |
INPUT (#) |
0 |
| R93/D93 |
Depreciation months |
INPUT (#) |
36 |
| R97/D97 |
Interest income rate |
INPUT (%) |
0 |
Debt (R99-R103)
| Row |
Label |
Type |
Default |
| R100/D100 |
Annual interest rate |
INPUT (%) |
0 |
| R101/D101 |
Repayment term months |
INPUT (#) |
0 |
| R102/D102 |
Interest-only months |
INPUT (#) |
0 |
Taxes (R105-R109)
| Row |
Label |
Type |
Default |
| R106/D106 |
Corporate tax rate |
INPUT (%) |
0 |
| R107/D107 |
Tax schedule |
DROPDOWN |
"quarterly" |
| R108/D108 |
VAT rate |
INPUT (%) |
0 |
Valuation (R118-R126)
| Row |
Label |
Type |
Default |
| R120/D120 |
WACC/NPV discount rate |
INPUT (%) |
8% |
| R121/D121 |
Long-term growth rate |
INPUT (%) |
4% |
| R124/D124 |
Multiple base |
DROPDOWN |
"revenues" |
| R125/D125 |
EV multiple |
INPUT (#) |
0 |
| R126/D126 |
% weight for multiple |
INPUT (%) |
50% |
Seasonality (R128-R143)
R131-R142: Monthly % change inputs (Jan-Dec), R143 = sum check
Model Checks (R146-R153)
All FORMULA returning yes/no
Revenues Sheet (B1:CU1174) — REVENUE ENGINE
Structure
Duplicated for Segment 1 and Segment 2. Contains:
- Outbound Sales cohorts (R20-R100)
- Growth Units cohorts (R103-R195)
- Conversion calculations (R199-R210)
- Revenue Units retention cohorts (R212-R373)
- Revenue calculations per model type (R375-R691)
- MRR metrics (R679-R691)
- Segment 2 repeats (R693-R1172)
- R22: New sales hires per period
- R99: Growth Units per ramped sales person
- R114: Manual growth adjustments
- R202: Manual conversion adjustments
- R378+: Per-month average revenue overrides
- Cohort tracking matrices (monthly retention/billing cohorts)
- Revenue recognition calculations
- MRR build calculations
Forecast Sheet (B1:CU689) — FORECAST ENGINE
Driver System (per row, columns K-X)
| Column |
Purpose |
| K |
Initial Value |
| L |
Starts in period # |
| M |
Repeats every N months |
| N |
Changing based on ("...", "% of", "# per", "% change", "# change") |
| O |
Changes every N months |
| P |
Changing by % or # |
| Q |
Using Driver (references another row label) |
| R |
Max N months |
| S |
Max value |
| U-X |
Use Seasonality/Event/Custom/Escalation (true/false) |
Main Input Area (R20-R96)
| Section |
Rows |
Notes |
| Operating Metrics |
R25-R34 |
Growth/Revenue Units from Revenues sheet; Salaries from Hiring Plan |
| Fundraising |
R37-R39 |
3 equity investment rows |
| Revenues & Billings |
R42-R47 |
Rev Cat 1-2 from Revenues; Cat 3 is INPUT |
| Hiring Plan |
R50-R65 |
Salaries + Benefits from Hiring Plan sheet |
| Operating Expenses |
R68-R95 |
Acquisition/Retention from Revenues; COGS, expenses via drivers |
| Section |
Rows |
Purpose |
| Forecast by Category |
R99-R162 |
Aggregates into standard categories |
| Actuals by Category |
R165-R228 |
INPUT area for actual financial data |
| Actuals + Forecast |
R231-R294 |
Merged view flowing to Statements |
| Burn/Runway |
R309-R387 |
Net burn, runway months, cash projection matrix |
| Revenue Recognition |
R389-R405 |
Deferred revenue, AR |
| Depreciation/Amort |
R407-R429 |
Schedules |
| Debt Repayment |
R431-R586 |
Monthly principal + interest |
| Tax Schedules |
R593-R611 |
Corporate + VAT |
| Inventory |
R613-R639 |
Purchase/disposal calcs |
| MRR/ARR Metrics |
R651-R674 |
Monthly/annual recurring revenue |
| Valuation |
R676-R688 |
DCF + Multiple methods |
Hiring Plan Sheet (B1:CU58)
- R24: Outbound Sales Staff (FORMULA from Revenues)
- R25: CEO row (INPUT: salary, category)
- R26-R55: 30 TBD hire rows (INPUT)
- Same driver system as Forecast (cols K-X)
- Category dropdown: R&D, Sales, G&A, Misc SG&A
- Segment dropdown: Unallocated, Segment 1, Segment 2
- R11-R40: Income Statement
- R43-R88: Balance Sheet
- R90-R121: Cash Flow Statement
- Summary: Annual rollup (5 years)
- Snapshot: 6-month forward cash flow
- Key Metrics: SaaS KPIs (ARR, Magic Number, Rule of 40, LTV:CAC)
- Unit Economics: Per-unit LTV, CAC, payback
- Budget: Forecast vs Actuals variance
- Breakdown: Segment-level P&L
- Sources & Uses: Funding deployment summary
Cross-Sheet References
Get Started → Revenues (growth, conversion, churn, pricing, seasonality)
Get Started → Forecast (timescale, balance sheet, tax, valuation)
Get Started → Unit Economics (revenue per unit, churn)
Revenues → Forecast R25-R28 (operating metrics)
Revenues → Forecast R42-R45 (revenue/billings)
Revenues → Forecast R68-R69 (acquisition/retention costs)
Hiring Plan → Forecast R50-R59 (salaries by category)
Forecast (R231-R294) → Statements
Statements → Summary (annual via SUMIFS)