6.) An investment resulted in the following cash flow: Year Cash Flow 0 - $500 1 $100 2 $150 3 $200 4 $250 Calculate the internal rate of return using an Excel spreadsheet and solve for IRR. Set up the spreadsheet as follows: B C DEF Year 0 1 2 3 4 IRR 1 2 Cash Flow -500 100 150 200 250 =IRR(B2:F2)