Returns the endofperiod payment for given present value at specified rate for specified period. Note: The result is not negated as a debt. (e.g. PMT(0, 10, 10000) = 1000.00 not 1000.00)
Syntax

Returns the endofperiod payment for given present value at specified rate for specified period. Note: The result is not negated as a debt. (e.g. PMT(0, 10, 10000) = 1000.00 not 1000.00) 

PMT(rate, period, presentvalue) 

Arguments: 


rate 
Numeric  the interest rate. 


period 
Numeric  the period. 


presentvalue 
Numeric  the present value or principal. 
Remarks
 Example: PMT(0.06, 3, 100000) returns 39700.533.
Comments
0 comments
Article is closed for comments.