Skip to content

Investing basics

XIRR vs CAGR: which return figure to trust for your SIP

1 min read

CAGR measures one investment from a start value to an end value. XIRR handles money added or withdrawn on different dates, which is why mutual fund statements report SIP returns as XIRR. Worked examples in rupees.

Use CAGR when one amount goes in and one value comes out. Use XIRR whenever money goes in or out on more than one date, as in a SIP. For a single investment held for whole years the two give the same answer; with several cash flows only XIRR is right.

CAGR: one start, one end

CAGR (compound annual growth rate) is the constant yearly rate that turns a starting value into an ending value over a number of years: (end ÷ start) ^ (1 ÷ years) − 1.

Example: ₹1,00,000 that grows to ₹1,50,000 in 3 years has a CAGR of about 14.47% a year.

XIRR: many cash flows, each with its own date

XIRR (extended internal rate of return) finds the single annual rate at which all your dated investments and withdrawals balance out. It gives each rupee credit only for the time it was actually invested, which is why fund statements and the Excel XIRR function use it for irregular cash flows.

Worked example: why CAGR misleads with two investments

Illustration with assumed figures, not a real fund.

DateCash flow
1 Jan 2021Invest ₹1,00,000
1 Jan 2023Invest ₹1,00,000
1 Jan 2026Portfolio worth ₹2,80,000

XIRR on these dates is about 8.68% a year. A CAGR that treats the full ₹2,00,000 as invested on 1 Jan 2021 gives only about 6.96%, because it ignores that the second ₹1,00,000 was invested for 3 years, not 5. The more often you invest, the bigger this error gets.

XIRR vs CAGR at a glance

CAGRXIRR
Cash flowsOne in, one outAny number, on any dates
Right forLumpsum, a stock held for years, index growthSIP, SIP plus top-ups, partial withdrawals
Needs dates?Only the number of yearsThe date of every cash flow
Same answer whenOne investment held for whole yearsOne investment held for whole years

Calculate both

The Fistotex CAGR calculator needs a start value, an end value and years. The XIRR calculator takes each dated cash flow, the way your mutual fund statement lists them.

This article is educational and is not investment, tax or legal advice. Past returns do not indicate future returns.

Sources