IPMT

Payment on interest

Description
Calculates the cumulative interest payments on an investment. This is done based on a constant interest rate and periodic payments of constant amounts.
Function signature
IPMT(rate: Number, period: Number, numberofperiods: Number, presentvalue: Number, futurevalue: Number, paymentsatthebeginningofperiod: Boolean) => Number
Parameter
Description
Rate
The interest rate
Period
The amortization period, between 1 and Number of periods.
Number of periods
The number of payments to be made
Present value
The current value of the annuity.
Future value
Future value left when the final payment has been completed, defaults to 0.
Payments at the beginning of period
Whether payments are due at the end (false) or beginning (true) of each period
Examples
Formula
Return value
IPMT(0.1, 4, 12, 100)
-8.45
IPMT(0.5, 4, 12, 100)
-49.08
IPMT(0.5, 6, 12, 100)
-47.44
IPMT(0.5, 6, 12, 100, 200)
-42.32
IPMT(0.5, 6, 12, 100, 200, true)
-28.21

INVESTMENT_PDURATION

IRR

Last updated 11 months ago

Formula	Return value
`IPMT(0.1, 4, 12, 100)`	`-8.45`
`IPMT(0.5, 4, 12, 100)`	`-49.08`
`IPMT(0.5, 6, 12, 100)`	`-47.44`
`IPMT(0.5, 6, 12, 100, 200)`	`-42.32`
`IPMT(0.5, 6, 12, 100, 200, true)`	`-28.21`

Parameter	Description
Rate	The interest rate
Period	The amortization period, between 1 and Number of periods.
Number of periods	The number of payments to be made
Present value	The current value of the annuity.
Future value	Future value left when the final payment has been completed, defaults to 0.
Payments at the beginning of period	Whether payments are due at the end (false) or beginning (true) of each period