You have been asked to calculate the internal rate of return for an investment with the following cash flows, using the Excel IRR function:

1.06% 14.72% You have been asked to calculate the internal rate of return for an investment with the following cash flows, using the Excel IRR function: The cost of the investment is $500,000. Cash flows in years 1 through 5 are $200,000; $160,000; $120,000; $80,000; and $40,000, respectively. There is no residual value to the investment. YOU WERE SURE AND INCORRECT 8.35% Using Excel's IRR function, what is the internal rate of return on the investment after 3 years? THE CORRECT ANSWER -2.19% I DON'T KNOW YET 14.72% You have been asked to calculate the internal rate of return for an investment with the following cash flows, using the Excel IRR function: The cost of the investment is $500,000. Cash flows in years 1 through 5 are $200,000; $170,000; $140,000; $110,000; and $80,000, respectively. There is no residual value to the investment. YOU WERE SURE AND INCORRECT -2.19% 9.72% Using Excel's IRR function, what is the internal rate of return on the investment after 3 years? THE CORRECT ANSWER 1.06% I DON'T KNOW YET