Hello, Please answer question using the EXCEL formula please, DO NOT just write the numbers I need the formula for the question to be correct. Thank you.

E F G H 3 4 Johnny Cake Ltd. has 8 million shares of stock outstanding selling at $22 per share and an issue of $40 million in 10 percent annual coupon bonds with a maturity of 17 years, selling at 94.0 percent of par. Assume Johnny Cake's weighted-average tax rate is 34 percent, its next dividend is expected to be $3 per share, and all future dividends are expected to grow at 5 percent per year, indefinitely. What is its WACC? (Do not round intermediate calculations and round your final answer to 2 decimal places.) 5 6 7 8 9 10 11 Shares outstanding 8,000,000 Price per share $ 22.00 Face value of outstanding bond issue $ 40,000,000 Coupon rate on bonds 10% Maturity of bonds 17 Price of bonds (% of par) 94.00 Weighted average tax rate 34.00% Next expected dividend 3.00 Expected dividend growth rate 5.00% 12 13 14 15 16 17 Complete the following analysis. Do not hard code values in your calculations. 18.64% Before-tax cost of equity Before-tax cost of debt Equity weight Debt weight WACC E F G H 3 4 Johnny Cake Ltd. has 8 million shares of stock outstanding selling at $22 per share and an issue of $40 million in 10 percent annual coupon bonds with a maturity of 17 years, selling at 94.0 percent of par. Assume Johnny Cake's weighted-average tax rate is 34 percent, its next dividend is expected to be $3 per share, and all future dividends are expected to grow at 5 percent per year, indefinitely. What is its WACC? (Do not round intermediate calculations and round your final answer to 2 decimal places.) 5 6 7 8 9 10 11 Shares outstanding 8,000,000 Price per share $ 22.00 Face value of outstanding bond issue $ 40,000,000 Coupon rate on bonds 10% Maturity of bonds 17 Price of bonds (% of par) 94.00 Weighted average tax rate 34.00% Next expected dividend 3.00 Expected dividend growth rate 5.00% 12 13 14 15 16 17 Complete the following analysis. Do not hard code values in your calculations. 18.64% Before-tax cost of equity Before-tax cost of debt Equity weight Debt weight WACC