Articles

How do you apply the treasury stock method to a DCF value per share?

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 →

The case

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.

Share capital and dilutive instruments
InstrumentNumberStrikeExercise proceeds
Basic shares24,000,000
Options, tranche 11,500,00010.0015,000,000
Options, tranche 21,000,00020.0020,000,000
Options, tranche 3800,00030.0024,000,000
Restricted stock units400,0000.000

Step 1: the method, one tranche at a time

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)

Step 2: the circularity, and why one pass is not enough

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:

Treasury stock method at the converged value of 23.61
InstrumentNumberStrikeShares bought backNet new shares
Tranche 11,500,00010.00635,433864,567
Tranche 21,000,00020.00847,244152,756
Tranche 3800,00030.0000
RSUs400,0000400,000
Diluted shares25,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.

Step 3: the closed form that removes the loop

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.

What if: the equity value moves

Diluted shares and value per share by DCF equity value
Equity valueBasic per shareDiluted sharesDiluted per shareDilution
400,000,00016.6724,963,85516.023.9%
500,000,00020.8325,145,63119.884.6%
600,000,00025.0025,417,32323.615.6%
700,000,00029.1725,619,04827.326.3%
800,000,00033.3325,797,43931.017.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 common mistakes

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.

Takeaway

Questions readers ask

Which share price should the treasury stock method use in a DCF?

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.

Do out-of-the-money options count in diluted shares?

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.

Why does the treasury stock method need iteration in a valuation?

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.

Read the whole case

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

Also on this site

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.