Reverse CAGR

Reverse Compound Annual Growth Rate is a calculation to determine the future value of your investment. In this calculation, the Compound Annual Growth Rate (CAGR), which is the mean annual growth rate of an investment over a specified period of time, is known.

Syntax:

FV = SA * (CAGR / 100 + 1) n
  • FV – Final Amount/Future Amount
  • SV – Starting Amount/Value
  • CAGR – Compound Annual Growth Rate
  • n – number of years the money is invested for

Reverse Compound Annual Growth Rate (CAGR) Example

Let’s calculate a Reverse CAGR. In our example, we know that our CAGR over 4 years is 9.25%. We use the following formula to calculate the final value.

=B6(((B8100)/100)+1)^B10

FV - Unknown
SV - $15,500
CAGR - 9.25%
n - 4 years
Reverse Compound Annual Growth Rate
Reverse CAGR