Short answer: A SaaS model investors trust is built from drivers, not targets. It starts with an ARR bridge (new, expansion, contraction and churn), ties customer acquisition to sales capacity and marketing spend, builds costs from a headcount plan, and flows into an integrated P&L, balance sheet and cash flow. Every assumption should trace back to your own historical data.
The building blocks
- ARR bridge: beginning ARR plus new, expansion, contraction and churn by month.
- Acquisition engine: pipeline, win rates, sales capacity and ramp time for new reps.
- Retention and expansion: cohort-based churn and upsell assumptions.
- Pricing: average contract value by plan and expected price changes.
- Headcount plan: every role, start date and fully loaded cost.
- Cash timing: billing terms, deferred revenue, collections and payables.
- Scenarios: base, upside and downside with clear triggers.
What investors will stress-test
- Whether planned bookings match the sales team you plan to hire
- Retention assumptions compared with your actual cohorts
- Gross margin as hosting and support scale
- Burn and runway in a slower-growth case
- How the use of funds connects to milestones
Mistakes to avoid
- Top-down revenue ("we will grow 3x") with no link to capacity
- Mixing bookings, billings and revenue
- Forgetting annual billing effects on cash
- No link between the model and actual results each month
How Capstone CFO helps
- Build a driver-based, three-statement SaaS model tailored to your go-to-market motion
- Calibrate assumptions with your cohort, pipeline and billing data
- Create base, upside and downside cases for board and investor discussions
- Refresh the model monthly against actuals so it stays credible
- Support due diligence questions during a raise
Frequently asked questions
How many months should a SaaS model cover?
Monthly detail for 24 to 36 months, with annual totals beyond that when raising capital.
Should we model by customer or by cohort?
Cohorts work well for most companies; large enterprise deals may need customer-level detail.
Can we use a template?
Templates help structure, but the assumptions must come from your own data to be credible.
Building or fixing your model? See how we build forecasts and plans or book a call with our CFO team.