Skip to main content



IPMT Function

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

Syntax​

IPMT(rate, period, totalPeriods, presentValue)

Returns the end-of-period interest 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 interest.

totalPeriods Numeric - the total number of periods.

presentValue Numeric - the present value or principal.

Remarks​

Example:

IPMT(0.06 / 12, 3, 12, 100000); // returns -418.7309042