EXCEL PLEASE!!!

.

9. Given the following information for Watson Power Co., find the WACC. Assume the company's tax rate is 30% Debt: 15,000 shares of 8.0 percent coupon bonds outstanding with 20 years to maturity, selling at 99% of par. Coupon payments are made semiannual. Common Stocks: 495,000 shares outstanding, selling for $22 per share. Recently paid a dividend of $2.00 and has an expected growth rate of 6%. Preferred Stocks: 15,000 shares of 9% preferred stocks outstanding, currently selling at 99% of par