Rate (FV)
Name | Rate (FV) |
Syntax | Rate (Real numPeriods, Real Pmt, Real PV, Real FV) |
Purpose | To return the interest rate per period for an annuity. |
Description | Returns the interest rate per period for an annuity. Also considers the Future Value. |
Return Type | Double |
Parameters | numPeriods [System.Double] Pmt [System.Double] PV [System.Double] FV [System.Double] |
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2Fgithub.com%2Fastera-software%2FAstera_Data_Stack_v9%2Fblob%2Fmain%2F.gitbook%2Fassets%2F0%2520%2842%29.png&width=768&dpr=4&quality=100&sign=f4e3b968&sv=1)
Example
In this example, we will be passing the required parameters to the function transformation object using a Variables object.
Where,
numPeriods = 5
Pmt = 10
PV = 3500
FV = 5000
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2Fgithub.com%2Fastera-software%2FAstera_Data_Stack_v9%2Fblob%2Fmain%2F.gitbook%2Fassets%2F1%2520%2843%29.png&width=768&dpr=4&quality=100&sign=9ac8ae6c&sv=1)
Right-click on the function transformation object and select Preview Output. You can see that Astera Data Stack has applied the Rate function, and returned the Interest rate value, while also considering the future value.
![](https://documentation.astera.com/~gitbook/image?url=https%3A%2F%2Fgithub.com%2Fastera-software%2FAstera_Data_Stack_v9%2Fblob%2Fmain%2F.gitbook%2Fassets%2F2%2520%2843%29.png&width=768&dpr=4&quality=100&sign=1027ff05&sv=1)
Last updated