Description:
The function equals the Excel FV function.
Syntax:
Fv(rate,nper,pmt,pv)
Note:
The external library function calculates the future value of an investment (i.e. the sum of principal amount and interest obtained after the investment ends) with periodic constant payments and a constant interest rate.
Parameter:
rate |
The interest rate per period; it is a fixed value |
nper |
The number of periods over which the investment (or loan) requires or is to be paid |
pmt |
The amount paid per period, which keeps unchanged during the whole period of paying off the loan. To omit it, pv must exist |
pv |
The present value of the loan /investment, known as the principal. That is the money that already exist when the payment for an investment (or a loan) begins, or an accumulated sum of present values of a series of future payments |
Option:
@t |
Indicating the payment type, it corresponds to the Excel type parameter. If using the option, choose type 1; if not, choose type 0. |
@p(rate,nper,pmt,fv) |
This option makes the function equivalent to Excel PV function and calculates the present value of an investment that is the total amount of a series of future payments. For example, the amount of borrower’s borrowed money is the present value of the loan delivered by the lender. |
Example:
Fv@t(0.07, 30,-2000,0,1) |
202146.08273281078 |
Fv@p(0.067/12,12*25,500,0) |
-72700.0451136414 |