All functions / Financial
PPMT
The principal (pay-down) part of one loan payment.
Syntax
=PPMT(rate, per, nper, pv, [fv], [type])
Arguments
rate: Interest rate per period, e.g. 5%/12 for monthly payments at 5% a year.per: Which payment: 1 for the first, up to nper.nper: Total number of payments.pv: The loan amount (present value).fv(optional): Balance left after the last payment (default 0).type(optional): 0 (default) = payments at the end of each period, 1 = at the start.
Example
=PPMT(6%/12, 1, 36, 20000) → -508.44 of principal in month 1