◄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#►