Could someone please helpmeet answer Problem 1 stock & Problem 2 stock in this workbook?

Thank you in advance

Instructions 1. You have two problems - one on each tab of this Excel file. 2. Please show your work in the cells. Use Excel formulas instead of writing the values/answers directly in the cell. The instructor will then know where you made a mistake and provide you valuable feedback and partial credit (if a Total Points: 8 s directly in the cell. k and partial credit (if appropriate). Company X is paying an annual dividend of $1.35 and has decided to pay the same amount forever. How much shoul Dividend $ 1.35 Rate of Return 0.095 Answer: Refer to the Solved Example 2 on Page 184 of your text. ever. How much should you pay for the stock, if you want to earn an annual rate of return of 9.5% on this investment? You want to purchase common stock of Company X and hold it for 7 years. The company just announced that they w How much should you pay for the stock, if you will be able to sell the stock for $28 at the end of seven years and you Future Price Dividend Rate of Return (r) Number of years (n) PRICE = ANSWER = $ $ 28.00 6.00 0.11 9 $ 28.00 x 0.434 + $ 6.00 x 5.146 Refer to the Solved Example 1 on Page 182 of your text. =B4 FORMULAS =(1/(1+B6)^(B7-1)) =B5 =(1-D11)/B6 st announced that they will be paying an annual cash dividend of $6.00 per share for the next 9 years. d of seven years and you want to earn an annual rate of return of 11% on this investment