A computer call center is going to replace all of its incandescent lamps with more energy- efficient fluorescent lighting fixtures. The total energy savings are estimated to be $1,875 per year, and the cost of purchasing and installing the fluorescent fixtures is $4,900. The study period is five years, and terminal market values for the fixtures are negligible. Solve, a. What is the IRR of this investment? b. What is the simple payback period of the investment? c. Is there a conflict in the answers to Parts (a) and (b)?List your assumptions. d. The simple payback "rate of return" is 1/0. How close does this metric come to matching your answer in Part (a)?

A computer call center is going to replace all of its incandescent lamps with more energy- efficient fluorescent lighting fixtures. The total energy savings are estimated to be $1,875 per year, and the cost of purchasing and installing the fluorescent fixtures is $4,900. The study period is five years, and terminal market values for the fixtures are negligible. Solve, a. What is the IRR of this investment? b. What is the simple payback period of the investment? c. Is there a conflict in the answers to Parts (a) and (b)?List your assumptions. d. The simple payback "rate of return" is 1/0. How close does this metric come to matching your answer in Part (a)?

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter26: Capital Budgeting (capbud)

Section: Chapter Questions

Problem 1R

See similar textbooks

Similar questions

A grocery store is considering the purchase of a new refrigeration unit with an Initial Investment of $412,000, and the store expects a return of $100,000 in year one, $72000 in years two and three, $65,000 in years four and five, and $38,000 in year six and beyond, what is the payback period?
If a garden center is considering the purchase of a new tractor with an initial investment cost of $120,000, and the center expects a return of $30,000 in year one, $20,000 in years two and three. $15,000 In years four and five, and $10,000 in year six and beyond, what is the payback period?
Austins cell phone manufacturer wants to upgrade their product mix to encompass an exciting new feature on their cell phone. This would require a new high-tech machine. You are excited about his new project and are recommending the purchase to your board of directors. Here is the information you have compiled in order to complete this recommendation: According to the information, the project will last 10 years and require an initial investment of $800,000, depreciated with straight-line over the life of the project until the final value is zero. The firms tax rate is 30% and the required rate of return is 12%. You believe that the variable cost and sales volume may be as much as 10% higher or lower than the initial estimate. Your boss understands the risks but asks you to explain the alternatives in a brief memo to the board, Write a memo to the Board of Directors objectively weighing out the pros and cons of this project and make your recommendation(s).
If a copy center is considering the purchase of a new copy machine with an initial investment cost of $150,000 and the center expects an annual net cash flow of $20,000 per year, what is the payback period?
A mini-mart needs a new freezer and the initial Investment will cost $300,000. Incremental revenues, including cost savings, are $200,000, and incremental expenses, including depreciation, are $125,000. There is no salvage value. What is the accounting rate of return (ARR)?
Caduceus Company is considering the purchase of a new piece of factory equipment that will cost $565,000 and will generate $135,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return In Excel, see Appendix C.
Friedman Company is considering installing a new IT system. The cost of the new system is estimated to be 2,250,000, but it would produce after-tax savings of 450,000 per year in labor costs. The estimated life of the new system is 10 years, with no salvage value expected. Intrigued by the possibility of saving 450,000 per year and having a more reliable information system, the president of Friedman has asked for an analysis of the projects economic viability. All capital projects are required to earn at least the firms cost of capital, which is 12 percent. Required: 1. Calculate the projects internal rate of return. Should the company acquire the new IT system? 2. Suppose that savings are less than claimed. Calculate the minimum annual cash savings that must be realized for the project to earn a rate equal to the firms cost of capital. Comment on the safety margin that exists, if any. 3. Suppose that the life of the IT system is overestimated by two years. Repeat Requirements 1 and 2 under this assumption. Comment on the usefulness of this information.
The Ham and Egg Restaurant is considering an investment in a new oven that has a cost of $60,000, with annual net cash flows of $9,950 for 8 years. The required rate of return is 6%. Compute the net present value of this investment to determine whether or not you would recommend that Ham and Egg invest in this oven.
Covington Pharmacies has decided to automate its insurance claims process. Two networked computer systems are being considered. The systems have an expected life of two years. The net cash flows associated with the systems are as follows. The cash benefits represent the savings created by switching from a manual to an automated system. The companys cost of capital is 10 percent. Required: 1. Compute the NPV and the IRR for each investment. 2. Show that the project with the larger NPV is the correct choice for the company.
Shonda & Shonda is a company that does land surveys and engineering consulting. They have an opportunity to purchase new computer equipment that will allow them to render their drawings and surveys much more quickly. The new equipment will cost them an additional $1.200 per month, but they will be able to increase their sales by 10% per year. Their current annual cost and break-even figures are as follows: A. What will be the impact on the break-even point if Shonda & Shonda purchases the new computer? B. What will be the impact on net operating income if Shonda & Shonda purchases the new computer? C. What would be your recommendation to Shonda & Shonda regarding this purchase?
Gardner Denver Company is considering the purchase of a new piece of factory equipment that will cost $420,000 and will generate $95,000 per year for 5 years. Calculate the IRR for this piece of equipment. For further Instructions on internal rate of return in Excel, see Appendix C.
Den-Tex Company is evaluating a proposal to replace its HID (high intensity discharge) lighting with LED (light emitting diode) lighting throughout its warehouse. LED lighting consumes less power and lasts longer than HID lighting for similar performance. The following information was developed: a. Determine the investment cost for replacing the 700 fixtures. b. Determine the annual utility cost savings from employing the new energy solution. c. Should the proposal be accepted? Evaluate the proposal using net present value, assuming a 15-year life and 8% minimum rate of return. (Present value factors are available in Appendix A.)