PPMT

Examples

• =PPMT(A2/12, 1, A3*12, A4)

  The function can be used to calculate the principal payment of a loan for a particular month or year. For example, this calculates the principal payment for month 1 of the loan. In this example, A2 is the loan amount, A3 is the interest rate, and A4 is the principal amount.

• =PPMT(A8, A9, 10, A10)

  The function can also be used to calculate the principal payment for a particular year. For example, this calculates the principal payment for year 10 of the loan from loan A8, loan A9, interest rate 10%, and principal amount A10.

• =PPMT(1000, 6, 5, 500)

  The function can also be used to calculate the principal payment of a loan with a specific loan amount, period, interest rate, and principal amount. For example, this calculates the principal payment for period 6 of the loan with a loan amount of 1000, an interest rate of 5%, and a principal amount of 500.

• =PPMT(5, 10, 3, 1000)

  The function can also be used to calculate the principal payment of a loan with a specific duration, interest rate, and principal amount. For example, this calculates the principal payment for 10 periods of the loan with an interest rate of 3%, and a principal amount of 1000.