5 - Forecasting 11.18.2024
Module 5: Forecasting Overview
Page 1: Introduction to Module 5 Forecasting
Introduction to the principles and methods underlying forecasting in financial contexts.
Page 2: Key Forecasting Principles
Roadmap for understanding the concepts of forecasting revenues, income statements (I/S), and balance sheets (B/S).
Page 3: General Thoughts about Forecasting
Art vs. Science: Forecasting is more of an art than a strict science.
Methods: No single correct method for forecasting exists.
Assumptions Impact Quality: Quality of forecasts is largely derived from the soundness of assumptions.
Garbage in, garbage out concept.
Reasonable Assumptions: Strive to base assumptions on intuition and economics.
Forecast Quality: A high-quality forecast may not necessarily be accurate; understanding bias vs. noise in assumptions is crucial.
Process Focus: Understand the rationale behind assumptions, rather than just seeking perfect balance in outputs.
Page 4: Importance of Forecasting for Valuations
Future Cash Flows: Critical to forecast future cash flows to properly value a company.
Estimation of Profits:
For Free Cash Flow to Firm (FCFF): Start with after-tax operational income (EBIT(1-t) or NOPAT).
For Free Cash Flow to Equity (FCFE): Start with net income, since equity holders are last in line for cash flow.
Reinvestment Needs: Growth often requires reinvestment in net operating assets.
1-Year Forecasts: This course focuses on forecasting I/S and B/S for just one year; true comprehensive forecasting extends beyond this time frame.
Page 5: FCFF and FCFE Defined
FCFF: Represents cash flows available to all capital suppliers after reinvestments.
FCFE: Represents cash flows available to common stockholders after accounting for debt payments and reinvestments.
Formulas:
FCFF = NOPAT - Net Capital Expenditures + Changes in Working Capital
FCFE = Net Income - Equity Reinvestments - Net Debt Issuance + Debt Repayment
Page 6: General Order of Forecasting
Forecasting Sequence: Sales forecast → Income Statement → Balance Sheet → Cash Flows.
Key Focus: Top-line sales forecasts drive all other forecasts.
Assumptions: Can be based on historical data, industry data, or firm guidance. Logically derived assumptions yield the best results.
Page 7: Income Statement Structure
Revenues: Start with next year's sales forecast.
Operating Expenses: Estimate based on gross margin, SG&A, R&D ratios.
Interest Expenses: Estimate from expected costs of debt and outstanding debt levels.
Tax Rate: Determine anticipated tax rates.
Page 8: Adjusting for Earnings Quality
Earnings Quality Definition: High quality earnings are those that persist over time.
Differences: Earnings quality can vary based on management practices regarding accruals.
Core Earnings: Adjustments may be necessary to isolate core earnings from management manipulations.
Page 9: Adjusting for Non-Recurring Items
Adjustment Purpose: Focus on the firm’s sustainable core earnings by removing one-time items.
Common Non-Recurring Adjustments include:
Restructuring expenses.
Litigation costs.
Discontinued operations.
Adjustments for inventory valuation methods (e.g., LIFO vs FIFO).
Page 10: Using Firm Guidance from Conference Calls
Case Example: Firm guidance from P&G’s conference call outlines revenue growth expectations, tax rates, CAPEX, and dividends for the fiscal year 2023.
Page 11: Forecasting P&G's Income Statement
Net Sales Growth: Use guidance to project net sales and analyze cost of goods sold (COGS).
Expense Ratios: Maintain stable ratios of SG&A as a percentage of sales unless data suggests otherwise.
Page 12: Considerations without Firm Guidance
Analyzing Other Analysts: Investigate performance relative to industry peers and historical investment levels to determine growth projections.
Revenue Estimations: Top-line revenue is pivotal in overall valuation efforts.
Page 13: COGS & Gross Margin Analysis
Inflation Impact: Post-COVID inflation negatively affected gross margins for FY2022.
Cost Management: Considerations of cost increases in commodities and transportation on overall gross margin.
Page 14: SG&A Expense Structure
Definition: Includes overhead costs incurred to operate the business.
Margin Impacts: Decrease in SG&A margin due to economies of scale from increased sales and reduced general costs.
Page 15: Interest Expense Overview
Debt Structure: Analyze both short-term and long-term debt structures to estimate interest.
Assumed Debt Levels: No new debt is assumed, focusing instead on contractual obligations.
Page 16: Income Tax Expense Considerations
Guidance Utilization: Use P&G's tax rate guidance unless other adjustments are needed based on past performance.
Estimate taxes based on pre-tax earnings and expected tax rates.
Page 17: Adjusting for Acquisitions
Pro Forma Analysis: Adjust historical data following acquisitions for accurate growth comparisons.
Example: P&G's acquisition of Gillette affecting subsequent sales forecasts.
Page 18: Adjusting for Discontinued Operations
Disconnecting Variables: Exclude sales and expenses from discontinued operations from forecasts to maintain validity.
Page 19: Balance Sheet Forecasting Assumptions
Forecasting Structure: Begin with asset estimates followed by liability and equity estimates.
Working Capital Accounts: Percentage of sales metrics drive these estimates.
Page 20: Balance Sheet Forecasting Details
Utilize Historical Relationships: Maintain stable relationships of current assets and liabilities as a percentage of sales.
Adjust estimates to reflect current economic conditions.
Page 21: Working Capital Accounts Dynamics
Cash Flow Cycle: Accounts Receivable, Inventory, and Accounts Payable are linked to sales forecasts, reflecting dynamic working capital needs.
Page 22: Long-Term Capital Expenditures Analysis
CAPEX Estimations: Use estimated sales to forecast necessary capital expenditures for growth.
Depreciation Considerations: Calculate depreciation to maintain accuracy in forecasts.
Page 23: Intangible Assets Management
Amortization of Intangibles: Project reductions in intangible assets based on expected amortization schedules.
Page 24: Managing Debt Structures
Short and Long-Term Debt: Reclassifications and payment assumptions to be integrated into forecasts with a focus on maintaining balance.
Page 25: Stock Buyback Forecasting
Treasury Stock: Consider guidance disclosures when forecasting future buyback activities and avoid unexpected changes.
Page 26: Dividends and Retained Earnings Structure
Payout Ratios: Estimate future dividends through historic payout ratios unless guidance is provided.
Guidance Utilization: Use projections for dividends to ascertain retained earnings adjustments.
Page 27: Retained Earnings Forecasting
Linkage to Net Income: Identify net income contributions and dividend payments to accurately project retained earnings balance.
Page 28: Detailed Balance Sheet Data
Comprehensive Review: Provide account balances, percentages, and calculations necessary for ensuring accurate forecasting.
Page 29: Plug for Cash Calculations
Cash Balance Estimation: Determine the necessary cash balance to maintain liquidity aligned with sales forecasts and operational requirements.
Page 30: Addressing Cash Balance Deficiencies
Adjusting Cash Levels: Explore methods to align cash balances with optimal levels by assessing operational strategies.
Page 31: Debt Issuance Impact
Financial Impacts: Analyze how additional debt affects interest expenses and net income by historical tax rates.
Page 32: Overall Debt Issuance Effects
Comprehensive Financial Review: Evaluate total impacts, including adjustments to net cash available after interest expenses are accounted for.
Page 33: Reassessing Overall Forecasts
Financial Alignment: Importance of adjusting forecasts based on current economic conditions, calling for sensitivity analysis on projections.