How to Calculate CAGR and Annualized Returns

What CAGR and annualized returns measure

Retail traders use CAGR (Compound Annual Growth Rate) and annualized returns to compare performance across investments with different durations. Both express a multi-period return as a single annualized number, but they differ in how they treat cash flows and interim volatility.

• CAGR (also called geometric average) assumes a single lump-sum investment held over n years and measures the constant annual growth rate that transforms the initial value into the ending value.
• Annualized return is a broader term: for a single holding it equals CAGR, but when there are interim cash flows you use money-weighted returns (IRR/XIRR) or time-weighted returns depending on what you want to measure.

This article gives the compound annual growth rate formula, the annualized return calculation methods, and worked examples you can replicate.

The basic compound annual growth rate formula

CAGR = (Ending Value / Beginning Value)^(1 / n) - 1

Where:

• Ending Value = portfolio or investment value at the end
• Beginning Value = value at the start
• n = number of years (can be fractional)

Important notes:

• Express CAGR as a percentage by multiplying by 100.
• Use consistent time units (years). For periods in days, convert to years: n = days / 365 (or 365.25 for leap-year adjustment).

Worked example: single lump-sum investment

Hypothetical numbers (illustrative only):

• Beginning Value = 10,000
• Ending Value after 5 years = 18,000
• n = 5 years

Step-by-step:

1. Compute Ending / Beginning: 18,000 / 10,000 = 1.8
2. Raise to the power 1/n: 1.8^(1/5) ≈ 1.1253
3. Subtract 1: 1.1253 - 1 = 0.1253
4. Convert to percent: 0.1253 × 100 = 12.53%

So the CAGR is approximately 12.53% per year. This is the constant yearly growth rate that would turn 10,000 into 18,000 over 5 years.

Annualizing short-term returns

If you hold an investment for less than a year, annualize it via: Annualized return = (1 + R)^(365 / d) - 1

Where R is the observed return over d days.

Example: a 6.0% gain over 120 days

1. R = 0.06, d = 120
2. Annualized = (1 + 0.06)^(365/120) - 1 ≈ 1.06^(3.0417) - 1 ≈ 0.191 = 19.1%

This shows how a short-period return scales to an equivalent yearly rate, assuming repeated similar performance.

When there are cash flows: IRR / XIRR (money-weighted) vs time-weighted returns

CAGR only works for single lump sums. If you add or withdraw money mid-period, use one of these:

• Money-weighted return (Internal Rate of Return, IRR or XIRR): solves for the discount rate that sets the net present value of cash flows (including final value) to zero. It reflects the investor’s actual experience.
• Time-weighted return: removes the effect of investor cash flows and measures the manager’s performance by compounding sub-period returns.

IRR formula (conceptual): 0 = Σ_{t=0}^{T} CF_t / (1 + r)^{t}

Where CF_t are cash flows at times t (with negative for investments into the portfolio and positive for withdrawals or final value), and r is the IRR. For irregular timing, use XIRR functionality in spreadsheets.

Worked example (cash flows): Hypothetical numbers:

• Jan 1, 2020: Investor deposits 5,000 (CF0 = -5,000)
• Jan 1, 2021: Investor deposits 3,000 (CF1 = -3,000)
• Jan 1, 2023: Ending value = 10,000 (CF3 = +10,000)

We need the annualized r that solves: -5,000 / (1 + r)^0 + -3,000 / (1 + r)^1 + 10,000 / (1 + r)^3 = 0

This equation doesn't have a closed-form algebraic solution; you solve numerically (trial-and-error, spreadsheet IRR/XIRR, or a financial calculator). Using a spreadsheet XIRR function on the three dated cash flows gives an annualized return roughly in the range of 4–8% depending on exact dates. (For most retail workflows, use Excel/Sheets XIRR or a calculator.)

Why choose IRR vs time-weighted?

• IRR: good if you want to evaluate your personal performance (including your timing of contributions).
• Time-weighted: better when comparing fund managers, because it neutralizes investor cash-flow timing.

Common pitfalls and how to avoid them

• Mixing nominal and real returns: adjust for inflation if you want purchasing power changes.
• Not accounting for fees: include fees as cash outflows when computing IRR/CAGR for net returns.
• Using CAGR with multiple cash flows: this understates or misstates performance when contributions/withdrawals occur.
• Relying on past CAGR as a prediction: CAGR is a historical descriptive statistic, not a forecast.

Quick checklist for calculations

1. Decide if cash flows occurred. If none, use the CAGR formula. If yes, use IRR/XIRR or time-weighted returns depending on the goal.
2. Use exact dates for XIRR; for even-year intervals CAGR is fine.
3. Include fees and taxes as outflows for a realistic net return.
4. Use spreadsheets (Excel/Google Sheets) or a reliable financial calculator for IRR/XIRR.

Practice these calculations risk-free in AIYUG’s free paper-trading race: https://aiyug.us/race

No guarantees are made here; the formulas and examples are educational and illustrative only, not financial advice.