Quick Navigation
PPMT Function
Summary
The PPMT function calculates the principal portion of a periodic payment for a loan or investment with constant payments and interest rate. It isolates how much of each payment reduces the principal balance.
Syntax
PPMT(rate, per, nper, pv, [fv], [type])Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| rate | Number |
Yes | Interest rate per period (e.g., annual rate/12 for monthly) |
| per | Number |
Yes | Specific period number (1 to nper) |
| nper | Number |
Yes | Total number of payment periods |
| pv | Number |
Yes | Present value or initial loan amount |
| fv | Number |
No | Future value after last payment (default 0) |
| type | Number |
No | 0=end of period, 1=beginning of period (default 0) |
Using the PPMT Function
PPMT helps financial analysts decompose loan payments into principal and interest components. Use it to create amortization schedules, track principal reduction over time, or analyze investment repayment structures.
Common PPMT Examples
Monthly Loan Principal Payment
=PPMT(10%/12, 1, 2*12, 2000)Principal portion for first month of $2,000 loan at 10% annual interest over 2 years. Returns -$75.62 (negative indicates payment outflow).
Annual Principal for Large Loan
=PPMT(8%, 10, 10, 200000)Principal payment in year 10 of $200,000 loan at 8% annual interest. Returns -$27,598.05.
Frequently Asked Questions
Common Errors and Solutions
#NUM! error
Cause: per not between 1 and nper, or rate/nper mismatch
Solution: Verify per ≤ nper and consistent time periods
#VALUE! error
Cause: Non-numeric arguments
Solution: Ensure all inputs are numbers
Unexpected principal amounts
Cause: Inconsistent rate and nper units
Solution: Use monthly rate (annual/12) with monthly periods (years*12)
Notes
- Always match rate period with nper (monthly rate for monthly periods)
- Negative results are normal for payment outflows
- Works with both loans (positive pv) and investments (negative pv)
- See PV function for detailed parameter explanations
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+