IPMT function
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])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| rate | Yes | Required. The interest rate per period.10%/12 |
| per | Yes | Required. The period for which you want to find the interest and must be in the range 1 to nper.1 |
| nper | Yes | Required. The total number of payment periods in an annuity.3*12 |
| pv | Yes | Required. The present value, or the lump-sum amount that a series of future payments is worth right now.80000 |
| fv | No | Optional. The future value, or a cash balance you want to attain after the last payment is made. If fv is omitted, it is assumed to be 0 (the future value of a loan, for example, is 0).0 |
| type | No | Optional. The number 0 or 1 and indicates when payments are due. If type is omitted, it is assumed to be 0.0 |
Try IPMT
Separate interest from the second equal payment
=IPMT(A2,D2,B2,C2)Each end-of-period payment is about 102.01. After the first payment the balance is about 200.99, so period 2 interest is about 2.01. Excel returns a negative payment for this positive loan receipt.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
IPMT · top-level call
=IPMT(A2,D2,B2,C2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.