advr.hlp (Topic list)
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.