t's a project evaluation spreadsheet intended to be used by a work colleague such that they can enter some variable values and then see the results of payback period, NPV, IRR and MIRR.

The inputs are:

project cash flows for time zero and 10 subsequent years (time 0 through time 10, thus 11 numbers),

the project required rate of return,

the company weighted average cost of capital.

Assume the only negative cash flow is the cash flow at time 0.

How this will be graded: Prof. Stewart will input three differing project examples to see whether your spreadsheet can compute the correct payback period, NPV, IRR and MIRR results.