please answer the following questions with formula typing too

B E H K The Absolute Zero Co. just issued a dividend of $3.40 per share on its common stock. The company is expected to maintain a constant 4.5 percent growth rate in its dividends indefinitely. If the stock sells for $53 a share, what is the company's cost of equity? Dividend per share $ Growth rate Stock price $ 3.40 4.50% 53 Complete the following analysis. Do not hard code values in your calculations. Cost of equity Holdup Bank has an issue of preferred stock with a $3.75 stated dividend that just sold for $87 per share. What is the bank's cost of preferred stock? Dividend per share Stock price $ $ 3.75 87.00 Complete the following analysis. Do not hard code values in your calculations. Cost of preferred A B D E F G H I Settlement Maturity Coupon rate Price (% of par) Redemption value (% of par) Payments per year Tax rate 01/01/00 01/01/27 7% 93 100 2 22% Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the YIELD function. You must use the built-in Excel function to answer this question. Pretax cost of debt Aftertax cost of debt Mullineaux Corporation has a target capital structure of 70 percent common stock, 5 percent preferred stock, and 25 percent debt. Its cost of equity is 11 percent, the cost of preferred stock is 5 percent, and the pretax cost of debt is 7 percent. The relevant tax rate is 23 percent. What is the company's WACC? Common stock Preferred stock Debt Cost of equity Cost of preferred stock Cost of debt Tax rate 70% 5% 25% 11% 5% 7% 23% Complete the following analysis. Do not hard code values in your calculations. WACC