XIRR Calculator
Find the true annualised return (XIRR) on money invested at different times — a starting lumpsum, optional monthly additions and a final value.
What is XIRR (Extended Internal Rate of Return)?
Extended Internal Rate of Return (XIRR) is the single standardized annualized compounding rate that accurately evaluates the performance of an investment featuring multiple cash inflows and outflows occurring at irregular calendar dates. Unlike simple point-to-point metrics like CAGR (which assumes a single initial deposit and a single exit), real-world investing involves dynamic cash flows: monthly SIPs, interim dividend payouts, ad-hoc lump sum top-ups, and partial unit redemptions.
XIRR weights every individual rupee deposited or withdrawn by the exact number of days it remained invested in the market, answering the definitive personal finance question: What did all my staggered cash flows earn as a net annual percentage? It is the gold standard benchmark displayed on mutual fund account statements and portfolio trackers.
The XIRR Cash Flow Equation
Σ [ CFₖ ÷ (1 + r)^( (dₖ − d₀) ÷ 365 ) ] = 0
- CFₖ: Cash flow at transaction k (Negative for investments/outflows; Positive for redemptions/inflows)
- dₖ: Specific calendar date of transaction k; d₀: Date of the initial transaction
- (dₖ − d₀) ÷ 365: Fractional holding period in years based on actual calendar days
- r: The internal rate of return (XIRR) that equates the net present value of all cash flows to zero
- Algorithm: Solved numerically via Newton-Raphson iteration identical to Microsoft Excel / LibreOffice XIRR engines
Worked example: Lump Sum plus Monthly SIP over 3 Years
Consider an investor deploying an upfront lump sum of ₹1,00,000 plus an ongoing monthly SIP of ₹5,00,000 ÷ 100 = ₹5,000 per month for 3 years (36 months), redeeming the entire portfolio for ₹3,50,000 at the end of Year 3:
- Initial Investment (Day 0): −₹1,00,000
- Monthly SIP Contributions: 36 monthly debits of −₹5,000 each = −₹1,80,000
- Total Capital Invested: ₹1,00,000 + ₹1,80,000 = ₹2,80,000
- Final Redemption Value (Year 3): +₹3,50,000
- Net Rupee Profit: ₹3,50,000 − ₹2,80,000 = ₹70,000 (25.0% absolute return)
- Personal XIRR: 11.42% per annum
Notice that while absolute profit is 25%, the true annualized return is 11.42% because later SIP instalments were invested for much shorter durations.
XIRR Benchmark Scenarios Across Cash Flow Profiles
| Investment Structure | Total Capital Invested | Holding Period | Final Value | Annualized XIRR |
|---|---|---|---|---|
| ₹1,00,000 Pure Lump Sum | ₹1,00,000 | 3 Years | ₹1,50,000 | 14.47% p.a. |
| ₹1,00,000 + ₹5,000/mo SIP | ₹2,80,000 | 3 Years | ₹3,50,000 | 11.42% p.a. |
| ₹10,000/mo Flat SIP | ₹3,60,000 | 3 Years | ₹4,35,000 | 12.82% p.a. |
| ₹1,00,000 Lump Sum (Loss) | ₹1,00,000 | 2 Years | ₹80,000 | −10.56% p.a. |
| ₹10,000/mo Flat SIP (5y) | ₹6,00,000 | 5 Years | ₹8,24,864 | 12.00% p.a. |
XIRR vs CAGR vs Absolute Return
Choosing the right metric prevents misleading conclusions:
- Absolute Return: Ignores time completely; only suitable for investments held under 12 months.
- CAGR: Measures compounding between two static dates; assumes zero additions or withdrawals in between. Ideal for fund scheme factsheets.
- XIRR: The only metric that evaluates an investor's actual lived experience, factoring in the exact timing of salary dates, bonuses deployed, and emergency redemptions.
Short Tenure Distortions and Annualization Traps
A vital mathematical caution when reading XIRR is the short-term annualization distortion. If an investment gains 5% in 15 days, annualizing that gain over 365 days yields an astronomical XIRR exceeding 230%. In reality, that pace cannot be maintained. Therefore, never evaluate XIRR for portfolios held for less than 12 to 18 months.
Frequently Asked Questions on XIRR
Key insights into calculation mechanics, SIP evaluation, short-term distortions, and tax impact.
CAGR measures the point-to-point compound growth of a single initial investment to an end value, assuming no interim cash movements. XIRR calculates the internal rate of return for multiple, recurring, or irregular cash inflows and outflows occurring on different calendar dates (such as monthly SIPs).
Because investors rarely invest all their money in a single transaction. Since a SIP involves multiple monthly purchases, earlier instalments compound for years while recent instalments compound for only months. XIRR accurately weighs each instalment by its exact holding duration.
Yes. If the total redemption value plus intermediate payouts is less than the cumulative capital invested, the net present value equates to zero at a negative discount rate, resulting in a negative XIRR indicating net capital loss.
This is a mathematical artifact called the annualization trap. If your SIP starts and the market rallies 4% in the first two weeks, compounding that 4% over an entire 365-day year creates a mathematical projection of 100%+ XIRR. Ignore XIRR until your plan has run for at least 12 to 18 months.
Cash dividends credited to your bank account should be entered as positive cash flows on their payment dates. However, in Dividend Reinvestment plans, dividends should NOT be added as external cash flows, as doing so artificially deflates the calculated XIRR through double-counting.
Indian equity indices have historically delivered long-term annualized returns around 11%–14%. While a surging bull market can temporarily push 3-year XIRRs above 20%, expecting long-term 10-to-15-year XIRRs to remain around 12% is a prudent planning assumption.
Expense ratios are deducted daily from the scheme’s Net Asset Value (NAV) before published returns. Choosing Direct plans over Regular plans saves 0.5% to 1.0% in annual distributor commissions, directly enhancing your personal XIRR by that exact percentage spread.
Standard mutual fund statements report pre-tax XIRR. To compute your true post-tax XIRR, subtract applicable capital gains taxes (e.g., 12.5% LTCG under Section 112A) from the final redemption cash flow before running the XIRR formula.
The fund’s published 5-year CAGR measures a hypothetical ₹10,000 lump sum invested exactly 5 years ago. If you started investing 2 years ago, stepped up contributions, or paused during volatility, your personal purchase timing creates a unique personal XIRR.
Yes. Any investment scenario involving dated cash outflows (purchases, renovations, stamp duty) and dated cash inflows (sales, rental income, dividends) can be accurately analyzed using XIRR.