Fv()

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