A 3-statement financial model links a company's Profit & Loss statement, balance sheet, and cash flow statement into one integrated spreadsheet, so that a change to any input flows through all three. You build it in calculation order: a driver-based revenue model, a cost model fed by a headcount schedule, the P&L, the balance sheet, and finally the cash flow statement using the indirect method. The model is mechanically sound when the balance sheet balances and the closing cash on the cash flow statement equals the cash on the balance sheet.
If you've ever sent a financial model to an investor and received a question that exposed a fundamental inconsistency in the numbers — a cash balance that didn't reconcile, a debt schedule that didn't link, retained earnings that didn't roll — you already know what the 3-statement model is for.
The 3-statement model is the foundation of serious financial modelling. It connects your Profit & Loss statement, your Balance Sheet, and your Cash Flow statement into a single, integrated, self-checking system. When built correctly, it is impossible for the three statements to be inconsistent with each other. When built incorrectly, it is a source of exactly the kind of errors that destroy credibility in fundraising conversations.
This guide walks through how to build one properly — from the architecture decisions to the common failure points — written for startup founders and SMB operators, not investment banking analysts.
What the 3-statement model is and why it matters
Most early-stage companies have a P&L model. Some have a cash flow projection. Very few have all three statements properly integrated.
The three statements are:
The Profit & Loss (P&L) or Income Statement shows revenue, costs, and profitability over a period. It answers: did the business make money?
The Balance Sheet shows assets, liabilities, and equity at a point in time. It answers: what does the business own and owe, and what is the net worth?
The Cash Flow Statement shows how cash moved in and out of the business over a period. It answers: how much cash did the business generate or consume?
The power of the 3-statement model is integration. Changes in the P&L flow through to the balance sheet and cash flow automatically. Net income hits retained earnings on the balance sheet. Depreciation on the P&L gets added back in the cash flow statement. Working capital movements on the balance sheet drive the operating cash flow section. When everything is linked correctly, the closing cash on the cash flow statement equals the cash on the balance sheet. That reconciliation is the internal check that tells you the model is mechanically sound.
For investors, the 3-statement model signals that you understand your business at a level of financial sophistication that one-page P&L projections do not. It also provides the foundation for every downstream analysis: DCF valuation, LBO modelling, debt capacity analysis, and M&A work all start here.
The architecture: how to structure the model before you build
The single biggest mistake people make in financial modelling is starting to build before deciding on the structure. A model built without architectural discipline becomes unmaintainable — formulas that reference the wrong cells, hardcoded numbers buried in calculations, circular logic that is impossible to trace.
Before writing a single formula, establish these structural principles:
Separate inputs from calculations from outputs. Every model should have a distinct assumptions section where all input values live. No number that could change should be hardcoded directly into a calculation. Calculations reference the assumptions block. Outputs (the three statements and any summary metrics) reference the calculations. It is also what makes scenario planning possible later: change the assumptions block and the whole model reruns.
Use a consistent time axis. Monthly columns for the first 24 months, quarterly thereafter, is the standard for early-stage companies. Annual summaries are useful for presentation but should be calculated from the monthly detail, not built separately.
Colour-code your cells. Blue font for input cells (things you type in), black font for formula cells (things calculated from other cells). This convention makes it immediately clear where assumptions live and prevents the model from being accidentally corrupted by someone typing over a formula.
Name your tabs logically. A standard tab order: Cover → Assumptions → Revenue Build → Headcount → P&L → Balance Sheet → Cash Flow → Outputs/Summary. Add supporting schedules (debt, depreciation, working capital) as separate tabs referenced by the main statements.
Step 1: Build the revenue model
The revenue model is the foundation everything else is built on. Before touching the P&L, you need a revenue build that derives revenue from underlying business drivers rather than from top-down growth rate assumptions.
For a SaaS business, the driver logic typically looks like:
- Opening ARR
- Plus: New ARR (new customers × average contract value)
- Less: Churned ARR (opening ARR × monthly churn rate)
- Plus: Expansion ARR (upsells, seat additions)
- Equals: Closing ARR
- MRR = Closing ARR ÷ 12
For a services business:
- Billable headcount × utilisation rate × average day rate = Revenue
For a product business:
- Units sold × average selling price = Revenue
The key is that every revenue line should be explainable in terms of a business driver. "Revenue grows 10% per month" is not a revenue model — it is an assumption masquerading as analysis. When an investor asks "why does revenue grow at this rate?" the answer should be: "because we're adding X new sales reps, each ramping to Y quota over Z months, at an average contract value of €W."
Step 2: Build the cost model
The cost model should be structured around the same categories you will eventually report on your P&L: Cost of Goods Sold (COGS), Sales & Marketing, Research & Development, and General & Administrative (G&A).
For each category, the drivers are typically a combination of headcount costs and non-headcount costs.
Headcount costs should be built from a headcount schedule — a separate tab listing every role, with the planned start date, salary, employer contribution percentage (which in most EU markets adds 15–30% to base salary), and department allocation. The headcount schedule feeds directly into each P&L cost line. When you add or remove a hire, the P&L updates automatically.
Non-headcount costs (SaaS tools, marketing spend, office rent, professional fees) should be itemised in the assumptions block with a monthly amount or a formula that scales with a relevant driver (e.g., hosting costs as a percentage of revenue, or marketing spend as a percentage of new ARR targets).
One important structural decision: gross margin presentation. For a SaaS business, COGS typically includes hosting, customer success headcount, and third-party software costs directly attributable to delivery. Everything above gross profit is product and delivery cost; everything below is operating expense. Getting this right matters because gross margin is one of the first metrics investors benchmark.
Step 3: Build the P&L
With the revenue and cost models complete, the P&L is largely an assembly exercise. The structure:
``` Revenue Less: Cost of Goods Sold (COGS) = Gross Profit Gross Margin %
Less: Sales & Marketing Less: Research & Development Less: General & Administrative = EBITDA EBITDA Margin %
Less: Depreciation & Amortisation = EBIT
Less: Interest Expense Plus: Interest Income = EBT (Earnings Before Tax)
Less: Tax = Net Income ```
Every line should be a formula referencing either the revenue build, the headcount schedule, or the assumptions block. No hardcoded numbers in the P&L itself.
Net income is the critical output that flows into the balance sheet — it increases retained earnings, which is the equity linkage between the two statements.
Step 4: Build the balance sheet
The balance sheet is where most self-taught modellers struggle, because it requires understanding how every P&L and cash flow item affects the stock of assets, liabilities, and equity at a point in time.
The structure:
``` ASSETS Current Assets: Cash & Equivalents ← comes from closing cash on cash flow statement Accounts Receivable ← revenue × (debtor days / 365) Prepaid Expenses Inventory (if applicable)
Non-Current Assets: Property, Plant & Equipment (net) ← prior period + capex - depreciation Intangible Assets
LIABILITIES Current Liabilities: Accounts Payable ← COGS/opex × (creditor days / 365) Deferred Revenue ← for SaaS: billings - recognised revenue Accrued Liabilities Current Portion of Debt
Non-Current Liabilities: Long-Term Debt ← opening debt + drawdowns - repayments
EQUITY Share Capital Retained Earnings ← prior period retained earnings + net income Total Equity ```
The balance sheet must balance: Total Assets = Total Liabilities + Total Equity. If it doesn't, there is an error somewhere in the linkages. The most common culprits are: a cash line that isn't correctly pulling from the cash flow statement, a retained earnings roll that is missing an adjustment, or a debt schedule that isn't properly linked.
Step 5: Build the cash flow statement
The cash flow statement is built using the indirect method — starting from net income and adjusting for non-cash items and working capital movements to arrive at operating cash flow, then adding investing and financing cash flows.
``` OPERATING CASH FLOW Net Income ← from P&L Plus: Depreciation & Amortisation ← non-cash charge added back Changes in Working Capital: (Increase)/Decrease in Receivables Increase/(Decrease) in Payables Increase/(Decrease) in Deferred Revenue = Net Cash from Operations
INVESTING CASH FLOW Less: Capital Expenditure Plus: Proceeds from Asset Sales = Net Cash from Investing
FINANCING CASH FLOW Plus: Equity Raised Plus: Debt Drawdowns Less: Debt Repayments Less: Dividends Paid = Net Cash from Financing
= Net Change in Cash Plus: Opening Cash Balance = Closing Cash Balance ← must equal Cash on Balance Sheet ```
The closing cash balance on the cash flow statement feeding the cash line on the balance sheet is the final reconciliation check. When this works, the model is mechanically integrated.
The seven most common errors in 3-statement models
1. Cash not linking between cash flow and balance sheet. Always trace the closing cash formula on the balance sheet back to the cash flow statement directly.
2. Retained earnings not rolling correctly. Retained earnings = prior period retained earnings + current period net income ± any dividends or equity adjustments.
3. Deferred revenue not modelled for SaaS businesses. If you bill annually but recognise monthly, the unrecognised portion is a liability on the balance sheet and a positive working capital item in cash flow. Ignoring this dramatically overstates cash.
4. Ignoring employer costs. Modelling salaries without employer taxes and benefits understates headcount costs by 15–30% depending on jurisdiction.
5. Depreciation not linking to the asset schedule. Build a separate depreciation schedule that tracks each asset class, and link the P&L depreciation and the balance sheet net asset value from it.
6. Circular references in the interest schedule. Interest expense depends on average debt, which depends on ending cash, which is affected by interest. Handle this with a manual interest assumption or a dedicated debt schedule that breaks the circularity.
7. Building the model in presentation order rather than calculation order. Build revenue → costs → P&L → working capital schedules → balance sheet → cash flow. Don't try to build the balance sheet before the P&L is complete.
FAQs
Do I need a 3-statement model to raise a seed round? Not always, but investors will scrutinise your numbers more carefully at every stage. A well-integrated 3-statement model demonstrates financial maturity and gives investors confidence in your assumptions. Even at seed, if you can show one, it differentiates you.
How long should it take to build a 3-statement model? For a reasonably experienced modeller, 1–3 days for a startup-stage model. For a first-time builder working from scratch, expect 1–2 weeks of iteration. The first build always takes longer than you expect.
What software should I use? Excel is the industry standard and offers the most flexibility. Google Sheets works well for collaborative teams but has performance limitations with large models. Avoid purpose-built financial modelling apps until the model is complex enough to warrant it.
BB Financial Services Kft builds 3-statement financial models for startups and SMBs across Europe. If you need a model built properly from scratch — or an existing model fixed — [get in touch].