Skip to main content



PPMT Function

Returns the end-of-period principal payment for given present value at specified rate for specified period.

Syntax​

PPMT(rate, period, totalPeriods, presentValue)

Returns the end-of-period principal payment for given present value at specified rate for specified period.

Arguments​

rate Numeric - the interest rate.

period Numeric - the period for which to calculate the principal.

totalPeriods Numeric - the total number of periods.

presentValue Numeric - the present value or principal.

Remarks​

Example:

PPMT(0.06 / 12, 3, 12, 100000); // returns -8187.912066