• esProc
Tutorial
Function Reference
Code Reference
User Reference
External Library Guide
Data File Tool Manual
DQL Tutorial
Cluster Server Manager Manual
SPL WIN Manual
• YModel
User Reference
JSON-style Parameter Guide
• ReportLite
User Reference
• Official Website

# Fv()

Read（2064）

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