To be submitted in excel:

Please show steps as I must submit this problem in excel. Thank you!

9. Given the following data, compute diluted earnings per share. . $2,000,000 Common stock (500,000 shares at $4.00 par value). Convertible debentures at 7 percent (6,000 bonds at $1,000 each; convertible into 20 shares per bond) Retained earnings... Earnings before interest and taxes Interest .. Earnings before taxes Earnings after taxes (50%) 6,000,000 8,000,000 3,420,000 420,000 3,000,000 $1,500,000 +4+