You have 3 projects with the following cash flows:

Year 0 1 2 3 4

Project 1 $-149 $20 $42 $60 $79

Project 2 -824 0 0 6,993 -6,509

'Project 3 20 38 59 79 -244

a. For which of these projects is the IRR rulereliable?(Select from thedrop-down menus.)

The IRR rule is reliable for project 1

. Unless all of the negative

cash flows of the project precede the positive

ones, the IRR rule may give the wrong answer and should not be used.Furthermore, there may be multiple IRRs or the IRR may not exist.

b. Estimate the IRR for each project(to the nearest 1 %

1%).

The IRR for project 1 is ____ (Round to the nearestinteger.)

The IRR for project 2 is _____(Round to the nearestinteger.)

The IRR for project 3 is _____(Round to the nearestinteger.)

c. What is the NPV of each project if the cost of capital is 5%? 20%? 50%?

The NPV for project 1 for a cost of capital of 5 %_____(Round to the nearestcent.)

The NPV for project 1 for a cost of capital of 20 % ______(Round to the nearestcent.)

The NPV for project 1 for a cost of capital of 50 % _______(Round to the nearestcent.)

The NPV for project 2 for a cost of capital of 5 %_________(Round to the nearestcent.)

The NPV for project 2 for a cost of capital of 20 % _________(Round to the nearestcent.)

The NPV for project 2 for a cost of capital of 50 %_______(Round to the nearestcent.)

The NPV for project 3 for a cost of capital of 5 %_______(Round to the nearestcent.)

The NPV for project 3 for a cost of capital of 20 %_______(Round to the nearestcent.)

The NPV for project 3 for a cost of capital of 50 %________(Round to the nearestcent.)

Please provide excel sheet with pluggable values. Thank you.