$*$Solve in Excel$*$

D$.$ D & H Inc. has $40,000,000$ shares of $$1$ par value common stock outstanding at January $1.$ On April $1,$ D & H issued $5,000,000$ shares at a cost of $$40$ per share. In

Dun & Harvey Inc. also has two convertible securities$.$

a$.$ Convertible bonds, $$10,000,000$ face value, $6\%$ interest, convertible into $800,000$ shares of common stock.

b$.30,000$ shares of $$100$ par value convertible preferred stock with a dividend rate of $4\mathrm{.}0\%.$ Each $$100$ par value share is convertible into $15$ shares each.

During $2023,$ D & H$\text{'}$s net income was $$30,700,000$ and all preferred stock dividends were declared and paid. The company's tax rate is $20\%.$