please show all work and use excel sheets and charts if necessary ty!

9-9 PREFERRED STOCK RETURNS Avondale Aeronautics has perpetual preferred stock out- standing with a par value of $100. The stock pays a quarterly dividend of $1.00 and its current price is $45. a. What is its nominal annual rate of return? b. What is its effective annual rate of return