CAGR vs IRR Calculator.
Use the Right Return Metric.
CAGR and IRR can give different answers for the same investment. The calculator on this page computes CAGR from a start value, an end value and a number of years. When money went in or out at different times, IRR or XIRR is the right measure; the sections below show how to calculate it in a spreadsheet and why the two differ.
CAGR vs IRR: Quick Reference
CAGR
Compound Annual Growth Rate
- Single start/end value
- Lumpsum investments
- Mutual fund NAV comparison
- Simple, no cash flows
IRR / XIRR
Internal Rate of Return
- Multiple cash flows
- SIP investments
- Real estate with rent income
- Accurate personal returns
Absolute Return
Total % Gain
- Total gain without annualization
- Good for short periods (<1yr)
- Not useful for comparison
- Easy to understand
CAGR Formula
CAGR = (End Value ÷ Start Value)^(1 ÷ Years) − 1CAGR Calculator
For a single start and end value. To project monthly contributions at an assumed return, use the SIP Calculator; to measure the return you actually earned on dated contributions, use XIRR in a spreadsheet as shown below.
CAGR Calculator Inputs
Calculate the compound annual growth rate of your investment
CAGR Results
Your investment growth analysis
Enter your investment values to calculate CAGR
Side-by-Side: CAGR vs IRR vs XIRR
| Factor | CAGR | IRR | XIRR |
|---|---|---|---|
| Cash flows | Single start/end | Multiple, equal intervals | Multiple, unequal dates |
| Use case | Lumpsum, fund NAV | Business projects, private equity | SIPs, personal portfolios |
| Excel formula | =(End/Start)^(1/n)-1 | =IRR(cash flows) | =XIRR(values, dates) |
| Dates needed | No | No (assumes equal periods) | Yes — actual dates |
| Accuracy for SIP | Misleading | Approximate | Most accurate |
| What it describes | The investment itself | A project's or deal's cash flows | Your own result, given your dates |
| Real estate analysis | Limited | Common | Best with actual dates |
| Complexity | Simple | Moderate | Moderate |
Example: A Fund's CAGR Is Not Your Monthly-Investing Return
Scenario
- You invest $500 at the start of every month for 10 years
- Total invested: $60,000 (120 × $500)
- The fund's NAV goes from $10.00 to $33.95, a 10-year CAGR of 13%
- Values are measured at the end of the 120th month
If the NAV rose exactly 13% every year
≈ $118,200 · XIRR 13%
Every instalment earns 13% a year, so your return equals the fund's CAGR
If your account ends at ≈ $107,400 instead
XIRR ≈ 11.2%
Same start and end NAV, but a different path in between
Why the difference? Less time in the market does not by itself lower an annualised rate: with steady 13% growth, an instalment invested for one year and one invested for ten both earn 13% a year. The gap comes from the path the NAV took. If most of the gain came in the early years and the NAV then moved sideways, the later instalments were bought at high prices and earned little, so your XIRR falls below the fund's CAGR. A path with a late surge does the opposite. Both numbers are correct; they measure different things.
Worked Example: One Fund, Three Investors, Three Different Returns
The cleanest way to see the gap between CAGR and IRR is to hold the investment constant and change only when the money goes in. Take a fund whose price (NAV) is $100 today, $120 after year 1, $90 after year 2 and $135 after year 3. The fund's own CAGR is (135 ÷ 100)1/3 − 1 = 10.52% for everyone. Now three investors each put in $10,000 in total:
| Investor | When they buy | Value after year 3 | Fund CAGR | Personal IRR |
|---|---|---|---|---|
| A: lumpsum | $10,000 today | $13,500 | 10.52% | 10.52% |
| B: waits for the dip | $5,000 today + $5,000 after year 2 (NAV $90) | $14,250 | 10.52% | 18.52% |
| C: buys into the rally | $5,000 today + $5,000 after year 1 (NAV $120) | $12,375 | 10.52% | 8.86% |
Same fund, same three years, and personal returns range from 8.86% to 18.52%. Only investor A's IRR equals the fund's CAGR, because only A had a single cash flow. Investor B's second $5,000 bought 55.6 units at $90 instead of 41.7 units at $120, which is why the IRR jumps. The fund's published CAGR describes the fund; your IRR describes you.
The tempting shortcut is wrong. For investor B, dividing $14,250 by the $10,000 invested and annualising over three years gives 12.5%. That treats every dollar as if it had been invested for the full three years, but half of it was invested for only one. The true figure is 18.52%.
How IRR Is Actually Calculated
CAGR has a closed-form formula. IRR does not. It is the single discount rate r that makes the net present value of every cash flow equal zero:
0 = CF₀ + CF₁ ÷ (1+r) + CF₂ ÷ (1+r)² + … + CFₙ ÷ (1+r)ⁿBecause r appears in every denominator, spreadsheets and calculators find it by trial and error: guess a rate, check whether NPV is positive or negative, adjust, repeat until NPV rounds to zero. XIRR does the same thing but raises (1+r) to the power of days ÷ 365 instead of whole periods, so a contribution made on the 14th counts for exactly the time it was invested.
Small numbers, worked by hand
You invest $10,000 at the end of each of years 0, 1 and 2, and the pot is worth $36,000 at the end of year 3. Try r = 9.4%: −10,000 − 10,000 ÷ 1.094 − 10,000 ÷ 1.094² + 36,000 ÷ 1.094³ ≈ 0. So the IRR is about 9.4%. A CAGR on "$30,000 became $36,000 in 3 years" would give 6.3%, which understates your return by roughly a third.
Where IRR can mislead
- Multiple answers. If cash flows change sign more than once (invest, withdraw, invest again), the equation can have several valid rates. Check the result against a sanity range or use MIRR.
- Reinvestment assumption. IRR implicitly assumes interim cash is reinvested at the IRR itself. At 25% that is rarely realistic, so MIRR with an explicit reinvestment rate is more conservative.
- Short periods get over-annualised. A 4% gain in two months is a 26.5% annualised IRR (1.046 − 1), but nothing says you can repeat it for ten more months.
- Percentage ≠ money. A 40% IRR on $500 matters far less than 12% on $50,000. Read IRR alongside the absolute gain.
Which Metric Answers Which Question
| Your question | Use |
|---|---|
| How fast did this stock, fund or index grow over a period? | CAGR |
| What return do I need to turn $20,000 into $50,000 in 8 years? | CAGR (solved backwards) |
| How did my own account perform, given when I added or withdrew money? | XIRR |
| Did my monthly SIP or dollar-cost averaging beat just holding the index? | XIRR vs the index's CAGR over the same dates |
| Is this rental property or private deal worth it? | IRR (or XIRR with exact dates), plus absolute gain |
| Which of two funds had the better manager? | CAGR of the NAV, not anyone's personal IRR |
For the compounding mechanics behind CAGR, read how to calculate CAGR. If you add money on a schedule, dollar-cost averaging and value averaging both produce uneven cash flows, which is exactly the case where IRR is the honest measure. To see how raising contributions over time changes the picture, see the escalating contributions guide, and to strip out inflation, real returns after inflation.
Frequently Asked Questions
What is the difference between CAGR and IRR?▾
CAGR (Compound Annual Growth Rate) measures the steady-state annual growth rate of a single investment from start to end value, assuming no interim cash flows. IRR (Internal Rate of Return) is the single annual rate that accounts for multiple cash flows at different times, which makes it the right measure for monthly investing (SIPs), real estate, or any investment with deposits or withdrawals along the way. CAGR describes one start value and one end value; IRR describes a series of cash flows.
When should I use IRR instead of CAGR?▾
Use IRR when: (1) You have multiple investments at different times (SIPs, monthly contributions); (2) You are evaluating real estate (purchase, rental income, and sale); (3) Comparing business projects with irregular cash flows; (4) Your investment has redemptions or withdrawals at different points. Use CAGR for: simple one-time investments, comparing mutual funds over a fixed period, or calculating what return you need to reach a goal.
What is XIRR and how is it different from IRR?▾
XIRR is IRR with actual dates (not just periods). Regular IRR assumes equally spaced cash flows (monthly, annually). XIRR takes the exact date of each cash flow, which matters for monthly investments made on specific dates. In Excel or Google Sheets, use XIRR(values, dates) with each investment as a negative number and the current value as a positive number on today's date.
Can CAGR and IRR give different results for the same investment?▾
Yes. For a single lumpsum investment held to the end, CAGR and IRR are identical. With several cash flows they usually differ. In the worked example on this page, one fund with a 10.52% CAGR gives three investors personal IRRs of 10.52%, 18.52% and 8.86%, depending only on when they put money in. The fund's CAGR describes the fund; your IRR describes your own result.
What is a good CAGR for stock market investments?▾
There is no single threshold. Compare your CAGR with a relevant benchmark over the same dates, such as the index your fund tracks, and with inflation over that period. Real return = (1 + CAGR) ÷ (1 + inflation) − 1, so a 12% CAGR with 7% inflation is a 4.67% real return, slightly less than the 5% you get by subtracting.
How do I calculate CAGR in Excel?▾
CAGR formula in Excel: =(End Value/Start Value)^(1/Years)-1. Example: Start = $10,000, End = $20,000, Years = 7. CAGR = (20000/10000)^(1/7)-1 = 10.41%. For returns on regular contributions, use the XIRR function with the actual dates.
Method and sources
The calculator computes CAGR = (final value ÷ initial value)^(1 ÷ years) − 1, plus total growth = (final − initial) ÷ initial and the absolute gain. It does not compute IRR or XIRR; the IRR and XIRR figures on this page were solved separately from the cash flows shown, using the same definition as the spreadsheet functions.
- Compound Interest Calculator — Investor.gov, U.S. Securities and Exchange Commission
- IRR function — Microsoft Support
- XIRR function — Microsoft Support
- 2020 GIPS Standards for Firms (money-weighted and time-weighted returns) — CFA Institute
Written by Utkarsh Mohan. Last reviewed . Results are estimates for education, not financial or tax advice.
Related Calculators
Disclaimer: These calculators use standard financial formulas. Past CAGR does not guarantee future returns. All investments carry risk. Consult a registered or licensed financial adviser before investing.
Guides on measuring and comparing returns
- Value Averaging: The Smarter DCA Alternative?Targeting a portfolio value rather than a fixed contribution.
- Cost Averaging Explained: Dollar, Rupee, Pound & Euro Cost AveragingCost averaging across dollars, rupees, pounds and euros.
- Averaging Down vs Dollar-Cost Averaging: Which Strategy Wins?Reactive conviction buying versus a systematic schedule — routinely confused.
- DCA Out: How to Sell Without Timing the MarketSelling systematically, so the exit isn't a single timing bet.
- Systematic Withdrawal Plan (SWP): How to Turn a Corpus Into Monthly IncomeConverting a corpus into monthly income without draining it early.
- Portfolio Rebalancing: The Art of Selling WinnersKeeping risk where you set it, and the tax cost of doing so.
- Dividend Investing: Build a Passive Income MachineBuilding income that grows, and the yield traps to avoid.
- International Diversification: How Much Should You Hold?How much to hold abroad, and why the answer isn't market weight.
- NRI Investing in India 2026: Complete Guide for Non-Resident IndiansNRE and NRO accounts, repatriation limits and compliance.
- Diversification: The Only Free Lunch in InvestingWhat genuinely diversifies, and what only appears to.