Excel Function : IPMT
Category
Financial
Description
Returns the interest payment for an investment for a given period
Microsoft Excel Reference Page
https://support.office.com/en-us/article/IPMT-function-5cce0ad6-8402-4a41-8d29-61a0b054cb6f
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
