Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I have to summit this problem in excel can you please provide the answers in excel format with formulas. Thank you 12-10 REPLACEMENT ANALYSIS The

I have to summit this problem in excel can you please provide the answers in excel format with formulas. Thank you image text in transcribed
12-10 REPLACEMENT ANALYSIS The Dauten Toy Corporation currently uses an injection mold- ing machine that was purchased 2 years ago. This machine is being depreciated on a straight-line basis, and it has 6 years of remaining life. Its current book value is $2,100, and it can be sold for $2,500 at this time. Thus, the annual depreciation expense is $2,100/6 = $350 per year. If the old machine is not replaced, it can be sold for $500 at the end of its useful life. Dauten is offered a replacement machine which has a cost of $8,000, an estimated useful life of 6 years, and an estimated salvage value of $800. This machine falls into the MACRS 5-year class so the applicable depreciation rates are 20%, 32%, 19%, 12%, 11%, and 6%. The replacement machine would permit an output expansion, so sales would rise by $1,000 per year; even so, the new machine's much greater efficiency would cause operating expenses to decline by $1,500 per year. The new machine would require that inventories be increased by $2,000, but accounts payable would simultaneously increase by $500. Dauten's marginal federal-plus-state tax rate is 40%, and its WACC is 15%. Should it replace the old machine

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered 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

Advanced Accounting

Authors: Paul M. Fischer, William J. Tayler, Rita H. Cheng

11th edition

538480289, 978-0538480284

Students also viewed these Finance questions