আরামবাগ, পশ্চিমবঙ্গ · 2020 থেকে +91 7699462154 |
BullishBrush logo BULLISHBRUSHLearn Today, Lead Tomorrow

XIRR vs CAGR: How to Measure Your Real Investment Returns

· BullishBrush · 3 মিনিটে পড়া

Investment apps, fund factsheets and advertisements show returns in different ways — absolute returns, CAGR, XIRR. They are not interchangeable. Knowing the difference helps you judge performance correctly and compare investments fairly.

Absolute return

Absolute return = (current value − invested amount) ÷ invested amount × 100.

If ₹1,00,000 becomes ₹1,50,000, the absolute return is 50%. It ignores time — 50% in two years and 50% in ten years look the same.

CAGR: for a single investment

Compound Annual Growth Rate shows the steady yearly growth rate that would take a starting value to an ending value over a period:

CAGR = (ending value ÷ starting value)^(1 ÷ years) − 1

₹1,00,000 growing to ₹1,50,000 in 3 years is a CAGR of about 14.5%. Use the CAGR calculator.

CAGR works for one investment made on one date — a lump sum, or comparing an index level from one year to another.

XIRR: for multiple cash flows

A SIP has many investments on different dates. Each instalment has been invested for a different length of time, so CAGR does not work. XIRR (Extended Internal Rate of Return) solves this: it finds the single annual rate at which all your cash flows (investments as outflows, current value as an inflow) balance out, taking each date into account.

XIRR is the standard way to measure SIP returns, and is what mutual fund statements typically report. Use the XIRR calculator or see XIRR for real fund SIPs in the SIP backtest.

A simple example

  • Lump sum of ₹1,20,000 on 1 January 2021, worth ₹1,80,000 on 1 January 2026 → CAGR ≈ 8.4%.
  • SIP of ₹2,000 a month for the same five years (total ₹1,20,000), worth ₹1,80,000 at the end → XIRR is much higher, because the average rupee was invested for only about half the period.

Same invested amount, same final value — very different annualised returns. That is why using absolute return or CAGR for SIPs is misleading.

Which to use when

Situation Measure
One-time investment CAGR
SIP or irregular investments XIRR
Comparing fund performance over a period CAGR (trailing returns)
Your own portfolio with many transactions XIRR
Very short periods (under 1 year) Absolute return

Common mistakes

  • Comparing a SIP's absolute return with an FD's annual interest rate.
  • Judging a fund on one-year returns.
  • Ignoring that annualised returns for very short periods can look extreme.

Rolling returns

For deeper analysis, many investors look at rolling returns — CAGR over every possible 3- or 5-year window — to see how consistent a fund's performance has been. Calendar-year returns on our fund pages give a quick view of consistency.

Key takeaways

  • Absolute return ignores time; CAGR annualises a single investment; XIRR annualises multiple cash flows.
  • Always use XIRR for SIPs and your actual portfolio.
  • Compare like with like: annualised returns with annualised returns.
  • Look at consistency, not just one number.

Frequently asked questions

Why is my SIP XIRR different from the fund's CAGR?

Because your instalments were invested at different dates and prices, while the fund's CAGR assumes a single investment at the start.

Is XIRR better than CAGR?

Neither is better — they answer different questions. XIRR is right for multiple cash flows; CAGR for a single investment.

Can XIRR be negative?

Yes, if the current value is less than the total invested.

How do I calculate XIRR?

Use our free XIRR calculator, or spreadsheet XIRR functions with dates and amounts.

Learn it properly — with a mentorLive classes in Bengali, Hindi and English since 2020. Join a free demo class and ask your questions.
Book a free demo class

BullishBrush শুধুমাত্র শেয়ার বাজারের শিক্ষা দেয়। আমরা SEBI-রেজিস্টার্ড ইনভেস্টমেন্ট অ্যাডভাইজার বা রিসার্চ অ্যানালিস্ট নই এবং কোনো কেনা-বেচার পরামর্শ বা টিপস দিই না। শেয়ার বাজারে বিনিয়োগ বাজারের ঝুঁকির অধীন; বিনিয়োগের আগে সব নথি মনোযোগ দিয়ে পড়ুন। অতীতের ফলাফল ভবিষ্যতের নিশ্চয়তা নয়।

এরপর পড়ুন → বিনিয়োগ ও ফান্ডSIP vs Lump Sum: Which Is Better for Mutual Fund Investing?Should you invest monthly through a SIP or put everything in at once? The honest answer depends on where your money comes from — and your nerves.

আরও লেখা