The range is built backwards: a multiple from listed peers, a discount to leave something for the first investors, then net debt and the share count to turn enterprise value into a price.
A company has EBITDA of 120 and net debt of 480. Its five listed peers trade on a median of 11.0x EBITDA. After a 15.0% IPO discount the enterprise value is 1,122, the equity value 642 and the price $6.42 a share on 100 existing shares. A range of plus or minus 7.5% runs from $5.94 to $6.90, which is 8.95x to 9.75x EBITDA. The discount takes $1.98 a share off the price at the peer median.
| Item | Value |
|---|---|
| Company EBITDA, next twelve months | 120 |
| Net debt before the offering | 480 |
| Shares in issue before the offering | 100 million |
| Primary raise | 200 |
| Underwriting fee on the raise | 4.0% |
| IPO discount to the peer multiple | 15.0% |
| Range around the mid-point | plus or minus 7.5% |
| Peer EV/EBITDA multiples | 9.8x, 10.6x, 11.0x, 11.8x, 12.4x |
The peers are assumed to be on the same calendar year and the same definition of EBITDA as the company. The price is the price per share before the new shares are counted: new shares are sold at the same price, so they do not change it.
Median of 9.8, 10.6, 11.0, 11.8, 12.4 = 11.0x
Mean = 55.6 / 5 = 11.12x
Excel: =MEDIAN(Multiples)
With five peers the median and the mean are close here, 11.0x and 11.12x. Using the mean would move the price by only $0.12 a share at a 15.0% discount, but a single outlier peer would move the mean and not the median.
Enterprise value at the peer median = 11.0 × 120 = 1,320
Enterprise value after the 15.0% discount = 1,320 × (1 − 15.0%) = 1,122
Excel: =Multiple*(1-Discount)*EBITDA
The discount is taken off the multiple, equivalently off the enterprise value. It removes 198 from the enterprise value.
Equity value = 1,122 − 480 = 642
Price = 642 / 100 = $6.42 a share
Range = 6.42 × (1 ± 7.5%) = $5.94 to $6.90
Excel: =(Multiple*(1-Discount)*EBITDA-NetDebt)/Shares
| Point of the range | Price, $ | Equity value before the raise | Implied EV/EBITDA | New shares sold, million | Free float after the raise |
|---|---|---|---|---|---|
| Low | 5.94 | 594 | 8.95x | 33.68 | 25.2% |
| Mid-point | 6.42 | 642 | 9.35x | 31.15 | 23.8% |
| High | 6.90 | 690 | 9.75x | 28.98 | 22.5% |
The raise of 200 at the mid-point sells 31.15 million new shares and leaves a post-money equity value of 842. After the 4.0% fee the company receives 192, which brings net debt down from 480 to 288.
| IPO discount | Enterprise value | Equity value | Price, $ | Change against no discount |
|---|---|---|---|---|
| 0.0% | 1,320 | 840 | 8.40 | – |
| 10.0% | 1,188 | 708 | 7.08 | −15.7% |
| 15.0% | 1,122 | 642 | 6.42 | −23.6% |
| 20.0% | 1,056 | 576 | 5.76 | −31.4% |
A 15.0% discount on the multiple takes 23.6% off the price, not 15.0%, because net debt of 480 does not move: the discount falls entirely on the equity. The higher the leverage, the larger the effect; here net debt is 4.0x EBITDA.
If EBITDA is 110 and not 120: EV = 11.0 × 0.85 × 110 = 1,028.5
Price = (1,028.5 − 480) / 100 = $5.49, 14.6% below the base case
An EBITDA shortfall of 8.3% (10 on 120) cuts the price by 14.6%, because the debt is again fixed.
Take the median EV/EBITDA of listed peers, apply an IPO discount, multiply by EBITDA, subtract net debt and divide by shares, then set a range around the result. Here 11.0x gives a mid-point of $6.42 and a range of $5.94 to $6.90.
New investors are asked to buy a company with no trading history, and the discount leaves them a return for that. At 15.0% it takes 23.6% off the price in this example because net debt does not change.
The median is less sensitive to one unusual peer. With these five peers they are 11.0x and 11.12x and the price differs by $0.12 a share.
The free companion files for The Equity Capital Markets Banker rebuild a fictional IPO's offering, greenshoe, valuation, book, first day and fees, and a block trade, with live formulas. The company in this article is invented and is 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 →