Just need the boxes filled in thank you so much!!!

BA212 Chapter 15 Excel Probles Problem Data The balance sheet for XYZ Co at the end of the current fiscal year indicated the following Bonds Payable, 8 Preferred 8% stol Common Stock, 5500,000 3,000000 4,750,000 Other infomation includes: Net Income befo Income tax exper Cash dividends p Market price for 3250,000 1,150,000 1 200000 Calculations Face Value of Bonds A1???1 Interest rate Anneal Inerest Expense Total Vae of Prefered Stock por valee Number of Preferred sh Annual total Prefcerred dividend Total Vakue of Common Stock pr value Numbor of Commmon shares L. Compate the umber of times bond interest charges are earnod: 2 Compate the mumber of times preferred dvidends are carned 3, Compute the earnings p? share on common stock. 4. Compate the Price-Earnings ratio . Compate the dividends per share of common stock 6 Compute the dividend yiekd: BA212 Chapter 15 Excel Probles Problem Data The balance sheet for XYZ Co at the end of the current fiscal year indicated the following Bonds Payable, 8 Preferred 8% stol Common Stock, 5500,000 3,000000 4,750,000 Other infomation includes: Net Income befo Income tax exper Cash dividends p Market price for 3250,000 1,150,000 1 200000 Calculations Face Value of Bonds A1???1 Interest rate Anneal Inerest Expense Total Vae of Prefered Stock por valee Number of Preferred sh Annual total Prefcerred dividend Total Vakue of Common Stock pr value Numbor of Commmon shares L. Compate the umber of times bond interest charges are earnod: 2 Compate the mumber of times preferred dvidends are carned 3, Compute the earnings p? share on common stock. 4. Compate the Price-Earnings ratio . Compate the dividends per share of common stock 6 Compute the dividend yiekd