Investing through a SIP? Switch to XIRR mode to find the true annualised return on your monthly instalments, which accounts for when each rupee was invested.
CAGR and XIRR formulas
CAGR = (End value ÷ Start value)^(1 ÷ years) − 1
- CAGR
- Single annual rate that takes the start value to the end value
- XIRR
- Annual rate at which all SIP instalments grow to the current value
- Absolute return
- Total gain as a % of total invested, ignoring time
CAGR suits one-time investments and business metrics measured at two points in time. It smooths out ups and downs in between.
For SIPs, simple CAGR understates returns because later instalments were invested for less time. XIRR solves for the rate that makes the growth of every instalment equal to today's value.
Using CAGR for your business
CAGR is the standard way investors read growth in a pitch deck.
- Report revenue, users or GMV growth as CAGR over 2 to 5 years.
- Compare your growth with industry benchmarks on the same basis.
- Be careful with very short periods; one strong quarter can inflate CAGR.