Articles

How do you calculate a PWERM valuation for a startup's common stock?

The probability-weighted expected return method is simple arithmetic; what makes it defensible is forcing it to reproduce the price investors just paid.

A PWERM values a share by running the capital structure's waterfall in each exit scenario, weighting each payoff by its probability and discounting it to today. The rate is then calibrated so that the latest preferred round is worth what investors paid for it. On an illustrative venture-backed company with a 5.00 Series B, that calibration gives a rate of 19.5 per cent and a common share worth 3.95, or 79.0 per cent of the round price.

Worked in full in The Private Markets Valuation Specialist by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →

The probability-weighted expected return method is the natural choice when a company's exit routes are visible: a credible IPO, a likely trade sale, a downside sale and a failure. The arithmetic takes a page. The difficulty is that every probability and every exit value is a judgment, and an uncalibrated PWERM can produce almost any number. Calibration is what turns it into evidence.

The assumptions

Illustrative capital structure. Both preferred series are 1x non-participating.
ClassSharesLiquidation preferencePer share
Series B (senior)4,000,00020.0m5.00
Series A5,000,00010.0m2.00
Common10,000,000  
Total19,000,00030.0m 
Exit scenarios, equity value at exit.
ScenarioEquity valueProbabilityYears to exit
IPO400.0m20%3
Strategic sale120.0m40%3
Downside sale30.0m30%2
Dissolution0.0m10%1

The calculation, step by step

Value per share = Σ probabilitys × payoff per shares / (1 + r)ts

In Excel, one row per scenario: =Prob*Payoff/(1+Rate)^Years, summed with =SUMPRODUCT. Then Goal Seek the rate so that the Series B value equals its issue price.

Step 1, the waterfall in each scenario. Each preferred series takes the better of its preference or conversion. At the IPO, 400.0m over 19,000,000 shares is 21.05 a share, so both series convert. In the strategic sale 120.0m is 6.32 a share, above the Series B's 5.00 preference, so everyone converts again. In the downside sale the Series B takes its 20.0m, the Series A its 10.0m, at 2.00 a share, and common receives nothing. In dissolution nobody receives anything.

Step 2, weight and discount at an assumed rate. At 25 per cent the Series B is worth 4.41 and the common 3.45.

Step 3, calibrate. Investors paid 5.00 for the Series B in an arm's length round. A model that says it is worth 4.41 is telling you its scenarios or its rate do not match what the market priced. Holding the scenarios, the rate that values the Series B at exactly 5.00 is 19.5 per cent.

The calibrated PWERM, per share, at 19.5 per cent.
ScenarioProbabilityDiscount factorSeries B payoffSeries B weighted PVCommon payoffCommon weighted PV
IPO20%0.586221.052.4721.052.47
Strategic sale40%0.58626.321.486.321.48
Downside sale30%0.70055.001.050.000.00
Dissolution10%0.83690.000.000.000.00
Value per share   5.00 3.95

The result

The common is worth 3.95 a share, a 21.0 per cent discount to the Series B, before any discount for lack of marketability the valuation policy applies to common.The whole of the gap comes from one row: in the downside sale the Series B collects 1.05 of present value per share and the common nothing. In the two good outcomes the classes are identical, because both preferred series convert.

What if: the probabilities change

Here calibration earns its keep. Change the scenario probabilities and an uncalibrated model swings widely; recalibrate each time and the answer is far more stable, because the round price keeps anchoring it.

Downside sale held at 30%. Common value per share.
IPO / sale / dissolutionAt 25%, uncalibratedCalibrated rateCommon, calibratedShare of round price
10% / 40% / 20%2.377.7%3.7174.1%
10% / 50% / 10%2.6911.5%3.7975.9%
20% / 30% / 20%3.1316.2%3.8977.8%
20% / 40% / 10% (base)3.4519.5%3.9579.0%
30% / 30% / 10%4.2026.4%4.0681.2%

Uncalibrated, the common ranges from 2.37 to 4.20. Calibrated, from 3.71 to 4.06. But read the rate column too: a calibrated rate of 7.7 per cent for a venture-stage company is not credible, which says the pessimistic scenario set is inconsistent with the price investors paid. Calibration tests the scenarios as much as it sets the rate.

Check before you sign off: the calibrated rate should sit within the range of venture returns the valuation policy documents. If it does not, revisit the exit values and probabilities rather than accepting the rate.

The common mistake

The common mistake is to value the common at the round price, 5.00, as if every class were the same security; here that overstates it by 1.05 a share. The second is to choose probabilities and a discount rate independently and never test them against the transaction, which at 25 per cent would have put the common at 3.45 while implying the Series B investors overpaid by 13.4 per cent. A model that cannot reproduce the last price is not yet a valuation.

Takeaway

Waterfall each scenario, weight, discount, then calibrate to the latest round: here 19.5 per cent and 3.95 a share for common. The book's companion files run a full equity waterfall through participating and non-participating preferred in the free valuation workbooks, and the other way to calibrate the same kind of scenario model, holding the timing aside and solving for the upside exit value instead of the rate, is worked in why common stock is worth less than the preferred round price.

Questions readers ask

What is the difference between PWERM and the option pricing method?

PWERM values each share class in a handful of discrete exit scenarios and weights them by probability; the option pricing method models equity as a continuous distribution and values each class as a call option. PWERM suits a company with visible exit routes. On the illustrative company PWERM gives common 3.95 a share against a 5.00 Series B.

What discount rate should a PWERM use?

The one that makes the model reproduce the most recent arm's length round. On the illustrative company an assumed 25 per cent values the Series B at 4.41, 11.8 per cent below the 5.00 investors paid, so the model is miscalibrated. The rate that returns 5.00 is 19.5 per cent, and the same rate is then applied to the common.

Why is common stock worth less than the preferred in a PWERM?

Because in the downside scenarios the liquidation preferences absorb the exit value. In a 30.0m sale the Series B takes 20.0m and the Series A 10.0m, so common receives nothing. Common only participates in the IPO and the strategic sale, which is why it is worth 79.0 per cent of the round price here.

Read the whole case

This article is one calculation from The Private Markets Valuation Specialist. The book takes the same case from first principles to the decision, chapter by chapter, and every figure it prints is a live formula in the free companion workbooks.

Get the book on Amazon →Free companion files

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada

Also on this site

Reading guide: private equity and private markets → · All 681 articles →

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The workbook stays free either way.