Calculate the WACC for the following firm: Debt: 80,000 bonds with 5.1 percent coupon, paid semiannually, a quoted price of 114.24, 25 years to maturity, and a par value of $1,000. Preferred Stock: 145,000 shares of 4.4 percent preferred stock with a price of $109 and a par value of $100. Common Stock: 3,400,000 shares of common stock with a price of $84 and a beta of 1.10. Market: The corporate tax rate is 21 percent, the market risk premium is 7 percent, and the risk-free rate is 3.1 percent. (Please include excel functions used for the whole problem so I can learn where the answers came from, thanks so much)

80.000 100 5.10% 114.240 L/100 1/1/25 1.000 145.000 4.454 109 3.400.000 84 1.10 7.0% 3.18 2194 17 Dube 18 Number of bonds 19 Pe value of part) 20 Coupon mate 21 Quod pece 22 Selene Purchase Date 23 Maturity date 24 Coupons per you 25 P value (5) 26 27 Pred 28 Number of shares 29 Dividend 30 Price 31 32 Costock 33 Number of shares 34 Price 35 Beta 36 37 Marke! 38 Muket sik parim 39 Risk 40 Taxate 41 42 43 Debe 44 45 YTM 46 Adet ut 47 48 Preferred 49 SO Dond 5. Requinol scum 52 53 T 54 SS CAPM 56 57 58 59 60 Hand 61 Pemel #1 | 145 63 Total 64 Market value Wat Wer Times Cost WACC 65 80.000 100 5.10% 114.240 L/100 1/1/25 1.000 145.000 4.454 109 3.400.000 84 1.10 7.0% 3.18 2194 17 Dube 18 Number of bonds 19 Pe value of part) 20 Coupon mate 21 Quod pece 22 Selene Purchase Date 23 Maturity date 24 Coupons per you 25 P value (5) 26 27 Pred 28 Number of shares 29 Dividend 30 Price 31 32 Costock 33 Number of shares 34 Price 35 Beta 36 37 Marke! 38 Muket sik parim 39 Risk 40 Taxate 41 42 43 Debe 44 45 YTM 46 Adet ut 47 48 Preferred 49 SO Dond 5. Requinol scum 52 53 T 54 SS CAPM 56 57 58 59 60 Hand 61 Pemel #1 | 145 63 Total 64 Market value Wat Wer Times Cost WACC 65