Desperately need help on this earning per share question. I need to calculate BO
ID: 2542401 • Letter: D
Question
Desperately need help on this earning per share question. I need to calculate BOTH basic EPS and dialuted EPS. There is a lot of information so please read it carefully. It’s all in the in the image. I really appreciate it! Please show all work Curse of the Bambino Entertainment (CotBE) had the following securities outstanding and other information for 2017: Preferred Stock: Issue A Preferred Stock, cumulative and nonconvertible, 5%, $100 par Issue B Preferred Stock, non-cumulative and convertible, 6%, S 100 par $1,000,000 Dividend payments are in arrears for three (3) years. $4,000,000 Conversion rate is 4 common shares for every preferred share. Common Stock: Class A Common Stock, $1 par, 5,000,000 shares authorized, 1,000,000 shares issued and outstanding at January 1, 2017 $1,000,000 Repurchased 120,000 shares on March 1, 2017 Repurchased 60,000 shares on July 1, 2017 Sold 100,000 of repurchased (treasury) shares on September 1, 2017 Stock Warrants - warrants are exchangeable for 100,000 common shares. The warrants were issued on October 1, 2016 and have a $15 exercise price per warrant. The average market price per share during 2017 was $20. Stock Options-CotBE's issued 100,000 stock options to key executives on January 1, 2017 which vest on December 31, 2019 and have an exercise price of $16 per option. Convertible Bonds-8% Convertible Bonds of $5,000,000 were sold at face value on July 1, 2017. Each $1,000 of bond is convertible into 120 shares of common stock Other Information: . · . Net Income for 2017 was $1,700,000 Income Tax Rate was 40% for 2017 CotBE's declared and paid a cash dividend of $200,000 on common stock during 2017. Required - Calculate CotBE's Basic and Diluted EPS for the year ended December 31, 2017, show all calculations.Explanation / Answer
Calculating Basis EPS
Basic Earning Per Share (EPS) = Net Income Attributable to Common Stock/ Weighteg Average Number of Common Shares
Net Income Attributable to Common Stock
Net Income (PBT) (note 1) - 1,700,000
less - Taxes @ 40% - 680,000
PAT - 1,020,000
Less - Amount Attributable to Issue A preferred Stock (note2) - 50,000
Less - Amount Attributable to Issue B preferred Stock - Nil
Net Profit Attribuatble to Common Stock Holder - 970,000.
Note 1 - It has been assumed that profit is before dividend and taxes. In case the profit was after dividend declared for common stock i.e. 200,000 then for calculating EPS the dividend declared on common stock would have been added back
Note 2 - Since Issue A preferred stock are cumulative in nature hence the dividend needs to be deducted from profit even though the same is not declared however for Issue B since they are non cumulative hence dividend is not provided unless declared upon.
Weighted Average number of Common Stock
This is the number of shares outstanding during the year.
In the current example since there has been transactions during the year hence refer below calculations
No of Opening Shares on 1/1/17, 1,000,000
On 1 March 120,000 shares repurchased hence net 880,000, on 1 July another 60,000 shares repurchased hence net on 1 July 820,000. On 1 September 100,000 re-issued hence net on 1 September - 920,000.
Now 1,000,000 were outstanding till 1 March i.e. 2 months, 880,000 were outstanding till 1 July i.e. 4 months, 820,000 shares were outstanding till 1 September i.e.2 months and 920,000 shares outstanding for 4 months i..e from September to December
Hence Weighted Average Shares Outstanding = (1,000,000*2+880,000*4+820,000*2+920,000*4)/12 = 903,333
Basic EPS = 970,000/903,333 = 1.07
Calculating Diluted EPS
(Net Income after tax - preference dividend + expense saved due to conversion of potential common stock) / (Weighted average no of common stock + weighted average number of converted common stock)
Profit for Diluted EPS
Net Income - 1,700,000 + 200,000*
* Interest saved on 8% convertible bond issued on 1 July = 5,000,000*8%/2 = 200,000. (July to Dec)
PAT = 1,900,000 - 760,000 (40%Taxes) = 940,000
Net Profit Attributable to Common Stock Holder = 940,000 - 50,000 (preference dividend refer note 2 above) = 890,000
Weighted Average Shares Outstanding + weighted average number of converted common stock
weighted average number of converted common stock (note 3)
Issue B preference shares = 4 Common shares for every share held = 40,000*4 = 160,000 (converted on 1 Jan hence outstanding for 12 months. Weighted number = 160,000
Stock Warrant = 100,000 on 1 October' 16 hence outstanding for entire 2017. Weighted number = 100,000
Stock Options - 100,000 on 1 January' 17 hence outstanding for entire year. Weighted number = 100,000
Converted Bonds - 120 shares for every $1000 = (5000000/1000)*120 = 600,000 outstanding for 6 months. Weighted Number = (600,000*6)/12 = 300,000
weighted average number of converted common stock = 160,000+100,000+100,000+300,000 = 660,000
Weighted Average Shares Outstanding + weighted average number of converted common stock = 903,333+660,000 = 1,563,333
Diluted EPS = 890,000/1,563,333 = $0.57.
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.