Lesson 3 of 6

Measuring returns: total return, CAGR, real return

Step 4 of 6

Do it yourself

Small and practical. Do it now while it is fresh.

About 15–20 minutes the first time.

  1. On Yahoo Finance, open a dividend-paying company you know (Coca-Cola, KO, works), then Historical Data. Above the table, set the time period to 5 years and the frequency to monthly.
  2. Note the first and last Close and Adj Close, and which months they are.
  3. Work out the price return and the reinvested total return.
  4. Turn both into CAGR with =(end/start)^(1/5)-1.
  5. Get CPI for the same two months. This FRED link downloads a small file (CPIAUCSL.csv) with US CPI for every month since January 2021. Open it in your spreadsheet. Each row is a month, dated by its first day: 2021-11-01 means November 2021. CPI comes out about two weeks after each month ends, so if your last month isn't there yet, use the latest one. Then work out inflation per year and the real CAGR.
Show answer

Your numbers depend on the company and the day. Two checks: the reinvested CAGR should beat the price CAGR by roughly the dividend yield, and the real CAGR should be lower than the reinvested CAGR by roughly the inflation rate. For a period ending in October 2026, CPI went from 276.550 (October 2021) to 337.476 (October 2026), about 4.1% a year.

Next lesson: Risk: volatility and drawdowns.