ANSWER IN DETAIL!!! DO THE EXCEL TABLE!!!

1. Develop an Excel table using the following financial evaluation and save it as alternative 1.

\fExhibit A: Financial Analysis for Project Management Intranet Site Project Discount rate Assume the project is done in about 6 months Year Total Costs 140,000 40,000 40,000 40.000 Discount factor 0.93 0.86 0.79 Discounted costs 140,000 37,037 34,294 31,753 243,084 Benefits 0 200.000 200,000 200,000 Discount factor 0.93 0.86 0.79 Discounted benefits 186, 185 171,468 158,756 515,419 Discounted benefits - costs (140,000) 148. 148 137,174 127.013 Cumulative benefits - costs (140,000) 8,148 145,322 272 336 4 NPV Payback in Year 1 Discounted life cycle RO|- 112% Assumptions Costs # hours PM (500 hours, $50/hour) 25,000 Staff (1,500 hours, $70/hour) 105,000 Outsourced software and services 10,000 Total project costs (all applied in year 0) 140,000 Benefits # consultants 400 Hours saved 40 Shour profit 10 Benefits from saving time 160,000 Benefits from 1%% increase in profits 40,000 Total annual projected benefits 200,000