Skip to content
AllFreeTools
GuidesDirectorySecurity
  1. Home
  2. Guides
  3. How to Calculate CAGR (and When to Use XIRR)
How-to

How to Calculate CAGR (and When to Use XIRR)

Updated 19 November 2026

CAGR, the compound annual growth rate, turns a gain over several years into a single yearly figure. It's the fairest way to compare investments held for different lengths of time, as long as the money went in once.

The CAGR formula

CAGR = (final value ÷ starting value)^(1 ÷ years) − 1. Multiply by 100 for a percentage.

A worked example

You invested ₹1,00,000 seven years ago and it's worth ₹2,50,000 today. The final value is 2.5 times the start, so CAGR = 2.5^(1 ÷ 7) − 1, which is about 14.0% a year. The total gain is 150%, but spread over seven years of compounding it is 14% a year, not 150 ÷ 7 = 21.4%.

Why not just divide by the years?

Dividing the total gain by the number of years ignores compounding and overstates the yearly return. CAGR answers a different question: what steady yearly return would have turned the starting amount into the final amount?

CAGR doesn't show the ride

An investment that rose 40% one year and fell 20% the next has a CAGR of about 5.8% over the two years. CAGR smooths out the ups and downs, so it says nothing about how bumpy the journey was.

When to use XIRR instead

CAGR assumes one investment at the start and one value at the end. For SIPs, top-ups or partial withdrawals, money went in and out on different dates, and CAGR gives the wrong answer. XIRR finds the single yearly rate that matches every amount on its actual date. It's the figure fund statements and investment apps show for SIPs.

In Excel

For CAGR: =(end/start)^(1/years)-1, or =RRI(years, start, end). For XIRR: list every investment as a negative amount with its date, add the current value as a positive amount with today's date, and use =XIRR(amounts, dates).

Comparing with other returns

An FD rate is already a yearly rate, so compare it directly with CAGR, keeping in mind that FD interest is taxed at your slab rate each year while equity gains are taxed differently. Compare returns after tax and inflation for a fair picture.

Try it

The CAGR & XIRR Calculator works out both: CAGR from a start and end value, or XIRR from a list of dated amounts. The results match Excel.

Related tools

Open CAGR & XIRR CalculatorOpen SIP CalculatorOpen Lumpsum Calculator

PDF Tools

  • All Tools
  • PDF Organize
  • PDF Edit & Sign
  • PDF Convert & Optimize

Image, Data & Calculators

  • Image Tools
  • Document & Data
  • Calculators
  • Utilities

Company & Legal

  • About Us
  • Security
  • Privacy Policy
  • Terms of Use
  • Disclaimer

Support

  • Help & FAQ
  • Contact Us
  • File Retention Policy
© 2026 AllFreeTools. All rights reserved.
Browser-Local ProcessingAvailable tools keep file bytes on your device