MIRR# Function
◄Summary► ◄Details► ◄Example► ◄Contents► ◄Index► ◄Back►
──────────────────────────────────────────────────────────────────────────────
Financial Functions available in Professional Edition only
──────────────────────────────────────────────────────────────────────────────
Returns the modified internal rate of return for a series of periodic cash
flows (payments and receipts). Requires FINANCE.QLB (FINANCE.LIB when
compiling); include FINANCE.BI.
MIRR# (valuearray#(), valuecount%, fin-rate#, reinv-rate#, status%)
■ valuearray#() Array of cash flow values
■ valuecount% Total number of items in the cash flow array
■ fin-rate# Interest rate paid as the cost of financing
■ reinv-rate# Interest rate received on gains from cash
reinvestment
■ status% Variable that returns a value indicating calculation
failure or success:
0 = success
1 = failure
See Also
◄Financial Function Summary► ◄$INCLUDE Metacommand► ◄Quick Libraries►