Name
MIRR Function
Class
Microsoft.VisualBasic.Financial
Syntax
MIRR(valuearray( ), financerate, reinvestrate
)
-
valuearray
( )
Use: Required
Data Type: Array of Double
An array of cash flow values
-
financerate
Use: Required
Data Type: Double
The interest rate paid as the cost of financing
-
reinvestrate
Use: Required
Data Type: Double
The interest rate received on gains from cash investment
Return Value
A Double representing the modified internal rate of return
Description
Calculates the modified internal rate of return, which is the internal rate of return when payments and receipts are financed at different rates
Rules at a Glance
valuearray
must be a one-dimensional array that contains at least one negative value (a payment) and one positive value (a receipt). The order of elements within the array should reflect the order in which payments and receipts occur.financerate
andreinvestrate
are percentages expressed as decimal values. For example, 10% is expressed as 0.10.
Programming Tips and Gotchas
Each element of valuearray
represents a
payment or a receipt that occurs at a regular time interval. If this
is not the case, MIRR
will return erroneous
results.
See Also
Get VB .NET Language in a Nutshell now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.