Use excel to solve The Pan American Bottling Co. is considering the purchase of anew machine that would increase the speed of bottling and savemoney. The net cost of this machine is $45,000. The annual cashflows have the following projections.Year Cash Flow1 $15,0002 20,0003 25,0004 10,00055,0006. What is the net present value of selecting the new machine,assuming cost of capital of 10%?a. $11,883b. $13,883c. $15,883d. $17,8837. What is the internal rate of return?a. About 7%b. About 10%c. About 23%d. About 27%

Net Present Value is the difference between present value of cash inflow and present value of cash…

Answered: What is the net present value of…

Business

Finance

What is the net present value of selecting the new machine

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter11: Capital Budgeting Decisions

Section: Chapter Questions

Problem 18EB: Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the...

See similar textbooks

Similar questions

Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?
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?
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?
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?
Garnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.
Jasmine Manufacturing is considering a project that will require an initial investment of $52,000 and is expected to generate future cash flows of $10,000 for years 1 through 3, $8,000 for years 4 and 5, and $2,000 for years 6 through 10. What is the payback period for this project?
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.
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?
Redbird Company is considering a project with an initial investment of $265,000 in new equipment that will yield annual net cash flows of $45,800 each year over its seven-year life. The companys minimum required rate of return is 8%. What is the internal rate of return? Should Redbird accept the project based on IRR?
The Ulmer Uranium Company is deciding whether or not to open a strip mine whose net cost is $4.4 million. Net cash inflows are expected to be $27.7 million, all coming at the end of Year 1. The land must be returned to its natural state at a cost of $25 million, payable at the end of Year 2. Plot the project’s NPV profile. Should the project be accepted if r = 8%? If r = 14%? Explain your reasoning. Can you think of some other capital budgeting situations in which negative cash flows during or at the end of the project’s life might lead to multiple IRRs? What is the project’s MIRR at r = 8%? At r = 14%? Does the MIRR method lead to the same accept-reject decision as the NPV method?
A company that manufactures magnetic flow meters expects to undertake a project that will have the cash flows below. At an interest rate of 10% per year, what is the equivalent annual cost of the project? Find the AW value using (a) tabulated factors, (b) calculator functions, and (c) a spreadsheet. Which method did you find the easiest to use?
The Pan American Bottling Company is considering the purchase of a new machine that would increase the speed of bottling and save money. The net cost of this machine is $72,000. The annual cash flows have the following projections. Use Appendix B and Appendix D for an approximate answer but calculate your final answer using the formula and financial calculator methods. Year Cash Flow 1 $ 35,000 2 38,000 3 35,000 4 28,000 5 12,000 If the cost of capital is 12 percent, what is the net present value of selecting a new machine? Note: Do not round intermediate calculations and round your final answer to 2 decimal places. What is the internal rate of return? Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. Should the project be accepted? multiple choice Yes No