Visual Basic Financial Function : MIRR

Purpose : The MIRR function returns the modified internal rate of return for a varying series of cash flows.

Syntax :
MIRR (dblValuesArray ( ) , dblFinanceInterestRate , dblReinvestmentInternalRate )

dblValuesArray : Array of cash flows
dblFinanceInterestRate : Interest rate of initial investment
dblReinvestmentInternalRate : Interst rate for reinvested monies

dblMoney(0) = -50000
dblMoney(1) = -25000
dblMoney(2) = 0
dblMoney(3) = 10000
dblMoney(4) = 30000
dblMoney(5) = 50000
dblMoney(6) = 200000
dblFinanceRate = 0.1
dblReinvestRate= 0.8

dblReturn = MIRR ( dblMoney ( ) , dblFinanceRate , dblReinvestRate ) * 100