1

Start Excel. Download and open the workbook named:

Zutter_Chapter_10_Start.

In cell D47, by using cell references to the given data and the function NPV, calculate the net present value of the project.

1

2

In cell C49, type either Accept or Reject depending on whether you would take on the project or not, based on the NPV rule.

1

3

In cell F49, type either > or < depending on whether the NPV is greater or less than zero.

1

4

In cell D53, by using cell references to the given data and the function IRR and an initial estimate of 0.1, calculate the internal rate of return of the project.

1

5

In cell C55, type either Accept or Reject depending on whether you would take on the project or not, based on the IRR rule.

1

6

In cell F55, type either > or < depending on whether the IRR is greater or less than the cost of capital.

1

7

In cell G61, type either True or False depending on whether you agree or not with the statement given above.

1

8

In cell range D67:D76, by using cell references to the given data, calculate the payback for years 0:10, respectively.

11

9

In cell E78, by using cell references to cells C73, D73 and E40, calculate the payback period of the project.

1

10

In cell E80, type either > or < depending on whether the payback period is greater or less than 7 years.

1

11

In cell H80, type either acceptable or unacceptable depending on whether you would take on the project or not, based on the payback rule.

1

12

Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.

0

Total Points

21