Calculate future value when CAGR is known in Excel

Release Feb 25, 2022Update Aug 24, 2022
Written in Excel for Microsoft 365 version 2202

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.