Question: 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

Please use excel step by step The injection molding machines need to

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!