Company Analysis: Forecasting

Learning Objectives Coverage

LO1: Explain principles and approaches to forecasting a company’s financial results and position

Core Concept

Financial forecasting involves projecting future financial performance based on historical data, market conditions, and strategic assumptions. It is the bridge between historical analysis and equity valuation, enabling investment decisions and risk assessment. The key components are forecast objects (what to forecast), forecast approaches (how to forecast), and forecast horizon (how far to forecast).

Formulas & Calculations

• Main formula: Forecast = Historical Base × (1 + Growth Rate) × Adjustment Factors
• HP 12C steps:
  • Enter base value: [BASE] [ENTER]
  • Enter growth rate: 1 [+] [%] [×]
  • Result: Forecasted value
• Common variations: Top-down (market → company) vs Bottom-up (components → total)

Practical Examples

• Traditional Finance Example: Forecasting Microsoft’s revenue considering tablet cannibalization of PC sales
• Calculation walkthrough:
  • Base PC market: 360M units
  • Cannibalization factor: 30% consumer, 10% non-consumer
  • Result: 25.6M PCs cannibalized, reducing revenue by $2.2B
• Interpretation: Technology disruption can significantly impact traditional revenue streams

DeFi Application defi-application

Forecasting Uniswap v3 volume requires combining TVL growth projections with market share assumptions. Smart contracts automatically track metrics that enable real-time forecasting updates. The advantage is transparent on-chain data; the challenges are high volatility and limited historical data, which widen forecast confidence intervals significantly compared to traditional company analysis.

LO2: Explain approaches to forecasting a company’s revenues

Core Concept exam-focus

Revenue forecasting uses either top-down (market-based) or bottom-up (component-based) approaches. Revenue drives all other financial projections and valuation models, making it the most consequential forecast item. Key inputs include market size, market share, pricing, volume, and product mix.

Formulas & Calculations

• Top-down formula: Revenue = Market Size × Market Share
• Bottom-up formula: Revenue = Σ(Volume_i × Price_i) for all products i
• HP 12C steps for growth:
  • Prior revenue: [ENTER]
  • Growth rate: [%] [+]
  • New revenue displayed

Practical Examples

• Traditional Finance Example: Warehouse Club revenue forecast
• Calculation walkthrough:
  • Market growth: 3.4% annually
  • Market share gain: 2 bps per year
  • Store count: 4-6 new stores annually
  • Sales per store growth: 3.8%
• Interpretation: Multiple drivers validate revenue projections

DeFi Application defi-application

Forecasting Aave lending protocol revenue follows a formula: TVL growth multiplied by utilization rate multiplied by interest spread equals revenue. On-chain data provides real-time utilization metrics, making the top-down approach particularly accessible. However, utilization rates are highly variable — swinging from 30% to 90% depending on market conditions — which makes DeFi revenue forecasting inherently wider-ranged than traditional company forecasts.

LO3: Explain approaches to forecasting a company’s operating expenses and working capital

Core Concept formula

Operating expense forecasting links costs to revenue drivers while maintaining operational coherence. Profitability depends on accurate cost projections and efficiency assumptions, drawn from historical analysis and financial statement analysis. Key components include COGS, SG&A, and working capital efficiency ratios (DSO, DOH, DPO).

Formulas & Calculations

• Gross margin formula: Gross Margin = (Revenue - COGS) / Revenue
• Working capital formulas:
  • DSO = Accounts Receivable / (Revenue/365)
  • DOH = Inventory / (COGS/365)
  • DPO = Accounts Payable / (COGS/365)
• HP 12C calculation for DSO:
  • Revenue: 365 [÷]
  • AR: [SWAP] [÷]
  • Result: DSO in days

Practical Examples

• Traditional Finance Example: Siam Cement Group margin analysis
• Calculation walkthrough:
  • Input cost increase: Higher by 9.8%
  • Revenue increase: 6.1%
  • Gross margin compression: 250 bps
  • Operating margin decline: 240 bps
• Interpretation: Input cost inflation erodes margins when not fully passed through

DeFi Application defi-application

MakerDAO’s operational costs illustrate DeFi cost structure forecasting. Smart contract gas fees scale with transaction volume (a variable cost), oracle costs are relatively fixed, and development costs are managed through DAO governance votes. The result is lower operational leverage than traditional financial institutions but higher technical infrastructure costs. The absence of working capital needs (instant settlement) simplifies forecasting relative to traditional companies with complex cash conversion cycles.

LO4: Explain approaches to forecasting a company’s capital investments and capital structure

Core Concept

Capital forecasting separates maintenance capex from growth capex and projects leverage ratios. Capital allocation drives long-term value creation and financial flexibility — the ROIC vs. WACC framework from company analysis depends on getting these projections right. See also Corporate Issuers for capital structure theory.

Formulas & Calculations

• Maintenance Capex: ≈ Depreciation & Amortization expense × (1 + inflation)
• Growth Capex: Revenue Growth × Capital Intensity Ratio
• Leverage ratio: Debt / EBITDA
• HP 12C for Capex/Revenue:
  • Capex: [ENTER]
  • Revenue: [÷]
  • Result: Capital intensity %

Practical Examples

• Traditional Finance Example: YY Ltd. capital structure projection
• Calculation walkthrough:
  • Target Debt/EBITDA: 2.0x by year 6
  • EBITDA margin: 6.0%
  • Revenue CAGR: 5.2%
  • Implied debt increase: CNY 28B over 3 years
• Interpretation: Growth requires balanced capital structure expansion

DeFi Application defi-application

Compound protocol’s treasury management offers a DeFi case study in capital forecasting. Protocol-owned liquidity deployment and reserve requirements based on lending volume replace traditional capex. With no conventional debt, the protocol uses token incentives instead — offering flexible capital without debt covenants but introducing token dilution risk as the main cost of capital.

LO5: Describe the use of scenario analysis in forecasting

Core Concept exam-focus

Scenario analysis evaluates multiple potential outcomes based on different assumptions about key risk factors. Single-point forecasts inadequately capture uncertainty and risk, making scenario analysis essential for robust valuation. The key components are base case, bull case, bear case, probability weighting, and sensitivity analysis.

Formulas & Calculations

• Expected value: E(V) = Σ(Probability_i × Outcome_i)
• Sensitivity formula: ΔOutput / ΔInput = Sensitivity coefficient
• HP 12C for scenarios:
  • Store each scenario result
  • Weight by probability
  • Sum for expected value

Practical Examples

• Traditional Finance Example: Microsoft tablet cannibalization scenarios
• Calculation walkthrough:
  • Base case: 30% consumer, 10% non-consumer cannibalization
  • Bull case: 15% consumer, 5% non-consumer
  • Bear case: 40% consumer, 20% non-consumer
  • EPS impact: -$0.13to-$0.35 range
• Interpretation: Technology disruption creates wide range of outcomes

DeFi Application defi-application

Analyzing Uniswap v3 under different market conditions illustrates the necessity of scenario analysis in DeFi. The bull case assumes high trading volume with concentrated liquidity driving strong fee generation. The base case models moderate growth with normal spreads. The bear case projects low volume, wide spreads, and significant impermanent loss for LPs. On-chain data enables real-time scenario updating, but crypto volatility widens outcome ranges far beyond what traditional financial analysts typically encounter.

Core Concepts Summary (80/20 Principle)

Must-Know Concepts

1. Forecast Objects: Focus on regularly disclosed items that can be verified
2. Four Forecast Approaches: Historical results, base rates & convergence, management guidance, analyst discretion
3. Revenue Drivers: Top-down (market share) vs bottom-up (volume × price)
4. Cost Structure: Fixed vs variable cost analysis for operating leverage
5. Working Capital: Efficiency ratios drive balance sheet projections
6. Scenario Analysis: Multiple outcomes capture uncertainty

Quick Reference Table

Concept	Formula	When to Use	DeFi Equivalent
Revenue Growth	Market Growth × Share Change	Mature companies	TVL Growth × Market Share
Gross Margin	(Revenue - COGS) / Revenue	Cost analysis	(Fees - Gas Costs) / Fees
Working Capital	DSO × Daily Sales	Liquidity planning	Not applicable (instant settlement)
Leverage	Debt / EBITDA	Capital structure	TVL / Protocol Revenue
Scenario Analysis	Probability-weighted outcomes	High uncertainty	Essential for all DeFi

Comprehensive Formula Sheet formula

Essential Formulas

Top-Down Revenue Forecast:
Revenue = Market Size × Market Share × (1 + Growth Rate)
Where: Market Size = Total addressable market
       Market Share = Company's percentage of market
       Growth Rate = Expected change year-over-year

Bottom-Up Revenue Forecast:
Revenue = Σ(Units_i × Price_i) for all products/segments
Where: Units = Volume sold
       Price = Average selling price

Gross Margin Analysis:
Gross Margin % = (Revenue - COGS) / Revenue × 100
If input costs ↑X% and prices ↑Y%:
New Margin = [Rev(1+Y%) - COGS(1+X%)] / Rev(1+Y%)

Working Capital Ratios:
DSO = Accounts Receivable / (Revenue / 365)
DOH = Inventory / (COGS / 365)
DPO = Accounts Payable / (COGS / 365)
Cash Conversion Cycle = DSO + DOH - DPO

Capital Structure:
Debt/EBITDA = Total Debt / EBITDA
Interest Coverage = EBIT / Interest Expense
Debt/Equity = Total Debt / Total Equity

Variable Cost Estimation:
%Variable ≈ %Δ(Operating Costs) / %Δ(Revenue)
%Fixed = 1 - %Variable

HP 12C Calculator Sequences

Revenue Growth Projection:
Current Revenue: [ENTER]
Growth Rate: [%] [+]
Result: Next Period Revenue

Market Share Calculation:
Company Revenue: [ENTER]
Market Size: [÷]
100 [×]
Result: Market Share %

Working Capital Days:
Annual Amount: 365 [÷]
Balance: [SWAP] [÷]
Result: Days Outstanding

EBITDA Margin:
EBITDA: [ENTER]
Revenue: [÷]
100 [×]
Result: EBITDA Margin %

Scenario Expected Value:
Scenario 1: [ENTER]
Probability 1: [×]
[STO] 1
Scenario 2: [ENTER]
Probability 2: [×]
[RCL] 1 [+]
Result: Expected Value

Practice Problems

Basic Level (Understanding)

1. Problem: A company has 10% market share in a $50B market growing at 5% annually. What is the forecasted revenue if market share remains constant?

   • Given: Market size = $50B, growth = 5%, market share = 10%
   • Find: Next year revenue
   • Solution:
     • Next year market = $50B\times 1.05=$52.5B
     • Revenue = $52.5B\times 10$5.25B
   • Answer: $5.25 billion revenue forecast

2. Problem: Calculate DSO if accounts receivable is $100Mandannualrevenueis$1,200M.

   • Given: AR = $100M,Revenue=$1,200M
   • Find: Days Sales Outstanding
   • Solution: DSO = $100M/($1,200M/365) = 30.4 days
   • Answer: 30.4 days of sales outstanding

Intermediate Level (Application)

1. Problem: A retailer forecasts 20 new stores next year. Each store generates $5Mrevenueonaverage.Currentrevenueis$500M from 100 stores. Calculate revenue growth rate.

   • Given: Current: 100 stores, $500Mrevenue;Adding:20storesat$5M each
   • Find: Revenue growth rate
   • Solution:
     • New revenue = 20 × $5M=$100M
     • Total revenue = $500M+$100M = $600M
     • Growth rate = $100M/$500M = 20%
   • Answer: 20% revenue growth expected

2. Problem: If COGS increases 15% due to inflation but the company can only raise prices 8%, what happens to a 40% gross margin?

   • Given: Current margin = 40%, COGS increase = 15%, price increase = 8%
   • Find: New gross margin
   • Solution:
     • Current: Revenue = 100, COGS = 60, Gross = 40
     • New: Revenue = 108, COGS = 69, Gross = 39
     • New margin = 39/108 = 36.1%
   • Answer: Margin compresses from 40% to 36.1%

Advanced Level (Analysis)

1. Problem: Microsoft faces tablet cannibalization of PC sales. Analyze three scenarios with different cannibalization rates and calculate EPS impact.
   • Given:
     • Base case: 30% consumer, 10% non-consumer cannibalization
     • Bull case: 15% consumer, 5% non-consumer
     • Bear case: 40% consumer, 20% non-consumer
     • Consumer ASP = $85,Non-consumerASP=$155
     • Tax rate = 17.53%, Shares = 8,593M
   • Find: EPS impact under each scenario
   • Solution:
     • Base: Revenue impact = -$2.2B,EPSimpact=-$0.25
     • Bull: Revenue impact = -$1.1B,EPSimpact=-$0.13
     • Bear: Revenue impact = -$3.0B,EPSimpact=-$0.35
   • Answer: EPS impact ranges from -$0.13(bull)to-$0.35 (bear)

DeFi Applications & Real-World Examples

Traditional Finance Context

• Institution Example: Investment banks use multi-scenario DCF models with probability weighting
• Market Application: Equity analysts forecast quarterly earnings to set price targets
• Historical Case: Dot-com bubble showed dangers of linear extrapolation without scenario analysis

DeFi Parallels

• Protocol Implementation: Uniswap v3 concentrated liquidity requires volume and fee forecasting
• Smart Contract Logic: Automated market makers use formulas to project impermanent loss
• Advantages: Real-time on-chain data, transparent fee structures, programmable forecasting
• Limitations: Short history, high volatility, regulatory uncertainty, smart contract risks

Case Studies

1. Case 1: Aave Protocol Revenue Forecasting

   • Background: Leading DeFi lending protocol
   • Analysis:
     • TVL growth: 50% annually
     • Utilization rate: 60-80% range
     • Net interest margin: 1-2%
     • Revenue = TVL × Utilization × NIM
   • Outcomes: $100M-400M revenue range
   • Lessons learned: DeFi metrics more volatile than TradFi

2. Case 2: Traditional Bank vs DeFi Lending Comparison

   • Background: JPMorgan vs Compound Protocol
   • Analysis:
     • JPM: Stable 3% NIM, regulated capital requirements
     • Compound: Variable 0.5-5% spreads, algorithmic rates
   • Outcomes: DeFi more efficient but less stable
   • Lessons learned: Different risk/return profiles require different forecasting approaches

Common Pitfalls & Exam Tips

Frequent Mistakes

• Mistake 1: Using single-point forecasts without scenarios - Always develop base/bull/bear cases
• Mistake 2: Ignoring working capital in cash flow forecasts - Changes in WC significantly impact FCF
• Mistake 3: Assuming linear relationships - Consider operating leverage and economies of scale
• Mistake 4: Over-relying on management guidance - Guidance often biased upward at upper bound
• Mistake 5: Forecasting unverifiable metrics - Stick to regularly disclosed items

Exam Strategy

• Time management: Spend 2-3 minutes per calculation question
• Question patterns:
  • Revenue driver identification (top-down vs bottom-up)
  • Working capital ratio calculations
  • Scenario analysis probability weighting
• Quick checks:
  • Gross margin should be between 0-100%
  • Growth rates should be reasonable (<50% for mature companies)
  • DSO + DOH > DPO for most companies

Key Takeaways

Essential Points

✓ Use multiple forecast approaches to validate projections ✓ Separate recurring from non-recurring items ✓ Fixed vs variable cost analysis drives operating leverage understanding ✓ Working capital forecasts use efficiency ratios × revenue/COGS ✓ Scenario analysis is essential for capturing uncertainty ✓ DeFi forecasting requires wider outcome ranges due to volatility

Memory Aids

• Mnemonic: “THROW” - Top-down, Historical, Rate convergence, Ownership (mgmt guidance), Wild card (discretionary)
• Visual: Funnel diagram - Market → Industry → Company → Segments
• Analogy: Weather forecasting - Multiple models, probability ranges, updating with new data

Cross-References & Additional Resources

Related Topics

• Prerequisite: Financial Statement Analysis, Company Analysis: Past and Present
• Related: Equity Valuation (using forecasts), Industry Analysis
• Next topic: Equity Valuation: Concepts and Basic Tools
• Advanced: Financial Modeling, Monte Carlo Simulation

Source Materials

• Primary Reading: Volume 5, Topic 7, Pages 285-331
• Key Sections:
  • Forecast approaches (p. 290-294)
  • Revenue forecasting (p. 295-300)
  • Scenario analysis (p. 318-330)
• Practice Questions: End-of-reading problems 1-8

External Resources

• Videos: Finance webcasts on financial modeling
• Articles: McKinsey on scenario planning, Damodaran on forecasting
• Tools: Excel templates for multi-scenario models, Python for Monte Carlo simulation

Review Checklist

Before moving on, ensure you can:

• Identify and apply all four forecast approaches
• Calculate revenue using both top-down and bottom-up methods
• Project operating expenses maintaining coherence with revenue
• Calculate working capital using efficiency ratios
• Distinguish maintenance from growth capex
• Build three-scenario forecasts with probability weighting
• Apply forecasting principles to DeFi protocols
• Recognize common forecasting pitfalls and biases