PV(P, R, N)

 

Description

This function returns the present value of an annuity given a periodic payment P, interest rate R, and N number of periods.  The function is given by:

 

 

Parameters

 

P

Periodic payment.

 

R

Interest range.

 

N

Number of periods.

 

Examples

 

PV(360, 11%, 4) = 1116.88

 

PV(V10, C6, 5) = 41001.97

Where C6 = 7% and V10 = 10000.

 

PV(4500, 0.05, -1) = #Error

"Period" must be an integer.