Problem solved in Excel only! Rating will be given. Discount Rate = 10%

Year Payment -3,000 150 1 2 3 4 5 1. You plan to invest $3,000 in a stock. You expect a Dividend of $150 for the first year, with growth rate at 4% per year through year 15. You also expec the stock price will be $9,000 at the end of year 15. Calculate the cash flows through year 15. 2. Format the cells to be currency with 2 decimal places. 3. Calculate the NPV and IRR of this stock investment. Would you make the investment? Why or why not? WRITE YOUR EXPLANATION HERE: 7 8 10 11 12 13 14 15 IRR NPV