The Eaton Company is a national manufacturer of consumer goods and is looking at purchasing a new computer system that will result in a reduction in total operating costs. The purchase cost of the computer system is $540,000. This cost will be fully depreciated using the straight line method over the equipment's 5 year life.

At the end of the 5th year, the company plans on selling the computer equipment. While it is unknown at this time how much the equipment can be sold for, management has assigned $80,000 as its potential salvage value. The company's accounting policy is not to subtract salvage value from the purchase cost for purposes of calculating depreciation expense.

Management believes that the new computer system can save the firm $170,000 per year in pre-tax operating costs. These cost savings are considered incremental revenues for the firm. In addition, the computer system requires an initial investment in net working capital of $29,000 which is assumed to be recovered or paid back at the end of the 5th year. The company's tax rate is 34% and its required return on all new capital expenditures is 10%. There are no other new incremental expenses to consider.

QUESTIONS:

1. Calculate the Net Present Value and Internal Rate of Return for this investment.

REQUIREMENTS:

You are required to create supporting calculations and/or schedules (worksheets) for question # 1. They are as follows:

a. Prepare the pro-forma income statement

b. Calculate the annual operating cash flow

c. Calculate the after tax salvage value

d. Create a chart showing the project's annual cash flows for years 0 through year 5

e. Show the keystrokes you used to calculate the NPV and IRR.

2. Should management purchase the computer system? State Yes or No AND explain your answer in 1-2 sentences.