In brief
An integrated model connects operating assumptions to the income statement, balance sheet and cash flow statement. Begin with reconciled opening balances, then forecast revenue, costs, working capital, capital expenditure and financing in supporting schedules. Cash is an output, not a balancing plug. Checks should confirm the statements reconcile while scenarios test whether the operating assumptions remain credible under different conditions.
Key takeaways
- An integrated model connects operating assumptions to the income statement, balance sheet and cash flow statement.
- Reconcile the inputs to source records and make assumptions explicit.
- Use the result to frame questions, not as an assurance conclusion.
Reconcile the opening balances
Start with a dated balance sheet tied to the accounts and a historical income statement for a matching reporting perimeter. Document classifications and adjustments. Build supporting schedules before linking the statements. An unexplained opening difference can carry through every forecast period even when later formulas appear consistent.
Illustrative worked example
Opening cash $100,000 plus $30,000 operating cash generation less $20,000 capex gives $110,000 ending cash before financing.
Connect operating drivers to cash
Forecast revenue from units, prices or customer cohorts. Link costs to activity and capacity, and distinguish fixed from variable spending. Model receivables, inventory and payables through explicit collection and payment assumptions. Capital expenditure, depreciation, taxes and financing belong in supporting schedules with a clear connection to the three statements.
Illustrative worked example
A sale increases revenue immediately but cash arrives after collection. With slower collections, receivables rise and cash funding needs increase even if profit is unchanged.
Checks detect errors, not unrealistic assumptions
Use balance-sheet, cash roll-forward and debt roll-forward checks. Test scenarios and inspect whether outputs change in plausible directions. Keep inputs separate and label units and periods. A balanced model can still contain unsupported growth or margins, so pair formula checks with evidence review.
Illustrative worked example
Doubling unit volume should change variable costs and working capital; if only revenue changes, the linked operating model is incomplete.
Frequently asked questions
Educational content — not an audit, assurance opinion, or investment or legal advice.
