Functions
PPMT
Principal payment for a period
Try it
When to use it
When should I use PPMT instead of IPMT?
Use PPMT for the principal portion of a single payment; use IPMT for the interest portion of that same payment.
Use cases
Principal portion of a mortgage payment
Reconstruct the full payment from principal and interest
Used in
finance · lending · real-estate
Syntax
PPMT(rate, per, nper, pv, [fv], [type])Examples
=PPMT(0.05/12,1,30*12,100000) // => -120.15495634547314
=PPMT(2,5,12,100) // => -0.030483215414722264
=PPMT(0.05/12,360,30*12,100000) // => -534.5941473979815