DeYoung Entertainment Enterprises is considering replacing the latex molding machine it uses to fabricate rubber chickens with a newer, more efficient model. The old machine has a book value of $450,000 and a remaining useful life of 5 years. The current machine would be worn out and worthless in 5 years, but DeYoung can sell it now to a Halloween mask manufacturer for $135,000. The old machine is being depreciated by $90,000 per year for each year of its remaining life. If DeYoung doesn't replace the old machine, it will have no salvage value at the end of its useful life. The new machine has a purchase price of $775,000, an estimated useful life and MACRS class life of 5 years, and an estimated salvage value of $105,000. The applicable depreciation rates are 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. Being highly efficient, it is expected to economize on electric power usage, labor, and repair costs, and, most importantly, to reduce the number of defective chickens. In total, an annual savings of $185,000 will be realized if the new machine is installed. The company's mar­ginal tax rate is 25%, and the project cost of capital is 12%.   What is the after-tax salvage value at Year 5? What are the total incremental project cash flows in Years 0 through 5? What is the NPV?

Financial Management: Theory & Practice
16th Edition
ISBN:9781337909730
Author:Brigham
Publisher:Brigham
Chapter11: Cash Flow Estimation And Risk Analysis
Section: Chapter Questions
Problem 10P: St. Johns River Shipyards welding machine is 15 years old, fully depreciated, and has no salvage...
icon
Related questions
Question

DeYoung Entertainment Enterprises is considering replacing the latex molding machine it uses to fabricate rubber chickens with a newer, more efficient model. The old machine has a book value of $450,000 and a remaining useful life of 5 years. The current machine would be worn out and worthless in 5 years, but DeYoung can sell it now to a Halloween mask manufacturer for $135,000. The old machine is being depreciated by $90,000 per year for each year of its remaining life. If DeYoung doesn't replace the old machine, it will have no salvage value at the end of its useful life.

The new machine has a purchase price of $775,000, an estimated useful life and

MACRS class life of 5 years, and an estimated salvage value of $105,000. The applicable depreciation rates are 20.00%, 32.00%, 19.20%, 11.52%, 11.52%, and 5.76%. Being highly efficient, it is expected to economize on electric power usage, labor, and repair costs, and, most importantly, to reduce the number of defective chickens. In total, an annual savings of $185,000 will be realized if the new machine is installed. The company's mar­ginal tax rate is 25%, and the project cost of capital is 12%.

 

  1. What is the after-tax salvage value at Year 5?
  2. What are the total incremental project cash flows in Years 0 through 5?
  3. What is the NPV?

How do you approach the math to get the solutions in excel?  Please show formulas

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 4 images

Blurred answer
Knowledge Booster
Capital Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
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
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