O'Reilly logo

VB.NET Language in a Nutshell, Second Edition by Steven Roman PhD, Paul Lomax, Ron Petrusha

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Name

MIRR Function

Class

Microsoft.VisualBasic.Financial

Syntax

MIRR(valuearray(  ), financerate, reinvestrate)
valuearray( ) (required; Array of Double)

An array of cash flow values

financerate (required; Double)

The interest rate paid as the cost of financing

reinvestrate (required; 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 and reinvestrate 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

IRR Function

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required