Treasury Stock Method (Formula, Examples) | Effect of Stock Options on EPS - YouTube

Channel: WallStreetMojo

[10]
hello everyone welcome to the channel of Wallstreetmojo. Watch the video till
[15]
the end and also if you are new to this channel then you can subscribe us by
[19]
clicking the bell icon. Friends today we are going to study tutorial on Treasury
[24]
stock method this is completely epicness guideline completely a pigness guide
[28]
employee stock options I mean our very complex column the options granted by
[33]
the companies as a part of the remuneration package I mean it's
[37]
difficult when when stock options are exercised in large quantities it can
[41]
have a significant impact on the total numbers of the outstanding shares
[44]
thereby diluting the EPS negatively affecting the valuation of the firm. So
[48]
to comply with the gap the dilutive impact the stock options and warrants
[52]
must be captured using the Treasury stock method. This tutorial discusses the
[57]
nuts and the bolts of Treasury stock method like what are the employee stock
[62]
options how do you employ stock options affect earning per share
[65]
what is Treasury stock method? Treasury stock method any examples. Treasury stock
[70]
with colgate example ok. Now let's start with the first what are the
[75]
employee stock options or ESO. ESO is option granted to company employees
[81]
that carries the right but not the obligation to buy the promised number of
[84]
shares at a predetermined price please note that the ESO are different from the
[88]
exchange traded options are as they are not traded and they don't come with the
[93]
put component also please note that the predetermined price is also called the
[97]
strike price or exercise price. Have a look at this option table from the
[102]
Colgate's 2014 10 k this table provides a detail of Colgate's outstanding stock
[107]
options along with its weighted average exercise price how to employ stock
[111]
options affect earning per share. See stock options can be exercised if the
[115]
market price is greater than the exercise price or the strike price that
[120]
is called in the money. Once these stock options are exercised the company issues
[123]
shares to the option holders this in turn increases the total number of the
[127]
outstanding shares. Earning per share which is known as net profit divide by
[131]
the number of shares outstanding decreases as
[133]
denominator increases. In addition you should also be aware of the two
[137]
important employee option terminologies option outstanding, an option exercisable.
[143]
Option outstanding is total number of the options issued by the company but
[147]
not necessarily wasted. These option may be in the money or out the money. In
[151]
Colgate options outstanding about $42.902.
[154]
options exercisable. Options that are vested as
[158]
of now this option again could be in the in the money or out of the money for
[162]
Colgate the option exercisable are 24.946
[165]
million. Let's take the example of Colgate 2014 10K which is the filings
[170]
as noted above that there are 24.946 million employees.
[174]
Stock options that are exercisable for considering the effect of the dilution
[178]
we only take the option that our exercisable
[181]
and note the option outstanding as many of the option outstanding may
[186]
not have been vested. Let us compare the average exercise price of $46
[191]
with the current market price of the Colgate. As of the closing
[194]
of the June 13 2016 Colgate was trading close enough to 76.67
[198]
since the market price is greater than the excess price
[201]
all 24.946 million are in the money and therefore
[205]
will increase the total number of the shares outstanding will be 24.946.
[209]
Now the basic EPA for EPS of Colgate.The
[213]
net income of 2014 of Colgate was close enough to 180
[218]
million.The basic shares were 9.5.1 million. So the
[223]
formula of basically EPS is the net income that was 2180
[226]
million divided by the 915 that is the number of shares which will
[230]
give us 2.38 dollar. Now what is the impact
[233]
of the stock option in the diluted EPS of colgate that is a Treasury stock
[236]
method not used. The net income of Colgate was let's take this in a excel
[241]
format and learn things very well let's say the net income
[247]
of the Colgate in 2014 this year talking over 2014 was 2180
[253]
million everything is a million. The outstanding shares that we are talking
[258]
is 915.1 million plus 24.916
[267]
that will give us 940.046 million so the diluted EPS is
[275]
going to be is equal to 2180 divided by 940.046.
[280]
As you can see that the EPS decreased from 2.38 to
[284]
2.31 due to the impact of these stock options if the amount of the
[289]
stock options issued by the company is large it can have a significant impact
[292]
on the EPS of the company thereby negatively affecting the valuation of
[296]
the firm. Do have a look at the p/e ratio for the further details hence in order
[300]
to minimize the impact of the EPS dilution we use the treasury stock
[304]
method. Now let us now try and understand following questions what is done
[310]
with the option proceeds company receives the funds from the employees on
[313]
exercise of the option second can this options proceed used proceeds that are
[319]
used in the same way and then in some way to reduce the impact of the dilution
[322]
read the Treasury stock method what is Treasury stock? The Treasury stock
[327]
method assumes that the options and the warrants are exercised at the beginning of
[331]
the year or at the date of the issue if later and the proceed from the exercised
[335]
options and the warrants are used to purchase the common stock of the
[338]
treasury. There is no adjustments to the net income in the numerator upon
[342]
exercise of the options or the warrant the company receives the following
[345]
amount of the proceeds exercise price the option X number into
[350]
number of shares issued to the holder of the options or warrants. The company will
[354]
then use the proceeds from the exercise of options and warrants to buy back the
[358]
common shares at the average market price of the year. The net change in the
[362]
number of shares outstanding is the number of shares issued to the holders
[366]
of the option or the warrant less the number of shares acquired from the
[369]
market. Now as you can see below are the three steps primary steps used for
[375]
treasury stock method. First in the money options and warrants are assumed to be
[378]
excised second they proceed from the exercise assumed to purchase common
[383]
stock at the average market price during the period.Third the incremental shares
[388]
that is the number of shares that issued is less the number of shares that are
[391]
assumed to be purchased will be included in the denominator so treasury stock
[395]
formula for net increase in the number of shares is going to be net increase is
[399]
going to be in the money option less the shares repurchase used using
[403]
hypothetical funds. If the exercise price of the option or warrant is lower than
[410]
the market price of the stock dilution occurs if higher the number of the
[415]
common shares is reduced and anti dilutive effect occurs in the later case
[418]
exercise is not assumed. Treasury stock method example let's take one
[423]
example during 2006 there was one company called KK Enterprise okay they
[430]
reported the net income of close enough to 250,000 okay let's take this
[436]
example and work on it the net income was a close enough to 250,000 and
[444]
had 100000 shares that is number of shares okay. During 2006 KK Enterprise
[454]
issued 1000 shares of 10% per 100 preferred stock outstanding. In
[461]
addition the company has 10000 options with the strike price X of 2 per
[466]
dollar so the strike price is 2 per dollar okay and the current market price
[474]
is 2.5 computed diluted EPS. Assume the tax rate is 40% okay so this
[487]
is the basic example let's see how things have been calculated as you can
[493]
see the basic EPS example the net income 250000 divided by the
[498]
preferred dividend 10000 okay 1000 preferred shares that is 10% par $100
[504]
1200 into 10 percent so that 10,000 and the common stock 100000. So the basic
[511]
EPS comes to 2.4 because we need to deduct preferred dividend from the net
[515]
income now talking about the diluted EPS denominator 1 lakh basic shares plus
[521]
10,000 in the money options buyback that is 102000 so net income -
[527]
250000, preferred dividend 10000, common stock 100000 in the money 10,000 and
[532]
shares repurchase 8,000 so company inflow is going to be 10000 *
[536]
2 i.e 20000 by back is 20000 divided by 2.5 okay that was a
[541]
ratio and which will give us 8000. So the diluted EPS comes down
[545]
to 2.35. So let's see the treasury stock with its colgate
[550]
example as you can see the data over here of the colgate consolidated
[555]
financial statement as you can see from the above for the year ended 2014 only
[558]
9.2 millions were considered instead of 24.946
[562]
million why the difference is 24.946 millions less
[566]
the 9.2 millions that is 15.746 million
[569]
shares the answer lies in the colgate 10K. It mentions that diluted earning
[573]
common share is computed using treasury stock method with this we may assume that
[578]
15.476 may be related to the buyback using the option
[583]
proceeds I hope you have got the best knowledge for the Treasury stock method
[588]
in this particular tutorial. So that's it for this particular topic if you have
[593]
learned and enjoyed watching this video please like and comment on this video
[597]
and subscribe to our channel for the latest updates thank you everyone
[601]
Cheers