Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

The controller of Tims Travel (TT) is deciding between upgrading the companys existing computer system or replacing it with a new one. Upgrading the four-year-old

The controller of Tims Travel (TT) is deciding between upgrading the companys existing computer system or replacing it with a new one. Upgrading the four-year-old system will cost $97,500 and extend its useful life for another seven years. The book value is $19,500, although it would sell for $24,000. Upgrading will eliminate one employee at a salary of $19,400; the new computer will eliminate two employees. Annual operating costs are estimated at $15,950 per year. Upgrading is expected to increase profits 3.5% above last years level of $553,000.

The BetaTech Company has quoted a price of $224,800 for a new computer with a useful life of seven years. Annual operating costs are estimated to be $14,260. The average processing speed of the new computer is 12% faster than that of other systems in its price range, which would increase TTs profits by 4.5%.

Tims present tax rate is 35%, and the cost of financing is 11%. After seven years, the salvage value, net of tax, would be $12,000 for the new computer and $7,500 for the present system. For tax purposes, computers are depreciated over five full years (six calendar years; a half year the first and last years), and the depreciation percentages are as follows:

Year Percent (%)
1 20.00
2 32.00
3 19.20
4 11.52
5 11.52
6 5.76

Required

Using a spreadsheet package, prepare an economic feasibility analysis to determine whether TT should rehabilitate the old system or purchase the new computer. As part of the analysis, compute the after-tax cash flows for years 1 through 7 and the payback, NPV, and IRR of each alternative.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Health Care Finance Basic Tools For Nonfinancial Managers

Authors: Judith Baker

2nd Edition

0763726605, 9780763726607

More Books

Students also viewed these Finance questions

Question

a. Did you express your anger verbally? Physically?

Answered: 1 week ago