Excel Hack

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 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

Future value is calculated

Press Ctrl +Enter to calculate the future value.

Display the accounting number format

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

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 function

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.

Future value is calculated

Press Ctrl + Enter to calculate the future value.

Select $ English

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

Future value is calculated

Press Enter to set the currency unit.

Comments

Please send us your comments on this article.

0 comments
Inline Feedbacks
View all comments