About 10 minutes, in a spreadsheet or on paper:
- Pick any company you know. Write one sentence each for a bull, base and bear case.
- Give each a probability (they must add to 100%) and a price in a year.
- In a sheet, put probabilities in column B and prices in column C, then compute
=SUMPRODUCT(B2:B4, C2:C4), which multiplies each probability by its price and adds the results. That's the EV. - Compare it with today's share price. Then move 10 percentage points from the base case to the bear case (for example base 50% → 40%, bear 25% → 35%), so the three still add to 100%, and see how much the EV moves.
Show answer
Your cases are your own, so there is no single answer. To check your method, use the example above: moving 10 points from base to bear gives (0.25 × 150) + (0.40 × 110) + (0.35 × 60) = 37.50 + 44.00 + 21.00 = $102.50, down $5 from $107.50.
Next lesson: The analyst's spreadsheet. You'll set one up the way analysts do, so calculations like this are quick and hard to get wrong.