Example

Three-Statement Financial Model Example

A 150-person manufacturing company in Sheffield with £8.5M revenue. The FP&A team maintains a three-statement model that links the P&L, Balance Sheet, and Cash Flow statement. This is the FY2025 annual summary used for lender reporting and strategic planning.

Example data

Financial model

Statement
Line Item
FY2025
P&L
Revenue
£8,500k
P&L
Net Income
£680k
BS
Total Assets
£5,200k
BS
Total Equity
£3,100k
CF
Operating CF
£920k
CF
Investing CF
(£350k)
CF
Net Change in Cash
£420k
Net Income

Net income of £680k (8% margin) flows directly into retained earnings on the Balance Sheet, increasing total equity from £2.42M to £3.1M.

Operating CF

Operating cash flow of £920k exceeds net income by £240k because depreciation (a non-cash charge) is added back and working capital improved.

Net Change in Cash

Despite £350k of capital investment, the business generated £420k of positive net cash flow, strengthening the balance sheet.

Formulas

Key formulas

fxRetained Earnings (BS) = Prior RE + Net Income (P&L) - Dividends

This is the primary link between P&L and Balance Sheet. Net income from the P&L flows into retained earnings on the equity section of the Balance Sheet.

fxOperating CF = Net Income + Depreciation + Working Capital Changes

The Cash Flow statement starts with net income from the P&L, adds back non-cash items, and adjusts for working capital movements from the Balance Sheet.

fxCash (BS) = Prior Cash + Net Change in Cash (CF)

The closing cash on the Balance Sheet must equal the prior period cash plus the total net cash movement from the Cash Flow statement. This is the key integrity check.

Analysis

What makes this example good

All three statements are mathematically linked with clear formulas
The Balance Sheet balances (Assets = Liabilities + Equity)
Cash flow reconciles to the change in cash on the Balance Sheet
Operating cash flow exceeds net income, showing strong cash conversion
The model supports what-if analysis across all three statements simultaneously

Customisation

How to adapt for your business

1

Add monthly or quarterly columns for more granular tracking

2

Include separate schedules for working capital, capex, and debt

3

Add ratio analysis (ROE, ROIC, debt/equity, current ratio) below the statements

4

Build in scenario toggles so changes to revenue assumptions cascade through all three statements

5

Add a debt schedule if the company has term loans or revolving facilities

Common variations

  • --Quarterly three-statement model for investor reporting
  • --Five-year projection model for strategic planning or fundraising
  • --Simplified two-statement model (P&L and Cash Flow only) for startups
  • --Multi-entity consolidated three-statement model with eliminations

FAQ

Frequently asked questions

Each statement tells a different part of the story. The P&L shows profitability, the Balance Sheet shows financial position, and the Cash Flow shows liquidity. A profitable company can still run out of cash; a cash-rich company can still be destroying value. You need all three views.

Build this in Grove FP in 10 minutes

No credit card required. Set up in minutes. 30-day money-back guarantee.