only task 6 please include formulas

B27 D E F G 01701/00 01/01/20 40,000 7.596 1.000 2 20 1.050 1 Input 2 Debt 3. Settlement date + Maturity date 5 Bonds outstanding 6. Annual coupon rate 7. Face value ($) 8. Coupons per year 9 Years to maturity 10 Bond price (5) 11 Common stock 12. Shares outstanding 13 Beta 1 Share price (S) 15 Preferred stock 18 Shares outstanding 17. Coupon rate 18 Share price (8) 3 Market 20 Market risk premium 21 Risk-free rate 22 Taxrate 23 750,000 0.BS 56 1400,000 5.096 26 7.0% 3.596 35.096 25 Calculation Output Market value of debt 28 Market value of equity 29 Market value of preferred 30 Market value offirm 01 Market value capital structure 32. Weight of Debt 33 Weight of Common Stock Weight of Preferred Stock DO UNUL 06 Question 10 17 Pretax cost of debt Aftertax cost of debt 33 Question 11 40 Cost of common stock 4 Cost of preferred stock 42 Question 12 4 WACC 15 46 47 Task 6: Welghted Average Cost of Capital (3 points) You are given the following information for Twitter, Inc. Asume the company's tax rate is 359 Det: 40,000 bonds outstanding with 7.5% coupon rate, $1,000 par valse, 20 years to matunity, selling for S1050; the bonds make semiannual payments. Common stock: 750 000 shares outstanding, selling fors56 per share the beta is 0.85, 1,400,000 shares of 5% preferred stock currently selling for $26 per share Market 7% market rink premium and 3.5% risk-free rate Questions Preferred stock 10 What is the company's after-tax cost of debt? 11. What is the company's cost of common and preferred stocka? 12. What is the company's WACC - ERC MA 01/01/00 01/01/20 40.000 7.596 1.000 2 20 1050 Input Debt Settlement date Maturity date Bonds outstanding Annual coupon rate Face value (8) Coupons per year Years to maturity Bond price (5) Common stock Shares outstanding Beta Share price (5) Preferred stock Shares outstanding Coupon rate Share price (5) Market Market risk premium Risk-free rate Tax rate 750.000 0.85 56 1,400,000 5.09 26 7.096 3.596 35.096 Calculation & Output Market value of debt Market value of equity Market value of preferred Market value offirm Market value capital structure 2. Weight of Debt Weight of Common Stock Weight of Preferred Stock Question 10 Pretax cost of debt Aftertax cost of debt 39 | Question 11 30 Cast of conimon Stock 1 Cost of preferred stock 42 Question 12 3 WACC INTI 45 45 17