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
Get Started Sheet (B1:G154): Core Input Sheet
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)
Key INPUT rows (can be overwritten per month in cols AB-CU)
- 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
Formulas to Never Touch
- 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 |
Calculated Sections (all FORMULA)
| 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
Statements Sheet: all FORMULA
Three monthly GAAP statements stacked on one sheet, built from the Actuals-plus-Forecast block on the Forecast sheet (R231-R294). Output only, nothing to edit here. Period headers (R4-R8) pull straight from the Forecast.
Income Statement (R11-R40)
| Rows | Lines |
|---|---|
| R13-R14 | Revenues, % Growth |
| R16 | COGS |
| R18-R19 | Gross Margin, Gross Margin % of Revenues |
| R21-R22 | SG&A, % of Revenues |
| R24-R25 | Operating Income (EBITDA), % of Revenues |
| R27-R32 | Depreciation, Amortization, Interest Income, Interest Expense, Other Income, Other Expense |
| R34 | Earnings before Taxes (EBT) |
| R36 | Taxes |
| R38-R40 | Net Income (Loss), Cumulative Net Income, % of Revenues |
Balance Sheet (R43-R88)
| Section | Rows | Lines |
|---|---|---|
| Assets | R45-R59 | Cash, Accounts Receivable, Inventory, Prepaid Expense, Other Current Assets, Total Current Assets; PP&E, Accumulated Depreciation, Total Fixed Assets; Other Assets, Accumulated Amortization; Total Assets |
| Current Liabilities | R61-R70 | Accounts Payable, Inventory AP, Deferred Revenue Liability, Accrued Liabilities, Corporate Tax Payable, VAT Payable, Working Capital Loan Facility, Total Current Liabilities |
| Noncurrent Liabilities | R72-R77 | Convertible Notes and SAFEs, Debt Financing, Accrued Interest, Total Noncurrent Liabilities |
| Stockholders Equity | R79-R85 | Owners Equity, Equity Investment, SAFE Investment, Retained Earnings, Net Income (Loss), Total Stockholders Equity |
| Check | R87-R88 | Total Liabilities and Shareholder's Equity, and a balance Check row |
Statement of Cash Flows (R91-R120)
| Section | Rows | Lines |
|---|---|---|
| Operations | R93-R100 | Cash beginning of period; Net Income, add back Depreciation, Amortization, Changes in Working Capital; Net Cash Flow from Operations |
| Investing | R102-R105 | CAPEX, Other Assets, Net Cash Flow from Investing |
| Financing | R107-R116 | Change in Equity / SAFE / Convertible Debt investments, New Debt Financing, Changes in Owners Equity, Dividends and Distributions, Debt Repayment, Draw (Repayment) on Working Capital Line, Net Cash Flow from Financing |
| Reconciliation | R118-R120 | Net Cash Flow, Cash End of Period |
Other Sheets (all FORMULA)
All output sheets, built from Forecast and Statements. Nothing to edit; useful as ready-made views.
Summary
Annual rollup (5 years), built from the Forecast via SUMIFS by fiscal year. A condensed income statement (Revenues with Y/Y growth and growth multiple, COGS, Gross Margin, SG&A with the four SG&A category lines, EBITDA, D&A, Interest, Other, Taxes, Net Income, each with % of revenue), then an annual Statement of Cash Flows (operations / investing / financing rolling to cash end of period), then an annual Balance Sheet.
Snapshot
A single-period cash view (R2-R24): cash beginning of period, then Revenues, gross margin, other income and expenses, corporate taxes, changes in working capital, net cash flows from investing and financing, ending at cash end of period. The "As of" period (R4) is selectable.
Key Metrics (R2-R34)
SaaS KPIs by year. ARR build (beginning, new ARR, expansion ARR, churn, contraction, ending ARR, Y/Y growth), Net New ARR, ARR per head, SaaS Magic Number, Rule of 40, then acquisition economics: average revenue and gross margin per unit, CAC (paid-only and blended), CAC payback months, CAC Ratio, LTV:CAC, and Customer Lifetime Value (pulled from the Unit Economics sheet).
Unit Economics (R2-R138)
Per-unit LTV, CAC, and payback, driven from the Get Started revenue and churn inputs. Inputs block (revenues, cost of sales, discounts, churn and growth, discount rate, acquisition and retention costs) feeds the headline LTV by type (recurring, one-time, transaction), total LTV, LTV/CAC, and CAC payback (R49-R54). Below that, a month-by-month per-unit cash flow detail (R56-R138) builds the LTV: revenues, cost of sales, discounts, billings, acquisition and retention costs net of churn, then cumulative discounted gross margin and the % of LTV realized over time.
Budget (R2-R46)
Budget versus Actuals variance for a selectable period (start and end month at R5-R6). Same P&L shape as the income statement, with a Budget column (from the Forecast block) and an Actuals column (from the Actuals block) side by side, down to Net Income.
Breakdown (R2-R50)
Segment-level P&L for a selectable year (R2). Full income statement (Revenues through Net Income) split by segment, with % of revenue and % of total columns, using SUMPRODUCT against the segment tag on the Forecast input rows.
Sources & Uses (R2-R27)
Funding deployment over a selectable month range (R5-R6). Sources (external funding, revenues) and Uses (the SG&A and expense categories from the Forecast, plus working capital as the balancing item), each shown in dollars and as a percent of the total.
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)