4-7.For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a hard and fast rule on payback period, all projects must be completed within 6 years or less.

Expected cash flows for the four potential projects that DHC is considering as shown below:

Year

Project A

Project B

Project C

Project D

0

-$4,000,000

-$8,000,000

-$6,000,000

-$3,000,000

1

$1,000,000

$1,250,000

$1,500,000

$300,000

2

$1,000,000

$1,250,000

$1,500,000

$500,000

3

$1,000,000

$1,250,000

$2,500,000

$500,000

4

$1,000,000

$1,250,000

$2,500,000

$750,000

5

$800,000

$1,250,000

$750,000

6

$0

$1,250,000

$750,000

7

$800,000

$1,250,000

$750,000

8

$300,000

$1,250,000

$750,000

9

$1,250,000

$750,000

10

$1,250,000

$750,000

I have provided a suggested template for your final answers. Below the grid (and/or next page) is where you should put all your required backup calculations. If you are working this in Excel, feel free to submit your Excel sheet, where the equations in the cells will provide the required backup. Be sure to clearly indicate the required rate of return (from part 3) you are using for each project.

what is the npv, irr, pi, and payback period