Financial Statement Analysis

Three-Statement Model: Linking IS, Balance Sheet and Cash

A three-statement model links the income statement, balance sheet and cash flow statement so that every change flows through all three. Net income starts the cash flow statement, non-cash items and working capital changes adjust it to operating cash flow, and the ending cash balance feeds the balance sheet. If the links are correct, assets always equal liabilities plus equity.

How do the three financial statements connect?

The income statement measures performance over a period on an accrual basis: revenue earned less expenses incurred. The balance sheet is a snapshot of what the company owns and owes at a point in time. The cash flow statement explains how cash moved between two balance sheet dates. The three are linked by a small number of relationships, and once those are understood, any transaction can be traced through all three statements. That traceability is what makes an integrated model useful for analysis and for spotting errors in reported numbers.

The primary links are straightforward. Net income from the income statement flows into retained earnings on the balance sheet and is also the starting point of the cash flow statement under the indirect method. Depreciation reduces net income and net fixed assets but is added back in operating cash flow because it involves no cash. Changes in working capital accounts on the balance sheet appear in operating cash flow. Capital expenditures increase fixed assets and appear in investing cash flow. Debt and equity changes appear in financing cash flow. Finally, the net change in cash updates the cash balance.

How is the income statement forecast?

Forecasting begins with revenue drivers rather than a single growth rate. For a product business that may be volume and price by segment; for a services firm it may be billable headcount, utilization and rates; for a subscription business it may be customer counts, retention and average revenue per account. Cost of goods sold is then driven by unit costs or a gross margin assumption grounded in history. Operating expenses are split between those that scale with revenue and those that are largely fixed or step with headcount.

Depreciation should come from a fixed asset schedule rather than a percentage of revenue, because it depends on the asset base and its useful lives. Interest expense should come from the debt schedule, which creates a link to the balance sheet and, often, a circular reference through cash. Taxes should apply a realistic effective rate and recognize that book tax expense can differ from cash taxes paid. Keeping each driver visible and separately labeled lets reviewers adjust a single assumption and see its effect ripple through all three statements.

How are balance sheet accounts projected?

Working capital accounts are typically driven by turnover days tied to income statement lines: receivables by days sales outstanding on revenue, inventory by days on hand on cost of goods sold, and payables by days payable on cost of goods sold or purchases. Accrued expenses and deferred revenue can be driven as a percentage of the related expense or revenue. These relationships connect balance sheet growth to operating activity and determine how much cash is absorbed or released as the business changes size.

Fixed assets roll forward from the opening balance plus capital expenditures less depreciation and disposals. Debt rolls forward from the opening balance plus borrowings less repayments. Equity rolls forward from the opening balance plus net income, plus any stock issued, less dividends and buybacks. Cash is not forecast directly on the balance sheet; it is the result of the cash flow statement. Treating cash as the output rather than an input is what guarantees the balance sheet will balance when every other link is correct.

• PP&E: opening + capex - depreciation - disposals
• Debt: opening + draws - repayments
• Retained earnings: opening + net income - dividends
• Cash: output of the cash flow statement, never a plug

How is the cash flow statement built under the indirect method?

Operating cash flow starts with net income and adds back non-cash charges such as depreciation, amortization, stock-based compensation and deferred taxes. It then adjusts for changes in operating assets and liabilities: an increase in receivables or inventory uses cash, while an increase in payables or accrued liabilities provides cash. Gains and losses on asset sales are removed because the cash proceeds belong in investing activities. The result shows how much cash the core business generated, which often differs sharply from net income in growing or seasonal companies.

Investing cash flow captures capital expenditures, acquisitions, asset sales and investment purchases. Financing cash flow captures borrowings, repayments, equity issued and dividends or distributions. Every line on the cash flow statement should correspond to a change in a balance sheet account. A useful audit is to list every balance sheet line and confirm where its change appears on the cash flow statement; any balance sheet movement without a corresponding cash flow entry is a likely source of an imbalance or a misstated cash figure.

Why does a model fail to balance, and how do you fix it?

Imbalances almost always come from a broken link: a balance sheet account that changes without a matching cash flow entry, a sign error on a working capital change, or an item counted twice. The fastest diagnosis is to compute the imbalance for each period and find the first period where it appears. If the imbalance is constant, the problem is usually in the opening balance sheet. If it grows, a flow item is being missed or double counted, and its size often matches the amount of a specific line.

Checking the sign convention on working capital is a reliable first step, since increases in assets should reduce cash and increases in liabilities should add it. Next, confirm that non-cash items added back on the cash flow statement are the same amounts recorded on the income statement and balance sheet. Never insert a plug to force the balance; a hard-coded balancing figure hides an error that will distort cash, debt capacity and covenant calculations. A clean model includes a visible check row that shows zero in every period.

Tracing one year through all three statements

1. Income statement: revenue 1,000; COGS 600; operating expenses 250; depreciation 50; interest 20. Pre-tax income = 1,000 - 600 - 250 - 50 - 20 = 80. Tax at 25% = 20. Net income = 60.
2. Operating cash flow: 60 + depreciation 50 - increase in receivables 15 - increase in inventory 10 + increase in payables 8 = 93.
3. Investing cash flow: capital expenditures of 70, so -70. Financing cash flow: debt repayment 25 and dividends 5, so -30.
4. Net change in cash = 93 - 70 - 30 = -7. Beginning cash 40, ending cash 33.
5. Change in assets: cash -7, receivables +15, inventory +10, net PP&E +70 - 50 = +20. Total = +38.
6. Change in liabilities and equity: payables +8, debt -25, retained earnings +60 - 5 = +55. Total = +38. The balance sheet balances.

How underwriters apply this

• Rebuild or audit the borrower's model to confirm cash is an output and that a check row shows zero every period.
• Compare forecast working capital days with history; improving days that release cash are a common source of overstated free cash flow.
• Confirm that interest in the income statement ties to the debt schedule and that repayments reduce debt on the balance sheet.
• Reconcile historical operating cash flow with net income to understand the quality and timing of earnings before trusting projections.
• Use the integrated model to test covenants, because leverage and coverage depend on balance sheet and income statement together.

Frequently asked questions

Keep reading

Educational content written by practitioners. Not investment, accounting, legal or tax advice.