PV()

From Recital Documentation Wiki
Revision as of 09:03, 2 June 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Class

Numeric Data


Purpose

Function to calculate the present value of equal regular payments on a loan


Syntax

PV(<expN1>,<expN2>,<expN3>)


See Also

CAGR(), FV(), LOG10(), PAYMENT(), PI(), PMT()


Description

The PV() function calculates the present value of equal regular payments on a loan, where <expN1> is the payment per period, <expN2> is the periodic interest rate and <expN3> is the number of equal payments.


Example

? pv(1000,.10,10)
   6144.57


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer