Friendly Tests Inc. is a commercial testing lab, performing a variety of lab tests for hospitals in the area. The management is considering an addition of a new type of test. There is plenty of room in its existing lab facility, but the new test would require an acquisition of new test equipment. The purchase price of the equipment is $215,000. It will be depreciated using MACRS 7-year recovery period (use the rates listed in Table 16-2 in the textbook). The management expects the demand for the new test type to only last 6 years, and therefore the project is expected to end in 6 years, and the equipment to be sold for $60,000 at the end of year 6. The company will also need to hire a part-time lab technician, for $30, 000 in the first year of the project, with an annual pay increase of 5% each year after. Equipment maintenance and operating cost is expected to be $4, 000 per year. It is also expected additional supplies will be needed, costing $10,000 per year. The additional revenues from the new test are expected to be $70, 000 in year 1, $80, 000 in year 2, $ 90, 000 in year 3, $100, 000 in year 4, $85, 000 in year 5, and $65, 000 in year 6. Compute the after - tax cash flows for each year of the project. Assume 30% tax rate, and 9% minimum attractive rate of return. Determine whether the company should launch the new testing service, and

Cornerstones of Cost Management (Cornerstones Series)
4th Edition
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Don R. Hansen, Maryanne M. Mowen
Chapter3: Cost Behavior
Section: Chapter Questions
Problem 13E
icon
Related questions
Question

Friendly Tests Inc. is a commercial testing lab, performing a variety of lab tests for hospitals in the area. The management is considering an addition of a new type of test. There is plenty of room in its existing lab facility, but the new test would require an acquisition of new test equipment. The purchase price of the equipment is $215,000. It will be depreciated using MACRS 7-year recovery period (use the rates listed in Table 16-2 in the textbook). The management expects the demand for the new test type to only last 6 years, and therefore the project is expected to end in 6 years, and the equipment to be sold for $60,000 at the end of year 6. The company will also need to hire a part-time lab technician, for $30, 000 in the first year of the project, with an annual pay increase of 5% each year after. Equipment maintenance and operating cost is expected to be $4, 000 per year. It is also expected additional supplies will be needed, costing $10,000 per year. The additional revenues from the new test are expected to be $70, 000 in year 1, $80, 000 in year 2, $ 90, 000 in year 3, $100, 000 in year 4, $85, 000 in year 5, and $65, 000 in year 6. Compute the after - tax cash flows for each year of the project. Assume 30% tax rate, and 9% minimum attractive rate of return. Determine whether the company should launch the new testing service, and explain why. Please include a written

answer. Do this in Excel 

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Fundamentals Of Financial Management, Concise Edi…
Fundamentals Of Financial Management, Concise Edi…
Finance
ISBN:
9781337902571
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning