← Back to Financial Modelling

Three-Statement Financial Model for Startups: Complete Walkthrough

Key Takeaways

A three-statement model links your P&L, balance sheet, and cash flow statement so every assumption flows through automatically. This is the foundation investors expect before a Series A.

Why a three-statement model matters

Most founders start with a P&L spreadsheet and call it a financial model. Investors at Series A and beyond expect something more rigorous: a three-statement model where the income statement, balance sheet, and cash flow statement are mathematically linked. A change in revenue in month 3 flows through to gross profit, then to net income, then adjusts retained earnings on the balance sheet, and changes operating cash flow automatically.

The linked model serves two purposes. First, it prevents inconsistency: it is impossible for your P&L to show profitability while your balance sheet shows a different equity position. Second, it enables scenario analysis: change one assumption (your CAC, your churn rate, your average contract value) and every downstream number updates immediately. This is what investors mean when they ask 'can you model that out?'

Building the P&L: the revenue build first

Start with revenue, not with expenses. The most credible revenue build in a startup model is bottom-up: number of customers times average revenue per customer per month, derived from your actual sales pipeline and conversion rate assumptions, not from a top-down market share percentage.

For a SaaS business: beginning MRR + new MRR from new customers + expansion MRR from upsells - churned MRR = ending MRR. This formulation makes churn visible as a first-class variable. Investors will immediately go to your churn assumption because it has the highest impact on long-run revenue projections.

Gross margin follows revenue. Build COGS line by line: hosting costs (typically per-customer or usage-based), customer success headcount allocated to delivery, any third-party software costs embedded in your product. For most SaaS businesses, gross margin of 70-80% is expected at scale. If yours is lower, understand why and be able to explain it.

The balance sheet: what most founders skip

The balance sheet tracks what you own (assets) and what you owe (liabilities), with equity being the residual. For a pre-revenue or early-revenue startup, the balance sheet is simple: cash is your primary asset; accounts payable and deferred revenue (if customers pay upfront) are your main liabilities; equity is your paid-in capital minus accumulated losses.

The balance sheet must balance: assets = liabilities + equity. If yours does not balance, there is an error in the model. The most common causes: forgetting to increase retained earnings (or increase accumulated deficit) by net income (loss) each period, or not correctly tracking capital raises as increases to equity.

Deferred revenue is the balance sheet item most SaaS founders miss. If a customer pays $12,000 upfront for an annual contract, you receive $12,000 cash but can only recognise $1,000 of revenue per month. The remaining $11,000 sits on the balance sheet as a liability (deferred revenue) until earned. This matters because your cash position and your revenue position can diverge significantly with annual billing.

Cash flow statement: the survival statement

The cash flow statement reconciles net income to actual cash movement. It has three sections: operating cash flow (net income adjusted for non-cash items and working capital changes), investing activities (capex, acquisitions), and financing activities (debt, equity raises). For a startup, financing activities is where your VC rounds appear.

Operating cash flow will be negative during your growth phase because you are spending more than you earn. This is expected. What matters is whether your burn rate is declining as revenue grows (improving unit economics) and whether you have sufficient runway before the next fundraise.

The most important output of your cash flow model is the ending cash balance each month. This is your runway calculation. Add a 'months of runway' row that divides ending cash by your current monthly burn. Most investors want to see 18-24 months of runway after a funding round. If your model shows you running out of cash before the next raise would be expected to close, you need to adjust the plan.

Linking the three statements correctly

The linkage points that must be correct: Net income from the P&L flows to the retained earnings section of equity on the balance sheet. Depreciation and amortisation (if any) is a non-cash item on the P&L that gets added back in operating cash flow. Changes in accounts receivable, accounts payable, and deferred revenue appear as working capital changes in operating cash flow.

A reliable check: if your model balances (assets = liabilities + equity) at every period AND your ending cash on the balance sheet matches the cash line on your cash flow statement, your three statements are linked correctly. Build these checks as separate rows with conditional formatting that highlights any discrepancy.


Related: Financial Modelling: Complete GuideAll ArticlesThe Raise Ready Book

Ready to put this into practice?

Start the Founder Assessment