Pmt
Name | Pmt |
Syntax | Pmt (Real Rate, Real Periods, Real numPeriods, Real PV) |
Purpose | To return the payment for an annuity based on periodic, fixed payments and a fixed interest rate. |
Description | Returns the payment for 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] |
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2F3083465318-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FsR50Wa7EwZGlmPSAMkkf%252Fuploads%252FoewuBDQj73Pjyq94AUmP%252F0.png%3Falt%3Dmedia&width=768&dpr=4&quality=100&sign=5e7bc35b&sv=1)
Example
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
rate = 1.0123
periods = 0
numPeriods = 1000
PV = 20000
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2F3083465318-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FsR50Wa7EwZGlmPSAMkkf%252Fuploads%252F8wIo55bZFVus87WVzb3g%252F1.png%3Falt%3Dmedia&width=768&dpr=4&quality=100&sign=290a3112&sv=1)
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the Pmt function, and returned the payment value.
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2F3083465318-files.gitbook.io%2F%7E%2Ffiles%2Fv0%2Fb%2Fgitbook-x-prod.appspot.com%2Fo%2Fspaces%252FsR50Wa7EwZGlmPSAMkkf%252Fuploads%252FTkykU6Mjn8fy0wePO4EV%252F2.png%3Falt%3Dmedia&width=768&dpr=4&quality=100&sign=58fc3b80&sv=1)
Last updated