PPMT Function
Finds the principal portion of a loan payment in a given period.
Syntax
Parameters
| Parameter | Description | Required |
|---|---|---|
| rate | Interest rate per period. | Required |
| per | The period for which to calculate principal (1 to nper). | Required |
| nper | Total number of payment periods. | Required |
| pv | Present value or loan principal. | Required |
| fv | Future value or desired cash balance after the last payment (default 0). | Optional |
| type | 0 = end of period (default), 1 = beginning of period. | Optional |
Basic Example
Principal portion of the first payment on a loan
=PPMT(0.05/12, 1, 360, 300000)For a $300,000 loan at 5% annual interest over 30 years, the first month's principal payment is about $348.55.
Advanced Examples
Example 1: Principal in a later period
Amortization schedulePrincipal portion of the 60th payment
=PPMT(0.05/12, 60, 360, 300000)How PPMT Works
PPMT calculates the principal portion of a specific payment. The total payment (PMT) equals the interest portion (IPMT) plus the principal portion (PPMT) for that period.
Important Notes & Limitations
Returns negative values by default.
Requires consistent period units.
Does not include fees or taxes.
Common Errors & Fixes
#NUM! errorper is outside the range 1 to nper.Fix: Ensure per is valid.
Wrong signPrincipal is negative when expecting positive.Fix: Use -PPMT or ABS.
Download Practice File
PPMT
ppmtPractice PPMT with Real Data
Download a sample CSV file with pre-populated data and practice exercises for the PPMT function. Works in both Excel and Google Sheets.
File format: CSV (comma-separated values) - opens in Excel, Google Sheets, and all spreadsheet apps