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.
Please show work
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
