Returns the endofperiod present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made
Syntax

Returns the endofperiod present value for a series of future payments given, the interest rate, the number of periods, the payment amount, and the future value remaining after all payments are made 

PV(rate, period, payment, futureValue) 

Arguments: 


rate 
Numeric  the interest rate 


period 
Numeric  the number of periods 


payment 
Numeric  the payment made each period 


futureValue 
Numeric  the future value remaining after all payments 
Remarks
 Example: PV(0.05, 36, 100, 0) returns 1654.685.
Comments
0 comments
Article is closed for comments.