IRR and XIRR in Excel
IRR is the discount rate that makes NPV of a cash-flow series equal zero.
=IRR(A2:A8)
=IRR(A2:A8, 0.1)
=XIRR(values, dates)Typical errors
- #NUM! → no sign change in cash flows, or no convergence
- #VALUE! → non-numeric cells in the range
- Multiple IRRs when cash flows change sign more than once
=IFERROR(IRR(A2:A8), "Check cash flow signs")NPV · #NUM! hub · Error directory