Question

A manufacturing company is considering switching to an advanced robotics system that will reduce the labor...

A manufacturing company is considering switching to an advanced robotics system that will reduce the labor cost in a given factory. The initial cost is $175,000 with annual costs of $45,000 and savings of $75,000 in the first year. Savings are projected to increase by $2500 annually after Year 1. The salvage value 10 years from now is projected to be $25,000. What rate of return will the factory make on this investment?

Round your answer to the nearest tenth of a percent (without the percent sign).  

PLEASE USE EXCEL TO SOLVE AND SHOW EXCEL FORMULAS

Homework Answers

Answer #1

Using the formula IRR in excel we find that the rate of return is 18.07%. The table is provided below

Eoy One time cash flow Periodic cash outflow Periodic cash inflow Final net cash flow
0 -175000 -175000
1 -45000 75000 30000
2 -45000 77500 32500
3 -45000 80000 35000
4 -45000 82500 37500
5 -45000 85000 40000
6 -45000 87500 42500
7 -45000 90000 45000
8 -45000 92500 47500
9 -45000 95000 50000
10 25000 -45000 97500 77500
Rate of return is 18.07%

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Square Manufacturing is considering investing in a robotics manufacturing line. Installation of the line will cost...
Square Manufacturing is considering investing in a robotics manufacturing line. Installation of the line will cost an estimated $9.8 million. This amount must be paid immediately even though construction will take three years to complete (years 0, 1, and 2). Year 3 will be spent testing the production line and, hence, it will not yield any positive cash flows. If the operation is very successful, the company can expect after-tax cash savings of $6.8 million per year in each of...
Holmes Manufacturing is considering a new machine that costs $240,000 and would reduce pretax manufacturing costs...
Holmes Manufacturing is considering a new machine that costs $240,000 and would reduce pretax manufacturing costs by $90,000 annually. Holmes would use the 3-year MACRS method to depreciate the machine, and management thinks the machine would have a value of $25,000 at the end of its 5-year operating life. The applicable depreciation rates are 33%, 45%, 15%, and 7%. Net operating working capital would increase by $22,000 initially, but it would be recovered at the end of the project's 5-year...
Rooney Manufacturing Company has an opportunity to purchase some technologically advanced equipment that will reduce the...
Rooney Manufacturing Company has an opportunity to purchase some technologically advanced equipment that will reduce the company’s cash outflow for operating expenses by $1,288,000 per year. The cost of the equipment is $7,417,622.91. Rooney expects it to have a 9-year useful life and a zero salvage value. The company has established an investment opportunity hurdle rate of 15 percent and uses the straight-line method for depreciation. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)...
Zachary Manufacturing Company has an opportunity to purchase some technologically advanced equipment that will reduce the...
Zachary Manufacturing Company has an opportunity to purchase some technologically advanced equipment that will reduce the company’s cash outflow for operating expenses by $1,287,000 per year. The cost of the equipment is $9,187,846.67. Zachary expects it to have a 11-year useful life and a zero salvage value. The company has established an investment opportunity hurdle rate of 15 percent and uses the straight-line method for depreciation. (PV of $1 and PVA of $1) (Use appropriate factor(s) from the tables provided.)...
American Company is considering a new product whose data are shown below. The equipment to be...
American Company is considering a new product whose data are shown below. The equipment to be used would be depreciated by the straight-line method over its 3-year life and would have a zero-salvage value, and no change in net operating working capital would be required. Revenues and other operating costs are expected to be constant over the project's 3-year life. However, this project would compete with other American products and would reduce their pre-tax annual cash flows. What is the...
Cranberry Manufacturing Company is considering an asset replacement project of replacing a control device. This old...
Cranberry Manufacturing Company is considering an asset replacement project of replacing a control device. This old control device has been fully depreciated but can be sold for $4,000. The new control device, which is more automated, will cost $34,000. The new device’s installation and shipping costs will total $14,000. The new device will be depreciated on a straight-line basis over its 2-year economic life to an estimated salvage value of $0. The actual salvage value of this device at the...
A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of...
A company is considering replacement of manufacturing equipment with computer controlled equipment, at a cost of $500,000, replacing equipment with a scrap value of $50,000. This will reduce defect costs by $150,000 a year. At the end of 7 years, the equipment will be replaced and will have a scrap value of $100,000. The interest charges for financing the purchase will be $25,000 a year. The new system will be housed in a building that is currently unused, with an...
Orange County Chrome Company manufactures three chrome-plated products—automobile bumpers, valve covers, and wheels. These products are...
Orange County Chrome Company manufactures three chrome-plated products—automobile bumpers, valve covers, and wheels. These products are manufactured in two production departments (Stamping and Plating). The factory overhead for Orange County Chrome is $213,389. The three products consume both machine hours and direct labor hours in the two production departments as follows: Direct Labor Hours Machine Hours Stamping Department Automobile bumpers 558 803 Valve covers 295 557 Wheels 340 597 1,193 1,957 Plating Department Automobile bumpers 171 1,166 Valve covers 175...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...