I created 5 worksheets as indicated in the case.

This can be located in the Documentation Worksheet, as been stated from the case, it should contain the name of the creator, worksheets and the date the workbook is created.
This can be located to the next worksheet which is the One-time cost worksheet where I placed the table (Table 2 from the case).


This one is placed in the Recurring cost worksheet, this table is the (Table 3 from the case).





This table can be seen in the tangible benefits worksheet same as what is given in the case (Table 1).






This is located at the last worksheet which is the economic feasibility worksheet, this is where the coloborating functions can be used. This worksheet must be linked to the rest of the worksheet. The most complicated worksheet among the 5 worksheets made. All of the functions are used on this worksheet. All the numbers on the cell are not encoded they have specific formulas (NPV, PV etc).

This is one of the example I made in the economic feasibility worksheet on how to concolidate the worksheets, the answer from the other sheet is located on this sheet. From this illustration the selected cell is consolidated from the tangible benefit worksheet.






This is the formula on how to get the present value factor. Formula is given from the case (Page 4).










If you see errors or clarifications, we can revised it, this is my contribution for the class case. Infosys classmates, comment on this if you have other idea, we need to work together.