On this page · 5 parts
How is a three-statement model built?
A three-statement financial model forecasts a business’s profit and loss (P&L), balance sheet and cash flow statement together, in one Excel workbook, with every line linked. Change one assumption, such as price, wages or an interest rate, and all three statements move together.
Analysts call it an integrated financial model or a 3-statement model; Australian accountants and lenders often say three-way forecast. Same thing. It is the heart of financial modelling (or modeling), and the base almost every other model sits on: a budget, a loan application, a capital raise and a discounted cash flow valuation all start from these three linked statements.
A well-built one runs in the same order every time:
- Inputs: every assumption on one sheet, from prices and volumes to wage rates, debtor days and interest rates.
- Revenue and costs, built from drivers such as customers, prices, staff and rent.
- Capital spending and depreciation, asset by asset or by class.
- Working capital: debtors, stock and creditors, plus the GST and tax you owe.
- Funding: loans, interest and repayments, equity raised and dividends paid.
- The three statements, followed by the checks that prove they agree.
How do the three statements link?
The links are what make it a model, not three separate forecasts. Follow one year of profit through the statements and you meet every one of them.
Take a café that makes $60,000 profit after $10,000 of depreciation. Its stock rises $5,000, it spends $40,000 on a kitchen upgrade and it repays $15,000 of its loan. Cash rises by only $10,000, and the balance sheet still balances: assets up $45,000, the loan down $15,000, retained earnings up $60,000.
- Net profit closes the P&L, adds to retained earnings on the balance sheet and starts the operating cash flow.
- Depreciation is an expense but not a payment: the cash flow adds it back and the balance sheet writes the asset down.
- Working capital is timing. When debtors or stock rise, cash falls behind profit; when creditors rise, cash runs ahead of it.
- Capital spending (capex) is an investing outflow that adds to property, plant and equipment, which then depreciates.
- Tax is charged in the P&L but paid later, so tax payable sits on the balance sheet in between.
- Loans drawn and repaid, equity raised and dividends paid run through financing cash flow and the balance sheet. Only interest reaches the P&L.
- Closing cash on the cash flow statement becomes cash on the balance sheet. That final link is what lets it balance.
- Assets up 45,000 = loan down 15,000 + profit kept 60,000
- Closing cash agrees to the balance sheet
- The balance sheet balances
Why does a balance sheet fail to balance?
The balance check is one line: total assets, less liabilities and equity, must come to zero in every period. If it doesn’t, a link is broken. In hand-built models and downloaded templates, the cause is usually one of these:
- An opening balance sheet that doesn’t balance itself, so the model is out from day one.
- A typed-in number in the cash flow, so cash stops following the other two statements.
- Profit that never reaches retained earnings, or dividends taken off twice.
- A sign flipped on working capital: a rise in debtors should reduce cash, not add to it.
- A circular reference from charging interest on closing balances, which needs iterative calculation and can hide real errors.
- Formulas pointing at the wrong row or year after someone inserted a column.
- A plug: a balancing figure that forces the balance sheet to agree and buries the real error.
How do lenders and investors read one?
They start with cash, not profit. The lowest closing cash balance in the forecast, and the month it falls in, shows how much funding the business needs and when.
Banks then check that operating cash flow covers interest and repayments with room to spare (the debt service cover ratio), and that the forecast squares with your recent results. Investors look at growth, margins and how long the cash lasts before the business pays its own way.
The balance sheet shows where it all ends up: what the business owns, what it owes and the equity in between. Debt that climbs every year while profit grows deserves a second look.
Then everyone tests the assumptions. Keep them on one sheet with a source against each, and a reader can challenge the few that matter instead of the whole model.
Can I get one built instead of a template?
A free three-statement financial model template gives you the frame and leaves the hard part to you: bending it to your revenue lines, costs, assets and debt. Every row you add is a new chance to break a link.
We build yours free from your description, documents or website, assembled from 1,500+ tested building blocks. Periods can be monthly, quarterly, half-yearly or annual, for up to 30 years. Interest runs on opening balances, so there are no circular references.
You get a standard .xlsx with every formula intact and no macros: inputs in blue with their sources, the three statements, a valuation, scenarios, a dashboard, a Checks sheet and a How It Works sheet that explains each part of the model.
Every model is checked to balance in every period and reviewed by our team before it reaches you, usually within the hour. Preview every sheet online, ask for changes, then download.