Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel step by step The injection molding machines need to be replaced. The list is narrowed down to two options based 011 various

Please use excel step by step

image text in transcribed

The injection molding machines need to be replaced. The list is narrowed down to two options based 011 various parameters like screw diameter, injection pressure, injection capacity, rate, rpm. etc. You are asked to make a recommendation based on the following financial information. The Cincinnati Milacron Plastic Injection Molding Machine costs $80,000 and the Kawaguchi machine costs $120,000. Based 011 the capacity of these machines, it can be safely estimated that the revenue for Cincinnati will be $30,000 for year 1 and $41, 500 for Kawaguchi. It is also assumed that the capacity could be increased and thereby the revenue by 20% every year for the next few years. The maintenance costs for both machines will be $2,000 and the amount will increase by $5,000 every year for the next few years. According to other companies that use similar machines, these machines are capable of producing products for 5 years before major breakdowns occur. Since this is a rough estimate, you can use straight line depreciation over the next five years. The marginal tax rate for this company is 40%. Assuming an after-tax MARR of 15%. calculate the PW of the after-tax cash flow. Perform a sensitivity analysis by changing the after-tax MARR from 10% to 20%

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

Ethics In Finance Case Studies From A Womans Life On Wall Street

Authors: Kara Tan Bhala

1st Edition

3030737535, 978-3030737535

More Books

Students also viewed these Finance questions

Question

What is the one's complement of 11010110?

Answered: 1 week ago