Question

In: Finance

annual cash flow, -500,000 125,000 150,000 175,000 200,000 250,000 What is the Modified IRR (MIRR), with...

annual cash flow,

-500,000
125,000
150,000
175,000
200,000
250,000

What is the Modified IRR (MIRR), with a reinvestment rate equal to the WACC of 8%?

Solutions

Expert Solution

The modified internal rate of return (MIRR) is a financial measure of an investment's attractiveness, used to rank alternative investment options.

The basic assumption is each year’s returns that are coming out of that investment will be put back into the same business each year.

MIRR = nth root of(TVCF/PVCF)- 1

Where n= no of periods

TVCF is the terminal value of positive cash inflows discounted at the reinvestment rate

PVCF is the present value of negative cash out    flows discounted at the financing rate

Here, n= 6; finance rate = WACC=8%; reinvestment rate = 8%

PVCF = -500,000


MIRR     = 6th root of(1,029,138/500,000)- 1 =  

                =

                = 1.1553 – 1

MIRR     = 0.1553 = 15.53% or approximately 16%


Related Solutions

annual cash flow, -500,000 125,000 150,000 175,000 200,000 250,000 What is the IRR of the investment
annual cash flow, -500,000 125,000 150,000 175,000 200,000 250,000 What is the IRR of the investment
Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the...
Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Celestial Crane Cosmetics is analyzing a project that requires an initial investment of $550,000. The project’s expected...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from...
4. Modified internal rate of return (MIRR) The IRR evaluation method assumes that cash flows from the project are reinvested at the same rate equal to the IRR. However, in reality, the reinvested cash flows may not necessarily generate a return equal to the IRR. Thus, the modified IRR approach makes a more reasonable assumption other than the project’s IRR. Consider the following situation: Blue Llama Mining Company is analyzing a project that requires an initial investment of $3,000,000. The...
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the...
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the discount rate is 14 percent? Year CF 0 -18,000    1 5000 2 7500 3 8400 4 2100 Also upload your excel files showing your work.
1. Suppose that a company has a Free Cash Flow of $150,000 in one year, $200,000...
1. Suppose that a company has a Free Cash Flow of $150,000 in one year, $200,000 in 2 years and then FCFs start growing at a constant rate of 5%. The WACC used as a discount rate for FCFs is 8%. The company has $ 18,000 in long-term debt and it has 40,000 shares outstanding. Find current stock price using FCF model. 2. Let's take a look at a different company. Free cash flows are usually volatile when a company...
What is the approximate IRR for a project that cost $200,000 and provide cash inflows of...
What is the approximate IRR for a project that cost $200,000 and provide cash inflows of $40,000 for 6 years. Please do not use excel
What is the difference between IRR and MIRR ? Explain with an example.
What is the difference between IRR and MIRR ? Explain with an example.
What is the correction that is made to the IRR method when using the Modified IRR...
What is the correction that is made to the IRR method when using the Modified IRR method?
What is the IRR of the following set of cash flows?     Year Cash Flow 0...
What is the IRR of the following set of cash flows?     Year Cash Flow 0 –$11,768             1 6,500             2 5,400             3 6,200             24.09% 25.36% 26.63% 25.87% 24.85%
What is the IRR of the following set of cash flows?    Year Cash Flow 0...
What is the IRR of the following set of cash flows?    Year Cash Flow 0 –$11,280             1 6,200             2 4,200             3 6,100             Multiple Choice 21.46% 21.9% 22.34% 20.8% 23%
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT