It is 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),

Years / Project Cash flows

0 (75,000)

1 100,000

2 108,000

3 7,500

4 250,00

5 178,000

6 50,000

7 18,000

8 12,000

9 10,000

10 8,000

the project required rate of return,

the company weighted average cost of capital 6%

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

Create an excel spreadsheet to compute (formulas) the correct payback period, NPV, IRR and MIRR results