## Calculate future value when CAGR is known in Excel

Learn how to use CAGR to determine the future value of an asset. Future value is the future asset value derived from the assumed growth rate. If you know the CAGR, you can easily determine the future value of an asset. You can predict how much your current investment will increase the value of your asset, how much your business will grow in the future.

### Formula for calculating future value

#### Basic Formula

FV=PV*(CAGR+1)^n

#### FV function

=FV(rate,nper,pmt,[pv],[type])

### Use basic formula

To calculate future values using FV=PV*(CAGR+1)^n, have the starting value, CAGR and Number of Years ready.

Total Time: 1 minute

#### Enter a basic formula

Enter **=B1*(B2+1)^B3** in any cell. Set the starting value to "PV" and the number of years of operation to "n".

#### Future value is calculated

Press **Ctrl** +**Enter** to calculate the future value.

#### Display the accounting number format

Press **Alt** + **H** + **A** + **N** to open the Accounting Number Format. Use **↓** (Down Arrow key) to select **$ English**.

#### Currency unit is set

Press **Enter** to set the currency unit.

### Use FV function

To calculate future values using =FV(rate,nper,pmt,[pv],[type]), have the starting value, CAGR and Number of Years ready.

Enter **=FV(B2,B3,,-B1,0)** in any cell.

Set CAGR to “rate”, Number of Years to “nper”, and the starting value with a minus sign to “pv”. Leave “pmt” empty.

“type” is the argument that sets the payment due date, where 0 represents the end of the period and 1 represents the beginning of the period. In this case, enter 0.

Press **Ctrl** + **Enter** to calculate the future value.

Press **Alt** + **H** + **A** + **N** to open the Accounting Number Format. Use **↓** (Down Arrow key) to select **$ English**.

Press **Enter** to set the currency unit.

### Comments

Please send us your comments on this article.