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.
Please send us your comments on this article.