Compound Growth Rate Formula in Excel: 3 Methods (CAGR Guide)
Warren Team
By the numbers
- 1928 to 2024
~10% a year
Long-run average annual return of the S&P 500 including dividends
Before inflation, 1928 to 2024, with wide swings year to year
Source: NYU Stern, Aswath Damodaran historical returns dataset - 2022 survey
$192,900
Median net worth of US families
The mean is about $1.06 million, pulled up by the wealthiest households
Source: Federal Reserve, Survey of Consumer Finances - 2024 survey, published May 2025
63%
Adults who could cover a $400 emergency expense with cash or its equivalent
Unchanged from the two previous years
Source: Federal Reserve, Economic Well-Being of US Households in 2024
National figures from the sources shown, as of the period on each card. They are context, not a forecast or advice for your situation.
Continue learning
Related articles
Compare side by side
Key terms
- Annual Percentage Rate (APR)The yearly cost of borrowing money, including interest and fees, expressed as a percentage. APR provides a complete picture of loan costs beyond just the interest rate.
- Compound InterestInterest calculated on both the initial principal and accumulated interest from previous periods. Often called 'interest on interest,' it's a powerful force for growing wealth over time.
- Fixed-Rate MortgageA mortgage where the interest rate remains constant throughout the loan term, providing predictable monthly payments. Most common terms are 15 and 30 years.
- Interest RateThe percentage charged by a lender for borrowing money, or earned on savings and investments. Can be fixed or variable depending on the financial product.
Get your first personalized plan in minutes
Free to start, no credit card required. Warren reads your accounts, it never moves money.