Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello Experts- I need help with the following question please!!. All previous answers were incorrect or answered incomplete. Please provide a detailed, clear and step

Hello Experts- I need help with the following question please!!. All previous answers were incorrect or answered incomplete. Please provide a detailed, clear and step by step answer in excel and show formulas if posible. Thank you in advance for your help!

The injection molding machines are need to be replaced. The list is narrowed down to two options based on various parameters like screw diameter, injection pressure, injection capacity, rate, and screw rpm and so on. Please take a look at the specs and make a recommendation. The Cincinnati Milacron Plastic Injection Molding Machine costs $80,000 and the Kawaguchi machine costs $120,000. Based on 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% year after year for the next few years. The maintenance costs will be $2,000 and the amount will increase by $5,000 year after year for the next few years. It can be assumed that the maintenance is the same for both machines. In talking with other companies who use these 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. Tax rate for this company is 40%. Assume an after-tax MARR of 15% and calculate the PW of the after tax cash flow. Also, perform a sensitivity analysis on MARR with plus or minus 5%. (Hint: use DATA TABLE)

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

M Finance

Authors: Marcia Cornett, Troy Adair, John Nofsinger

3rd Edition

0077861779, 978-0077861773

More Books

Students also viewed these Finance questions

Question

Prove that 2n Answered: 1 week ago

Answered: 1 week ago