In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
rate = 0.5
periods = 10
numPeriods = 100
PV = 50000
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the PPmt function, and returned the principal payment value.
Name
PPmt
Syntax
PPmt (Real Rate, Real Periods, Real numPeriods, Real PV)
Purpose
To return the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
Description
Return the principal payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate.
Return Type
Double
Parameters
Rate [System.Double]
periods [System.Double]
numPeriods [System.Double]
PV [System.Double]
