bas7qck.hlp (Table of Contents; 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
  Syntax  Details  Example                 Contents  Index  Back
──────────────────────────────────────────────────────────────────────────────
MIRR# (valuearray#(), valuecount%, fin-rate#, reinv-rate#, status%)
 
    ■ valuearray#()     An array of cash flow values.
    ■ valuecount%       The total number of items in the cash flow array.
    ■ fin-rate#         The interest rate paid as the cost of financing.
    ■ reinv-rate#       The interest rate received on gains from cash
                        reinvestment.
    ■ status%     A variable that returns a value indicating calculation
                  failure or success: 0 = success; 1 = failure.
 
Returns
    The modified internal rate of return for a series of periodic cash
    flows (payments and receipts).
 
See Also    IRR#    Rate#