How to Calculate CAGR and Annualized Returns

What CAGR and annualized returns mean

Compound Annual Growth Rate (CAGR) and annualized returns both describe an investment's average yearly growth over a period. For a single lump-sum investment with no intermediate cash flows, CAGR is the standard measure: it answers the question "What constant annual rate would turn my starting value into my ending value over N years?".

"Annualized return" is often used interchangeably with CAGR, but in broader usage it can refer to returns standardized to a one-year period for comparison — including geometric averages for multiple years, time-weighted returns (TWR) when you want to exclude the effect of cash flows, or money-weighted returns (IRR) when cash flows matter.

This article focuses on the concrete math: the compound annual growth rate formula, how to compute it by hand and in Excel, and how to approach annualized return calculation when you have contributions or withdrawals.

The compound annual growth rate formula

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

Where:

• Ending Value = final portfolio or investment value
• Beginning Value = initial invested amount
• Years = total number of years (can be fractional)

CAGR gives the constant annual percentage growth that compounds each year to move the beginning value to the ending value.

Worked example: simple lump-sum investment

Hypothetical numbers (for illustration only):

• Beginning Value (BV): $10,000
• Ending Value (EV): $18,000
• Holding Period: 4.5 years

Step 1 — compute EV / BV: EV / BV = 18,000 / 10,000 = 1.8

Step 2 — take the 1/Years power: Power = 1 / 4.5 = 0.222222... (1.8)^(0.222222) ≈ 1.1369

Step 3 — subtract 1 to get the rate: CAGR = 1.1369 - 1 = 0.1369 = 13.69% per year

Interpretation: A 13.69% annual compounded return would turn $10,000 into approximately $18,000 in 4.5 years.

Excel / Google Sheets formulas

• For the above example: =POWER(18000/10000,1/4.5)-1
• Alternatively, use the RATE function if you prefer: =RATE(Periods,0,-BeginningValue,EndingValue) where Periods is number of periods (years).

Annualized returns when there are cash flows

When you make deposits or withdrawals during the period, simple CAGR no longer applies. Two standard approaches are:

1) Money-weighted return (MWR) / Internal Rate of Return (IRR) — accounts for timing and size of cash flows. Use when you want to capture the investor's actual experience influenced by contributions/withdrawals.

2) Time-weighted return (TWR) — removes the impact of external cash flows and measures the manager's performance. Use when you want to compare managers irrespective of investor cash flows.

Money-weighted annualized return (IRR) — worked example

Hypothetical cash flows:

• Day 0: invest $5,000
• End of Year 1: add $2,000
• End of Year 3: withdraw $1,000
• End of Year 4: portfolio value = $7,500 (final value)

Construct cash flow sequence (negative = outflow from investor, positive = inflow to investor):

• t=0: -5000
• t=1: -2000
• t=3: +1000 (withdrawal means investor received $1,000 back; represent as +1000)
• t=4: +7500 (final value realized)

In Excel, use XIRR to handle irregular dates: =XIRR(values, dates) Or with equal-year spacing and simple IRR: =IRR(values)

Plugging these values into XIRR or an IRR calculator yields the annualized money-weighted return (example result might be around 8–12% depending on timing; compute in your spreadsheet for exact number based on date entries).

Note: XIRR returns the annualized internal rate of return that sets the net present value of cash flows to zero.

Time-weighted return (TWR) process — simplified steps

1. Break the total period into sub-periods at each cash flow.
2. For each sub-period, compute the sub-period return = (Ending Value before cash flow / Starting Value after previous cash flow) - 1.
3. Chain-link the sub-period returns: (1+r1)(1+r2)...*(1+rn) - 1 gives the total geometric return.
4. Annualize by taking the nth-root if needed: Annualized = (1 + TotalReturn)^(1 / Years) - 1.

TWR is best computed in a spreadsheet when there are several flow dates.

Practical tips and gotchas

• Use consistent time units. If you express Years as fractions (e.g., 4.5), the CAGR formula handles it; for XIRR you must provide actual dates.
• Beware arithmetic averages: averaging yearly percentage returns (simple mean) misstates compounded growth. Always use geometric/compounded math for multi-year performance.
• For short periods, annualizing monthly or daily returns requires care: Annualized = (1 + monthly_return)^(12) - 1, or (1 + daily_return)^(252) - 1 for trading days — but volatility makes short-term annualization noisy.
• Fee effects and taxes reduce realized returns; calculate net returns for realistic performance comparisons.

Quick reference formulas

• CAGR (lump sum): (EV/BV)^(1/Years) - 1
• Annualizing a periodic return: (1 + period_return)^(periods_per_year) - 1
• IRR/XIRR: solves sum(CFi / (1+IRR)^(ti)) = 0 for IRR

Where to practice

You can practice calculating CAGR, IRR and TWR with hypothetical trades and portfolio cash flows in a risk-free environment using AIYUG's free paper-trading race: https://aiyug.trading/signup

Final note

These formulas describe how to calculate compound annual growth rate and annualized returns, with options for handling cash flows. They are mechanics for measurement and comparison — not investment advice or predictions. Always test calculations on your own data and verify results in a spreadsheet.