What is PPMT?
Calculates the principal portion of a payment for a specific period of a loan.
Syntax
=PPMT(rate, per, nper, pv, [fv], [type])
Example
Formula: =PPMT(6%/12, 1, 360, -200000)
Result: $199.10
How It Works
Calculates first month's principal on a $200,000 mortgage at 6%. Principal portion increases each month.