ipmt Function

Description:
The interest payable for a specific periodic investment at a fixed interest rate.
Returns:
Number
Parameters:
Parameter
Data Type
Description
1
Number
The interest rate.
2
Whole Number
The investment period.
3
Whole Number
The number of investment periods.
4
Number
The present value of the investment.
5
Number
The future value of the investment.
6
Boolean
Interest payable at the beginning of each period?
Examples:
When using functions inside a field, remember the field brackets:
{ipmt(BaseRate, InvestmentPeriod, NumberInvestmentPeriods, CurrentValue, FutureValue, InterestPayable)}
Expression
Result
ipmt( 0.12, 1, 12, 0, 24133.13, false )
0
ipmt( 0.12, 2, 12, 0, 24133.13, false )
120
ipmt( 0.12, 3, 12, 0, 24133.13, false )
254.4

Related content