RATE() - Investment periods

Calculates the periodic interest rate necessary for an investment to grow over a number of compounding periods.

Returns

Double value if successful. If an error occurs, this function returns a zero.

Arguments

Type	Field	Description
double	dFV	Future value
double	dPV	Present value
long	lTerm	Number of periods

16-bit DLL declarations

PowerBuilder Function declaration

function double RATE(double dFV, double dPV, long lTerm) library "IFL16.DLL"

Visual Basic Function declaration

Declare Function RATE lib "IFL16" (ByVal dFV As Double, ByVal dPV As Double, ByVal lTerm As Long) As Double

C/C++ Synopsis

#include "function.h"

double RATE(double dFV, double dPV, long lTerm)

32-bit DLL declarations

PowerBuilder Function declaration

function double RATE(double dFV, double dPV, long lTerm) library "IFL32.DLL"

Visual Basic Function declaration

Declare Function RATE lib "IFL32" (ByVal dFV As Double, ByVal dPV As Double, ByVal lTerm As Long) As Double

C/C++ Synopsis

#include "function.h"

double RATE(double dFV, double dPV, long lTerm)

Example:

dFV	=	18000
dPV	=	10000
lTerm	=	60

Result: 0.00984 (0.984% per period)