Syntax 
Pv(Rate,NPer,Pmt,Fv,Due) 

Description 
Calculates the present value of an annuity based on future periodic fixed payments and a constant rate of interest. 

Comments 
The Pv function requires the following parameters: 


Parameter 
Description 

Rate 
Double representing the interest rate per period. When used with monthly payments, be sure to normalize annual percentage rates by dividing them by 12. 

NPer 
Double representing the total number of payments in the annuity. 

Pmt 
Double representing the amount of each payment per period. 

Fv 
Double representing the future value of the annuity after the last payment has been made. In the case of a loan, the future value would be 0. 

Due 
Integer indicating when the payments are due for each payment period. A 0 specifies payment at the end of each period, whereas a 1 specifies payment at the start of each period. 

Rate and NPer must be expressed in the same units. If Rate is expressed in months, then NPer must also be expressed in months. Positive numbers represent cash received, whereas negative numbers represent cash paid out. 

Example 
This example demonstrates the present value (the amount you'd have to pay now) for a $100,000 annuity that pays an annual income of $5,000 over 20 years at an annual interest rate of 10%. Sub Main() 

See Also 
Fv (function); IRR (function); MIRR (function); Npv (function). 
P 