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