PLEASE INCLUDE FORMULAS ALL I NEED AND STRUGLE WITH $!!!$ 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

$$9,410,000$

$6\%$ convertible bonds issued at par $($ $$1,000$ per bond$)$; each bond is convertible into $60$ shares of common stock

$4,930,000$

$4\%$ convertible, cumulative preferred stock, $$100$ par value; each share is convertible into $4$ shares of common sto

$2,450,000$

Shares of common stock, $$1$ par value

Tax rate for $2026$

$9,760,000$

Average market price of common stock, per share

$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:

$20$

$1$ Preferred dividends paid

$2$ Basic earnings 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:

$\backslash$table$[[$$$98,000$