Question

Please Solve in excell Required:Using the data below, calculate the seven required items related to EPS and diluted EPs Tips:This spreadsheet contains macros which will provide realtime feedback on EACH cell in the shaded area.Your score on the assignment will be calculated based upon the % of the 7 cells that are completed correctly.Use cell referencing where you can and work in order (i.e. start with required #1. The information below pertains to Hood Company for 2026. Net income for the year 6% convertible bonds issued at par ($1,000 per bond); each bond is convertible into 60 shares of common stock 4% convertible, cumulative preferred stock, $100 par value; each share is convertible into 4 shares of common s Shares of common stock,$1par value Tax rate for 2026 Average market price of common stock,per share $9,410,000 4,930,000 2,450,000 9,760,000 20% 20 There were no changes during the year in the number of common shares,preferred shares,or convertible bonds outstanding.There is no treasury stock.The company also has common stock options (granted in a prior year) to purchase 120,000 shares of common stock at $12 per share. Required-Calculate the following: 1 Preferred dividends paid 2 Basic eamings per share 3 Incremental shares issued for stock options 4 Incremental shares issued for convertible bonds 5 Interest savings for convertible bonds (inclusive of tax effect) 6 EPS effect of convertible,cumulative preferred stock (numerator/denominator impact) 7 Final diluted earnings per share Record Answers Here

          Please Solve in excell
Required:Using the data below, calculate the seven required items related to EPS and diluted EPs
Tips:This spreadsheet contains macros which will provide realtime feedback on EACH cell in the shaded area.Your score on the assignment will be calculated based upon the % of the 7 cells that are completed correctly.Use cell referencing where you can and work in order (i.e. start with required #1.
The information below pertains to Hood Company for 2026. Net income for the year 6% convertible bonds issued at par ($1,000 per bond); each bond is convertible into 60 shares of common stock 4% convertible, cumulative preferred stock, $100 par value; each share is convertible into 4 shares of common s Shares of common stock,$1par value Tax rate for 2026 Average market price of common stock,per share
$9,410,000 4,930,000 2,450,000 9,760,000 20% 20
There were no changes during the year in the number of common shares,preferred shares,or convertible bonds outstanding.There is no treasury stock.The company also has common stock options (granted in a prior year) to purchase 120,000 shares of common stock at $12 per share.
Required-Calculate the following: 1 Preferred dividends paid 2 Basic eamings per share 3 Incremental shares issued for stock options 4 Incremental shares issued for convertible bonds 5 Interest savings for convertible bonds (inclusive of tax effect) 6 EPS effect of convertible,cumulative preferred stock (numerator/denominator impact) 7 Final diluted earnings per share
Record Answers Here

please solve in excell requiredusing the data below calculate the seven required items related to eps and diluted eps tipsthis spreadsheet contains macros which will provide realtime feedbac 44734

Added by Adam C.

Question

Please give Ace some feedback