use excel and show formulas pls

Finding the WACC: Given the following information for Lightning Power Co., find the WACC. Assume the company's tax rate is 21%. Debt: 12,000 bonds with a 4.6% coupon outstanding, $1,000 par value, 25 years to maturity, selling for 105% of par; the bonds make semiannual payments. Common Stock: 575,000 shares outstanding, selling for $81 per share; the beta is 1.04. Preferred Stock: 30,000 shares of 3.4% preferred stock outstanding, a $100 par value, currently selling for $94 per share. Market: 7% market risk premium and 3.2% risk-free rate