Excel Function : PPMT
Returns the payment on the principal for an investment for a given period
Microsoft Excel Reference Page
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.