Lesson 5 of 6

Probability and expected value

Step 4 of 6

Do it yourself

Small and practical. Do it now while it is fresh.

About 10 minutes, in a spreadsheet or on paper:

  1. Pick any company you know. Write one sentence each for a bull, base and bear case.
  2. Give each a probability (they must add to 100%) and a price in a year.
  3. 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.
  4. 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.