INSIROCTOR: J. DOUGLAS WELLINGTON NAME 2. Internal rate of return. Calculate the internal rate of return for each project from the following cash flows. Attach an Excel spreadsheet a. Original Investment Year 2Year Year Year 4 6,000,00)| 1.200.00| 1.400.00 1,600.001-27000001 (3,100.00) 3,500.00 1000.00 780.00 (2,200 (3,100.00)| 3.500.00| 1,000.00 | 780.00! (2200.00) or i0% 2A 2B Use a guess in Excel Use a guess in Excel 2C b. What are the advantages and disadvantages of using the internal rate of return