The Excel function: PPMT
Description
Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.
Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate.