Question
GoodEats, a chain of diner restaurants, is considering the purchase of new Garland brand energy efficient refrigerators for all of its 60 restaurants. These new
GoodEats, a chain of diner restaurants, is considering the purchase of new Garland brand energy efficient refrigerators for all of its 60 restaurants. These new refrigerators will cost $15,000 each and will have useful lives of five years before they will need to be replaced. Installation of the total set of 60 refrigerators will cost $100,000. The net cost saving is expected to peak in the first year at $200,000 and subsequently decline at a rate of 12% each year. At the end of their usage lifecycle, the salvage value of these refrigerators is likely to be 5% of their total purchase price.
What is the payback period?
In addition, to the option of purchasing the Garland brand energy efficient refrigerators; the company is also considering some less expensive models from Bolger Appliances. The Bolger units will cost only $6000 each and it will cost the same ($100,000) to install all 60 refrigerators. The refrigerators will have a useful life of only four years and will produce net cost savings of $120,000 per year because they are not as energy efficient. There is no salvage value associated with these refrigerators. Based on a careful analysis, the company sets a discount rate at 10%. Calculate the NPV for both projects? What model of refrigerators should the company purchase?
Please show work/formulas in excel
Thank you
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started