show me how you would get the answer for these (show the hard code)

XUS WACC (Weighted-Average Cost of Capital) - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Arial 12 AA % Paste BIU Cells Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font D22 ... A B D E F G H 5 6 7 8 9 10 11 Shares outstanding Price per share Face value of outstanding bond issue Coupon rate on bonds Maturity of bonds Price of bonds (% of par) Weighted average tax rate Next expected dividend Expected dividend growth rate 8,000,000 $ 22.00 $ 40,000,000 10% 17 94.00 34.00% $ 3.00 5.00% 12 13 14 15 16 17 18 19 Complete the following analysis. Do not hard code values in your calculations. 20 21 18.64% 22 23 Before-tax cost of equity Before-tax cost of debt Equity weight Debt weight WACC 24 25 26 27 Sheet1 READY HH 100%