please help solve with explanations !

The balance sheet for XYZ Co. at the end of the current fiscal year indicated the following: $ Bonds Payable, 7% Preferred 3% stock, $45 par Common Stock, $1 par 4,800,000 3,100,000 4,500,000 Other information includes: Net Income before tax Income tax expense Cash dividends paid on common Stock Market price for common stock, per share 3,480,000 1,050,000 1,050,000 37 $ Calculations enter data in blue cells Face Value of Bonds Annual Interest rate Annual Interest Expense anter forkers in yellow cells Total Value of Preferred Stock par value Number of Preferred shares Annual total Preferred dividend Total Value of Common Stock par value Number of Common shares 1. Compute the number of times bond interest charges are earned: enter formulas in yellow cells 2. Compute the number of times preferred dividends are earned: 3. Compute the earnings per share on common stock: 4. Compute the Price Earnings ratio: 5. Compute the dividends per share of common stock: 6. Compute the dividend yield