Question

Bellinger Industries is considering two projects for inclusion in its capital budget, and you have been asked to do the analysis. Both projects' after-tax cash flows are shown on the time line below. Depreciation, salvage values, net operating working capital requirements, and tax effects are all included in these cash flows. Both projects have 4-year lives, and they have risk characteristics similar to the firm's average project. Bellinger's WACC is 8%.

	0		1		2		3		4
Project A	-1,350		650		440		250		300
Project B	-1,350		250		375		400		750

What is Project A's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.

What is Project B's MIRR? Do not round intermediate calculations. Round your answer to two decimal places.

Answer 1

a). Calculating the Project A's MIRR using Excel "MIRR" function:-

Assuming Re-investment rate to be 8% as well.

So, MIRR of Project A is 8.95%

b). Calculating the Project B's MIRR using Excel "MIRR" function:-

Assuming Re-investment rate to be 8% as well.

So, MIRR of Project B is 9.41%

If you need any clarification, you can ask in comments.    

If you like my answer, then please up-vote as it will be motivating