?can someone please show me all the formulas they inputted into excel to get these answers. i really need the help and i need to see the formulas for each.

Given the data below: 1) Calculate the book-value weights for each source of capital. 4 pts 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 Capital using of both market-value and book-value weights. Note that Book Value does not have a Float Cost. 6 pts Source of Capital Book Value BV Weights BV WACC Units Market Value Share Market Value MV Weights MV WACC 350,000 Common Stock 6,500,000 35 Preferred Stock 375,000 7,500 60 965 Debt 4,000,000 4,000 Total Additional Bond Data Additional Preferred Data Additional Common Data 35% Dividend 0 1.43 Tax Rate 5.00 Dividend 8% Growth Rate 5% Coupon Rate 1.000 Face Value 10 Maturity 1.00% 2.00% 5.00% Float Cost Float Cost Float Cost