Excel Function : PPMT
Category
Financial
Description
Returns the payment on the principal for an investment for a given period
Microsoft Excel Reference Page
https://support.office.com/en-us/article/PPMT-function-c370d9e3-7749-4ca4-beea-b06c6ac95e1b
Syntax and Description of the PPMT Excel Function
PPMT(rate, per, nper, pv, [fv], [type])
About PPMT Excel Function
PPMT(rate, per, nper, pv, fv, type) The PPMT function calculates the payment for a given period for a loan based on an annuity. The payment includes both principal and interest.