You are asked to conduct a five-year economic feasibility study of an e-commerce site for a small office supply company. Due to construction time, the system will only be in operation for 6 months for the current year (Year 1). Once the system is in operation, you expect to reduce staff cost by $37,000 and to reduce printing/postage cost by $12,000 for a full year of operation between year 1 and year 3. The numbers will be $38,000 and $15,000, respectively, for year 4 and year 5.

New computer and software costs $6,000, and the cost of system development is estimated at $87,500. The software license and the cost of hiring/training a part-time operator is totaled $8,000 per full year of operation between year 1 and year 3. The same cost is estimated to be $9,000 for year 4 and 5.

1.) Calculate the NPV for the above project assuming a discount rate of 6%. Is there a break-even point in the first five years? If so, when? What is the ROI for the project? Make sure to prorate the appropriate system costs and benefits for Year 1. Make a spreadsheet showing all years.

2.) What is the impact on NPV if the discount rate is 9% instead? Does the NPV decreases with higher discount rate? Why or why not? Paste another copy of the spreadsheet.

3.) Use Goal Seek feature of Excel to find out the amount of the development cost that would make the NPV zero for the project.