Please help with the items in YELLOW using Excel as that is how I need to do it in exam.

Please check the ones in yellow that I answered and show how to do the ones I didnt answer.

Please show using EXCEL ONLY.

Task 2: Weighted Average Cost of Capital (WACC) 01/01/00 01/21/00 50.000 8.5% 1.000 20 1.040 1 Input 2 Debt 3 Settlement date 4 Maturity date 5 Bonds outstanding 6 Annual coupon rate 7 Face value (5) 8 Coupons per year 0 Years to maturity 10 Bond price ($) 11 Common stock 12 Shares outstanding 13 Beta 14 Share price (5) 15 Preferred stock 16 Shares outstanding 17 Coupon rate 18 Share price (5) 19 Market 20 Market risk premium 21 Risk free rate 22 Tax rate You are given the following information for Twitter, Inc. Assume the company's tax rate is 21% Debt: 50,000 bonds outstanding with 8.5% coupon rate, $1,000 par value, 20 years to maturity, selling for 51040, the bonds make semiannual payments. Common stock: 700,000 shares outstanding selling for $52 per share the beta is 0.90 Preferred stock 140,000 shares of 6% preferred stock, currently selling for $35 per share. Market: 8% market risk premium and 2% risk-free rate Questions 700,000 0.90 52 140,000 6.09 3. What is the company's after tax cost of debt? (s point) 4 What is the company's cost of common stock? (5 point) 5. What is the company's cost of preferred stock? (5 point) 6. What is the company's WACC? (5 point) 8.09 2016 21.096 24 25 Calculation & Output 26 27 Market value of debt 52,000,000 28 Market value of equity 36,400,000 29 Market value of preferred 4,900,000 30 Market value of firme 93,300,000 31 Market value capital structure 32 Weight of Debt 0.5573 33 Weight of Common Stock 0.3901 34 Weight of Preferred Stock 0.0525 36 Question 3 37 Pretax cost of debt 38 Aftertax cost of debt 39 Question 4 40 Cost of common stock 41 Question 5 42 Cost of preferred stock 43 Question 6 44 WACC 9.20% 17.14%