Question

Compute the MIRR statistic for Project I and note whether to accept or reject the project with the cash flows shown as follows if the appropriate cost of capital is 15 percent. Project I Time 0 1 2 3 4 5 Cash Flow –$ 1,000 $ 400 $ 300 $ 200 $ 300 $ 50 Multiple Choice The project's MIRR is 18.19 percent and the project should be accepted. The project's MIRR is 12.67 percent and the project should be rejected. The project's MIRR is 10.29 percent and the project should be rejected. The project's MIRR is 17.17 percent and the project should be accepted.

Answer 1

=MIRR({-1000;400;300;200;300;50},15%,15%)=12.666%

The project's MIRR is 12.67 percent and the project should be rejected.