Returns the endofperiod principal payment for given present value at specified rate for specified period.
Syntax

Returns the endofperiod principal payment for given present value at specified rate for specified period. 

PPMT(rate, period, totalPeriods, presentValue) 

Arguments: 


rate 
Numeric  the interest rate. 


period 
Numeric  the period for which to calculate the principal. 


totalPeriods 
Numeric  the total number of periods. 


presentValue 
Numeric  the present value or principal. 
Remarks
 Example: PPMT(0.06 / 12, 3, 12, 100000) returns 8187.912066.
Comments
0 comments
Article is closed for comments.