Three-Statement Model
Integrated financial model linking the income statement, balance sheet, and cash flow statement.
FAQs
Why does the balance sheet need to balance in a three-statement model?
The balance sheet must balance (assets = liabilities + equity) because it reflects the fundamental accounting equation: everything a company owns (assets) must be financed by either what it owes (liabilities) or what owners contributed/earned (equity). In a well-built model, the balance sheet balances automatically if all linkages are correctly implemented—cash (from the ending cash per the cash flow statement) is the 'plug' that makes assets equal liabilities plus equity. If the balance sheet doesn't balance, the model has an error: a missing or double-counted item, an incorrect linkage, or inconsistent assumptions between statements.
What is the correct order to build a three-statement model?
The conventional sequence: (1) Build the income statement first—project revenues and costs through to net income; (2) Build the balance sheet structure (assets, liabilities, equity sections) with historical data as the starting point; (3) Build the cash flow statement, starting with net income and adding operating adjustments, then investing (capex from balance sheet assumptions), then financing; (4) Plug cash flow ending balance back into the balance sheet cash line; (5) Add the debt schedule (revolver, term loans) to handle financing needs and interest expense; (6) Wire together any remaining circular linkages (interest expense → income statement → net income → cash flow → debt balance → interest expense). Test balance sheet balance at every step.
How do non-cash charges like depreciation and stock-based compensation flow through the three statements?
Non-cash charges appear on the income statement (reducing pre-tax income and net income) but are added back on the cash flow statement (because they don't represent actual cash outflows), netting to zero effect on cash. Depreciation also reduces PP&E on the balance sheet. Stock-based compensation (SBC) is expensed on the income statement (reducing net income), added back on the cash flow statement, and increases additional paid-in capital (APIC) on the balance sheet equity section—reflecting the equity value transferred to employees. Understanding non-cash charges is essential for EBITDA reconciliation, free cash flow calculation, and evaluating whether reported earnings accurately represent cash generation.
Related Terms
Financial Modeling
Building quantitative representations of a company's finances to support decision-making and valuation.
Discounted Cash Flow
A valuation method that estimates the present value of a company or investment by discounting projected future cash flows at an appropriate rate.
LBO Model
Financial model analyzing private equity returns from a leveraged buyout at various exit scenarios.
Merger Model
Financial model assessing the accretion or dilution to acquirer EPS resulting from an acquisition.