A solid financial model is essential for fundraising and board reporting. This guide walks through building a three-statement startup model from scratch.
[next-mdx-remote-client] error compiling MDX: Unexpected character `1` (U+0031) before name, expected a character that can start a name, such as a letter, `$`, or `_` More information: https://mdxjs.com/docs/troubleshooting-mdx
Build a 3-year model at minimum: the current year with monthly detail, and years 2-3 with quarterly detail. Investors evaluating a Series A want to see a credible path to scale over 3 years. For internal management, a rolling 18-month monthly forecast is most useful — enough detail to manage hiring decisions and cash, but not so far out that it becomes fiction. Update the long-range view annually.
A top-down model starts with a market size estimate and assumes a certain market penetration percentage — for example, '1% of a $5B market is $50M revenue.' Investors generally dislike top-down models because they are not grounded in operational reality. A bottom-up model builds revenue from actual drivers: number of sales reps × quota × attainment, or number of marketing leads × conversion rate × ACV. Bottom-up models are harder to build but far more credible.
The essential metrics are: ARR and ARR growth rate, gross margin, monthly burn rate, cash runway, net revenue retention (NRR/NDR), CAC and LTV:CAC ratio, CAC payback period, and headcount by department. For board and investor reporting, also include Rule of 40 (ARR growth % + EBITDA margin %) and Magic Number (net new ARR ÷ prior quarter S&M spend). These metrics together tell a complete story about growth efficiency and sustainability.
Usage-based models require tracking consumption drivers separately from customer count. Model: number of active customers × average usage per customer per month × price per unit. Add a customer growth curve for new customer acquisition and a usage expansion curve for existing customers (as they embed the product deeper, usage typically grows). Apply a usage churn rate for customers who reduce consumption. Validate your assumptions against actual cohort usage data from your first customers.
Bring a three-statement model (P&L, balance sheet, cash flow statement) with monthly detail for the current year and quarterly detail for years 2-3. Include: a revenue build by cohort or segment, a headcount plan, operating expense detail, scenario analysis (base/upside/downside), and a summary dashboard with key SaaS metrics. Investors will stress-test your assumptions — be prepared to explain the logic behind every key input, especially revenue growth, churn rate, and hiring plan.
2026/05/08
