Three-Statement Model: How All Three Financials Link

Key Takeaways

• A three-statement model connects income statement, balance sheet, and cash flow statement so every assumption change cascades through all three reports automatically.
• Capex flows to PPE and then to depreciation on both the income statement and cash flow statement, a single missed link breaks the balance check.
• The most common mistake is building three tabs that do not share inputs; a collection of disconnected spreadsheets is not an integrated model.
• Every downstream model, DCF, LBO, merger model, is built on top of a working three-statement model, making this the most foundational skill in financial modeling.

What It Is

The three-statement model is a connected set of Excel schedules that projects future financial performance. You forecast revenue and expenses on the income statement, roll balance sheet accounts forward using drivers or ratios, and reconcile the two with a cash flow statement. Change one assumption and every dependent cell updates.

The phrase "integrated" is load-bearing. A spreadsheet with three tabs that do not talk to each other is not a three-statement model. The statements must share inputs and outputs so that, when the balance sheet balances, you have a consistent view of the business.

The Intuition

The three statements answer three different questions about the same company. The income statement asks how profitable the period was. The balance sheet asks what the company owns and owes at a point in time. The cash flow statement asks where actual cash came from and went. A healthy business often shows profit on one statement and cash drain on another, so you need all three to see the full picture.

Linking them in a model forces internal consistency. If you raise the capex assumption, depreciation should rise in future years, cash should drop, and property, plant and equipment (PPE) on the balance sheet should climb. If any one of those links is missing, the model gives you the wrong answer somewhere.

How It Works

Four link types do almost all the work. Get these right and the model balances.

Net income to retained earnings. The bottom line of the income statement is added to retained earnings on the balance sheet each period, minus any dividends paid.

Net income to cash flow from operations. Net income is the starting line of the cash flow statement's operating section. Non-cash items (depreciation, amortization, stock-based comp) are added back, and changes in working capital are reflected.

Capex to PPE to depreciation. Capital expenditures flow through the investing section of the cash flow statement and increase PPE on the balance sheet. Depreciation reduces PPE and appears both as an expense on the income statement and as an add-back on the cash flow statement.

Cash flow statement to balance sheet cash. The ending cash balance at the bottom of the cash flow statement is the cash line on the balance sheet. This is the single most important link for the balance check.

Balance check:
  Total assets = Total liabilities + Total equity
  If the difference is not zero, a link is broken.

Debt schedules, revolver plugs, and working capital schedules then feed into this core. Each of those gets its own article.

Worked Example

A simplified one-year projection for a hypothetical manufacturer, starting from year 0 balances.

Year 0 balance sheet (selected lines):

Cash             100
PPE              500
Total assets     600
Debt             200
Equity           400

Year 1 income statement drivers:

Revenue                1,000
Operating expenses      (700)
Depreciation            (50)
Interest expense        (10)
Tax (at 25 percent)     (60)
Net income              180

Year 1 cash flow statement:

Net income                180
Add back depreciation      50
Change in working capital (20)
Capex                    (100)
Debt repayment            (30)
Net change in cash         80
Ending cash              180

Year 1 balance sheet:

Cash             180   (= 100 + 80)
PPE              550   (= 500 + 100 capex - 50 depn)
Total assets     730
Debt             170   (= 200 - 30)
Retained earnings 180  added to equity
Equity           560   (= 400 + 180 net income, no dividends)
Total L+E        730

Assets equal liabilities plus equity, so the balance check passes. If the capex figure were entered on the cash flow statement but forgotten on PPE, the balance sheet would miss by 100.

Common Mistakes

1. No balance check formula. Every model needs a single cell that computes total assets minus total liabilities and equity. Without it, you can stare at a broken model for hours. Put the check in the top-right corner of the balance sheet and highlight it red when non-zero.

2. Double-counting non-cash items. Depreciation is subtracted from revenue on the income statement and added back on the cash flow statement. Beginners sometimes also subtract it from PPE manually and then again through a separate link, cutting the asset in half.

3. Depreciation not flowing to both the income statement and cash flow statement. Depreciation has to hit both reports from the same source cell. Calculating it twice with different formulas is the most common reason models drift out of balance over time.

4. Missing equity-method investments or minority interest. If the company owns a stake in another business accounted for under the equity method, the income line flows to equity on the balance sheet, not to revenue. Dropping this link in a model of a holding company produces a silent error.

5. Broken signs on the investing section. Capex is a cash outflow, so it is negative on the cash flow statement, but it is a positive addition to PPE on the balance sheet. Mixing the signs is a classic Friday-afternoon bug.

Frequently Asked Questions

Q: What is a three-statement model in simple terms? A three-statement model is a set of linked Excel schedules that projects a company's income statement, balance sheet, and cash flow statement together. Change one assumption and every dependent cell updates across all three reports.

Q: How does a three-statement model affect investment decisions? It forces internal consistency, so an investor or analyst cannot accidentally assume higher profits without also reflecting the cash drain or balance sheet change that comes with them. Valuation models built on top of it inherit that consistency.

Q: What is a real-world example of a three-statement model in use? In an LBO model, the debt schedule feeds interest expense to the income statement, reduces cash on the cash flow statement, and updates the debt balance on the balance sheet each year. Any of those three links missing produces a broken model that gives wrong answers silently.

Q: How can investors use the three-statement model? Investors can use it to stress-test management guidance: change a revenue growth rate and see what actually happens to free cash flow and leverage ratios rather than accepting a summary slide at face value.

Q: How is a three-statement model different from a simple income statement forecast? An income statement forecast projects earnings in isolation. A three-statement model also tracks where cash goes (cash flow statement) and what the company owns and owes at each period end (balance sheet), including the balance check that catches broken links the income statement alone cannot catch.

Sources

1. Wall Street Prep. "3-Statement Model | Complete Guide (Step-by-Step)." https://www.wallstreetprep.com/knowledge/build-integrated-3-statement-financial-model/
2. Wall Street Prep. "How Are the Three Financial Statements Linked?" https://www.wallstreetprep.com/knowledge/how-are-the-financial-statements-linked/
3. Mergers & Inquisitions. "3-Statement Model: Full Tutorial, Guide, and Excel File." https://mergersandinquisitions.com/3-statement-model/
4. Corporate Finance Institute. "What is a 3-Statement Model? Your Complete Guide." https://corporatefinanceinstitute.com/resources/financial-modeling/3-statement-model/

Disclaimer

This article is educational content only and is not financial advice. Nothing here is a recommendation to buy, sell, or hold any security. Consult a licensed advisor before making investment decisions.