PPMT function
Returns the payment on the principal for an investment for a given period
Syntax
PPMT(rate, per, nper, pv, [fv], [type])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| rate | Yes | The interest rate per period.10%/12 |
| per | Yes | The period for which you want to find the interest and must be in the range 1 to nper.1 |
| nper | Yes | The total number of payment periods in an annuity.3*12 |
| pv | Yes | The present value, or the lump-sum amount that a series of future payments is worth right now.80000 |
| fv | No | The future value, or a cash balance you want to attain after the last payment is made.0 |
| type | No | The number 0 or 1 and indicates when payments are due.0 |
Try PPMT
Separate principal from the second equal payment
=PPMT(A2,D2,B2,C2)The second payment has the same total as the first, but less interest and more principal. PPMT gives the negative principal portion; adding IPMT for period 2 gives the total PMT.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
PPMT · top-level call
=PPMT(A2,D2,B2,C2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.