A fully built 3-year financial model for a hypothetical B2B SaaS startup. 8 tabs, 36 months of projections, scenario analysis, and an executive KPI dashboard — all color-coded and ready to adapt to any real business.
Compatible with Google Sheets and Microsoft Excel.
Base Case Results
CloudSync Pro — 10 founding customers, $500 ARPU, 2.5% monthly churn
Model Structure
Central inputs tab — ARPU, churn, growth rates, headcount, capex, tax rate. Change one number and the entire model updates.
36 months of customer count × ARPU, new acquisition, churn, and expansion revenue — fully linked to assumptions.
Month-by-month income statement — Revenue, COGS, S&M, R&D, G&A, Headcount, EBITDA, and Net Income.
Operating, investing, and financing cash flows. Cumulative cash balance and runway calculation for every month.
Simplified balance sheet — Current assets, fixed assets, liabilities, paid-in capital, and retained earnings.
Bear / Base / Bull comparison. Side-by-side Year 1–3 snapshots across 18 KPIs with assumption toggle table.
Executive summary: MRR, ARR, CAC, LTV, LTV:CAC, Gross Margin, Burn Rate, and Runway — all in one view.
Summary
Starting from $60K ARR (10 customers × $500 ARPU), the base case reaches $2.3M ARR by Month 36 — driven by 5% monthly compounding in new customer acquisition and 1% monthly ARPU expansion.
With 20% COGS (hosting, support, infrastructure), the business maintains a consistent 80% gross margin throughout the 3-year period — typical for a well-run B2B SaaS product.
The model turns EBITDA-positive around Month 18, funded by a $3M Series A equity raise at the start of Year 2. Cash balance grows from $2M at launch to over $4M by Year 3.
With a $2,000 CAC and 2.5% monthly churn, the customer lifetime value substantially exceeds acquisition cost — demonstrating a capital-efficient, scalable go-to-market.