A company is evaluating the purchase of a machine to improve product quality and output levels. The new machine would cost $1.6 million and would be depreciated for tax purposes using the straight-line method over an estimated six-year life to its expected salvage value of $100,000. The new machine would require an addition of $70,000 to working capital at the beginning of the project, which will of course be returned to the firm at the end of the project. In each year of the machine's life, the machine would increase the company's pre-tax cash receipts by $400,000. During each of the six years, additional cash operating costs would increase by $15,000. In addition, at the end of the 4th year, a major repair of the machine costing $40,000 (pre-tax) would be required. The company has a 8% overall cost of capital and is in the 35% marginal tax bracket.
Create an Excel spreadsheet to organize your answers to the following problem.
Part 1: Prepare a Cash Flow Spreadsheet that identifies the incremental cash flows for each year of the machine's life.
Part 2: Calculate the investment's net present value (NPV).
Part 3: Calculate the investment's internal rate of return (IRR).
Part 4: Should the company purchase the machine? Why or why not?
Please find the solution in given screen shots,
Amount in $
A company is evaluating the purchase of a machine to improve product quality and output levels....
A company is evaluating the purchase of Machine A. The new machine would cost $120,000 and would be depreciated for tax purposes using the straight-line method over an estimated ten-year life to its expected salvage value of $20,000. The new machine would require an addition of $30,000 to working capital. In each year of Machine A’s life, the company would reduce its pre-tax costs by $40,000. The company has a 12% cost of capital and is in the 35% marginal...
17) Delta Inc. is considering the purchase of a new machine which is expected to increase sales by $10,000 in addition to increasing cash expenses by $3,000 annually. Due to the sales increase, Delta will need to increase working capital by $2,000 at the beginning of the project. This working capital investment will not be recouped in the final year of the project. Delta will depreciate the machine using the straight-line method over the project's five-year life to a salvage...
Wendell's Donut Shoppe is investigating the purchase of a new $34,600 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $6,200 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 2,200 dozen more donuts each year. The company realizes a contribution margin of $2.00 per dozen donuts sold. The new machine would have...
Wendell's Donut Shoppe is investigating the purchase of a new $37,700 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $6,600 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 1,500 dozen more donuts each year. The company realizes a contribution margin of $2.00 per dozen donuts sold. The new machine would have...
Wendell's Donut Shoppe is investigating the purchase of a new $33,000 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $5,700 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 1,100 dozen more donuts each year. The company realizes a contribution margin of $2.60 per dozen donuts sold. The new machine would have...
Wendell's Donut Shoppe is investigating the purchase of a new $33,700 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $5,500 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 2,200 dozen more donuts each year. The company realizes a contribution margin of $2.00 per dozen donuts sold. The new machine would have...
Wendell's Donut Shoppe is investigating the purchase of a new $18,600 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $3,800 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 1,000 dozen more donuts each year. The company realizes a contribution margin of $1.20 per dozen donuts sold. The new machine would have...
(Ignore income taxes in this problem.) Allen Company's required rate of return is 14%. The company is considering the purchase of a new machine that will save $10,000 per year in cash operating costs. The machine will cost $40,000 and will have an 8-year useful life with zero salvage value.Required:i) Compute the machine's internal rate of return to the nearest whole percent. Would you recommend purchase of the machine? Explain.ii) The company would like to use NPV to evaluate the project...
Wendell’s Donut Shoppe is investigating the purchase of a new $48,300 donut-making machine. The new machine would permit the company to reduce the amount of part-time help needed, at a cost savings of $6,800 per year. In addition, the new machine would allow the company to produce one new style of donut, resulting in the sale of 1,700 dozen more donuts each year. The company realizes a contribution margin of $2.00 per dozen donuts sold. The new machine would have...
3. CK Company uses the machine for cleaning the furniture. The current machine has purchased since the three years ago. The initial cost is $300,000. The machine has the useful life 5 years since the date of purchases. The residual value is $50,000. The Current machine can generate the cash revenue per year is $100,000 and cash operating costs is $60,000 per year. If the company continues to keep or use the current machine, it will have the repairing expense...