Calculate the WACC using excel, please show excel formulas!

2. Weighted Average Cost of Capital Question: Use Excel Calculate the WACC for Zee Corp. Zee's has primarily long-term debt, currently trading at 950.25/bond. The 8% coupon, 25 year bonds have 12 years left to maturity. Zee's preferred annual dividend is S2.55, and its preferred stock is currently trading at $32.00/share, 8,000 shares outstanding. Zee just paid common dividend of $1.66/share and is growing at a constant rate of 8.5% annually. Zee's stock is priced at $23.50/share, and it has 35,000 shares of common stock outstanding. Zee's total capital is $1.6 million and it is in the 32% marginal tax bracket. 2. Weighted Average Cost of Capital Question: Use Excel Calculate the WACC for Zee Corp. Zee's has primarily long-term debt, currently trading at 950.25/bond. The 8% coupon, 25 year bonds have 12 years left to maturity. Zee's preferred annual dividend is S2.55, and its preferred stock is currently trading at $32.00/share, 8,000 shares outstanding. Zee just paid common dividend of $1.66/share and is growing at a constant rate of 8.5% annually. Zee's stock is priced at $23.50/share, and it has 35,000 shares of common stock outstanding. Zee's total capital is $1.6 million and it is in the 32% marginal tax bracket