Please solve question in 24 hours if possible

Zinn Corp. has 3.50 million shares of common stock outstanding. The firm is in steady-state growth, and analysts expect the firm's earnings and dividends to continue to grow at their historical rate for the foreseeable future-per share dividends on common have grown from $2.00 six years ago to $2.80 today. Each share of Zinn's common stock is selling for $32.07 today. The firm's beta is estimated to be 1.85. The long-term Treasury rate is 3.75%, and the expected market risk premium is 5.5%. Analysts estimate that potential equity investors will require a premium of 5% over the firm's bond vield The firm's long-term debt consists of 7.25% coupon bonds, which were issued 8 years ago with an original maturity of 25 years. These bonds pay interest semiannually. Today, these bonds have a yield of 8.25%. The book value of these bonds is $300 million. Zinn Corp. also has 475,000 shares of perpetual preferred stock outstanding, and these pay a fixed dividend of $7 per year on a face value of $50. Each share of the firm's preferred currently sells for $74 The firm's marginal tax rate is 25%. Estimate the firm's weighted average cost of capital (WACC) Make sure to show all work clearly. As you set up the table in Excel, please use the order of columns and rows as sho wn below. Pre-Tax Post-Tax Cost Wtd Post- Tax Securities Price Mkt Value Weight Cost Source Debt Preferred Common