How to Build a Three-Statement Model in Excel

A three statement model ties the income statement, balance sheet, and cash flow statement into one connected forecast. You build the income statement first, drive most balance sheet items off it, then construct the cash flow statement from changes in the other two. The model is correct only when the balance sheet balances, and that depends on routing ending cash from the cash flow back into the balance sheet.

What the three statement model is and how it fits together

A three statement model forecasts the three core financial statements so that they move as one. The income statement reports profit, the balance sheet reports the financial position at a point in time, and the cash flow statement explains how cash moved between two balance sheet dates. None stands alone; each pulls from the others.

The standard build order is income statement, then balance sheet, then cash flow statement. You forecast revenue and expenses down to net income, drive working capital and fixed assets on the balance sheet off income statement drivers, and then reconstruct cash flow from the period over period changes in those balance sheet accounts plus the non cash items on the income statement.

The single test of correctness is that total assets equals total liabilities plus equity in every forecast period. If it does not balance, a link is missing or has the wrong sign.

Build the statements step by step

Below is a compact one period layout that shows where each number originates. Inputs are blue, formulas pull from prior lines, and ending cash flows back to the balance sheet.

1. Forecast the income statement: revenue, costs, EBITDA, depreciation, interest, taxes, down to net income.
2. Project balance sheet operating items: accounts receivable, inventory, and payables off revenue and cost drivers; net PP&E off capex and depreciation.
3. Roll retained earnings forward: beginning retained earnings + net income - dividends.
4. Build the cash flow statement: start with net income, add back depreciation, subtract the increase in net working capital, subtract capex, and add or subtract financing flows.
5. Sum to ending cash and link that ending cash back to the cash line on the balance sheet.
6. Add a revolver or cash plug so the balance sheet closes when operating cash is short or in surplus.

Ending cash from the cash flow statement is the cash line on the balance sheet, which is what closes the model.

The key links between the statements

Three links carry most of the connectivity. Net income flows into retained earnings on the balance sheet and is the top line of the cash flow statement. Depreciation reduces income but is added back on the cash flow statement because it is non cash. Ending cash on the cash flow statement is the cash balance on the balance sheet.

• Retained earnings: =prior_RE + net_income - dividends.
• Cash flow start: =net_income at the top of cash flow from operations.
• D&A add-back: =+depreciation inside cash flow from operations.
• Balance sheet cash: =ending_cash from the bottom of the cash flow statement.
• Revolver plug: if cash falls below a minimum, draw on the revolver; if surplus, repay it, and feed interest back to the income statement.

Pitfalls and what reviewers check

The most common failure is a balance sheet that does not balance. Build a check row, =total_assets - total_liabilities_and_equity, and require it to read zero in every period. A nonzero check usually means a cash flow line has the wrong sign or a balance sheet item is not linked to its cash flow driver.

Reviewers also confirm that the model has no plugs hardcoded into cash, that interest on the revolver feeds back into the income statement, and that signs on working capital changes are correct. An increase in receivables uses cash, so it is a negative on the cash flow statement.

Watch for circularity introduced by interest on average cash or debt. If you enable it, turn on iterative calculation and isolate the switch so you can break the loop while auditing.