A base case is one point on a distribution. Weighting three scenarios by probability gives the number a position should be judged on, and shows how fast it moves.
A stock at $50 with a bull case of $72 (25%), a base case of $58 (50%) and a bear case of $34 (25%) has an expected value of $55.50, an expected return of 11.0%, against 16.0% if only the base case is read: 0.25 × 72 + 0.50 × 58 + 0.25 × 34. The expected gain is $9.50 and the expected loss $4.00, a ratio of 2.4 to 1. Moving 10 points of probability from the base case to the bear case cuts the return to 6.2%.
| Item | Value |
|---|---|
| Current price | $50.00 |
| Bull case price and probability | $72.00 at 25% |
| Base case price and probability | $58.00 at 50% |
| Bear case price and probability | $34.00 at 25% |
| Return the idea must clear | 8.0% in 12 months |
Dividends are ignored and the three scenarios are treated as the only outcomes, so the probabilities sum to 100%. Each scenario should be a story with a cause, not just a price: what has to happen for the stock to reach $72, and what for it to fall to $34.
Scenario return = scenario price ÷ current price − 1
Expected value = Σ probability × scenario price
Expected return = expected value ÷ current price − 1
Excel: =SUMPRODUCT(Prob,Price)/Px-1
| Scenario | Price | Probability | Return | Probability × price |
|---|---|---|---|---|
| Bull case | $72.00 | 25% | +44.0% | $18.00 |
| Base case | $58.00 | 50% | +16.0% | $29.00 |
| Bear case | $34.00 | 25% | −32.0% | $8.50 |
| Expected value | 100% | +11.0% | $55.50 |
The base case returns +16.0% and the weighted answer is +11.0%. The gap of 5.0 points is the bear case: it is rarer than the base case but it falls $16.00 below the current price, against a base case that sits $8.00 above it.
Split the weighted outcome into what the idea is expected to make and what it is expected to lose. The expected gain is 0.25 × (72 − 50) + 0.50 × (58 − 50) = 5.50 + 4.00 = $9.50. The expected loss is 0.25 × (50 − 34) = $4.00. The difference, $5.50, is the expected value less the price. The ratio, 9.50 ÷ 4.00 = 2.38, says the idea expects to make about 2.4 dollars for every dollar it expects to lose.
Hold the bull case at 25% and let the bear case take probability from the base case. With x as the bear probability, the expected value is 0.25 × 72 + 58 × (0.75 − x) + 34 × x = 61.50 − 24x. Each point of probability moved from base to bear costs $0.24, because the two cases are $24.00 apart.
| Bear | Base | Expected value | Expected return |
|---|---|---|---|
| 25% | 50% | $55.50 | 11.0% |
| 30% | 45% | $54.30 | 8.6% |
| 35% | 40% | $53.10 | 6.2% |
| 40% | 35% | $51.90 | 3.8% |
| 47.9% | 27.1% | $50.00 | 0.0% |
The expected return reaches zero when the bear case is 47.9% likely: 61.50 − 24x = 50, so x = 0.4792. The idea clears an 8.0% hurdle, an expected value of $54.00, only while the bear case stays below 31.3%: x = (61.50 − 54.00) ÷ 24. Against a 25% estimate that is a margin of 6.3 points, and it is the number to test a view against.
A smaller upside leaves the bull case at $66.00. The expected value becomes 0.25 × 66 + 0.50 × 58 + 0.25 × 34 = $54.00, a return of 8.0%, exactly the hurdle. A $6.00 cut to the bull case removes $1.50 of expected value, as much as moving 6.25 points of probability from base to bear (1.50 ÷ 0.24).
Multiply each scenario price by its probability, add them, and divide by the current price. With $72 at 25%, $58 at 50% and $34 at 25% the expected value is $55.50 on a $50 stock, a return of 11.0%.
Because the bear case is $16.00 below the price while the base case is only $8.00 above it. Even at 25% probability the bear case pulls the average from $58.00 to $55.50.
With the bull case fixed at 25%, each point moved from base to bear costs $0.24 of expected value. The expected return hits zero at 47.9% and an 8.0% hurdle fails at 31.3%.
The free companion files for The Hedge Fund Analyst rebuild a fictional fund's long and short ideas, scenarios, position sizes and quarterly attribution with live formulas, with an editable toolkit. The scenario prices and probabilities in this article are invented and are not in them. No account and no email address.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: corporate finance, valuation and markets → · All 1908 articles →