formualizer

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.

SummaryB6:AB39

Saved workbook valuesInputOutput

RowBCDEFOAB
6Revenues178,550200,668223,654554,3391,421,770
7
8CoGS38,89250,98248,696156,569444,770
9% of revenues22%25%22%28%31%
10
36Starting bank balance500,0005,428,9315,418,8333,915,6712,160,785
37Cash from financing5,000,0000000
39Ending bank balance5,428,9315,418,8335,176,6092,887,624892,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 / descriptionType / constraints / default
organic_growth_year1

Decimal fraction/month organic signup growth year 1. Default: 0.12.

Type: number

Default: 0.12

basic_churn

Decimal fraction/month Basic customer churn. Default: 0.03.

Type: number

Default: 0.03

pro_churn

Decimal fraction/month Pro customer churn. Default: 0.02.

Type: number

Default: 0.02

enterprise_mrr_target_year1

USD/month target Enterprise MRR at month 12; sales hiring is driven by this target. Default: 400000.

Type: number

Default: 400000

enterprise_mrr_target_year2

USD/month target Enterprise MRR at month 24; sales hiring is driven by this target. Default: 800000.

Type: number

Default: 800000

marketing_spend_first_month

USD/month positive initial marketing spend. Default: 20000.

Type: number

Default: 20000

marketing_spend_monthly_increase

USD/month incremental marketing spend each month. Default: 10000.

Type: number

Default: 10000

basic_arpa

USD/customer/month starting Basic ARPA. Default: 50.

Type: number

Default: 50

pro_arpa

USD/customer/month starting Pro ARPA. Default: 250.

Type: number

Default: 250

infrastructure_fraction

Decimal fraction of MRR spent on server infrastructure; nonnegative expense. Default: 0.07.

Type: number

Default: 0.07

payment_fee_fraction

Decimal fraction of cash collections (including annual Enterprise prepayments) spent on payment processing; nonnegative expense. Default: 0.015.

Type: number

Default: 0.015

starting_cash

USD opening month-1 bank balance. Default: 500000.

Type: number

Default: 500000

month1_financing

USD positive financing inflow in month 1. Default: 5000000.

Type: number

Default: 5000000

Outputs (6)
Port / descriptionType / constraints / default
arr_month12

USD/year ARR = 12 times month-12 MRR, not annual recognized revenue.

Type: number

arr_month24

USD/year ARR = 12 times month-24 MRR, not annual recognized revenue.

Type: number

cash_month12

USD ending bank balance month 12; negative indicates funding deficit.

Type: number

cash_month24

USD ending bank balance month 24; negative indicates funding deficit.

Type: number

operating_cashflow_month12

USD/month signed operating cash flow month 12; negative means cash burn.

Type: number

operating_cashflow_month24

USD/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/mcp

Slug: 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.