Using the IRR function, you can easily calculate the internal rate of return based on a series of cash flows. The result provides an annual rate of return, which can be compared with the required ...