What does IRR tell traders? IRR tells traders the projected rate of growth that a company is likely to experience following a project. A high IRR means that a project is likely to be good for growth ...

Be sure the cell range in the IRR formula always starts with the lump-sum cell in Column C and ends with the age you want. For example, =IRR (C1:C18) would be the formula used at age 80 in Column D.

Similar to IRR, the XIRR formula will give results whether the investment amounts are the same or different.