© 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.
