17. One year ago, your company purchased a machine used in manufacturing for $110,000. You have learned that a new machine is available that offers many advantages and you can purchase it for $150,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin (revenues minus operating expenses other than depreciation) of $40,000 per year for the next 10 years. The current machine is expected to produce a gross margin of $20,000 per year. The current machine is being depreciated on a straight- line basis over a useful life of 11 years, and has no salvage value, so depreciation expense for the current machine is $10,000 per year. The market value today of the current machine is $50,000. Your company's tax rate is 25%, and the opportunity cost of capital for this type of equipment is 10%. Should your company replace its year-old machine? Excel

EBK CFIN
6th Edition
ISBN:9781337671743
Author:BESLEY
Publisher:BESLEY
Chapter10: Project Cash Flows And Risk
Section: Chapter Questions
Problem 13PROB
icon
Related questions
Question

please use excel and show work

17.
One year ago, your company purchased a machine used in manufacturing for $110,000. You
have learned that a new machine is available that offers many advantages and you can purchase it for
$150,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value.
You expect that the new machine will produce a gross margin (revenues minus operating expenses
other than depreciation) of $40,000 per year for the next 10 years. The current machine is expected to
produce a gross margin of $20,000 per year. The current machine is being depreciated on a straight-
line basis over a useful life of 11 years, and has no salvage value, so depreciation expense for the
current machine is $10,000 per year. The market value today of the current machine is $50,000. Your
company's tax rate is 25%, and the opportunity cost of capital for this type of equipment is 10%.
Should your company replace its year-old machine?
Excel
Transcribed Image Text:17. One year ago, your company purchased a machine used in manufacturing for $110,000. You have learned that a new machine is available that offers many advantages and you can purchase it for $150,000 today. It will be depreciated on a straight-line basis over 10 years and has no salvage value. You expect that the new machine will produce a gross margin (revenues minus operating expenses other than depreciation) of $40,000 per year for the next 10 years. The current machine is expected to produce a gross margin of $20,000 per year. The current machine is being depreciated on a straight- line basis over a useful life of 11 years, and has no salvage value, so depreciation expense for the current machine is $10,000 per year. The market value today of the current machine is $50,000. Your company's tax rate is 25%, and the opportunity cost of capital for this type of equipment is 10%. Should your company replace its year-old machine? Excel
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
Recommended textbooks for you
EBK CFIN
EBK CFIN
Finance
ISBN:
9781337671743
Author:
BESLEY
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Financial Management: Theory & Practice
Financial Management: Theory & Practice
Finance
ISBN:
9781337909730
Author:
Brigham
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
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
EBK CONTEMPORARY FINANCIAL MANAGEMENT
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:
9781337514835
Author:
MOYER
Publisher:
CENGAGE LEARNING - CONSIGNMENT
Corporate Fin Focused Approach
Corporate Fin Focused Approach
Finance
ISBN:
9781285660516
Author:
EHRHARDT
Publisher:
Cengage