Problem
Create the cost benefit analysis spreadsheet as done in class and calculate the NPV, ROI and payback period.
A new marketing system will have developmental costs of $165,000. Its operating costs start at $8000 for the first year and then decrease by $500 each year. The benefits are $50,000 per year. The life of the system is 5 years. The discount factors are .96, .92, .89, 85, .82.