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
-
Financial Functions
Format:
Article,
1 min read