show formulas

1 2 3 4 5 Payment -3,000 150 1. You invest $3,000 in a project. You expect a cash flow of $150 for the first year, with net revenues to grow at 4% per year through year 15. Calculate the cash flows through year 15. 2. Format the cells to be currency with 2 decimal places. 3. Calculate the IRR of this project. Would you take it? Why or why not? WRITE YOUR EXPLANATION HERE: 7 8 9 10 11 12 13 14 15 16 17 18 19 IRR 20 21 22 Year 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 23 24 25