AVAILABLE SINCE 5.3.1
Description (Future Value)
Calculates the value of a recurring annuity investment at a set point in the future. It is based on an interest rate, a number of recurring payments, the amount of individual payments, the present value and either ordinary annuity or annuity due (type) indicating whether payments are due at the beginning or the end of period.
FV('Rate', 'Nper', 'Pmt' [, 'Pv' , ["Type"]])
In case the costs/payments are entered as a positive number within your model, this function needs to be multiplied by (-1).
(Number of Periods)
(Payment per Period - Amount)
Payment at Beginning of Period (Annuity Due) = 1
Payment at End of Period (Ordinary Annuity) = 0
FV(Rate, Nper, Pmt, Pv, Type)