Work out CAGR, XIRR, and total gain on a lump sum, SIP, or holding you already own
₹0
Invested
Returns
| Year | Invested | Portfolio Value | Returns | Return % |
|---|---|---|---|---|
| 1 | ₹1,00,000 | ₹1,12,000 | ₹12,000 | 12.0% |
| 2 | ₹1,00,000 | ₹1,25,440 | ₹25,440 | 25.4% |
| 3 | ₹1,00,000 | ₹1,40,493 | ₹40,493 | 40.5% |
| 4 | ₹1,00,000 | ₹1,57,352 | ₹57,352 | 57.4% |
| 5 | ₹1,00,000 | ₹1,76,234 | ₹76,234 | 76.2% |
Same lump sum (₹1,00,000) and 5-year tenure at illustrative rates — not live fund NAVs or bank quotes.
Three modes: project a lump sum at a fixed annual rate, project a monthly SIP at that rate, or enter what you invested, what it is worth today, and the dates to back out CAGR on an existing holding.
Lump sum uses FV = P × (1 + r)^t. SIP uses the standard annuity formula with monthly compounding. Existing mode derives CAGR from invested amount, current value, and elapsed years between the two dates.
Example: ₹1 lakh lump sum at 12% for 5 years → about ₹1.76 lakh (₹76k gain, CAGR 12%). ₹10k/month SIP at 12% for 5 years → about ₹8.25 lakh on ₹6 lakh invested. ₹1 lakh → ₹1.5 lakh over 5 years → CAGR about 8.5%.
Absolute return is total gain as a percentage of money put in — it ignores how long you held. CAGR smooths a lump sum or SIP outcome into one annual rate. XIRR here approximates the annualised return when cash goes out each month (SIP); for a single lump sum with no further flows, XIRR matches CAGR.
Expense ratios, STT, LTCG/STCG tax, exit loads, and inflation are not deducted. Projected modes assume a flat return every year — real markets move up and down. The rate comparison cards use round illustrative rates, not fund fact sheets.
The lump-sum comparison block shows how the same principal would grow at fixed rates tagged to FD, debt, balanced, index, and equity — useful for rough side-by-side math, not as a forecast or recommendation.
Match the rate to the product — debt funds and FDs do not compound at 14%. For goals, use the inflation calculator to deflate targets, then SIP or goal SIP for contribution sizing. Check actual CAGR/XIRR on your AMC statement or CAS when reviewing a live portfolio.
Disclaimer: Projections assume constant returns. Past performance and illustrative rates do not guarantee future results. Confirm tax and charges with your adviser or fund house.
Other tools in the same category on QList.