5: Preferred Stock (25 points) Answer the following Preferre…

5: Preferred Stock (25 points) Answer the following Preferred Stock questions in Excel and submit into Canvas. Extra Special Corporation issued preferred stock in 2014 that had a par value of $75. The stock pays a dividend of 4.2%. Assume that the markets required yield (required rate of return) is 6.5%, and the current price of the preferred stock is $44.75. i. What is the value of the preferred stock? ii. What is the expected rate of return of the preferred stock? iii. Would you purchase the preferred stock for $44.75 if your required rate of return was 6.5%? Explain. Complete in Excel and upload at the end of the exam.