Question

The final tally is in: This year’s operating costs were down $100,000, a decrease directly attributable...

The final tally is in: This year’s operating costs were down $100,000, a decrease directly attributable to the $520,000 investment in the automated materials handling system put in place at the beginning of the year. If this level of annual savings continues for five more years, resulting in six total years of annual savings, what compounded annual rate of return will that represent? If these annual savings continue for nine more years, what compounded annual rate of return will that represent? (You may ignore income taxes.)

Homework Answers

Answer #1

We can use IRR to calculate the rate:

$ -5,20,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
IRR 4.25%

Excel formula: =IRR(A1:A7) where A1 to A7 are the cash flows with A1 being -520,000

Similarily in second case:

$ -5,20,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
$   1,00,000.00
IRR 14.08%

Excel formula: =IRR(A1:A10) where A1 to A7 are the cash flows with A1 being -520,000

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
The aged but cenrally located golf course you manage does not have a in-ground automated water...
The aged but cenrally located golf course you manage does not have a in-ground automated water sprinkling system. Instead, to properly water the course, sprinklers and hoses must be repeatedly set, moved, and put away by some of the grounds crew a tedious and laborious task. If over the next 12 years, you project annual savings of about $40,000 from having an automated system, what is the maximum price you would be willing to pay today for an installed, automated...
EnterTech has noticed a significant decrease in the profitability of its line of portable CD players....
EnterTech has noticed a significant decrease in the profitability of its line of portable CD players. The production manager believes that the source of the trouble is old, inefficient equipment used to manufacture the product. The issue raised, therefore, is whether EnterTech should (1) buy new equipment at a cost of $120,000 or (2) continue using its present equipment. It is unlikely that demand for these portable CD players will extend beyond a five-year time horizon. EnterTech estimates that both...
EnterTech has noticed a significant decrease in the profitability of its line of portable CD players....
EnterTech has noticed a significant decrease in the profitability of its line of portable CD players. The production manager believes that the source of the trouble is old, inefficient equipment used to manufacture the product. The issue raised, therefore, is whether EnterTech should (1) buy new equipment at a cost of $120,000 or (2) continue using its present equipment. It is unlikely that demand for these portable CD players will extend beyond a five-year time horizon. EnterTech estimates that both...
EnterTech has noticed a significant decrease in the profitability of its line of portable CD players....
EnterTech has noticed a significant decrease in the profitability of its line of portable CD players. The production manager believes that the source of the trouble is old, inefficient equipment used to manufacture the product. The issue raised, therefore, is whether EnterTech should (1) buy new equipment at a cost of $120,000 or (2) continue using its present equipment. It is unlikely that demand for these portable CD players will extend beyond a five-year time horizon. EnterTech estimates that both...
In December 2006, Bob Prescott, the controller for the Blue Ridge Mill, was considering the addition...
In December 2006, Bob Prescott, the controller for the Blue Ridge Mill, was considering the addition of a new on-site longwood woodyard. The addition would have two primary benefits: to eliminate the need to purchase shortwood from an outside supplier and create the opportunity to sell shortwood on the open market as a new market for Worldwide Paper Company (WPC). The new woodyard would allow the Blue Ridge Mill not only to reduce its operating costs but also to increase...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater...
Asia’s e-commerce landscape has been booming in recent years. The swift adoption of smartphones and greater access to the internet has allowed consumers in the region to be a major force in the global digital economy. The expansion looks set to continue at a rapid pace. According to a November 2018 report by Fitch Solutions, e-commerce sales in the region are forecast to increase by 14.2% this year, with an estimated average annual increase of 14% over the medium term...
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...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From...
Sign In INNOVATION Deep Change: How Operational Innovation Can Transform Your Company by Michael Hammer From the April 2004 Issue Save Share 8.95 In 1991, Progressive Insurance, an automobile insurer based in Mayfield Village, Ohio, had approximately $1.3 billion in sales. By 2002, that figure had grown to $9.5 billion. What fashionable strategies did Progressive employ to achieve sevenfold growth in just over a decade? Was it positioned in a high-growth industry? Hardly. Auto insurance is a mature, 100-year-old industry...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT