# Christoph Janz SaaS Financial Plan 2.0 Site-served catalog guide. Service API contracts remain at catalog.formualizer.com. - [Workbook page](https://formualizer.com/catalog/janz-saas-financial-plan) - [Subject guide (text)](https://formualizer.com/catalog/subjects/saas/llms.txt) - [Subject guide (JSON)](https://formualizer.com/catalog/subjects/saas/llms.json) - [Publisher page](https://christophjanz.blogspot.com/2016/03/saas-financial-plan-20.html) - [Ports (text)](https://formualizer.com/catalog/agents/janz-saas-financial-plan/v2.0/ports/llms.txt) - [Ports (JSON)](https://formualizer.com/catalog/agents/janz-saas-financial-plan/v2.0/ports/llms.json) - [OpenAPI](https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/openapi.json) - [TypeScript types](https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/types.d.ts) - [SheetPort manifest](https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/fio.yaml) - [Evaluate endpoint (POST)](https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/evaluate) - [MCP endpoint (POST)](https://catalog.formualizer.com/v1/mcp) ```json { "schemaVersion": 1, "kind": "workbook", "key": "janz-saas-financial-plan/v2.0", "title": "Christoph Janz SaaS Financial Plan 2.0", "summary": "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.", "edition": "v2.0", "html": "https://formualizer.com/catalog/janz-saas-financial-plan", "parent": { "text": "https://formualizer.com/catalog/subjects/saas/llms.txt", "json": "https://formualizer.com/catalog/subjects/saas/llms.json" }, "publisher": "Christoph Janz / Point Nine Capital", "publisherPageUrl": "https://christophjanz.blogspot.com/2016/03/saas-financial-plan-20.html", "verificationLevel": "baseline-excel-cache", "verificationExplanation": "Outputs equal the values Excel saved in the file. This checks the saved baseline, not changed-input calculations.", "rightsExplanation": "The workbook download opens on the publisher’s site.", "limitations": [ "Historical SaaS Financial Plan 2.0 from the 2016 publisher article; not a current benchmark or financial forecast.", "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." ], "releaseBlockers": [], "licenseClass": "reference-only", "disclaimer": "Catalog calculations, not certification.", "removal": "Entries are removed on the publisher’s request.", "flows": [ { "id": "quick_saas_arr_burn_forecast", "title": "quick saas arr burn forecast", "description": "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.", "inputPorts": [ "organic_growth_year1", "basic_churn", "pro_churn", "enterprise_mrr_target_year1", "enterprise_mrr_target_year2", "marketing_spend_first_month", "marketing_spend_monthly_increase", "basic_arpa", "pro_arpa", "infrastructure_fraction", "payment_fee_fraction", "starting_cash", "month1_financing" ], "outputPorts": [ "arr_month12", "arr_month24", "cash_month12", "cash_month24", "operating_cashflow_month12", "operating_cashflow_month24" ] }, { "id": "full_saas_operating_plan", "title": "full saas operating plan", "description": "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.", "inputPorts": [ "organic_growth_year1", "basic_churn", "pro_churn", "enterprise_mrr_target_year1", "enterprise_mrr_target_year2", "marketing_spend_first_month", "marketing_spend_monthly_increase", "basic_arpa", "pro_arpa", "infrastructure_fraction", "payment_fee_fraction", "starting_cash", "month1_financing", "revenue_assumption_6", "revenue_assumption_7", "revenue_assumption_8", "revenue_assumption_10", "revenue_assumption_11", "revenue_assumption_20", "revenue_assumption_22", "revenue_assumption_23", "revenue_assumption_33", "revenue_assumption_34", "revenue_assumption_45", "revenue_assumption_48", "revenue_assumption_49", "revenue_assumption_51", "revenue_assumption_53", "revenue_assumption_54", "revenue_assumption_60", "revenue_assumption_61", "revenue_assumption_74", "revenue_assumption_80", "revenue_assumption_81", "revenue_assumption_82", "revenue_assumption_83", "revenue_assumption_96", "cost_e4", "cost_c7", "cost_d7", "cost_e7", "cost_c8", "cost_d8", "cost_e8", "cost_c9", "cost_d9", "cost_e9", "cost_c10", "cost_d10", "cost_e10", "cost_c11", "cost_d11", "cost_e11", "cost_c12", "cost_d12", "cost_e12", "cost_c13", "cost_d13", "cost_e13", "cost_c14", "cost_d14", "cost_e14", "cost_c15", "cost_d15", "cost_e15", "cost_c21", "cost_d21", "cost_e21", "cost_c22", "cost_d22", "cost_e22", "cost_c23", "cost_d23", "cost_e23", "cost_c24", "cost_d24", "cost_e24", "cost_c25", "cost_d25", "cost_e25", "cost_c26", "cost_d26", "cost_e26", "cost_c27", "cost_d27", "cost_e27", "cost_c28", "cost_d28", "cost_e28", "cost_c29", "cost_d29", "cost_e29", "cost_c30", "cost_d30", "cost_e30", "cost_c31", "cost_d31", "cost_e31", "cost_c32", "cost_d32", "cost_e32", "cost_c33", "cost_d33", "cost_e33", "cost_c34", "cost_d34", "cost_e34", "cost_c35", "cost_d35", "cost_e35", "cost_c36", "cost_d36", "cost_e36", "cost_c37", "cost_d37", "cost_e37", "cost_c38", "cost_d38", "cost_e38", "cost_c39", "cost_d39", "cost_e39", "cost_c40", "cost_d40", "cost_e40", "cost_c41", "cost_d41", "cost_e41", "cost_c42", "cost_d42", "cost_e42", "cost_c43", "cost_d43", "cost_e43", "cost_c44", "cost_d44", "cost_e44", "cost_c45", "cost_d45", "cost_e45", "cost_c46", "cost_d46", "cost_e46", "cost_c47", "cost_d47", "cost_e47", "cost_c48", "cost_d48", "cost_e48", "cost_c54", "cost_d54", "cost_e54", "cost_c55", "cost_d55", "cost_e55", "cost_c56", "cost_d56", "cost_e56", "cost_c57", "cost_d57", "cost_e57", "cost_c58", "cost_d58", "cost_e58", "cost_c59", "cost_d59", "cost_e59", "cost_c60", "cost_d60", "cost_e60", "cost_c61", "cost_d61", "cost_e61", "cost_c67", "cost_d67", "cost_e67", "cost_d68", "cost_e68", "cost_d69", "cost_e69", "cost_d70", "cost_e70", "cost_d71", "cost_e71", "cost_c77", "cost_d77", "cost_e77", "cost_c78", "cost_d78", "cost_e78", "cost_c79", "cost_d79", "cost_e79", "cost_c80", "cost_d80", "cost_e80", "cost_e94", "cost_e95", "cost_e96", "cost_e97", "cost_e98", "cost_e102", "cost_e103", "cost_e104", "cost_e105", "cost_e106", "cost_e110", "cost_e111", "cost_e112", "cost_e113", "cost_e114", "cost_d123", "cost_e123", "cost_e124", "cost_d125", "cost_e125", "cost_e126", "sales_d6", "sales_d7", "sales_d8", "sales_d9", "sales_d10", "financing_month_2", "financing_month_3", "financing_month_4", "financing_month_5", "financing_month_6", "financing_month_7", "financing_month_8", "financing_month_9", "financing_month_10", "financing_month_11", "financing_month_12", "financing_month_13", "financing_month_14", "financing_month_15", "financing_month_16", "financing_month_17", "financing_month_18", "financing_month_19", "financing_month_20", "financing_month_21", "financing_month_22", "financing_month_23", "financing_month_24" ], "outputPorts": [ "arr_month12", "arr_month24", "cash_month12", "cash_month24", "operating_cashflow_month12", "operating_cashflow_month24", "month_1_mrr", "month_1_ebit", "month_1_operating_cashflow", "month_1_cash", "month_2_mrr", "month_2_ebit", "month_2_operating_cashflow", "month_2_cash", "month_3_mrr", "month_3_ebit", "month_3_operating_cashflow", "month_3_cash", "month_4_mrr", "month_4_ebit", "month_4_operating_cashflow", "month_4_cash", "month_5_mrr", "month_5_ebit", "month_5_operating_cashflow", "month_5_cash", "month_6_mrr", "month_6_ebit", "month_6_operating_cashflow", "month_6_cash", "month_7_mrr", "month_7_ebit", "month_7_operating_cashflow", "month_7_cash", "month_8_mrr", "month_8_ebit", "month_8_operating_cashflow", "month_8_cash", "month_9_mrr", "month_9_ebit", "month_9_operating_cashflow", "month_9_cash", "month_10_mrr", "month_10_ebit", "month_10_operating_cashflow", "month_10_cash", "month_11_mrr", "month_11_ebit", "month_11_operating_cashflow", "month_11_cash", "month_12_mrr", "month_12_ebit", "month_12_operating_cashflow", "month_12_cash", "month_13_mrr", "month_13_ebit", "month_13_operating_cashflow", "month_13_cash", "month_14_mrr", "month_14_ebit", "month_14_operating_cashflow", "month_14_cash", "month_15_mrr", "month_15_ebit", "month_15_operating_cashflow", "month_15_cash", "month_16_mrr", "month_16_ebit", "month_16_operating_cashflow", "month_16_cash", "month_17_mrr", "month_17_ebit", "month_17_operating_cashflow", "month_17_cash", "month_18_mrr", "month_18_ebit", "month_18_operating_cashflow", "month_18_cash", "month_19_mrr", "month_19_ebit", "month_19_operating_cashflow", "month_19_cash", "month_20_mrr", "month_20_ebit", "month_20_operating_cashflow", "month_20_cash", "month_21_mrr", "month_21_ebit", "month_21_operating_cashflow", "month_21_cash", "month_22_mrr", "month_22_ebit", "month_22_operating_cashflow", "month_22_cash", "month_23_mrr", "month_23_ebit", "month_23_operating_cashflow", "month_23_cash", "month_24_mrr", "month_24_ebit", "month_24_operating_cashflow", "month_24_cash", "month_1_customers", "month_1_basic_mrr", "month_1_pro_mrr", "month_1_enterprise_mrr", "month_2_customers", "month_2_basic_mrr", "month_2_pro_mrr", "month_2_enterprise_mrr", "month_3_customers", "month_3_basic_mrr", "month_3_pro_mrr", "month_3_enterprise_mrr", "month_4_customers", "month_4_basic_mrr", "month_4_pro_mrr", "month_4_enterprise_mrr", "month_5_customers", "month_5_basic_mrr", "month_5_pro_mrr", "month_5_enterprise_mrr", "month_6_customers", "month_6_basic_mrr", "month_6_pro_mrr", "month_6_enterprise_mrr", "month_7_customers", "month_7_basic_mrr", "month_7_pro_mrr", "month_7_enterprise_mrr", "month_8_customers", "month_8_basic_mrr", "month_8_pro_mrr", "month_8_enterprise_mrr", "month_9_customers", "month_9_basic_mrr", "month_9_pro_mrr", "month_9_enterprise_mrr", "month_10_customers", "month_10_basic_mrr", "month_10_pro_mrr", "month_10_enterprise_mrr", "month_11_customers", "month_11_basic_mrr", "month_11_pro_mrr", "month_11_enterprise_mrr", "month_12_customers", "month_12_basic_mrr", "month_12_pro_mrr", "month_12_enterprise_mrr", "month_13_customers", "month_13_basic_mrr", "month_13_pro_mrr", "month_13_enterprise_mrr", "month_14_customers", "month_14_basic_mrr", "month_14_pro_mrr", "month_14_enterprise_mrr", "month_15_customers", "month_15_basic_mrr", "month_15_pro_mrr", "month_15_enterprise_mrr", "month_16_customers", "month_16_basic_mrr", "month_16_pro_mrr", "month_16_enterprise_mrr", "month_17_customers", "month_17_basic_mrr", "month_17_pro_mrr", "month_17_enterprise_mrr", "month_18_customers", "month_18_basic_mrr", "month_18_pro_mrr", "month_18_enterprise_mrr", "month_19_customers", "month_19_basic_mrr", "month_19_pro_mrr", "month_19_enterprise_mrr", "month_20_customers", "month_20_basic_mrr", "month_20_pro_mrr", "month_20_enterprise_mrr", "month_21_customers", "month_21_basic_mrr", "month_21_pro_mrr", "month_21_enterprise_mrr", "month_22_customers", "month_22_basic_mrr", "month_22_pro_mrr", "month_22_enterprise_mrr", "month_23_customers", "month_23_basic_mrr", "month_23_pro_mrr", "month_23_enterprise_mrr", "month_24_customers", "month_24_basic_mrr", "month_24_pro_mrr", "month_24_enterprise_mrr" ] } ], "example": { "id": "baseline_quick_saas_arr_burn_forecast", "flow": "quick_saas_arr_burn_forecast", "inputs": {}, "expectedOutputs": { "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 }, "inputsJson": "{}", "expectedOutputsJson": "{\"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}" }, "ports": { "text": "https://formualizer.com/catalog/agents/janz-saas-financial-plan/v2.0/ports/llms.txt", "json": "https://formualizer.com/catalog/agents/janz-saas-financial-plan/v2.0/ports/llms.json" }, "service": { "openapi": "https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/openapi.json", "types": "https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/types.d.ts", "fio": "https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/fio.yaml", "evaluate": "https://catalog.formualizer.com/v1/models/janz-saas-financial-plan/v2.0/evaluate", "mcp": "https://catalog.formualizer.com/v1/mcp" } } ```