Investment Calculators

    Make informed investment decisions with our suite of financial calculators

    XIRR Calculator

    Calculate Extended Internal Rate of Return for irregular cash flows

    Date
    Cash Flow (₹)
    Action

    Note: Enter investment amounts as negative values and returns as positive values.

    XIRR measures the annualized return considering the exact timing of cash flows.

    Results

    Your investment growth analysis

    Extended Internal Rate of Return (XIRR) Calculator

    Calculate the annualized return on investments with irregular cash flows and timing.

    Purpose

    XIRR is essential for calculating returns when you make multiple investments or withdrawals at different times, which is common in real-world investing scenarios such as SIPs, real estate, or private equity investments.

    Formula

    XIRR solves for r in the equation: 0 = Σ(Pi / (1 + r)^((di - d0)/365))

    Where Pi is the cash flow (positive for investments, negative for withdrawals), di is the date of the cash flow, d0 is the first date, and r is the rate of return. XIRR accounts for the actual timing of each cash flow.

    Example

    If you invested ₹50,000 on Jan 1, another ₹30,000 on Apr 15, and received ₹95,000 on Dec 31, XIRR would calculate your annualized return considering these specific dates.

    Use Cases

    • Evaluating SIP investments in mutual funds
    • Analyzing returns from real estate investments with irregular maintenance costs and rental income
    • Calculating returns on private equity investments with multiple capital calls
    • Assessing portfolio performance with periodic additions or withdrawals