# Fv()

Description:

The function equals the Excel FV function.

Syntax:

Fv(rate,nper,pmt,pv)

Note:

The 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.

Parameters:

 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

Options:

 @t Indicating the pamyment 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 functionand 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 Fv@p(0.067/12,12*25,500,0) -72700