PV()

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, Recital Server