Important Notice
The pages on this site contain documentation for very old MS-DOS software,
purely for historical purposes.
If you're looking for up-to-date documentation, particularly for programming,
you should not rely on the information found here, as it will be woefully
out of date.
MIRR# Function Details
◄Summary► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
MIRR# (valuearray#(), valuecount%, fin-rate#, reinv-rate#, status%)
Usage Notes
■ The argument valuearray#() must contain at least one negative value (a
payment) and one positive value (a receipt).
■ The arguments fin-rate# and reinv-rate# are percentages expressed as
decimal values (for example, 12% is expressed as .12).
■ The argument status% can be any variable that returns information about
the success or failure of the calculation. The value of status% will be
0 if the calculation was successful, and 1 if it was not.
■ MIRR# returns the modified internal rate of return. MIRR# considers
both the cost of the investment (fin-rate#) and the interest received
on reinvestment of cash (reinv-rate#).
■ MIRR# uses the order of values within the array to interpret the order
of payments and receipts. Be sure to enter your payment and receipt
values in the correct sequence.