Building a Three-Statement Financial Model Under Investor Scrutiny

The Foundation of Serious Financial Planning

The three-statement financial model is called "three-statement" because it integrates three financial statements that together describe the complete financial picture of a business: the profit and loss account (P&L), the balance sheet, and the cash flow statement. Each statement tells a different story, and the discipline of building all three, fully linked, forces you to confront inconsistencies that a P&L-only model can obscure for years.

In the fundraising context, investors who review financial models are testing for two things simultaneously: the plausibility of the underlying assumptions, and the technical competence with which the model has been constructed. A model with compelling assumptions but structural errors signals that the finance function cannot be trusted to provide reliable information in the post-investment period. The reverse is also true: a technically impeccable model with implausible assumptions does not close rounds. Both dimensions matter.

This article focuses on the technical architecture of the model, covering the linkages that make a three-statement model work, the errors that most commonly undermine it, and the specific considerations for fintech businesses.

The Architecture: How the Three Statements Link

The fundamental insight of a three-statement model is that every financial event appears in all three statements, consistently and simultaneously. Understanding where each item appears, and how it flows between statements, is the prerequisite for building a model that balances and behaves correctly.

P&L to balance sheet: retained earnings

The most direct link between the P&L and the balance sheet is through retained earnings (or accumulated deficit). Net income (or net loss) for the period flows from the bottom of the P&L to the equity section of the balance sheet, increasing retained earnings by the net income amount or decreasing it by the net loss. This link is the reason a company with cumulative losses has a negative equity line on its balance sheet.

P&L to cash flow: non-cash charges

The cash flow statement begins with net income from the P&L and adjusts for non-cash items. Depreciation and amortisation charges appear as expenses in the P&L (reducing net income) but do not involve cash leaving the business; they must therefore be added back in the operating section of the cash flow statement to arrive at cash from operations. Similarly, share-based compensation is a non-cash P&L charge that is added back in operating cash flow.

Working capital: the often-missed link

Changes in working capital (trade receivables, trade payables, accruals, deferred revenue) affect both the balance sheet and the cash flow statement but do not appear in the P&L. When trade receivables increase (customers owe more than last period), this is a use of cash: the business has recognised revenue in the P&L but not yet collected the cash. The increase in receivables therefore appears as a negative adjustment in operating cash flow. This logic applies in reverse for trade payables: when payables increase, the business has recorded costs in the P&L but not yet paid them, generating a positive cash flow adjustment.

Capital expenditure: the investing activity

When a business purchases a fixed asset, the cash outflow appears in investing activities in the cash flow statement, and the asset appears on the balance sheet (gross cost). Over time, the asset is depreciated: the depreciation charge appears in the P&L and reduces the net book value of the asset on the balance sheet. This creates a three-way link: capex in investing cash flow, gross asset and accumulated depreciation on the balance sheet, and depreciation in the P&L.

Debt: the financing activity and the balance sheet

New borrowing appears as an inflow in financing activities in the cash flow statement and increases the debt balance on the balance sheet. Debt repayment is an outflow in financing activities and reduces the debt balance. Interest on the debt is a P&L charge (reducing net income) and the cash payment of interest appears in operating cash flow (or financing cash flow, depending on the accounting policy). The balance sheet debt schedule must be consistent with both the financing cash flows and the P&L interest charge.

Common Structural Errors

The following errors appear with high frequency in financial models reviewed during fundraising and M&A processes. Each of them undermines the model's reliability and signals to investors that the finance function may have gaps.

Hardcoded numbers instead of formula-driven cells

A model that contains hardcoded numbers in the P&L, balance sheet, or cash flow statement (other than in the designated assumptions tab) is not a model: it is a set of numbers presented as a model. Every projected number in the financial statements should be driven by a formula that references assumptions in the assumptions tab. Hardcoded numbers cannot be sensitised, cannot be rolled forward, and create a false sense of rigour. This is the single most common deficiency in models built by non-specialists.

Balance sheet that does not balance

A balance sheet that does not balance (assets do not equal liabilities plus equity) is a fundamental structural error. The balance sheet must balance as a mathematical identity: there is no legitimate reason for it not to. An imbalanced balance sheet indicates that the linkages described above are broken, typically because one of the statements has been modified without updating the others. If your balance sheet does not balance, stop and find the error before presenting the model.

Circular references from revolving credit facility interest

A common source of circular references in financial models is the treatment of interest on a revolving credit facility. If the facility balance depends on the cash position at the end of the period, and the cash position depends on the interest paid on the facility, and the interest depends on the facility balance, you have a circular reference. This can be resolved by iterative calculation (enabled in Excel settings) or by using the opening balance for the interest calculation rather than the closing balance. Both approaches have precedent; the important thing is to be intentional about which you use.

Inconsistent periods

A model that mixes monthly and annual periods in the same P&L or balance sheet will produce incorrect totals and ratios. Decide on a period structure (monthly actuals and forecast, with quarterly and annual summaries) and maintain it consistently throughout the model. Date headers should be formula-driven (not typed), so that rolling the model forward by one month correctly updates all calculations.

Key Revenue and Cost Drivers for a Fintech Model

The revenue and cost model for a SaaS or fintech business has specific structural characteristics that differ from a traditional product business. Understanding these characteristics is necessary for building a model that accurately represents the economics of the business.

ARR cohort model

The revenue model for a SaaS fintech should be built as a cohort model. Each month's new ARR is a separate cohort; the cohort declines over time at the churn rate; expansion ARR (upgrades, seat additions) adds to each cohort over time. The total ARR in any period is the sum of all cohort balances outstanding. This approach captures the economics of subscription revenue correctly: it shows why revenue is sticky (prior cohorts continue to generate revenue), what the churn impact is (cohort balances declining), and why net retention matters so much (expansion ARR offsetting churn).

Specifically, the cohort model requires the following monthly inputs for each cohort: new ARR added (from the new business model), churn rate applied to the cohort balance, and expansion rate applied to the cohort balance. The opening cohort balance carries forward from the previous month, and the closing balance equals: opening + expansion - churn.

Headcount-driven cost model

For most growth-stage fintech businesses, staff costs represent 60 to 80% of total operating costs. The cost model should therefore be headcount-driven: each role is listed individually (or by team and grade), with a fully loaded cost per role (base salary, employer NI, employer pension, benefits, and a management overhead). New hires are modelled individually for the forecast period, with a specific start month. This approach allows the cost model to be directly reconciled to the payroll and the headcount plan, and allows investors to assess whether the planned headcount is consistent with the revenue and product milestones.

Infrastructure costs as a function of revenue

For fintech businesses with significant cloud infrastructure or processing costs (payments processing fees, cloud hosting, data costs), these costs are typically modelled as a function of revenue or transaction volume. The key metric to track is gross margin trend: as the business scales, cloud and processing costs per unit of revenue should decrease as a result of volume discounts and architectural improvements. The model should show this trajectory explicitly, rather than projecting infrastructure costs as a fixed percentage of revenue.

The Correct Build Sequence

One of the most valuable pieces of guidance for someone building a three-statement model from scratch is the sequence in which the components should be built. Building in the wrong sequence leads to structural errors and rework. The correct sequence is:

What Investors Find Wrong in Models They Review

Based on the experience of reviewing models in fundraising and M&A due diligence, the most frequently cited deficiencies by investors and their advisers are:

• Revenue disconnected from operational drivers: A P&L that shows revenue growing from £2m to £8m in two years, with no cohort model, no headcount plan for the sales team, and no customer count projection. The number is aspirational, not analytical.
• Gross margin that does not deteriorate correctly under the cohort model: As a SaaS business scales, the blended gross margin changes as the mix of revenue shifts. A model that uses a fixed gross margin percentage regardless of scale is missing this dynamic.
• Cash flow that does not reflect the working capital cycle: Many models show net loss as the primary cash consumption and do not model the working capital build as the business grows (increasing receivables as revenue scales, deferred revenue dynamics). This underestimates or overestimates cash consumption at various growth rates.
• Capex absent from an asset-heavy business: A fintech business with significant data centre or technology infrastructure investment that models zero capex is presenting an unrealistic cash flow picture.
• Runway that uses net income instead of operating cash flow: Using net income (or EBITDA) to calculate runway ignores working capital and capex. Runway must be calculated from the cash balance and the projected operating and investing cash flows.

Key Takeaways

• A three-statement model is a prerequisite for serious fundraising. Investors test both the plausibility of assumptions and the technical integrity of the model.
• The four core linkages are: net income to retained earnings; D&A add-back to operating cash flow; working capital changes between balance sheet and cash flow; and capex to investing cash flow and balance sheet.
• The most common structural errors are: hardcoded numbers in financial statements, an unbalanced balance sheet, circular references from revolving credit facility interest, and inconsistent period structures.
• Every model should have a balance sheet check cell that produces a visible error if assets do not equal liabilities plus equity.
• For fintech, revenue should be built as a cohort ARR model; costs as a headcount-driven schedule; and infrastructure costs as a function of revenue with a margin improvement curve.
• The correct build sequence is: assumptions, revenue, costs, P&L, working capital, balance sheet, cash flow. Always in this order.
• Runway must be calculated from projected cash flows, not from EBITDA or net income.