© Copyright 2023, Astera Software
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]
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.
