PPMT ​

Calculates the principal portion of a loan payment for a given period.

PPMT(rate, per, nper, pv, fv, type)

PPMT(rate, per, nper, pv, fv, type)

Parameters ​

• rate - The interest rate per period.
• per - The period for which you want to find the principal.
• nper - The total number of payments for the loan.
• pv - The present value, or the total amount of the loan.
• fv - The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0. (optional)
• type - The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0. (optional)

Examples ​

PPMT(0.05 / 12, 1, 12, 10000)

PPMT(0.05 / 12, 1, 12, 10000)

Result: -814.41

Note: Calculates the principal payment for the first period of a loan with a present value of $10,000, 12 monthly payments, and a 5% annual interest rate compounded monthly.