Create a 5-year Cost Benefit Analysis (CBA) in Excel using the values that follow The yearly value of benefits are estimated at $100.000 each year. The annual expense is estimated to be $25,000 each year. Discount factor and contingency are not being used. Do 3 evaluations in your one CBA One with the initial.development.costs set at $100,000, one at $250,000, and one at $500.000. Explain and describe your findings here. Include payback period and ROi while also explaining how those will impact the project depending on the development cost. Complete this request in MS Excel and submit the original file (not just screenshots) to the link along-side the test

Create a 5-year Cost Benefit Analysis (CBA) in Excel using the values that follow The yearly value of benefits are estimated at $100.000 each year. The annual expense is estimated to be $25,000 each year. Discount factor and contingency are not being used. Do 3 evaluations in your one CBA One with the initial.development.costs set at $100,000, one at $250,000, and one at $500.000. Explain and describe your findings here. Include payback period and ROi while also explaining how those will impact the project depending on the development cost. Complete this request in MS Excel and submit the original file (not just screenshots) to the link along-side the test

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter9: Capital Budgeting And Cash Flow Analysis

Section: Chapter Questions

Problem 19P

See similar textbooks

Similar questions

Gina Ripley, president of Dearing Company, is considering the purchase of a computer-aided manufacturing system. The annual net cash benefits and savings associated with the system are described as follows: The system will cost 9,000,000 and last 10 years. The companys cost of capital is 12 percent. Required: 1. Calculate the payback period for the system. Assume that the company has a policy of only accepting projects with a payback of five years or less. Would the system be acquired? 2. Calculate the NPV and IRR for the project. Should the system be purchasedeven if it does not meet the payback criterion? 3. The project manager reviewed the projected cash flows and pointed out that two items had been missed. First, the system would have a salvage value, net of any tax effects, of 1,000,000 at the end of 10 years. Second, the increased quality and delivery performance would allow the company to increase its market share by 20 percent. This would produce an additional annual net benefit of 300,000. Recalculate the payback period, NPV, and IRR given this new information. (For the IRR computation, initially ignore salvage value.) Does the decision change? Suppose that the salvage value is only half what is projected. Does this make a difference in the outcome? Does salvage value have any real bearing on the companys decision?
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.
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?
A restaurant is considering the purchase of new tables and chairs for their dining room with an initial investment cost of $515,000, and the restaurant expects an annual net cash flow of $103,000 per year. What is the payback period?
Project B cost $5,000 and will generate after-tax net cash inflows of $500 in year one, $1,200 in year two, $2,000 in year three. $2,500 in year four, and $2,000 in year five. What is the NPV using 8% as the discount rate? For further instructions on net present value in Excel, see Appendix C.
Consolidated Aluminum is considering the purchase of a new machine that will cost $308,000 and provide the following cash flows over the next five years: $88,000, 92,000, $91,000, $72,000, and $71,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel, see Appendix C.
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?
Manzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?
Home Garden Inc. is considering the construction of a distribution warehouse in West Virginia to service its east coast stores based on the following estimates: a. Determine the net present value of building the warehouse, assuming a construction cost of 20,000,000, an annual net cost savings of 4,000,000, and a desired rate of return of 14%. Use the present value tables provided in Appendix A. b. Determine the net present value of building the warehouse, assuming a construction cost of 25,000,000, an annual net cost savings of 2,500,000, and a desired rate of return of 14%. Use the present value tables provided in Appendix A. c. Interpret the results of parts (a) and (b).
Project A costs $5,000 and will generate annual after-tax net cash inflows of $1,800 for five years. What is the NPV using 8% as the discount rate?
Falkland, Inc., is considering the purchase of a patent that has a cost of $50,000 and an estimated revenue producing life of 4 years. Falkland has a cost of capital of 8%. The patent is expected to generate the following amounts of annual income and cash flows: A. What is the NPV of the investment? B. What happens if the required rate of return increases?
Buena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?