Excel workbook · Catalog edition v2.0
Christoph Janz SaaS Financial Plan 2.0
Christoph Janz / Point Nine Capital
Forecast 24 months of recurring revenue, operating cash flow, bank balances and staffing across Basic, Pro and Enterprise SaaS plans.
- Inputs
- 245
- Outputs
- 198
- File size
- 335 KB
- Verification
- Excel baseline check
Try it
Try it loads a copy of this file from formualizer.com.
Saved workbook valuesInputOutput
| Row | B | C | D | E | F | O | AB |
|---|---|---|---|---|---|---|---|
| 6 | Revenues | 178,550 | 200,668 | 223,654 | 554,339 | 1,421,770 | |
| 7 | |||||||
| 8 | CoGS | 38,892 | 50,982 | 48,696 | 156,569 | 444,770 | |
| 9 | % of revenues | 22% | 25% | 22% | 28% | 31% | |
| 10 | |||||||
| 36 | Starting bank balance | 500,000 | 5,428,931 | 5,418,833 | 3,915,671 | 2,160,785 | |
| 37 | Cash from financing | 5,000,000 | 0 | 0 | 0 | 0 | |
| 39 | Ending bank balance | 5,428,931 | 5,418,833 | 5,176,609 | 2,887,624 | 892,146 |
What was checked
Outputs equal the values Excel saved in the file. This checks the saved baseline, not changed-input calculations.
Scope and limitations
Catalog calculations, not certification.
Try it uses a Formualizer formula that annualizes monthly recurring revenue to calculate ARR.
Forecast 24 months of Basic, Pro and Enterprise recurring revenue, operating cash flow, bank balances and staffing with Christoph Janz’s SaaS Financial Plan 2.0.
- Fixed 24-month historical axis starts January 2016; hire dates are Excel 1900 serials. Fractional customer and headcount expectations follow the original workbook.
- Enterprise revenue is target driven: the model derives new enterprise customers and required sales hiring from MRR targets; it is not a pipeline-constrained sales simulation.
- ARR is annualized end-month MRR, not yearly recognized revenue. Signed cash flow is negative for burn; bank balances may be negative.
- Full flow maps every numeric assumption block, employee date/salary/bonus and monthly financing entry; source labels and lookup/chart data remain pinned.
- Publisher redistribution permission has not been established; reference-only provenance does not establish redistribution permission.
- Excel-cached baseline outputs are matched. Changed-input scenarios apply expense and cash deltas to Excel-cached revenue, collections, EBIT and cash values; core growth, churn, ARPA and revenue schedules are not independently recalculated. ARR annualizes cached MRR.
What it computes
Ports for the compact flow: quick_saas_arr_burn_forecast. The full port contract includes all 443 ports.
Inputs (13)
| Port / description | Type / constraints / default |
|---|---|
organic_growth_year1Decimal fraction/month organic signup growth year 1. Default: 0.12. | Type: number Default: 0.12 |
basic_churnDecimal fraction/month Basic customer churn. Default: 0.03. | Type: number Default: 0.03 |
pro_churnDecimal fraction/month Pro customer churn. Default: 0.02. | Type: number Default: 0.02 |
enterprise_mrr_target_year1USD/month target Enterprise MRR at month 12; sales hiring is driven by this target. Default: 400000. | Type: number Default: 400000 |
enterprise_mrr_target_year2USD/month target Enterprise MRR at month 24; sales hiring is driven by this target. Default: 800000. | Type: number Default: 800000 |
marketing_spend_first_monthUSD/month positive initial marketing spend. Default: 20000. | Type: number Default: 20000 |
marketing_spend_monthly_increaseUSD/month incremental marketing spend each month. Default: 10000. | Type: number Default: 10000 |
basic_arpaUSD/customer/month starting Basic ARPA. Default: 50. | Type: number Default: 50 |
pro_arpaUSD/customer/month starting Pro ARPA. Default: 250. | Type: number Default: 250 |
infrastructure_fractionDecimal fraction of MRR spent on server infrastructure; nonnegative expense. Default: 0.07. | Type: number Default: 0.07 |
payment_fee_fractionDecimal fraction of cash collections (including annual Enterprise prepayments) spent on payment processing; nonnegative expense. Default: 0.015. | Type: number Default: 0.015 |
starting_cashUSD opening month-1 bank balance. Default: 500000. | Type: number Default: 500000 |
month1_financingUSD positive financing inflow in month 1. Default: 5000000. | Type: number Default: 5000000 |
Outputs (6)
| Port / description | Type / constraints / default |
|---|---|
arr_month12USD/year ARR = 12 times month-12 MRR, not annual recognized revenue. | Type: number |
arr_month24USD/year ARR = 12 times month-24 MRR, not annual recognized revenue. | Type: number |
cash_month12USD ending bank balance month 12; negative indicates funding deficit. | Type: number |
cash_month24USD ending bank balance month 24; negative indicates funding deficit. | Type: number |
operating_cashflow_month12USD/month signed operating cash flow month 12; negative means cash burn. | Type: number |
operating_cashflow_month24USD/month signed operating cash flow month 24; negative means cash burn. | Type: number |
Questions this workbook answers
- Forecast SaaS ARR and cash burn with Point Nine financial plan
- Model SaaS churn enterprise MRR targets and hiring
- How do infrastructure and payment fees affect SaaS cash runway?
Questions and answers
What are the units and default assumptions?
All mapped revenue assumptions, employee hire dates (Excel 1900 date serial), annual USD salaries and bonus fractions, sales quota/ramp, cost rates, and all 24 monthly financing inflows. Outputs include 24-month MRR, EBIT, cash flow, cash balances and customer/segment MRR schedules. Rates are decimal fractions, costs positive, cash flow signed. Unmapped cells retain source defaults.
Is this publisher endorsed?
No. This independent mapping preserves source attribution and pins the original bytes. Public availability does not establish redistribution rights.
What is the edition?
Historical SaaS Financial Plan 2.0 from the 2016 publisher article; not a current benchmark or financial forecast.
For agents
Connect an MCP client to the catalog endpoint:
https://catalog.formualizer.com/v1/mcpSlug: janz-saas-financial-plan · Edition: v2.0
- search_workbooks
- Optional arguments: query (string), theme (string), tag (string).
- inspect_workbook
- Required: slug (string). Optional: edition (string), flow (string).
- evaluate_workbook
- Required: slug (string), inputs (object). Optional: edition (string), flow (string), cellOverrides (object), selectCells (array of strings), trace (boolean).
{
"name": "evaluate_workbook",
"arguments": {
"slug": "janz-saas-financial-plan",
"edition": "v2.0",
"flow": "quick_saas_arr_burn_forecast",
"inputs": {}
}
}cellOverrides sets individual cells. selectCells reads at most 256 cells per request. trace requests formula lineage.
Flows
quick_saas_arr_burn_forecast
quick saas arr burn forecast
13 inputs covering growth, churn, target-driven enterprise sales, marketing, ARPA, infrastructure/payment fees and opening funding. Six outputs report month-12/24 ARR, signed operating cash flow and ending cash.
13 input ports · 6 output ports. Full membership in the port contract.
full_saas_operating_plan
full saas operating plan
245 input ports · 198 output ports. Full membership in the port contract.
REST example
Bundle scenario: baseline_quick_saas_arr_burn_forecast · Flow: quick_saas_arr_burn_forecast
curl 'https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/evaluate?flow=quick_saas_arr_burn_forecast' \
-H 'Content-Type: application/json' \
--data '{"inputs":{}}'Expected response
These expected values are the ones Excel saved.
{
"outputs": {
"arr_month12": 6652073.173891382,
"arr_month24": 17061235.729326542,
"cash_month12": 2887624.2892133095,
"cash_month24": 892145.9382080245,
"operating_cashflow_month12": -1028046.392048663,
"operating_cashflow_month24": -1268639.2578443787
}
}Looking for another spreadsheet? Request a workbook.