Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please show me this in excel with the formulas! Prepare a professional Excel spreadsheet using the following information: A company is considering replacing a manual

image text in transcribed
please show me this in excel with the formulas!
Prepare a professional Excel spreadsheet using the following information: A company is considering replacing a manual production process with a machine. The manual process requires three relatively unskilled workers and a supervisor. Each of the three unskilled workers makes $17,500 a year and the supervisor earns $24,500. The new machine can be operated with only one skilled operator who will earn $41,000. Payroll taxes and employee benefits are an additional one-third of all wages and salaries. The machine costs $150,000 to buy and $10,000 to install. It will be depreciated on a straight line basis for five years. The project life is 6 years and the machine is expected to have a zero salvage value by the end of the project. A service contract covers all maintenance of the proposed new machine for $5,000 a year. The machine's output will be virtually indistinguishable from that of the manual process in both quality and quantity. There are no other operating differences between the manual and machine processes. The company's cost of capital is 10.53%. The corporate tax rate is 40%. Using the IRR and NPV criteria should you accept the project? NOTE: All calculations must be completed within Excel, using cell references

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

International Financial Management

Authors: Geert Bekaert, Robert J. Hodrick

4th International Edition

013284298X, 9780132842983

More Books

Students also viewed these Finance questions

Question

Discuss how S. Truett Cathys values shaped Chick-fil-As operation.

Answered: 1 week ago