PV()

From Recital Documentation Wiki
Revision as of 15:46, 28 October 2009 by Helengeorge (Talk | contribs)

Jump to: navigation, search


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