From ZCubes Wiki
Jump to navigation Jump to search
MIRR (ValuesArray,FinanceRate,ReinvestmentRate)

  • is the array of values.
  • is the finance rate.
  • is the reinvestment rate.
    • MIRR(), returns the internal rate of return where positive and negative cash flows are financed at different rates.


  • This function gives the value of the modified internal rate of return for a particular cash flows.
  • is a modification of the internal rate of return.
  • The internal rate of return (IRR) assumes the cash flows from a project are reinvested at the IRR, the modified IRR assumes that positive cash flows are reinvested at the firm's cost of capital, and the initial outlays are financed at the firm's financing cost.
  • So more accurately reflects the cost and profitability of a project.
  • , is the array of cash flow values.
  • is the finance rate which is the interest rate we pay on the money used in the cash flows or it is the cost of capital.
  • is the interest rate which we receive on the cash flows as we reinvest in to that.
  • For calculation involves two rates – finance rate, which is your weighted average cost of capital and reinvest rate.
  • Also calculation is having the following rules.
  1.The cash flows must occur at regular intervals, but do not have to be the same amounts for each interval.
  2.projects with MIRR greater the project's hurdle rate should be accepted; while in case of mutually exclusive projects, the project with higher MIRR should be preferred. 
  • The formula for is :

where is the reinvestment rate, is the finance rate, is the positive values in the array only, is the negative values in the array only, is the number of periods and is the CALCI function.

  • This function will give the result as error when
  1.Any one of the argument is nonnumeric. is not containing the atleast one positive value and one negative value.


1 -250000 -8000000
2 20000 90000
3 30500 25000
4 25000 20000
5 37000 10000
6 28000 5000
7 11% 10%
8 12% 9%
  1. MIRR(A1:A6,A7,A8)=-0.07
  2. MIRR(B1:B6,B7,B8)=-0.52
  3. MIRR([-8000000,90000,25000,20000,10000,5000],10%,9%) = -0.52

Related Videos


See Also