Description:
The function equals the Excel FV function.
Syntax:
Fv(rate,nper,pmt,pv)
Note:
The external library function (See External Library Guide) 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 |