Articles

How do you turn bull, base and bear scenarios into an expected return?

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%.

The assumptions

Illustrative 12-month scenarios for one long idea
ItemValue
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 clear8.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.

Step 1: the return in each scenario

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 table, price per share
ScenarioPriceProbabilityReturnProbability × price
Bull case$72.0025%+44.0%$18.00
Base case$58.0050%+16.0%$29.00
Bear case$34.0025%−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.

Step 2: expected gain against expected loss

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.

Step 3: how much probability the bear case can take

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.

Expected value as the bear probability rises, bull case fixed at 25%
BearBaseExpected valueExpected return
25%50%$55.5011.0%
30%45%$54.308.6%
35%40%$53.106.2%
40%35%$51.903.8%
47.9%27.1%$50.000.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.

What if: the bull case is $66, not $72

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).

The common mistakes

Takeaway

Questions readers ask

How do you calculate an expected return from scenarios?

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%.

Why is the expected return lower than the base case?

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.

How much can the bear case probability rise before the idea stops paying?

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 workbooks behind this article

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.

Open the companion files →

Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: corporate finance, valuation and markets → · All 1908 articles →