Downloads
DAXFinancialIntermediate

PPMT

Returns the principal part of the payment for a given period of a loan with a fixed rate.

Syntax
PPMT(<rate>, <per>, <nper>, <pv> [, <fv>] [, <type>])

Returns: A number. It is negative when the loan amount is positive, because principal is paid out of cash.

What it does

PPMT gives the principal part of one loan payment, which is the portion that reduces the balance owed. Together with IPMT, it splits every payment into interest and principal. Finance teams use PPMT for the financing section of the cash flow statement, where principal repayments are shown separately from interest, and for the schedule that shows the balance falling over time.

Syntax and arguments

Example

For the same loan as in the PMT example (300,000 at 6% a year over 360 monthly payments), the controller wants the principal in the first payment and in the twelfth payment.

Principal Payment 1 = PPMT(0.06 / 12, 1, 30 * 12, 300000)

Principal Payment 12 = PPMT(0.06 / 12, 12, 30 * 12, 300000)

The first payment reduces the balance by 298.65, which is the payment of 1,798.65 less the interest of 1,500.00. The results are -298.65 and -315.49, with the minus sign for cash paid. The principal portion grows each month, because the interest portion shrinks.

Example: a second, different use

Total principal repaid in the first year, which is the reduction in the loan balance over twelve months. GENERATESERIES supplies the payment numbers.

Principal Year 1 =
SUMX(
    GENERATESERIES(1, 12),
    PPMT(0.06 / 12, [Value], 30 * 12, 300000)
)

The result is about -3,684.04, which is the total principal repaid in the first year. Adding the interest for the same year (17,899.78, see IPMT) gives about 21,583.82, the total of the twelve payments. The small difference from 12 times 1,798.65 is rounding in the displayed payment.

Things to watch

In business terms

PPMT supports the debt schedule, the principal line in the cash flow statement, the reconciliation of the loan balance to the lender's statement and the check on debt covenants that depend on the principal paid. Treasury teams use it to forecast the cash needed each year for debt repayment.

Related functions

All DAX functions · View as Markdown · DAX fundamentals