text: # Manuals/calci/MIRR
  
  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.
  
  ## Description
  
  • 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.
  2.ar is not containing the atleast one positive value and one negative value.
  
  
  ## Examples
  
  A B
  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
  
  MIRR
explanation: The document describes the MIRR (Modified Internal Rate of Return) function, which is used to calculate the internal rate of return for a series of cash flows, considering different rates for financing and reinvesting. It provides a detailed explanation of the function's parameters, the formula used, and some examples of how to use the function.
  
  The document contains examples that serve as both questions and answers, as they show how to use the MIRR function and provide the resulting values.
distilabel_metadata.content: Evaluate the user given text extract and determine if it contains a math question and optionally and answer to this question.
  
  Output rules:
  
  1. Briefly describe the document and mention if it contains a question or a question and answer.
  2. Finalize the output with: Label: no-question,question,question-and-answer,multiple-question,multiple-question-and-answer
distilabel_metadata.role: system
distilabel_metadata.content: # Manuals/calci/MIRR
  
  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.
  
  ## Description
  
  • 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.
  2.ar is not containing the atleast one positive value and one negative value.
  
  
  ## Examples
  
  A B
  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
  
  MIRR
distilabel_metadata.role: user
distilabel_metadata.raw_output_q_a_detector_0: The document describes the MIRR (Modified Internal Rate of Return) function, which is used to calculate the internal rate of return for a series of cash flows, considering different rates for financing and reinvesting. It provides a detailed explanation of the function's parameters, the formula used, and some examples of how to use the function.
  
  The document contains examples that serve as both questions and answers, as they show how to use the MIRR function and provide the resulting values.
  
  Label: multiple-question-and-answer