IPMT
Returns the interest payment for an investment for a given period.
FinancialFinance & Accounting
What it does
Calculates the interest portion of a loan payment for a specific period.
Syntax
IPMT(rate, per, nper, pv, [fv], [type])
Arguments
rate(number) — Interest rate per period.per(number) — Period to find interest for.nper(number) — Total periods.pv(number) — Present value.
Examples
Interest Payment
Interest for month 1.
FORMULA
=IPMT(0.05/12, 1, 60, 10000)
RESULT
-41.67
SAMPLE DATA
| A | |
|---|---|
| 1 | Loan |
| 2 | 10000 |