two numbers often appear on mutual fund statements. cagr. xirr.
they look similar. they are not.
one measures the growth of a single investment. the other accounts for multiple investments made at different times. using the wrong one can give a misleading picture of returns.
what is cagr
cagr is the compounded annual growth rate. it shows the average yearly growth of an investment over a specific period.
the formula is straightforward. cagr = (ending value / beginning value)^(1/n) – 1. n is the number of years.
example. an investment of ₹1 lakh grows to ₹1.5 lakh in three years. the absolute return is 50%. the cagr is roughly 14.5%.
cagr assumes one investment at the start. one redemption at the end. no additions. no withdrawals. it smooths out volatility to show the average annual return.
what is xirr
xirr stands for extended internal rate of return. it calculates the annualised return when there are multiple transactions over time.
xirr accounts for the timing and amount of every cash flow. investments are negative values. redemptions and current values are positive values.
example. a monthly sip of ₹5,000 for three years. each instalment happens on a different date. xirr calculates the actual return considering when each rupee was invested.
xirr is more accurate for real-world investing. it reflects the investor’s actual experience rather than a simplified average.
key differences
| factor | cagr | xirr |
|---|---|---|
| cash flow | assumes one initial investment | accounts for multiple, irregular investments |
| usage | lump sum investments | sips and staggered investments |
| timing | ignores timing | considers timing of each transaction |
| precision | moderate – averages growth | more precise due to time-sensitive calculations |
| complexity | simple to calculate | complex but reliable |
when to use each
use cagr for: lump sum investments. one-time purchases. comparing different funds with the same investment pattern. benchmarking against indices.
use xirr for: sips. multiple investments at different times. partial withdrawals. any investment with more than one cash flow.
cagr is a simplified measure. it works for single investments. it does not work for sips. the last sip instalment has only one month to grow. the first has several years. cagr ignores this difference.
xirr bridges that gap. it gives the investor a personalised return figure based on actual data.
frequently asked questions
1. what is cagr in mutual funds?
cagr is the annualised return of an investment, assuming it grew at a steady rate each year. it works for lump sum investments with no additional cash flows.
2. what is xirr in mutual funds?
xirr calculates the annualised return considering the timing and amount of multiple investments and redemptions. it works for sips and irregular investments.
3. which is more accurate for sip returns?
xirr is more accurate. it accounts for when each sip instalment was invested. cagr assumes all money was invested at the start.
4. can cagr and xirr be the same?
they can be similar for a single lump sum investment with no additions or withdrawals. for sips, xirr is typically different from cagr.
5. how is xirr calculated in excel?
enter transaction dates in one column and cash flows in another (investments as negative, redemptions as positive). use the formula =xirr(values, dates).
