Please show formulas for excel

Given the data below: 1) Calculate the book-value weights for each source of capital. Remember, BV does not consider float cost. 4 pts DO NOT MODIFY 1 O Book Value Weights 2 o Market Value Weights 3 o Costs of Capital (6 answers) 4 0 WACC (2 answers) 0 2) Calculate the market value weights for each source of capital. 4 pts 3) Calculate the costs of capital for Common Stock, Preferred Stock and Debt using both market value and book-value. 6 pts 4) Calculate the Weighted Average Cost of Capital using both market-value and book-value weights. Remember, BV does not consider float cost. 6 pts Source of Capital Common Stock Preferred Stock Debt Total Book Value $ 6,500,000 $ 375,000 $ 4,000,000 $ 10,875,000 BV Weights 59.77% 3.45% 36.78% 100.00% BV WACC 13.09% 10.00% 5.20% 10.08% Units Market Value / Share 350,000 $ 35 $ 7,500 $ 60 $ 4,000 $ 965 $ $ Market Value 12,250,000 450,000 3,860,000 16,560,000 MV Weights 73.97% 2.72% 23.31% 100.00% MV WACC 9.52% 8.50% 5.80% 8.62% Additional Preferred Data Dividend $ 5.00 Additional Common Data Dividendo $ 1.43 Growth Rate 5% Additional Bond Data Tax Rate Coupon Rate Face Value $ Maturity Float Cost 35% 8% 1,000 10 1.00% Float Cost 2.00% Float Cost 5.00% Given the data below: 1) Calculate the book-value weights for each source of capital. Remember, BV does not consider float cost. 4 pts DO NOT MODIFY 1 O Book Value Weights 2 o Market Value Weights 3 o Costs of Capital (6 answers) 4 0 WACC (2 answers) 0 2) Calculate the market value weights for each source of capital. 4 pts 3) Calculate the costs of capital for Common Stock, Preferred Stock and Debt using both market value and book-value. 6 pts 4) Calculate the Weighted Average Cost of Capital using both market-value and book-value weights. Remember, BV does not consider float cost. 6 pts Source of Capital Common Stock Preferred Stock Debt Total Book Value $ 6,500,000 $ 375,000 $ 4,000,000 $ 10,875,000 BV Weights 59.77% 3.45% 36.78% 100.00% BV WACC 13.09% 10.00% 5.20% 10.08% Units Market Value / Share 350,000 $ 35 $ 7,500 $ 60 $ 4,000 $ 965 $ $ Market Value 12,250,000 450,000 3,860,000 16,560,000 MV Weights 73.97% 2.72% 23.31% 100.00% MV WACC 9.52% 8.50% 5.80% 8.62% Additional Preferred Data Dividend $ 5.00 Additional Common Data Dividendo $ 1.43 Growth Rate 5% Additional Bond Data Tax Rate Coupon Rate Face Value $ Maturity Float Cost 35% 8% 1,000 10 1.00% Float Cost 2.00% Float Cost 5.00%