IPMT
Name
Interest payment
Description
Calculates the payment of interest on a loan.
Syntax
IPMT(rate,per,nper,pval,fval,type)
Remarks
The result is represented by a negative number because it is money paid out by you.
This function has the following arguments:
Argument | Description |
---|---|
rate | Value of interest rate per period |
per | Number of the period for which to find the interest, between 1 and nper |
nper | Total number of payment periods in an annuity |
pval | Present value, worth now |
fval | [Optional] Future value, cash value after the last payment; if omitted, the calculation uses zero |
type | [Optional] Indicates when payments are due; at the end (0) or beginning (1) of the period; if omitted, the calculation uses the end (0) |
Data Type
Accepts numeric data for all arguments. Returns numeric data. For more information, see Data Type for Each Cell Type.
Example
IPMT(0.65,A1,B3,C42)
IPMT(R1C1,R12C12,R13C13,R32C1)
IPMT(0.45,2,30,6000)=-2699.98