MODULE 7: COMPANY ANALYSIS: FORECASTING

Forecasting: The Analyst's Job Before Valuation

1. Forecasting is where you turn the company story into numbers. Valuation needs future revenue, margins, working capital, capital expenditure, debt, and equity assumptions. If the forecast is lazy, the valuation is fake precision.
2. The source module gives four common forecast objects: drivers of financial statement lines, individual financial statement lines, summary measures, and ad hoc objects.
3. Forecast objects should be disclosed regularly or directly calculable from regularly disclosed items. If you forecast something management never reports, you may build a beautiful model that cannot be checked later.
4. Drivers are the most explainable. For a retailer, drivers could be stores, members, average basket size, and sales per square foot. For an airline, drivers could be routes, capacity, passengers, and ticket yield.
5. Individual line items are simpler. Instead of forecasting every cost driver, you may forecast revenue, cost of sales, operating expenses, and operating income directly.
6. Summary measures are efficient but less transparent. Forecasting gross margin or asset turnover is faster, but you lose detail about what caused the change.
7. Ad hoc objects are special one-off items, such as a legal settlement, asset sale, restructuring charge, or unusual loss. Do not mix these into normal recurring revenue or operating cost forecasts.

Forecast Approaches

1. Historical results are the default when the business is stable and the past is a reasonable guide. Think of a mature consumer staples company with steady demand.
2. Historical base rates and convergence are used when a company is moving toward an industry norm. A fast-growing firm may slowly converge toward normal industry growth, margins, and capital intensity.
3. Management guidance can be useful for items management controls, such as capital spending, store openings, or planned debt levels.
4. Management guidance is weaker for macro variables. Management usually does not have a magic edge in forecasting GDP, commodity prices, interest rates, or the business cycle.
5. Analyst discretion is needed when history is not enough: new business models, strategy changes, disrupted industries, cyclicality, or unique company events.
6. A clothing brand moving from luxury into mass market should not be forecast by blindly extending its old margins. The business itself is changing.

Forecast Horizon

1. Forecast horizon depends on the investment strategy, industry cyclicality, company-specific change, and the analyst's use case.
2. For a cyclical company, the forecast period should cover enough of the cycle to avoid mistaking a peak year for normal earnings.
3. For a company in transition, the forecast should run long enough for the new strategy to show up in the financial statements.

Revenue Forecasts

1. Revenue can be forecast top-down or bottom-up.
2. Top-down starts with market size and market share. Example: estimate national retail sales first, then estimate the company's share of that market.
3. Bottom-up starts with operating drivers. Example: forecast stores, customers per store, units per customer, and average selling price.
4. Top-down keeps you honest about the size of the pool. Bottom-up shows the gears inside the business.
5. Non-recurring revenue should be separated. Do not let one asset sale or currency effect pollute the recurring revenue forecast.
6. Commodity prices can affect both revenue and cost of sales. Whether higher input prices can be passed to customers depends on competition and demand elasticity.

Operating Expenses and Working Capital

1. Operating cost forecasts must be coherent with revenue forecasts. If a low-margin product is growing faster than the rest of the business, the overall margin should usually weaken.
2. Gross margin forecasts should reflect product mix, input costs, pricing power, competition, and hedging.
3. Fixed costs and variable costs should not be forecast the same way. Fixed costs may move slowly; variable costs often follow volume, prices, or commodity inputs.
4. Working capital forecasts usually use efficiency ratios with revenue and operating cost forecasts.
5. Receivables follow sales and collection speed. Inventory follows sales, cost of sales, and inventory days. Payables follow purchases and payment terms.
6. Do not simply grow every current asset and current liability by the sales growth rate. Each line has its own driver.

Capital Investments and Capital Structure

1. Capital expenditure forecasts can separate maintenance spending from growth spending.
2. Maintenance capital expenditure is often linked to depreciation and amortization because it keeps existing assets productive.
3. Growth capital expenditure is tied to expansion plans, new stores, new factories, new systems, or capacity needs.
4. If capital expenditure happens in bursts, capacity usage may explain it better than a smooth historical average.
5. Capital structure forecasts should consider historical leverage, target leverage, free cash flow, dividend policy, buybacks, debt maturity, and management strategy.
6. Earnings before interest, taxes, depreciation, and amortization can be useful for leverage forecasts because debt capacity is often discussed relative to that measure.

Scenario Analysis

1. Scenario analysis means building several possible futures instead of pretending one forecast is destiny.
2. A base case is the normal expected path. An upside case captures better demand, stronger pricing, or better execution. A downside case captures weak demand, cost inflation, competition, or strategy failure.
3. Scenario analysis is especially useful when risk factors can move the business in very different directions, such as regulation, technology, commodity prices, or cyclicality.
4. A good forecast does not just say what happens. It shows which assumptions matter most and what would break the thesis.