How to Use Reverse CAGR to Project Future Value

To project a future value with reverse CAGR, multiply your starting amount by one plus the growth rate, raised to the power of the number of years: Ending Value = Beginning Value x (1 + CAGR)^n. For example, $25,000 growing at a 10% CAGR for 15 years projects to 25,000 x (1.10)^15 = 25,000 x 4.177248 = about $104,400. This flips the usual CAGR question around. Instead of solving for the rate from a known start and end, you supply the start, a rate, and a time horizon, then solve for the ending value your money should reach.

If you just want the number, our free CAGR calculator projects forward in seconds. Read on for the formula, a fully worked example with the arithmetic shown, the one-line Excel version, and a table that projects a single amount across several rates and years so you can sanity-check any forecast yourself.

What reverse CAGR means (and how it differs from regular CAGR)

Standard CAGR is a backward-looking measure. You already know where your money started and where it ended, and you reverse-engineer the single smoothed rate that connects the two. Our companion guide on how to calculate CAGR walks through that direction in detail: CAGR = (EV / BV)^(1/n) - 1.

Reverse CAGR runs the same engine in the opposite direction. Here you do not know the ending value yet. You assume a growth rate (often a long-run average, like the S&P 500's roughly 10% nominal historical return), pick a number of years, and project what a starting balance grows into. That makes reverse CAGR a forecasting tool for goal setting, retirement planning, and "what will my investment grow to" questions, rather than a reporting tool for past performance.

The reverse CAGR formula

The formula to project value with CAGR is the compound-growth equation:

Ending Value (EV) = Beginning Value (BV) x (1 + CAGR)^n

• Beginning Value (BV): the amount you have or invest today.
• CAGR (r): the assumed compound annual growth rate, written as a decimal (10% = 0.10).
• n: the number of full years you are projecting forward.
• (1 + CAGR)^n: the growth multiplier. It tells you how many times your starting money multiplies over the whole period.

This is the same math that powers our future value calculator and compound interest calculator. Only the vocabulary changes: in CAGR land we call the rate a "growth rate" instead of an "interest rate," but the exponential mechanics are identical. As Investopedia notes in its CAGR entry, CAGR describes the smoothed annual rate of a single lump sum, with no cash flows added or removed along the way.

How to calculate future value using CAGR, step by step

Here is the full method using the headline example: $25,000 at a 10% CAGR over 15 years.

1. Write down your three inputs. BV = $25,000, CAGR = 10% (0.10), n = 15 years.
2. Add 1 to the rate. 1 + 0.10 = 1.10. This is your annual growth factor.
3. Raise it to the power of the years. 1.10^15 = 4.177248. This is the total growth multiplier across all 15 years.
4. Multiply by the beginning value. 25,000 x 4.177248 = $104,431, which rounds to about $104,400.
5. Interpret the result. Your $25,000 is projected to more than quadruple. The roughly $79,400 of growth is all compounding; you never added another dollar.

That single number, the growth multiplier, is the heart of reverse CAGR. Once you know that 10% over 15 years multiplies money by about 4.18x, you can apply it to any starting amount instantly. A $10,000 stake, for instance, projects to about $41,800 on the same assumptions.

Projecting one amount across several rates and years

Because CAGR is smoothed, the smartest way to forecast is not to bet on one rate. Run a small grid instead. The table below projects the same $25,000 starting balance forward at four realistic rates over six time horizons, so you can see best-case, base-case, and conservative outcomes side by side. All figures are rounded to the nearest dollar and assume no extra contributions.

Years (n)	6% CAGR	8% CAGR	10% CAGR	12% CAGR
5	$33,456	$36,733	$40,263	$44,059
10	$44,771	$53,973	$64,844	$77,646
15	$59,914	$79,304	$104,431	$136,839
20	$80,178	$116,524	$168,187	$241,157
25	$107,297	$171,212	$270,868	$425,002
30	$143,587	$251,566	$436,235	$748,998

Notice how the gap between rates widens over time. At 5 years the spread between 6% and 12% is modest. By year 30, a 12% assumption projects more than five times the 6% result. That sensitivity is exactly why you should treat any single CAGR projection as a midpoint, not a promise. A one- or two-point change in your rate assumption swings the long-run number enormously.

How to project future value with CAGR in Excel or Google Sheets

You do not need a special function. Reverse CAGR is a one-line formula. Put your beginning value in cell A2, your rate in B2, and your years in C2, then type:

• The core formula: =A2*(1+B2)^C2 — beginning value times one plus the rate, raised to the years.
• The built-in alternative: =FV(B2, C2, 0, -A2) — Excel's FV function returns the future value of a lump sum. Enter the present value as a negative number so the result shows as positive.

Both return $104,431 for the example above. To build the full grid yourself, put rates across the top row and years down the left column, then use a mixed-reference formula (lock the rate's row and the year's column with $) so you can drag it across the whole table in one motion. Google Sheets uses the identical syntax.

A second worked example: a longer retirement horizon

Say you have $50,000 in an index fund today and want to project it forward 20 years at an 8% CAGR — deliberately conservative, below the long-run US equity average, to leave room for fees and a margin of safety.

EV = 50,000 x (1.08)^20 = 50,000 x 4.660957 = $233,048.

So that lump sum is projected to grow roughly 4.66x over two decades, turning $50,000 into about $233,000 without a single additional contribution. If you also plan to add money every month, a lump-sum CAGR projection understates your real result. For that, switch to our investment calculator, which layers ongoing deposits on top of the same compounding math.

A quick sanity check with the Rule of 72

Reverse CAGR pairs neatly with the Rule of 72, a back-of-the-envelope shortcut for doubling time. Divide 72 by your growth rate to estimate how many years it takes your money to double. At a 10% CAGR, 72 / 10 = about 7.2 years to double.

Check it against the table: $25,000 at 10% reaches about $40,263 by year 5 and roughly $48,700 by year 7, crossing $50,000 (a true double) early in year 8 — almost exactly the 7.2 to 7.3 years the Rule of 72 predicts. Using the rule as a gut check helps you catch projection errors before they snowball.

The big caveat: CAGR is smoothed, real paths are bumpy

This is the most important thing to understand about any reverse CAGR projection. CAGR is a smoothed, straight-line rate. Real markets are not. The formula assumes your money grows by the exact same percentage every single year, but actual returns zig-zag: a great year, a flat year, a painful down year. Two portfolios can post the same 10% CAGR while taking wildly different paths to get there.

That distinction matters for three practical reasons:

• Sequence-of-returns risk. If a crash hits early while you are still contributing, or right as you start withdrawing in retirement, your real outcome can diverge sharply from the smooth projection, even at the same average CAGR.
• The rate is an assumption, not a guarantee. Past averages, including the S&P 500's roughly 10% nominal long-run figure, do not lock in future returns. Always run a conservative case alongside your base case, which is exactly why the table above shows a range.
• Inflation eats nominal growth. A 10% nominal CAGR with roughly 3% inflation works out to about a 7% real (purchasing-power) CAGR. For long horizons, decide upfront whether you want nominal or inflation-adjusted dollars and label your forecast accordingly.

Used honestly, reverse CAGR is one of the most useful planning tools you have: it turns a starting balance, a rate, and a horizon into a concrete target. Just remember it draws a clean line through a messy reality, so treat the output as a well-reasoned estimate, not a precise prediction.

Ready to project your own number? Open our free CAGR calculator, enter your starting amount, an assumed growth rate, and your time horizon, and see exactly what your investment is projected to grow to — complete with a year-by-year breakdown you can stress-test against different rates.

Frequently asked questions

How do I use a reverse CAGR calculator to project future value?

Enter three inputs: your starting amount, an assumed annual growth rate, and the number of years. The calculator applies Ending Value = Beginning Value x (1 + CAGR)^n and returns the projected future value. For example, $25,000 at a 10% CAGR over 15 years projects to about $104,400. Most tools also show a year-by-year breakdown so you can stress-test different rates.

What is the CAGR future value formula?

The CAGR future value formula is Ending Value = Beginning Value x (1 + CAGR)^n, where n is the number of years and CAGR is written as a decimal. It is identical to the standard compound-growth equation. For instance, $50,000 at an 8% CAGR over 20 years equals 50,000 x 1.08^20 = about $233,048. The (1 + CAGR)^n term is simply your total growth multiplier.

How do I calculate future value using CAGR in Excel?

Use the formula =BV*(1+r)^n, placing your beginning value, rate, and years in their own cells, for example =A2*(1+B2)^C2. You can also use Excel's built-in =FV(rate, years, 0, -BV), entering the present value as a negative number so the result is positive. Both methods return the same projected future value and work identically in Google Sheets.

What will my investment grow to at 10% over 15 years?

A lump sum grows by a factor of (1.10)^15 = about 4.18x at a 10% CAGR over 15 years. So $25,000 projects to roughly $104,400, and $10,000 projects to about $41,800. Multiply any starting amount by 4.177248 to get its 15-year projection at 10%. Remember this assumes a smoothed rate with no added contributions and no withdrawals.

What is the difference between CAGR and reverse CAGR?

CAGR solves for the rate when you already know the start and end values: CAGR = (EV/BV)^(1/n) - 1. Reverse CAGR solves for the ending value instead, given a starting amount, an assumed rate, and a horizon: EV = BV x (1 + CAGR)^n. CAGR reports past performance; reverse CAGR projects a future value for goal setting and planning.

Is a reverse CAGR projection accurate?

A reverse CAGR projection is a reasonable estimate, not a guarantee. CAGR assumes the same smoothed growth every year, but real markets are bumpy and rates vary, so actual results differ from the straight-line forecast. To stay realistic, project a range of rates rather than one, and adjust for roughly 3% inflation if you need purchasing-power (real) dollars instead of nominal ones.

How do I project one amount to its ending value across different rates?

Build a small grid: keep one starting amount, then apply EV = BV x (1 + r)^n across several rates and years. For $25,000, 10% over 15 years projects to about $104,431, while 6% gives about $59,914 and 12% gives about $136,839. Seeing the spread shows how sensitive long-run projections are to the rate you assume, which guards against over-optimistic forecasts.

Does reverse CAGR account for monthly contributions?

No. Reverse CAGR projects a single lump sum with no money added or removed during the period. If you plan to invest regularly, this formula understates your real result. Use an investment or compound interest calculator that adds periodic contributions on top of the same compounding math. For uneven deposits and withdrawals over time, internal rate of return (IRR) is the correct tool instead.

What growth rate should I assume for a reverse CAGR projection?

Use a rate grounded in history and tilted conservative. US large-cap stocks have returned roughly 10% nominal per year long term, so 7% to 10% is a common base case, and many planners use 6% to 8% to leave a margin of safety. Always run a low, middle, and high case rather than one rate, and subtract about 3% if you want inflation-adjusted real growth.

Related guides

How to calculate CAGR: formula, Excel method, and worked examples · How to calculate unit price: the simple way to find the best deal · CAGR vs Average Annual Return: What's the Difference? · How to Calculate Price Per Unit: Formula, Conversions, and Worked Examples