From a 600,000,000 DCF equity value to a diluted value per share, with three option tranches and restricted stock units.
The treasury stock method adds the shares that in-the-money options would create and assumes the exercise cash buys some of them back at the value per share. Applied to a DCF it is circular, because the value per share depends on the share count, but it has an exact closed form: equity value plus the exercise proceeds of in-the-money options, divided by basic shares plus those options and the RSUs. On an illustrative 600,000,000 of equity value that is 635,000,000 / 26,900,000 = 23.61 a share, not the 25.00 that basic shares give.
Worked in full in Business Valuation by Julian R. Sterling, with every figure reproduced in a free workbook.See the book on Amazon →
A DCF and the bridge from enterprise value give an equity value of 600,000,000. The company has 24,000,000 basic shares outstanding, three tranches of employee options and 400,000 restricted stock units that will vest. All figures are illustrative.
| Instrument | Number | Strike | Exercise proceeds |
|---|---|---|---|
| Basic shares | 24,000,000 | ||
| Options, tranche 1 | 1,500,000 | 10.00 | 15,000,000 |
| Options, tranche 2 | 1,000,000 | 20.00 | 20,000,000 |
| Options, tranche 3 | 800,000 | 30.00 | 24,000,000 |
| Restricted stock units | 400,000 | 0.00 | 0 |
For each tranche whose strike is below the value per share, the options are assumed exercised; the company receives the strike times the number, and uses that cash to repurchase shares at the value per share. The net new shares are the options less the buyback. RSUs have no strike, so they add one share each. Tranches with a strike above the value per share add nothing.
Net new shares = n × (1 − K / P), for each tranche with K < P
Excel: =IF(P>K, n-n*K/P, 0)
The obvious starting point is the basic value per share, 600,000,000 / 24,000,000 = 25.00. At 25.00, tranche 1 nets 900,000 new shares and tranche 2 nets 200,000; tranche 3 is out of the money. With the RSUs that makes 25,500,000 diluted shares and 23.53 a share. But 23.53 is not the price the buyback was computed at. Run it again at 23.53, then at the new answer, and it settles after a few rounds:
| Instrument | Number | Strike | Shares bought back | Net new shares |
|---|---|---|---|---|
| Tranche 1 | 1,500,000 | 10.00 | 635,433 | 864,567 |
| Tranche 2 | 1,000,000 | 20.00 | 847,244 | 152,756 |
| Tranche 3 | 800,000 | 30.00 | 0 | 0 |
| RSUs | 400,000 | 0 | 400,000 | |
| Diluted shares | 25,417,323 |
600,000,000 / 25,417,323 = 23.6059, and at 23.6059 the buyback gives back exactly 25,417,323 shares. That is the fixed point.
The fixed point can be written without iteration. If P is the value per share, the treasury stock method says P × (basic + options + RSUs) − option proceeds = equity value. Rearranged:
P = (equity value + proceeds of in-the-money options) / (basic shares + in-the-money options + RSUs)
= (600,000,000 + 15,000,000 + 20,000,000) / (24,000,000 + 1,500,000 + 1,000,000 + 400,000)
= 635,000,000 / 26,900,000 = 23.61
Excel, with an in-the-money flag ("Y") typed against each tranche: =(Equity+SUMIF(ITM,"Y",Proceeds))/(Basic+SUMIF(ITM,"Y",n)+RSU)
The only check left is that the tranches flagged in the money really are: 10.00 and 20.00 are below 23.61, and 30.00 is above. If a strike sits right at the answer, test it both ways and keep the consistent one. Because the flags are inputs checked against the result, rather than formulas that read it, the method needs no circular reference switched on in Excel.
| Equity value | Basic per share | Diluted shares | Diluted per share | Dilution |
|---|---|---|---|---|
| 400,000,000 | 16.67 | 24,963,855 | 16.02 | 3.9% |
| 500,000,000 | 20.83 | 25,145,631 | 19.88 | 4.6% |
| 600,000,000 | 25.00 | 25,417,323 | 23.61 | 5.6% |
| 700,000,000 | 29.17 | 25,619,048 | 27.32 | 6.3% |
| 800,000,000 | 33.33 | 25,797,439 | 31.01 | 7.0% |
Dilution rises with value, because more options are in the money and each buys back fewer shares. A sensitivity grid that divides every cell of equity value by one fixed share count is therefore wrong at both ends: too high in the upside cases, and slightly too low in the downside ones where tranche 2 falls out of the money.
The share count is the last line of the bridge from enterprise value to equity per share; the items above it are in what goes in the bridge from enterprise value to equity value. The free workbook for this case runs the bridge for each of the book's three values, so that the gap between methods can be read in value per share as well as in enterprise value.
The value per share the DCF itself produces, not the market price. Options are in or out of the money relative to what the valuation says the shares are worth. In this case the DCF gives 23.61; running the method at a market price of 21.00 counts fewer dilutive shares and overstates value at 23.78 a share.
Not under the treasury stock method: an option with a strike above the value per share would not be exercised, so it adds no shares. Here the 800,000 options struck at 30.00 are excluded at a value of 23.61. Counting every option without the buyback gives 27,700,000 shares and 21.66 a share, 8.2 per cent too low.
Because value per share depends on diluted shares, and diluted shares depend on value per share. A single pass at the basic value of 25.00 gives 25,500,000 shares and 23.53. Iterating converges on 23.61, which equals equity value plus option proceeds, 635,000,000, divided by 26,900,000 shares, with no iteration at all.
This article is one calculation from Business Valuation. 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
Reading guide: corporate finance, valuation and markets → · All 1340 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.