Please show answer in Excel with formulas used. Given the following information for Watson Power Co., find the weighted average cost of capital (WACC). Assume the company tax rate is 20%. Debt: 11,950 bonds with coupon rate of 4%. $1,000 par value, 22 years to maturity quoted at 99.85 (99.85 percent of par). The bonds make semiannual coupon payments. Flotation cost is 2% of market price. Preferred stock: 11,000 shares of preferred stock outstanding currently pay $4.4 dividends per share, sell for $97 per share with flotation cost of $1.5. Common stock: 390,000 shares outstanding, selling for $108 per share; the beta is 0.97. Market: 7.5% market risk premium and 2% risk-free rate.