ppmt Function

Description:
The payment (minus interest) 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?
Example:
When using functions inside a field, remember the field brackets:
{ppmt(BaseRate, InvestmentPeriod, NumberofInvestmentPeriods, CurrentValue, FutureValue, InterestPayable)}
Expression
Result
ppmt( 0.12, 5, 12, 0, 24133.13, false )
-1573.52

Related content