# 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
The text passage describes the MIRR function, which calculates the modified internal rate of return for a series of cash flows, and provides examples of how to use the function.
multiple_questions_with_answers

the passage contains multiple examples of the mirr function being used to calculate the modified internal rate of return, and the answers to these calculations are provided.
Given a text passage, determine:
    1. If it contains a mathematical question (including word problems or calculations)
    2. If an answer to that mathematical question is provided in the text

First, describe the content structure you found in 1-2 sentences.

Then provide your analysis in the following format:
TYPE: <one of the following values>
- NO_QUESTION
- SINGLE_QUESTION
- SINGLE_QUESTION_WITH_ANSWER
- MULTIPLE_QUESTIONS
- MULTIPLE_QUESTIONS_WITH_ANSWERS
system
# 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
user
The text passage describes the MIRR function, which calculates the modified internal rate of return for a series of cash flows, and provides examples of how to use the function.

TYPE: MULTIPLE_QUESTIONS_WITH_ANSWERS

The passage contains multiple examples of the MIRR function being used to calculate the modified internal rate of return, and the answers to these calculations are provided.