PPMT practice

PPMT returns the principal part of one loan payment. Below are the 1 financial modeling exercise on Modeldrill that use it, each checked instantly in your browser.

Syntax

PPMT(rate, period, number_of_periods, present_value, [future_value], [end_or_beginning])

What people get wrong

Principal grows every period as interest shrinks; the two always add up to PMT.

financial modeling exercise that use PPMT

• Split payments with IPMT and PPMTLevel 3Pro

Often used together with: IPMT