Average Return Calculator
Two modes: (1) IRR from starting/ending balance with deposits & withdrawals ยท (2) Average & cumulative return across multiple holding periods
Mode 1 - Average Return Based on Cash Flows
Enter starting balance, ending balance, and any deposits or withdrawals with dates. The calculator solves for the IRR (money-weighted return) that reconciles all cash flows.
| # | Activity | Amount ($) | Date | |
|---|---|---|---|---|
| - | Starting Balance | $ |
||
| - | Ending Balance | $ |
| Activity | Date | Amount | Days Elapsed | Weight |
|---|
Mode 2 - Average & Cumulative Return (Multiple Periods)
Enter the return percentage and holding length for each investment period. The calculator computes the overall cumulative return, geometric mean (CAGR), and arithmetic mean.
| # | Period Return (%) | Years | Months |
|---|
| # | Period Return | Years | Ann. Return | Growth Factor | Cumulative |
|---|
Mode 1: How IRR from Cash Flows Works
The Internal Rate of Return (IRR) is the annualized return rate that makes the net present value (NPV) of all cash flows equal to zero. For an investment account with deposits and withdrawals, it's the most accurate measure of your actual personal return.
Sign Convention
- Starting balance: Treated as an outflow (money you put in)
- Deposits: Additional outflows (money you add)
- Withdrawals: Inflows (money you take out)
- Ending balance: Final inflow (what you get back)
Mode 2: Cumulative & Average Return Across Periods
When you have a sequence of returns across different time periods (e.g., year 1 returned +12%, year 2 returned -5%, year 3 returned +20%), this calculator computes the full picture:
Geometric Mean (CAGR)
The geometric mean is the single constant return rate that would produce the same cumulative result as the actual sequence of returns. It's the correct measure for multi-period investment performance.
Arithmetic Mean
The simple average of all annualized period returns. It's easier to calculate but overstates long-term compounding because it ignores the sequence-of-returns effect. Always compare arithmetic and geometric means together.
Cumulative Return
The total percentage gain or loss over all periods combined, without annualizing:
Return Metrics: A Complete Guide
There are multiple ways to measure investment returns, each appropriate for different purposes. Understanding which metric to use - and when each is misleading - is essential for evaluating your portfolio and comparing investments.
1. Holding Period Return (HPR)
The simplest return measure: total gain or loss over any holding period, without annualizing.
2. Annualized Return (CAGR)
Converts any holding period return into an equivalent annual rate for fair comparison across different time periods.
3. Arithmetic Mean Return
The simple average of multiple periodic returns. Easy to calculate but consistently overstates long-term compounding. A classic example shows why:
4. Geometric Mean Return (CAGR)
Accounts for the compounding effect of returns. The only correct measure for comparing multi-period investment performance. Always lower than the arithmetic mean when returns vary.
5. Time-Weighted Return (TWR)
Eliminates the effect of external cash flows by dividing the total period into sub-periods between each cash flow event, computing a return for each sub-period, then linking them geometrically. Used by fund managers to report performance because it removes the impact of investor timing.
6. Money-Weighted Return (MWR / IRR)
The discount rate that makes NPV of all cash flows (including timing) equal to zero. Reflects the actual investor's experience - affected by when they deposit and withdraw money. If an investor put a large sum in at a market peak, their MWR will be worse than the fund's TWR.
| Metric | Accounts for Timing? | Best Used For | Main Limitation |
|---|---|---|---|
| HPR | No | Simple period comparison | Can't compare different periods |
| Arithmetic Mean | No | Expected 1-period return | Overstates long-run compounding |
| CAGR / Geometric Mean | No (cash flows) | Multi-period annualized return | Ignores cash flow timing |
| TWR | Eliminates it | Evaluating fund managers | Doesn't reflect investor outcome |
| MWR / IRR | Yes, fully | Measuring personal return | Affected by cash flow timing |
The Arithmetic-Geometric Gap: Why It Matters
The difference between arithmetic and geometric mean return is called the variance drag. It directly reduces your actual compounded wealth:
This formula, derived by Harry Markowitz, shows that higher volatility directly reduces your realized compounded return, even if the average return stays the same. It's one of the mathematical foundations of why diversification improves risk-adjusted returns - by reducing variance, you raise the geometric mean without changing the arithmetic mean.
Sequence of Returns Risk
The arithmetic mean doesn't capture the sequence in which returns occur, but the sequence matters enormously - especially near retirement. Two investors can have identical arithmetic mean returns but vastly different outcomes if the poor returns come at different times relative to their withdrawal schedule.
- Accumulation phase: Sequence matters less - dollar-cost averaging actually benefits from early losses
- Distribution phase: Early losses (selling assets at low prices to fund withdrawals) permanently reduce capital, a risk not captured by average return statistics
Historical Market Returns Reference
| Asset Class | Period | Arithmetic Mean | Geometric Mean |
|---|---|---|---|
| US Large Cap (S&P 500) | 1928-2024 | ~11.8% | ~10.0% |
| US Small Cap | 1928-2024 | ~14.2% | ~11.7% |
| International Developed | 1970-2024 | ~10.5% | ~8.5% |
| Emerging Markets | 1990-2024 | ~11.2% | ~7.8% |
| US 10-yr Treasury | 1928-2024 | ~5.0% | ~4.6% |
| US 3-mo T-Bill (cash) | 1928-2024 | ~3.3% | ~3.3% |
| US Real Estate (REITs) | 1972-2024 | ~11.0% | ~9.5% |
| Gold | 1971-2024 | ~8.2% | ~5.9% |