How to Build a Three-Statement Financial Model from Scratch

A three-statement model is the cornerstone of equity research and corporate finance. It links the income statement, balance sheet, and cash flow statement so that a change in any assumption ripples through the entire model. Getting this right means your forecasts stay internally consistent -- revenue growth drives working capital, depreciation feeds back from capex, and net income flows into retained earnings.

Start with the income statement. Revenue is your anchor. From there, project cost of goods sold (often as a percentage of revenue), operating expenses, and work your way down to net income. The key is to separate items you can forecast with confidence from those that are more volatile. Revenue growth rates, gross margins, and operating leverage are the levers that matter most.

Next, build the balance sheet. Current assets and liabilities are typically modeled as days outstanding -- days sales outstanding for receivables, days payable outstanding for payables, and days inventory outstanding for inventory. Fixed assets grow with capital expenditures and shrink with depreciation. Debt balances change with issuances and repayments.

The cash flow statement is where everything comes together. Start with net income, add back non-cash charges like depreciation, adjust for changes in working capital, subtract capex, and account for financing activities. The ending cash balance should tie exactly to the balance sheet. If it does not, there is a broken link somewhere.

Once the three statements are linked, you can layer on a DCF valuation. Project free cash flow to the firm (FCFF) from the model, discount at your weighted average cost of capital, add a terminal value, and bridge from enterprise value to equity value. The entire process becomes much faster and more reliable when the underlying model is solid.

Common pitfalls include circular references (interest expense depends on debt, which depends on cash, which depends on interest expense), sign convention errors, and forgetting to link depreciation from the balance sheet back to the cash flow statement. A well-structured model avoids these by keeping formulas transparent and auditable.