ppmt

Principal portion of a periodic loan payment.

Syntax

v = ppmt(rate, per, nper, pv, fv, type)

Description

For period per of a loan, returns the portion of the payment going toward principal (vs. interest). Useful for amortization schedules.

Example

ppmt(0.05/12, 1, 30*12, 200000)

See also

• pmt — Periodic payment for a loan or annuity.
• ipmt — Interest portion of a periodic loan payment.
• cumipmt — Cumulative interest paid between two periods.