What is the XIRR calculator?
An Extended Internal Rate of Return (XIRR) calculator is the industry standard for determining the annualized return of an investment that has multiple cash flows occurring at irregular intervals. Unlike simple ROI or CAGR, which only evaluate a single start-and-end value, this XIRR calculator weights each transaction by the exact number of days it compounds.
When you invest in a mutual fund SIP, you make monthly payments. Each installment compounds for a different duration: your first payment compounds for 12 months, your second for 11 months, and so on. Evaluating this timeline using simple CAGR is mathematically incorrect. XIRR resolves this by building a precise daily timeline of all cash inflows and outflows to compute your actual annualized growth rate.
You select the investment frequency, start date, maturity date, recurring contribution amount, and the current portfolio value. The calculator constructs the transaction timeline and solves for the internal rate of return.
How do XIRR calculators work?
This tool treats all deposits as negative cash flows (outflows) and your final portfolio value as a positive cash flow (inflow). It applies the internal rate of return equation, discounting each transaction based on its date.
The engine solves this equation using the Newton-Raphson numerical method, starting with a 10% baseline guess and iterating until the net present value (NPV) of all cash flows equals zero. This ensures your calculations match the internal logic used by Excel, Google Sheets, and investment platforms.
Σ [ Ci / (1 + XIRR)(di − d1) / 365 ] = 0
Where –
| Ci | Cash flow on transaction date i (investments are negative, redemptions are positive) |
|---|---|
| di | Exact calendar date of transaction i |
| d1 | Calendar date of the very first transaction |
| XIRR | Annualized internal rate of return |
Newton-Raphson iteration is used to find the XIRR rate that forces the sum of all discounted cash flows to equal zero.
Worked example: Analyzing a 3-year monthly SIP
Let's trace a ₹5,000 monthly mutual fund SIP for 3 years (36 installments) starting on 1 January 2021 and maturing on 1 January 2024. Total principal invested is ₹1,80,000. On the maturity date, your portfolio value is ₹2,15,396, giving a wealth gain of ₹35,396.
Each of the 36 installments is modeled as a negative cash flow of -₹5,000 on its debit date. The final value of +₹2,15,396 is modeled on 1 January 2024. The calculator discounts each monthly transaction by the exact number of days it spent in the market relative to the 365-day year.
Iterating through the equation, the calculator finds the XIRR is exactly 11.98% p.a. If you had incorrectly calculated simple CAGR on the total ₹1,80,000, it would show a misleadingly lower return. XIRR reflects the true compounding power of each rupee based on its market exposure time.
The Friction Section: Transaction Delays and Dividend Cuts
An XIRR calculator assumes that cash flows occur exactly on the scheduled dates. Real-world transaction processing introduces timing drag.
First, consider bank auto-debit lags. If your SIP date falls on a weekend or bank holiday, the debit is delayed by 1 to 2 days, and units are allocated at the next business day's NAV. This minor date shift alters the actual compound days, causing a slight variance between your bank records and the clean calendar schedule modeled by the calculator.
Second, consider dividend distribution tax. If you invest in IDCW (dividend payout) plans, the dividend distribution tax is deducted at source, reducing your cash inflows. Reinvested dividends also occur at different dates, requiring separate transaction entries to calculate a true XIRR.
Third, beware of redemptions. If you make partial withdrawals, you must treat them as positive cash flows on their respective dates. Failing to record partial redemptions will make your XIRR projection collapse.
Our Take: Why CAGR is the Wrong Tool for Portfolio Auditing
In our experience, comparing a monthly SIP's performance using CAGR is the most common portfolio auditing error. CAGR is only valid for a single, one-time investment. If you use it on a recurring SIP, you will severely understate your investment performance because you fail to account for the fact that later installments had only a few months to grow.
We recommend utilizing XIRR for all recurring or irregular investments, including SIPs, SWPs, and stock portfolios where you buy on dips. When auditing your wealth, check the XIRR reported on your consolidated account statement (CAS) rather than simple absolute returns, as this reflects the true compound rate of your capital.
How to use this XIRR calculator
Select your investment frequency, enter the start and maturity dates, set the recurring investment amount, and enter the final maturity value. Results and cash flow breakdowns update instantly.
For forward-looking projections of a flat SIP at a constant return, use the SIP calculator. For lumpsum compound interest projections, try the lumpsum calculator.
Frequently asked questions
What is the difference between XIRR and CAGR?
CAGR is designed for a single lumpsum investment with a single start and end point. XIRR is designed for multiple cash flows occurring at different times, calculating the annualized rate based on the exact day-count of each transaction.
Why does XIRR use negative numbers for deposits?
XIRR is based on cash flow direction. Outflows (money leaving your bank account to be invested) are represented as negative numbers, while inflows (money you withdraw or the current valuation of your portfolio) are represented as positive numbers.
Why does the XIRR calculation sometimes fail to converge?
XIRR uses the Newton-Raphson method, which requires a mathematical guess to start iterations. If your cash flows are highly irregular or contain massive contradicting values, the algorithm may fail to find a stable solution, resulting in an error.