XIRR

    Extended Internal Rate of Return

    Investment Planning

    The annualised return of a series of cash flows on irregular dates, solved so their present values sum to zero. It is the correct return measure for SIPs and staggered investments.

    Formula

    Sum of [CF_t / (1 + XIRR)^(days/365)] = 0

    Why it matters

    Point-to-point returns mislead when money entered at different times. XIRR weighs each rupee by how long it was actually invested, which is why fund statements report it.

    Indian example

    Related terms

    Learn the concept

    Time Value of Money