How to Read CAGR From a Mutual Fund Statement
Turn the units, NAV and dates on your statement into an annual return, and learn why CAGR is right for one purchase but misleading for a SIP.
A statement shows value, not a yearly return
Your mutual fund statement tells you how many units you hold, the NAV (price per unit) and the current value. What it does not give you in plain form is the one number that lets you compare the fund with an FD, a PPF account or another fund: the average return per year. That number is the CAGR, the compound annual growth rate. This guide shows how to get it from the figures on your statement, when it is correct, and when it quietly misleads you.
This is general information, not investment or tax advice. The examples use made-up numbers for illustration.
Absolute return versus CAGR
Absolute return is the total gain as a percentage of what you put in. If you invested Rs. 50,000 and the holding is now worth Rs. 80,000, the absolute return is 60%. It sounds good, but it ignores time. A 60% gain in three years and a 60% gain in eight years are very different outcomes.
CAGR spreads the growth into a steady yearly rate. The formula is:
CAGR = (current value ÷ invested amount)^(1 ÷ years) − 1
Here is the same 60% absolute return over three different holding periods:
| Holding period | Absolute return | CAGR |
|---|---|---|
| 3 years | 60% | 16.96% a year |
| 5 years | 60% | 9.86% a year |
| 8 years | 60% | 6.05% a year |
The percentage on the statement is identical, yet the yearly return falls from about 17% to about 6%. This is why absolute return alone should never be used to compare two holdings.
Worked example: one purchase, five years
Suppose you bought 1,000 units at a NAV of Rs. 50 and the NAV is now Rs. 80, five years later.
- Invested amount: 1,000 × Rs. 50 = Rs. 50,000.
- Current value: 1,000 × Rs. 80 = Rs. 80,000.
- Gain: Rs. 30,000, or 60% absolute.
- CAGR: (80,000 ÷ 50,000)^(1/5) − 1 = about 9.86% a year.
You can check this with the mutual fund returns calculator. Enter units, buy NAV, current NAV and the holding period in years. It reports the invested amount, current value, absolute return in rupees and per cent, and the CAGR. It uses exactly the formula above.
A useful sanity check: compound the CAGR forward. Rs. 50,000 growing at 9.86% for five years gives roughly Rs. 80,000 again. You can run that in the lumpsum calculator, which computes amount × (1 + rate)^years with annual compounding.
How to read the number
- Compare like with like. A CAGR of 9.86% is a comparison point against other options over a similar period. It does not mean the fund earned 9.86% in each of those five years. The NAV may have risen 30% in one year and fallen in another.
- Look at the period. A CAGR over two years is very sensitive to where the market happened to be on your start and end dates. For example, Rs. 1,00,000 growing to Rs. 1,50,000 is 22.47% a year over two years but only 6.99% a year over six. Short-period CAGR can look spectacular or terrible without saying much about the fund.
- Do not project it forward as a promise. Past CAGR is a description of what happened. If you want to see what a future amount could look like, enter a range of assumed rates, not just the best past figure.
Where CAGR goes wrong: SIPs and top-ups
CAGR assumes one amount went in on one date and stayed there. If you invested through a SIP, or topped up at different times, your money was invested for different lengths of time, and a single buy NAV does not describe it.
Take a SIP of Rs. 10,000 a month for 12 months, with the NAV drifting from Rs. 100 at the first instalment to Rs. 120 at the end of the year. (This NAV path is invented for the example.) You invest Rs. 1,20,000 in total and end up with about 1,102 units worth about Rs. 1,32,277, a gain of 10.23% in absolute terms. What is your yearly return? Three quick answers give three different results:
| Method | Result | Problem |
|---|---|---|
| CAGR using the first NAV (100 to 120) over 1 year | 20.00% | Pretends all the money was invested on day one, so it overstates. |
| CAGR using your average buy NAV (about Rs. 108.86) over 1 year | 10.23% | Pretends all the money was invested a year ago, so it understates. It is also just the absolute return. |
| XIRR using the date of each instalment | about 19.41% | Accounts for when each rupee went in. This is the right measure. |
XIRR solves for the single yearly rate that makes all your dated cash flows (each instalment as an outflow, the current value as an inflow) net to zero. It needs the date of every transaction, which your statement lists. A spreadsheet's XIRR function can do it. Our returns calculator does not: it takes one buy NAV and one holding period, so for a SIP it can only give you one of the two misleading answers above.
To see what a regular investment might grow to under an assumed rate, use the SIP calculator. To understand the compounding behind all of these numbers, the compound interest calculator shows the effect of rate and time directly.
A quick decision guide
- One purchase, never added to, no withdrawals: CAGR is correct. Use units, buy NAV, current NAV and the exact period in years (for example, 3 years 6 months is 3.5).
- SIP, or several purchases on different dates: use XIRR with every dated transaction. Do not average the NAVs and apply CAGR.
- Partial redemptions or switches: these are cash flows too. They also need XIRR, or you can analyse each lot separately.
- Comparing with an FD or PPF: compare CAGR (or XIRR) with the post-cost, post-tax rate of the alternative, not the headline rate.
Limits: what the calculator does not cover
- Single purchase only. It accepts one buy NAV and one holding period. It does not take multiple dates or amounts and does not compute XIRR.
- Capital gains tax. Tax depends on the type of fund and how long you held it, and the rules change from time to time. The result is before tax, so check the current rules for your fund category before comparing with a post-tax option.
- Exit load. If you redeemed early and paid an exit load, the real proceeds are lower than units × NAV.
- Dividends or IDCW payouts. Money received during the holding period is not included. If your fund paid any, your true return is higher than the figure shown.
- Expense ratio. Fund costs are already reflected in the NAV, so you do not subtract them again, but they are one reason the fund's return differs from its portfolio's return.
The practical takeaway: use CAGR to put a single, untouched investment on a yearly scale, and switch to a date-based method the moment money has gone in or out at different times. For personal decisions, a SEBI-registered adviser can look at your whole situation.