Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
Syntax
IPMT(rate, per, nper, pv, [fv], [type])Argumente
rateerforderlich
The interest rate per period.
pererforderlich
The period for which you want to find the interest, must be in the range 1 to nper.
npererforderlich
The total number of payment periods in an annuity.
pverforderlich
The present value, or the total amount that a series of future payments is worth now.
fvoptional
The future value or a cash balance you want to attain after the last payment is made.
typeoptional
The number 0 or 1 and indicates when payments are due (0 = end of period, 1 = beginning of period).
The IPMT function calculates the interest portion of a loan or investment payment for a specific period. It assumes that payments are made at regular intervals and the interest rate remains constant throughout the term.
=IPMT(0.05/12, 1, 36, 10000)→-41.67Calculates the interest for the first month of a $10,000 loan at 5% annual interest over 3 years.
Identify loan parameters
Ensure you have the annual interest rate, total number of months, and the loan amount.
Apply the IPMT formula
Enter the IPMT function into a cell, adjusting the rate to a monthly figure (annual rate / 12).
The result is negative because it represents a cash outflow (payment) from the borrower's perspective.