SaaS Financial Model — 5-Year Forecast

What you get

A single Excel workbook that runs a complete five-year financial model for a B2B SaaS business, covering a realistic zero-to-$5M ARR arc. Every output cell — MRR, ARR, P&L, cash runway, and unit economics — is formula-driven and recalculates the moment you change an input. The model includes a standalone Investor Summary tab formatted to share directly with investors without additional cleanup.

Who it's for

Built for B2B SaaS founders preparing for a pre-seed, seed, or Series A raise, and for early-stage finance leads who need an investor-grade model without building one from scratch. It is most useful in the weeks before a fundraise, when you need to answer pointed questions about growth trajectory, burn rate, and unit economics with a model that holds together under scrutiny.

What's inside

• Assumptions sheet — single source of truth for pricing tiers, conversion rates, churn, CAC, and headcount inputs; change one cell and every downstream metric updates
• MRR/ARR Projections — bottoms-up monthly build from new bookings, expansion revenue, and gross churn
• Headcount Plan — role-by-role hiring schedule organized by department and linked to salary assumptions
• Profit and Loss — full income statement from revenue through gross margin to EBITDA
• Unit Economics — LTV, CAC, LTV/CAC ratio, and CAC payback period, all formula-driven
• Cash Flow and Runway — monthly cash position and months of runway remaining based on current burn
• Investor Summary tab — ARR growth, gross margin, net new MRR, CAC payback, LTV/CAC, and runway surfaced in one shareable view

How to use it

Download the .xlsx file and open it in Microsoft Excel or Google Sheets. Begin on the Assumptions sheet, enter your pricing tiers, growth rates, churn rate, CAC, and planned hires, then work through each tab to review the outputs. The Investor Summary tab is ready to screenshare or export as-is — no reformatting required.