Short answer: CAGR and XIRR are both correct, but they measure different things. CAGR is the right return for a single lump sum that goes in once and comes out once. XIRR is the right return for a SIP, where money goes in on many different dates. Your statement and your SIP calculator seem to disagree because a SIP has 12 or more start dates in a year, and only XIRR accounts for that. Once you calculate XIRR, the mismatch disappears.
Here is the scenario that confuses everyone. Your fund’s fact sheet says it returned 15 percent last year. Your SIP statement shows your gain as just 8 percent. Did you get a worse deal than the fund? No. Those two numbers measure different things, and both are right. Let me show you exactly why, with a worked example and the Excel formula to check your own statement.
What CAGR actually measures
CAGR, or Compound Annual Growth Rate, is the smooth yearly rate that takes a single starting amount to a single ending amount. Its formula is simple:
\text{CAGR} = \left(\frac{\text{Ending Value}}{\text{Beginning Value}}\right)^{\frac{1}{n}} - 1Here n is the number of years. CAGR assumes one inflow at the start and one value at the end, with nothing added in between. That makes it perfect for a lump sum. If you put ₹1 lakh in a fund and it became ₹2 lakh in 6 years, CAGR tells you the annual rate. But CAGR has no way to handle money added every month, which is exactly what a SIP does. Apply it to a SIP and it quietly assumes all your money was invested from day one, which is simply not true. You can see CAGR in action for one-time investments in our lumpsum investment calculator.
What XIRR actually measures
XIRR, or Extended Internal Rate of Return, is built for messy, real-life cash flows. It is the single annual rate that makes the present value of all your inflows and outflows net to zero, no matter what dates they fall on. In plain terms, it is the one rate of return that ties together every installment you paid and the value you hold today. The equation it solves looks like this:
\sum_{i=1}^{N} \frac{C_i}{(1 + \text{XIRR})^{\frac{d_i - d_1}{365}}} = 0Here each C is a cash flow on its date d. Because it weighs every payment by how long it was actually invested, XIRR is the correct measure for SIPs, for lump sums added later, for partial withdrawals, and for any mix of the above. If you invest on many dates, XIRR is your real return.
The worked example: same SIP, two numbers
Say you invest ₹10,000 on the first of every month for 12 months. You put in ₹1,20,000 in total, and at the end of the year your investment is worth ₹1,28,090. Now let us measure that same result three ways.
| Measure | What it assumes | Result on this SIP |
|---|---|---|
| Absolute return | Time does not matter at all | 6.7% |
| CAGR applied to the SIP | All ₹1.2 lakh was invested for the full year | 6.7% (wrong for a SIP) |
| XIRR | Each installment invested for its actual duration | 12.7% (correct) |
The absolute gain of ₹8,090 on ₹1,20,000 is 6.7 percent, and that is the number that makes people feel shortchanged. But it treats a rupee invested in January the same as a rupee invested in December, which is nonsense. Your January installment worked for 12 months. Your December installment worked for just 1. On average, your money was invested for only about 6.5 months, not 12.
| Installment | Months it stayed invested |
|---|---|
| 1st (January) | 12 |
| 6th (June) | 7 |
| 12th (December) | 1 |
| Average | About 6.5 |
A 6.7 percent gain earned in only about 6.5 months is not a 6.7 percent annual return. Annualize it properly and it works out to roughly 12.7 percent, which is your XIRR. That is your true rate, and it lines up with the fund’s own performance. The 6.7 percent was never your annual return, it was just your absolute gain squeezed over a short average holding period.
Why your statement doesn’t match the calculator
Now the original puzzle solves itself. When a fund advertises a 15 percent one-year return, that is a point-to-point figure, the CAGR of money that sat in the fund for the entire year. Your SIP money did not sit there for the entire year. Most of it arrived in the second half, so your absolute gain looks smaller even though your XIRR can match, or even beat, the fund’s headline number.
Your SIP calculator adds to the confusion because it projects a clean annual rate applied neatly to every installment, while your statement often shows a plain absolute gain. They are describing the same investment with different rulers. This is the same reason projected and real returns feel off, which we cover in why SIP returns look different in real life vs calculator results. The fix is always the same: stop comparing an absolute gain to an annual rate, and calculate your XIRR instead. You can also model expected outcomes cleanly in our SIP calculator.
How to check your own XIRR in Excel
You do not need special software. Excel and Google Sheets both have a built-in XIRR function. Here is how to check your real return in a few minutes.
- Step 1: In column A, list the date of every SIP installment you paid.
- Step 2: In column B, next to each date, enter that installment as a negative number, since it is money going out, for example -10000.
- Step 3: In the last row, put today’s date in column A and your current total value as a positive number in column B, as if you redeemed everything today.
- Step 4: In an empty cell, type the formula below and format the cell as a percentage.
The formula is:
=XIRR(B2:B14, A2:A14)
Here B2:B14 is your list of cash flows and A2:A14 is your list of dates. A simple layout looks like this:
| Date (column A) | Cash flow (column B) |
|---|---|
| 01-Jan-2025 | -10000 |
| 01-Feb-2025 | -10000 |
| … (each month) | -10000 |
| 01-Dec-2025 | -10000 |
| 31-Dec-2025 | 128090 |
The result is your annualized return. If Excel shows a #NUM error, add a guess to the end, like =XIRR(B2:B14, A2:A14, 0.1), and it will solve. For CAGR on a one-time investment instead, use =(End/Start)^(1/years)-1. Nearly every fund app also shows your XIRR directly in the returns section, so you can cross-check your sheet against it.
When to use which
The rule is short. Use CAGR when there is a single investment and a single value, like a lump sum or comparing two funds over the same fixed period. Use XIRR whenever money went in or out on more than one date, which covers every SIP, every top-up, and every partial withdrawal. Since CAGR is really the lump sum version of the same idea, the choice mirrors the SIP vs lumpsum decision itself: one date means CAGR, many dates mean XIRR.
The bottom line
Your statement is not wrong and your calculator is not lying. They just speak different languages. CAGR measures a lump sum from one date to another, while XIRR measures the true annual return on money invested across many dates, which is what a SIP really is. The next time a low-looking number worries you, do not compare your absolute gain to a fund’s advertised rate. Open a sheet, run =XIRR, and read your actual return. Almost always, it is healthier than you feared.
CAGR measures the annual return of a single investment with one start and one end value, so it suits a lump sum. XIRR measures the annual return when money is invested or withdrawn on multiple dates, so it is the correct measure for a SIP. Both are accurate, but they answer different questions.
Because your absolute return ignores timing. In a SIP, your early installments stay invested much longer than your recent ones, so on average your money is invested for far less than the full period. XIRR annualizes the gain over that shorter true holding period, which makes it higher than the raw absolute percentage.
XIRR is the correct choice for a SIP. Because a SIP adds money on many different dates, CAGR cannot handle it and effectively assumes all the money was invested from day one. XIRR weighs each installment by how long it was actually invested, giving your true annualized return.
List every SIP installment as a negative amount next to its date, then add today’s date with your current value as a positive amount. Use the formula =XIRR(values, dates), for example =XIRR(B2:B14, A2:A14), and format the result as a percentage. Add a guess like 0.1 if you see a #NUM error.
The calculator usually shows a clean annual rate, while your statement often shows an absolute gain on money that was invested for varying lengths of time. They measure the same investment with different rulers. Calculate your XIRR to reconcile them, and the numbers will line up.
Not useless, just wrong for measuring a SIP’s overall return. CAGR is still perfect for a single lump sum or for comparing two funds over the same fixed period. For any investment with multiple cash flow dates, use XIRR instead so timing is properly accounted for.
