## Answers

**How to find MIRR?**

For computation of MIRR, unlike IRR we assume that the reinvestment of cashflows are made at cost of capital. Hence , we need to find the terminal value of positive cashflows(return) and the present value of negative cashflows(outlay).

For computation of terminal value, we need to find what will be the value of each cashflow at the end of 4th year if reinvested at 7%. For year 1 , it will be Cashflow of year 1 x (1.07)^{3} . Similarly for year 3 it will be cashflow of year 3 x (1.07) , since it will be reinvested only for a year. For year 4 the value will be cashflow itself, since we have to find value at end of year 4.

The sum of these 3 figures will give you the terminal value.

For computation of Present value cashflows, in the given problem we have initial outlay and a negative cash flow in year2. Hence we need to find the PV factor and discount both these cashflows.

Now, by applying the formula given in the computation we can find the MIRR. Note: the n in formula refers to the no.of years. which in this case is 4.( hence the sort formula applied twice to arrive the answer using excel)

**MIRR DECISION RULE**

In case of MIRR, the project can be accepted if the MIRR is greater than the cost of capital.

Hence if Celestial Crane Cosmetics' managers select projects based on the MIRR criterion, they should **select/accept** this independent project.

**Statement best describing difference between MIRR and IRR**

**Answer : statement 2:** The IRR method assumes that the cashflows are reinvested at a rate of return equal to the IRR . The MIRR method assumes that the cashflows are reinvested at a rate of return equal to cost of capital.

Statement 1 is wrong because the basic principle of IRR is that it is the rate at which net present value of a project will be equal to zero.The NPV is the net present value of its cash inflows and outflows.

Statement 3 is partially wrong because in MIRR method also we need to calculate the present value of initial investment.

100000 0.873 87,343.87 6,87,343.87 MIRR Computation MIRR=Terminal cash flow Outlay |=SQRT(SQRT(1415891.125/687343.87))-1 19.80%