1. Calculate the WACC. ? - Sic 15d WACC (Weighted-Average Cost of Capital) - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW HOME INSERT FILE X A A Calibri -111 Cells 96 Alignment Number Conditional Format as Cell Formatting* Table Styles Styles Paste BIU- Font Clipboard fo E D G H F B 6 7 8 9 10 11 12 13 14 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% 15 16 17 Complete the following analysis. Do not hard code values in your calculations. 18 19 20 21 22 23 24 25 18.64% Before-tax cost of equity Before-tax cost of debt Equity weight Debt weight WACO