please answer in EXCEL formulas

During the past few years, Super Technologies has been too constrained by the high cost of capital to make many capital investments. Recently, though, capital costs have been declining and the company has decided to look seriously at a major expansion program that had been proposed by the marketing department. As the assistant to the financial vice-president, it is your task is to estimate Super's weighted average cost of capital (WACC). The VP has provided you with the following information: 1. The firms' tax rate is 40%. 2. The current market price of Super's outstanding bonds is $1,153.72. The bonds have an annual coupon rate of 12% and make coupon payments semiannually. The bonds mature in 15 years and have a par value of $1,000 3. The current price of the firm's preferred stock is $113.10 per share. The stock has a $100 par value and a 10% annual dividend rate (paid annually). 4. The current price of the firm's common stock is $50 per share. Its last dividend was D0=$4.19 per share. Dividends are paid semiannually and are expected to grow at an annual rate of 5% into the foreseeable future. is attached. page 1, example 1-calculate each of the following: capital weights, cost of debt, cost of preferred stock, cost of common equity. Using these, calculate the overall weighted average cost of capital (WACC)