Question: 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

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 six months for the current year (Year 1). Once the system is in operation, you expect to reduce the secretarial cost by $25,000 and reduce printing/postage cost by $12,000 for a full year of operation between year 1 and year 3. The numbers will be $28,000 and $16,000, respectively, for years 4 and 5. New computer and software cost $3,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 years 4 and 5. 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. Paste a copy of the spreadsheet. What is the impact on NPV if the discount rate is 9% instead? Does the NPV decrease with a higher discount rate? Why or why not? Use Goal Seek feature of Excel to find out the amount of the development cost that would make the NPV zero for the project

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!