What is the MIRR of project with the following cash flows? The discounting rate is 14%....

What is the MIRR of project with the following cash flows? The discounting rate is 14%.

Year Cash Flow

0 -1,200,000

1 400,000

2 500,000

3 500,000

4 500,000

5 500,000

6 500,000

Expert Solution


Project
Combination approach
All negative cash flows are discounted back to the present and all positive cash flows are compounded out to the end of the project’s life
Thus year 6 modified cash flow=(770165.83)+(844480.08)+(740772)+(649800)+(570000)+(500000)
=4075217.91
Thus year 0 modified cash flow=-1200000
=-1200000


Discount rate	0.14
Year	0	1	2	3	4	5	6
Cash flow stream	-1200000	400000	500000	500000	500000	500000	500000
Discount factor	1	1.14	1.2996	1.481544	1.6889602	1.925415	2.194973
Compound factor	1	1.925415	1.68896	1.481544	1.2996	1.14	1
Discounted cash flows	-1200000	0	0	0	0	0	0
Compounded cash flows	-8.33333E-07	770165.8	844480.1	740772	649800	570000	500000
Modified cash flow	-1200000	0	0	0	0	0	4075218
Discounting factor (using MIRR)	1	1.226013	1.503107	1.842828	2.2593303	2.769967	3.396015
Discounted cash flows	-1200000	0	0	0	0	0	1200000
NPV = Sum of discounted cash flows
NPV=	5.3551E-09
MIRR is the rate at which NPV = 0
MIRR=	22.60%
Where
Discounting factor =	(1 + discount rate)^(Corresponding period in years)
Discounted Cashflow=	Cash flow stream/discounting factor
Compounding factor =	(1 + reinvestment rate)^(time of last CF-Corresponding period in years)

jeff jeffy answered 1 year ago

A project manager is trying to ascertain a discounting rate for the project cash flows that...

A project manager is trying to ascertain a discounting rate for the project cash flows that carry the same risk as the core business of the firm. The manager has been told by the finance team at the firm that the current capital structure has a debt to value ratio of 0.3, however, they are targeting a ratio of 0.25 to get a better credit rating. The better credit rating would reduce the cost of debt to 7%. The current...

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.

Calculate the MIRR of the cash flows of the project below. Assume both the finance rate...

Calculate the MIRR of the cash flows of the project below. Assume both the finance rate and the reinvestment rate are 5% Time Period Cash Flow 0 -100 1 20 2 80 3 90

Find the modified internal rate of return (MIRR) for the following series of future cash flows...

Find the modified internal rate of return (MIRR) for the following series of future cash flows if the company is able to reinvest cash flows received from the project at an annual rate of 8.91 percent.The initial outlay is $354,000. Year 1: $169,600 Year 2: $137,900 Year 3: $178,100 Year 4: $132,200 Year 5: $182,300 Round the answer to two decimal places in percentage form.

Find MIRR for the project with a cost of -$20,000 and subsequent cash flows of 10,000;...

Find MIRR for the project with a cost of -$20,000 and subsequent cash flows of 10,000; $40,000; - $5,000; -$30,000. Use WACC of 6%. Will you proceed with this project? Why or why not?

find MIRR for a project with a cost of -$20,000 and subsequent cash flows of 10,000;...

find MIRR for a project with a cost of -$20,000 and subsequent cash flows of 10,000; $40,000, -$5,000; -$30,000. use wacc of 6%. will you proceed with this project? why or why not ?

What is the internal rate of return (IRR) of this project given the following cash flows?...

What is the internal rate of return (IRR) of this project given the following cash flows? Year CF 0 -$9,800 1 $1,000 2 $4,500 3 $1,000 4 $1,500 5 $1,700 6 $2,700 Convert your answer to percentage and round off to two decimal points. Do not enter % in the answer box.

16) A project has the following cash flows. What is the internal rate of return? Year/Cash...

16) A project has the following cash flows. What is the internal rate of return? Year/Cash Flow 0/ -$89,300.00 1/ $82,900.00 2/ $4,200.00 3/ $5,800.00 A) 1.02 percent B) 6.77 percent C) 5.97 percent D) 1.11 percent E) 3.45 percent 17) A company wants to purchase a new machine costing $1.46 million. Management is estimating the machine will generate cash inflows of $223,000 the first year and $600,000 for the following four years. If management requires a minimum 12 percent...

16. Problem 11.21 (MIRR) Project A costs $4,000, and its cash flows are the same in Years...

16. Problem 11.21 (MIRR) Project A costs $4,000, and its cash flows are the same in Years 1 through 10. Its IRR is 16%, and its WACC is 9%. What is the project's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.

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...

Question