Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate.
구문
IPMT(rate, per, nper, pv, [fv], [type])인수
rate필수
The interest rate per period.
per필수
The period for which you want to find the interest, must be in the range 1 to nper.
nper필수
The total number of payment periods in an annuity.
pv필수
The present value, or the total amount that a series of future payments is worth now.
fv선택
The future value or a cash balance you want to attain after the last payment is made.
type선택
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.