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
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 cash flow of £920k exceeds net income by £240k because depreciation (a non-cash charge) is added back and working capital improved.
Despite £350k of capital investment, the business generated £420k of positive net cash flow, strengthening the balance sheet.
Formulas
Retained Earnings (BS) = Prior RE + Net Income (P&L) - DividendsThis 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.
Operating CF = Net Income + Depreciation + Working Capital ChangesThe 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.
Cash (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
Customisation
Add monthly or quarterly columns for more granular tracking
Include separate schedules for working capital, capex, and debt
Add ratio analysis (ROE, ROIC, debt/equity, current ratio) below the statements
Build in scenario toggles so changes to revenue assumptions cascade through all three statements
Add a debt schedule if the company has term loans or revolving facilities
Keep exploring
A 120-person B2B software company based in Manchester with £5.2M annual revenue. The business sells a subscription product to mid-market companies and is forecasting 18% growth this year. The finance team is building the annual budget for FY2026.
View exampleA 40-person e-commerce company in Leeds with £2.8M revenue. The business is profitable but cash-tight due to inventory purchasing cycles. The finance team runs a weekly 13-week cash forecast to ensure the company never drops below its £50k minimum cash threshold.
View exampleA 200-person manufacturing company in Coventry with £12M revenue. The Finance Director is building a 3-year capital expenditure plan for board approval. The company needs to invest in new production equipment, warehouse expansion, and IT infrastructure to support the growth plan.
View exampleFAQ
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.
No credit card required. Set up in minutes. 30-day money-back guarantee.