Introduction to CAGR

August 28, 2007 by Pinyo.

On books, web sites, and blogs (including this one) you may have come across references such as the S&P 500 has grown 13% annually for the past 30 years or something to that effect. You may wonder what that means and where did they get that number.

When someone states an annualized return, most likely he is referring to CAGR, or Compound Annual Growth Rate. The S&P 500 did not return a steady 13% gain each year — in reality, some years it went up and some down. In the graph below, you can see the S&P 500 percentage growth adjusted for dividend yield. You can see that the growth rate is different each year. In fact, in 5 out of the 30 years it actually went down (table column F).

S&P 500 Growth Rate

Mathematically, CAGR measures the rate of change in a value between two points in time. The formula is express as:

CAGR = (ending value / beginning value) ^ (1 / years) - 1

For example, S&P 500 from 1977 to 2006 (adjusted for dividend yield)

CAGR = (3179.65 / 95.10) ^ (1 / 30) - 1 = 12.41%

Graphically, it is a graph smoothing function. In the graph below, you can see S&P 500 growth — blue line (table column B) represents investment growth, and green line (table column G) represents investment growth plus dividend yield. Notice that the two lines trend upward, but go up and down each year. The two smooth lines represent CAGR of S&P 500 (orange, table column D) and S&P 500 plus dividend (purple, table column H).

S&P 500 Chart with CAGR

From the table below, you can see that CAGR of S&P 500 plus dividend yield from 1977 to 2006 was 12.41%. Of course, your actual return can be very different from this scenario. For example, if invested from 2000 to 2006, your CAGR would be a mere 2.47%!

S&P 500 Growth and CAGR Table

Notes:

  1. S&P 500 index data points reflect the last trading day of the year — i.e., 2006 is December 26, 2006
  2. Yield data from S&P Earnings: 1960-Current
  3. Link to CAGR Spreadsheet

Here are a few things I learned about CAGR over the years:

  • It is a good measure of performance for a specified time period
  • It may have no bearing for my specific investment period. For instance, I started investing in 1996, so my CAGR would have been 8.34% if I had invested in an S&P 500 index fund.
  • It does not say anything about investment volatility — i.e., CD has CAGR of about 5% with no volatility but S&P 500 has its good years and bad years

What else do you know about CAGR that you can share with us?

Carnivals:

Please share your comment:

Please read our comment policy and guidelines.


Please do not use the name of your site or keywords.

11 blogs that link to this article:

If your trackback does not show in 24 hours, please resend to this trackback URI.

  1. Sep 3, 2007: Advanced Personal Finance » Blog Archive » Carnival of Personal Finance #116 - NSA Edition
  2. Sep 5, 2007: Quit Your Job, Collect Credit Cards, Save With Grocery Deals: My Carnival Picks » Money and Personal Finance Blog In Silicon Valley
  3. Sep 6, 2007: Does dollar cost averaging work? | Moolanomy
  4. Sep 7, 2007: Beating the S&P 500, part 2 | Moolanomy
  5. Sep 18, 2007: The mortgage refinancing that nearly cost me $370,000 | Moolanomy
  6. Sep 22, 2007: Lower Gain by 50% with High Expense Ratio Funds | Moolanomy
  7. Sep 28, 2007: The First Million Is The Hardest | Moolanomy
  8. Oct 9, 2007: Impact of Taxes, Inflation, and Currency Illustrated | Moolanomy
  9. Dec 4, 2007: What Difference Does A Decade Make? | Moolanomy
  10. Mar 18, 2008: Gold hits $1,000: Should I Invest In Gold? | Moolanomy
  11. Apr 16, 2008: The Weak Dollar is Killing Americans’ Wealth (Reprint) | Moolanomy

M-NetworkBlogs

Beat That Quote: Compare loans to find the best rates and start saving money today

Debt Free Direct: In debt? Seek impartial and expert debt advice about an IVA, bankruptcy or another debt solution.

Money Hackers Network Frugal Hacks