PPMT function
Summary
Returns the payment on the principal for an investment for a given period
Syntax
PPMT(rate, per, nper, pv, [fv], [type])
Note: For a more complete description of the arguments in PPMT, see PV.
The PPMT function syntax has the following arguments:
• Rate Required. The interest rate per period.
• Per Required. Specifies the period and must be in the range 1 to nper.
• Nper Required. The total number of payment periods in an annuity.
• Pv Required. The present value — the total amount that a series of future payments is worth now.
• Fv Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
• Type Optional. The number 0 or 1 and indicates when payments are due.
0 or omitted | At the end of the period
1 | At the beginning of the period
The PPMT function syntax has the following arguments:
• Rate Required. The interest rate per period.
• Per Required. Specifies the period and must be in the range 1 to nper.
• Nper Required. The total number of payment periods in an annuity.
• Pv Required. The present value — the total amount that a series of future payments is worth now.
• Fv Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (zero), that is, the future value of a loan is 0.
• Type Optional. The number 0 or 1 and indicates when payments are due.
0 or omitted | At the end of the period
1 | At the beginning of the period
Example
=PPMT(A2/12, 1, A3*12, A4)
=PPMT(A8, A9, 10, A10)
=PPMT(A8, A9, 10, A10)