PPmt
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] |
Example
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.