Excel Function : IPMT

Download now!

Excel Function : IPMT




Returns the interest payment for an investment for a given period

Microsoft Excel Reference Page


Syntax and Description of the IPMT Excel Function

=IPMT(rate, per, nper, pv, [fv], [type])

About IPMT Excel Function

The IPMT function calculates the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. The syntax for the IPMT function is as follows: IPMT(interest_rate, period, number_of_periods, present_value, [future_value], [type]) where interest_rate is the interest rate for the investment period is the period for which the interest payment is calculated number_of_periods is the total number of periods for the investment present_value is the present value of the investment future_value is the future value of the investment type is the