please show the answers with the excel formula

Problem 11-1 WACC (Weighted-Average cost of Capital) 1. Calculate the WACC. WACC (Weighted-Average Cost of Capital) - Excel PAGE LAYOUT FORMULAS DATA REVIEW FILE HOME INSERT VIEW Sign In Arial 12 A A % Daste BIU. Cells Alignment Number Conditional Format as Call Formatting Table Styles Styles Clipboard Font D23 v X A B E F G H 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 BUBUWBOU 16 17 18 19 Complete the following analysis. Do not hard code values in your calculations. 20 21 22 23 Before-tax cost of equity Before-tax cost of debt Equity weight Debt weight WACC 24 25 26 27 Sheet1 L 100% READY Attempt(s) 3/5 Hint