please help me solve this im so lost! ASAP

A Coleman Technologies is considering a major expansion program that has been proposed by the company's information technology group. Before proceeding with the expansion, the company must estimate its cost of capital. You are an assistant to Jerry Lehman, the financial vice president. Your first task is to estimate Coleman's cost of capital. Lehman has provided you with the following data, which he believes may be relevant to your task. stc 5 You have been provided the following information: The firm's tax rate is 25%. The current price of Coleman's 12% coupon, semiannual payment, noncallable bonds with 15 years remaining to maturity is $1,153.72. Coleman does not use short-term, interest-bearing debt on a permanent basis. New bonds would be privately placed with no flotation cost. 8 The current price of the firm's 10%, $100.00 par value, quarterly dividend, perpetual 9 preferred stock is $111.10. pro Coleman's common stock is currently selling for $50.00 per share. Its last dividend (D) was $4.19, and dividends are expected to grow at a constant annual rate of 5% in the foreseeable future. Coleman's beta is 1.2, the yield on T-bonds is 7%, and the market risk premium is 10 estimated to be 6%. For the bond-yield-plus-risk-premium approach, the firm uses a risk 11 Coleman's target capital structure is 30% debt, 10% preferred stock, and 60% common equity. 12 13 cor 14 15 DE F G 1 Coleman Technologies Inc. Cost of Capital Yellow = cells you need to input Green - cells you need to calculate Light blue = answers you need for D2L Target Capital Structure Debt Preferred Equity Total Capital 0% 0% Py Debt Wd Rd tax rate cost of debt 25.00% Pmt= N PV For Rd (cost of debt), you have to get the yield to maturity. Don't forget this is a semiannual bond; check your payments, periods, and interest Look on side 16 of the chp 10 deck for help on getting Rp For Re, use the bond yield + risk premium method (slide 21, chp 10) 1) what is the cost of debt relative to the firm's total capital? 0.00% Preferred Wp Rp 0% 0% Dp Pp = 0.00% 2) what is the cost of preferred stock relative to the firm's total capital? cost of preferred Rp 0.00% 3) what is the cost of equity relative to the firm's total capital? 3 4) what is Coleman Technologies' WACC? 0.00% Equity We Re cost of equity 09 0.00% 0.00% bond yield risk premium Re 0.00% 5) What is Coleman Technologies WACC if the capital structure shifts 1 to 40% debt and 60% equity? 2 Hord code where (te, type it in) and then put back the original weights 3 so that you have the correct answers for 1-4 4 5 WACC