Financial functions can be used in the data load script and in chart expressions to calculate payments and interest rates.
For all the arguments, cash that is paid out is represented by negative numbers. Cash received is represented by positive numbers.
Listed here are the arguments that are used in the financial functions (excepting the ones beginning with range-).
Use the drop-down on each function to see a brief description and the syntax of each function. Click the function name in the syntax description for further details.
This function returns the future value of an investment based on periodic, constant payments and a simple annual interest.
FV(rate, nper, pmt [ ,pv [ , type ] ])
This function returns the number of periods for an investment based on periodic, constant payments and a constant interest rate.
nPer(rate, pmt, pv [ ,fv [ , type ] ])
This function returns the payment for a loan based on periodic, constant payments and a constant interest rate. It cannot change over the life of the annuity. A payment is stated as a negative number, for example, -20.
Pmt(rate, nper, pv [ ,fv [ , type ] ] )
This function returns the present value of an investment.
PV(rate, nper, pmt [ ,fv [ , type ] ])
This function returns the interest rate per period on annuity. The result has a default number format of Fix two decimals and %.
Rate(nper, pmt , pv [ ,fv [ , type ] ])