XLeratorDB/financial Documentation
RRI
Updated: 4 Apr 2017
Use the scalar function RRI to calculate an equivalent interest rate for the growth of an investment. The formula is:
Where
| FV | = | the future value of the investment |
| PV | = | the present value of the investment |
| nper | = | the number of periods. |
Syntax
SELECT [wct].[RRI] (
<@Nper, float,>
,<@PV, float,>
,<@FV, float,>)
Arguments
| Input Name | Description |
| @Nper | Number of periods. @Nper must be of type float or of a type that implicitly converts to float. |
| @PV | Present value of the investment. @PV must be of type float or of a type that implicitly converts to float. |
| @FV | Future value of the investment. @FV must of a type float or of a type that implicitly converts to float. |
Return Type
float
Remarks
- If @PV is NULL then @PV = 0
- If @PV = 0 then NULL is returned
- If @FV is NULL then @FV = 0
- If @Nper is NULL then @Nper = 0
- If @Nper = 0 then NULL is returned
- Available in XLeratorDB / financial 2008 only
Example
SELECT
wct.RRI(
36
,1000
,1100
) as RRI
This produces the following result.
See Also