IPmt (FV)
Last updated
Last updated
Name
IPmt (FV)
Syntax
IPmt (Real Rate, Real Periods, Real numPeriods, Real PV, Real FV)
Purpose
To return a value by applying the interest payment function on specified values.
Description
Returns the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. Also takes into account, the specified Future Value.
Return Type
Double
Parameters
Rate [System.Double]
periods [System.Double]
numPeriods [System.Double]
PV [System.Double]
FV [System.Double]
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
rate = 3
periods = 5
numPeriods = 100
PV = 5000000
FV = 1000
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the IPmt function, and returned the interest amount of an annuity, dependent on a specified period and period amount and Future Value.