Please show how you calculated each of the payments for years 2 through 15.

HW 2 FV PV IRR (1) -Excel Sign in HOME INSERT PAGE LAYOUT FORMULAS DATAREVIEW VIEW Foxit PDF AutoSum A Fill Wrap Text Currency 10A A o Conditional Format a Cell tting Table Styles Sort &Find & Filter Select Insert Delete Format , Clear. 4 Merge & Certer. Nignment $, % , B IU A.- Edting Clipboard B9 496 4 r, intrest rate Payment -3,000 150 Year 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: 10 12 13 14 15 16 17 18 19 20 6 10 12 13 14 15 23 24 IRR 25 Instructions Problem 1 Problem 2 Problem 3 115% EDII 4:28 PM la 9/9/2018 1 O Type here to search