Please answer using Excel and leaving step by step instructions for calculations, thank you!

2. The following information is available on a company for the current year: Net income Average number of common shares outstanding $1,000,000 100,000 Details of convertible securities outstanding Convertible preferred shares outstanding o Dividend/share o Each preferred share is convertible into five shares of common stock 2,000 $10 $80,000 Convertible bonds, $100 face value per bond o 8% coupon o Each bond is convertible into 25 shares of common stock 40% Corporate tax rate What is the company's basic & diluted EPS