MIRR() - Modified internal rate of return

Calculates the Internal Rate of Return of an investment based on a series of periodic cash flows and a discount rate.

Returns

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

Arguments

Type	Field	Description
double	dInitial	Initial investment
double	dIntPos	Guess interest percentage positive cash flows
double	dIntNeg	Guess interest percentage negative cash flows
double	dCF[]	Array of cash flows
integer	iCount	Number of cash flows in array
integer	iBasis	Value: 0 = end 1 = begin

16 bit DLL declarations

PowerBuilder Function declaration

function double MIRR(double dInitial, double dIntPos, double dIntNeg, double dCF[], int iCount, int iBasis) library "IFL16.DLL"

Visual Basic Function declaration

Declare Function MIRR lib "IFL16" (ByVal dInitial As Double, ByVal dIntPos As Double, ByVal dIntNeg As Double, ByVal dCF[] As Double, ByVal iCount As Integer, ByVal iBasis As Integer) As Double

Access Function declaration

Declare Function MIRR lib "IFL16" (Byval dInitial As Double, ByVal dIntPos As Double, ByVal dIntNeg As Double, dCF As Any, ByVal iCount As Integer, ByVal iBasis As Integer) As Double

C/C++ Synopsis

#include "function.h"

double MIRR(double dInitial, double dIntPos, double dIntNeg, double *dCF, int iCount, int iBasis)

32 bit DLL declarations

PowerBuilder Function declaration

function double MIRR(double dInitial, double dIntPos, double dIntNeg, double dCF[], int iCount, int iBasis) library "IFL32.DLL"

Visual Basic Function declaration

Declare Function MIRR lib "IFL32" (ByVal dInitial As Double, ByVal dIntPos As Double, ByVal dIntNeg As Double, ByVal dCF[] As Double, ByVal iCount As Integer, ByVal iBasis As Integer) As Double

Access Function declaration

Declare Function MIRR lib "IFL32" (Byval dInitial As Double, ByVal dIntPos As Double, ByVal dIntNeg As Double, dCF As Any, ByVal iCount As Integer, ByVal iBasis As Integer) As Double

C/C++ Synopsis

#include "function.h"

double MIRR(double dInitial, double dIntPos, double dIntNeg, double *dCF, short sCount, short sBasis)

Example:

dInitial	=	-1,200
dIntPos	=	0.05	(5%)
dIntNeg	=	0.07	(7%)
dCF[1]	=	400
dCF[2]	=	-200
dCF[3]	=	500
dCF[4]	=	-150
dCF[5]	=	500
iCount	=	5
iBasis	=	0	(end of period)

Result: 0.011934 (1.1934%)