How to Track Investment Returns Over Time — A Practical Guide

Investor tracking portfolio returns over time with spreadsheet

Most investors check their account balance and mistake it for their return. But a growing account balance can mask poor returns if you’ve been adding money. And a shrinking balance can hide good returns if you’ve been withdrawing. Here’s how to calculate — and track — true investment returns.

Simple Return vs Time-Weighted Return

Simple return: (ending value − beginning value) ÷ beginning value. Accurate when no money is added or withdrawn. When you contribute regularly (401k, monthly transfers), you need a time-weighted or money-weighted return for accuracy.

Use our investment return calculator for projections. For actual historical returns, the calculation depends on cash flow timing.

The 4 Return Metrics Every Investor Should Know

1. Total Return

The percentage gain or loss on an investment including dividends, interest, and capital gains: (Ending Value + Distributions − Beginning Value − Contributions) ÷ Beginning Value + Contributions. This is what actually happened, but doesn’t account for timing.

2. CAGR (Compound Annual Growth Rate)

Formula: (Ending Value ÷ Beginning Value)^(1/years) − 1. This converts any multi-year return to an annual equivalent for easy comparison. $10,000 growing to $18,000 in 6 years: (18,000/10,000)^(1/6) − 1 = 10.3% CAGR.

3. Real Return (Inflation-Adjusted)

Nominal return minus inflation. If you earned 10% but inflation was 3%, your real return was approximately 7%. Long-term wealth is built on real returns, not nominal ones. Our inflation calculator shows purchasing power impact.

4. Risk-Adjusted Return (Sharpe Ratio simplified)

A 12% return with extreme volatility may be less desirable than a 9% return with low volatility. For most personal investors, comparing your return to a benchmark (like the S&P 500) over the same period is the most practical risk-adjustment.

What Return Should You Expect?

Asset ClassHistorical Annual ReturnReal (Inflation-Adjusted)
US Stocks (S&P 500)~10% nominal~7% real
International Stocks~8-9% nominal~5-6% real
US Bonds~4-5% nominal~1-2% real
Real Estate (REITs)~9% nominal~6% real
Cash (HYSA)~4-5% (varies)~1-2% real

Simple Quarterly Tracking System

Four times per year, record:

  1. Total portfolio value across all accounts
  2. Contributions since last check
  3. Investment gain/loss = (New Value − Old Value − Contributions)
  4. Percentage return = Investment Gain ÷ Average Balance

Investment and Net Worth Tracker Spreadsheet

Quarterly portfolio tracking with automatic return calculations, CAGR analysis, and benchmark comparison column. Enter your numbers quarterly — the spreadsheet does the math.

Get the Tracker →
Is a 10% annual return realistic?

Historically, the US stock market (S&P 500) has averaged approximately 10% per year including dividends, over long periods. Individual years vary from -40% to +50%. The 10% average only applies over long periods (20+ years) with consistent investment through downturns. Future returns may differ from historical averages.

How do I compare my returns to a benchmark?

If your portfolio is mostly US stocks, compare to the S&P 500 total return index (includes dividends). If you hold international stocks, compare to MSCI World. Most brokerage platforms show benchmark comparisons automatically. Beating your benchmark consistently over 5+ years is genuinely impressive — most active fund managers don’t.