Purchase new equipment or maintain the current equipment

Assignment Help Financial Management

Reference no: EM132058922

The Managerial Accounting Department at your company has been engaged by the Production Department for assistance in evaluating a purchase decision. The equipment the production department is currently utilizing is outdated and has become costly to maintain. New machines would also provide increased efficiencies leading to increased sales. Due to this, the department is considering replacing all equipment with new machines.

Data:

- Cost of Current Machines: $800,000

- Cost of New Machines: $1,250,000

- Annual Maintenance on Current Machines: $125,000

- Annual Maintenance on New Machines: $54,000

- Salvage Value of Current Machines: $325,000

- Immediate employee training cost on new machines: $15,000 - Working Capital needed for new machines: $50,000

- Would be needed once machines are purchased and working capital released after 5 years

- Increased sales opportunity provided by new machines: $200,000 first year and growing at 5% per year after

- Company’s Required Rate of Return: 10%

- Contribution margin: 47%

- Depreciation and income taxes should be ignored.

Given the financial information listed above, provide the following :

- An Excel worksheet showing the annual cash flows by line-item and in total for the keep vs. purchase decision, for 8 years.

Calculate the NPV in excel

Should the Department purchase new equipment or maintain the current equipment?

Reference no: EM132058922

Questions Cloud

Determine the amount of cash hult paid for rent : Additional data for the current year are as follows: Sales of 2014 were $950,000. Determine the amount of cash HULT paid for rent during 2014

Find the probability that among the first 4 songs : Find the probability that among the first 4 songs played you like two of them.

What is the probability that the shipment is rejected : If 1 or more components is defective, the shipment is rejected. What is the probability that the shipment is rejected?

What is the probability that exactly 2 of them are girls : Each child born to a set of parents has a probability of .5 of being male or female. A particular set of parents wishes to have all boys.

Purchase new equipment or maintain the current equipment : Should the Department purchase new equipment or maintain the current equipment?

Probability of selecting a jury of at least one student : What is the probability of selecting a jury of at least one student?

Organize a program to address needs for development : Develop a six-to-eight-page document in Word format detailing how you would approach and organize a program to address needs for development.

Three democrats and four republicans : What id the probability that a committee is composed of three democrats and four republicans?

Evaluation of the effectiveness of workforce planning : Evaluation of the effectiveness of workforce planning and change processes against objectives and targets. Use information from Appendix 1.

User Account

All Pages