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.

  ◄Syntax►  ◄Details►  ◄Example►                 ◄Contents►  ◄Index►  ◄Back►
──────────────────────────────────────────────────────────────────────────────
MIRR# returns the modified internal rate of return for a series of periodic
cash flows (payments and receipts).
 
MIRR# (valuearray#(), valuecount%, fin-rate#, reinv-rate#, status%)
    ■ 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.
 
Usage Notes
    ■ MIRR# returns the modified internal rate of return. MIRR# considers
      both the cost of the investment (finrate#) 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.
    ■ The formula for MIRR# is found in the BASIC Language Reference
      manual.
 
Important
    ■ To use MIRR# in the QBX environment, use the FINANCER.QLB Quick
      library. To use MIRR# outside the QBX environment, link your program
      with the appropriate FINANCxx.LIB file. Depending on the compiler
      options you chose when you installed BASIC, one or more of the
      following files will be available:
 
           Filename         Compiler options
           ════════════     ═════════════════════════════════════════════
           FINANCER.LIB     80x87 or emulator math; DOS or OS/2 real mode
           FINANCAR.LIB     Alternate math; DOS or OS/2 real mode
           FINANCEP.LIB     80x87 or emulator math, OS/2 protected mode
           FINANCAP.LIB     Alternate math; OS/2 protected mode
 
    ■ The FINANC.BI header file contains the necessary function
      declarations for MIRR#.
    ■ For more information on using libraries, see "Creating and Using
      Quick Libraries" and "Using LINK and LIB" in the BASIC Programmer's
      Guide.