The build order
A three-statement model begins with clean history, operating drivers, and supporting schedules. The statements should be outputs of the business logic, not independent forecasts that are forced to match.
Historical setup
Standardize the income statement, balance sheet, cash-flow statement, and equity information. Confirm that assets equal liabilities plus equity and that cash movement reconciles. Map company-specific line items into a stable model structure without deleting economically important detail.
Revenue schedule
Build revenue from drivers appropriate to the business: units, customers, locations, capacity, utilization, price, mix, contracts, or market share. Segment when necessary. The model should explain why growth occurs rather than apply a percentage to the prior year indefinitely.
Cost and margin schedule
Separate cost categories that behave differently. Model variable cost as a function of volume or revenue where appropriate, fixed cost with inflation or step changes, and capacity investment when growth requires it. Avoid forcing every margin smoothly toward a target without operational support.
Working capital
Forecast receivables, inventory, payables, deferred revenue, and other operating accounts using turnover, days, or operational relationships. Consider seasonality and business-model changes. The cash impact is the period change, not the ending balance.
Fixed assets and depreciation
Roll property and equipment from beginning balance plus capital expenditures minus depreciation and disposals. Separate maintenance and growth capex when useful. Depreciation should follow asset lives and investment timing rather than a simple percentage if the business is changing materially.
Debt and interest
Build each debt tranche with opening balance, issuance, mandatory amortization, optional repayment, maturity, interest rate, cash interest, and fees. Interest may depend on average debt, creating circularity when cash flow determines repayment. Use a controlled iterative setting, a switch, or an algebraic solution and document it.
Taxes
Forecast book tax and cash tax with attention to jurisdiction, net operating losses, interest limitations, deferred taxes, and transaction-specific items. A simple effective rate can be sufficient for a high-level model but should be labeled as an approximation.
Equity and shares
Roll retained earnings using net income and dividends. Model issuance, repurchases, stock compensation, options, restricted units, convertibles, and other diluted-share effects. EPS depends on the weighted-average diluted count, not only ending shares.
Cash and revolver
Set a minimum cash balance. Excess cash can repay a revolver or debt; deficits can draw available facilities. Confirm that the company has the capacity to fund operations and that the model doesn't allow negative cash without a financing response.
Linking the statements
Net income feeds retained earnings and the cash-flow statement. Depreciation reduces income, accumulates against fixed assets, and is added back in operating cash. Working-capital changes affect cash and the related balance-sheet accounts. Debt affects cash, interest, and the balance sheet. The final cash-flow result updates cash.
Checks and diagnostics
The balance sheet must balance for a reason. Review cash conversion, leverage, interest coverage, working-capital days, capex intensity, return on capital, and scenario behavior. A plug in “other assets” can hide a broken model and should never be the solution.
Forecasting discipline
The model is a representation of assumptions, not a prediction engine. Show base, downside, and upside cases, and identify the variables that determine liquidity and value. The most useful model makes the business debate visible.