Company Analysis: Forecasting

Welcome to Company Analysis: Forecasting!

In our journey through Equity Investments, we’ve learned how to look at industries and business models. Now, we are getting to the "heart" of valuation: Forecasting. Why do we do this? Because the value of a stock isn't about what the company did yesterday; it's about what it will do tomorrow. Don't worry if this seems like a lot of math at first—at its core, forecasting is just telling a story about a company's future using numbers!

1. Approaches to Forecasting Revenue

Revenue is the "top line," and it's the starting point for almost every financial model. There are three main ways to forecast it:

A. Top-Down Approach

Think of this like a funnel. You start with the big picture and narrow it down to the specific company.
1. Forecast the GDP growth (the whole economy).
2. Forecast the total market sales for that industry.
3. Estimate the company’s market share.
Example: "The US economy will grow 3%, the smartphone industry will grow 5%, and Apple will keep 20% of that market."

B. Bottom-Up Approach

Think of this like building blocks. You start with the smallest parts of the business and add them up.
1. Forecast sales by individual product lines or store locations.
2. Forecast units sold and price per unit.
Example: "This Starbucks location sells 500 coffees a day at \$5 each. There are 30,000 locations..."

C. Hybrid Approach

This is the most common method. Analysts use both Top-Down and Bottom-Up to see if they match. If the Top-Down says the market is shrinking but your Bottom-Up says the company will double sales, you know you need to re-check your assumptions!

Quick Review:
- Top-Down: Economy → Industry → Company.
- Bottom-Up: Segments/Products → Company.

2. Forecasting Costs and Margins

Once we have revenue, we need to know how much it costs to generate that revenue. We generally look at two types of costs:

Cost of Goods Sold (COGS)

These are the variable costs that change directly with sales (like the flour in a bakery).
Pro Tip: Analysts often forecast COGS as a percentage of revenue. If the company gains economies of scale, this percentage should theoretically go down as they grow!

Operating Expenses (SG&A)

These are often fixed costs (like the rent for the bakery).
Key Concept: Operating Leverage. If a company has high fixed costs, a small increase in sales leads to a huge increase in profit because the rent stays the same while the revenue climbs.

Did you know? Gross Margin is often used to check a company's "pricing power." If a company can raise prices without losing customers, its Gross Margin \( (\frac{\text{Gross Profit}}{\text{Revenue}}) \) will stay steady or rise even if costs go up.

Key Takeaway: COGS is usually linked to volume (variable), while SG&A is more stable (fixed/semi-fixed). Increasing margins usually signals improving efficiency.

3. Forecasting the Balance Sheet

We don't just forecast the Income Statement; we need the Balance Sheet to see how much capital the company needs to grow. Most items are projected using the "Percentage of Sales" method.

• Accounts Receivable: Usually forecasted using Days Sales Outstanding (DSO). If sales go up, we expect the money owed to us to go up too.
• Inventory: Forecasted using Inventory Turnover. More sales usually mean the company needs to keep more "stuff" on the shelves.
• Capital Expenditures (CapEx): This is vital! To grow revenue, a company usually needs to buy more equipment or build more factories. Analysts look at the CapEx-to-Sales ratio to ensure the company is investing enough to support its growth forecast.

Common Mistake to Avoid: Forgetting that growth isn't free. If you forecast 20% revenue growth but 0% increase in assets (like machines or inventory), your model is likely unrealistic!

4. The Impact of Inflation and Technology

External factors can ruin a perfect forecast. Here is how to think about them:

Inflation

If prices are rising everywhere:
- Pass-through: Can the company raise its own prices? If yes, margins stay safe.
- Cost pressure: If they can't raise prices, their margins will get squeezed.

Technological Change

Technology can be a "Disruptor" or an "Enabler."
- Disruption: Makes a company's products obsolete (Think: Digital cameras vs. Film).
- Cannibalization: When a company's new product eats the sales of its old product (Think: iPhone eating iPod sales). Analysts must account for this "lost" revenue in the old category.

5. Sensitivity and Scenario Analysis

Since we can't see the future perfectly, we use two "stress tests":

1. Sensitivity Analysis ("What if one thing changes?"):
Changing one variable at a time to see how it affects the valuation.
Example: "What happens to the stock price if interest rates go up by exactly 0.5%?"

2. Scenario Analysis ("What if a big event happens?"):
Changing multiple variables at once to reflect a specific situation.
Example: "What happens if there is a 'Recession Scenario' where GDP falls, interest rates drop, and our sales decline by 10%?"

Memory Aid:
- Sensitivity = Single variable.
- Scenario = Situation (multiple variables).

Summary and Final Tips

Forecasting is an iterative process. You start with the top line (Revenue), estimate the costs to get there (Margins), and then determine what investments are needed (Balance Sheet/CapEx). Always check if your story makes sense: Does the company have enough capacity to produce what you've forecasted? Are your assumptions consistent with the industry's history?

Quick Review Box:
- Revenue: Use Top-down, Bottom-up, or Hybrid.
- Costs: Distinguish between fixed (SG&A) and variable (COGS).
- Working Capital: Link to sales using efficiency ratios (DSO, Turnover).
- Risk: Use Sensitivity and Scenario analysis to handle uncertainty.

You've got this! Forecasting is where the art of storytelling meets the science of finance. Keep practicing these links between the statements, and it will become second nature.