The Pan American Bottling Co. 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 $60,000. The annual cash flows have the following projections: Year 1 ........... 2 ........... 3 ........... 4 ........... 5 ........... Cash Flow $23,000 26,000 29,000 15,000 8,000 a. If the cost of capital is 13 percent, what is the net present value of selecting a new machine? I need to see the work. I can't use Excel to solve the problem. Excel doesn't help me solve Part a.

The Pan American Bottling Co. 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 $60,000. The annual cash flows have the following projections: Year 1 ........... 2 ........... 3 ........... 4 ........... 5 ........... Cash Flow $23,000 26,000 29,000 15,000 8,000 a. If the cost of capital is 13 percent, what is the net present value of selecting a new machine? I need to see the work. I can't use Excel to solve the problem. Excel doesn't help me solve Part a.

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

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.
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)?
Toy World Products is considering producing toy action figures and sandbox toys. The products require different specialized machines, each costing $1.1 million. Each machine has a five-year life and zero residual value. The two products have different patterns of predicted net cash inflows. Annual Net Cash Inflows Year Toy action figure project Sandbox toy project Year 1. . . . . . . . . . . $327,000 $500,000 Year 2. . . . . . . . . . . 327,000 350,000 Year 3. . . . . . . . . . . 327,000 300,000 Year 4. . . . . . . . . . . 327,000 275,000 Year 5. . . . . . . . . . . 327,000 40,000 Total $1,635,000 $1,465,000 Toy World will consider making capital investments only if the payback period of the project is less than 3.5 years and the ARR exceeds 8%. Calculate the toy action figure project's ARR. If the toy action figure project had a residual value of $200,000, would the ARR change? Explain and recalculate if…
The Pan American Bottling Co. 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 $60,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 $ 23,000 2 26,000 3 29,000 4 15,000 5 8,000 a. If the cost of capital is 13 percent, what is the net present value of selecting a new machine? b. What is the internal rate of return?
A machine costs $25,000; it is expected to generate annual cash revenues of $8,000 and annual cash expenses of $2,000 for five years. The required rate of return is 12%. The net present value of the machine is: Select one: a. $(3,840). b. $(3,370). c. $0. d. $21,630. e. $28,840.
LLL Products is considering producing toy action figures and sandbox toys. The products require different specialized machines, each costing $1 million. Each machine has a five-year life and zero residual value. The two products have different patterns of predicted net cash inflows: Annual Net Cash Inflows Year Toy action figure project Sandbox toy project Year 1. . . . . . . . . . . $428,750 $520,000 Year 2. . . . . . . . . . . 428,750 390,000 Year 3. . . . . . . . . . . 428,750 300,000 Year 4. . . . . . . . . . . 428,750 280,000 Year 5. . . . . . . . . . . 428,750 50,000 Total $2,143,750 $1,540,000 LLL will consider making capital investments only if the payback period of the project is less than 3.5 years and the ARR exceeds 8%. Calculate the sandbox toy project's payback period. If the sandbox toy project had a residual value of $225,000, would the payback period change? Explain and recalculate if…
First Choice Carpets is considering purchasing new weaving equipment costing $730,000. The company's management has estimated that the equipment will generate cash inflows as follows: Year 1 $204,000 2 $204,000 3 $266,000 4 $266,000 5 $150,000 Considering the residual value is zero, calculate the payback period. (Round your answer to two decimal places.) A. 3.70 years B. 4.61 years C. 3.42 years D. 3.21 years
Dock Company is considering a capital investment in machinery: E (Click the icon to view the data.) 8. Calculate the payback. 9. Calculate the ARR. Round the percentage to two decimal places. 10. Based on your answers to the above questions, should Dock invest in the machinery? 8. Calculate the payback. Payback years - X Data Table Initial investment $ 1,500,000 Residual value 350,000 Expected annual net cash inflows 500,000 Expected useful life 4 years Required rate of return 9% Print Done
Alter company's manager has proposed installing an equipment that will cost $36,000, have a 8-year life, and have no salvage value. The company estimates that the machine could produce 4000 units which can be sold evenly throughout the year. The expected income through the life of machinery is $16,000. The machine will generate net cash flows per year of $8,000. Calculate the average rate of return on the investment. a. 44.44% b. 22.22% с. 33.33% d. 11.11%
Tyler, Inc., is considering switching to a new production technology. The cost of the required equipment will be $3,727,533 . The discount rate is 12.86 percent. The cash flows that the firm expects the new technology to generate are as follows. Years CF 0 $(3,727,533) 1–2 0 3–5 $874,667 6–9 $1,546,005 a. Compute the payback and discounted payback periods for the project. b. What is the NPV for the project? Should the firm go ahead with the project? c. What is the IRR, and what would be the decision based on the IRR?
The Ohm Depot Co. is currently considering the purchase of a newmachine that would increase the speed of manufacturing electronic equipmentand save money. The net cost of the new machine is $66,000. Theannual cash flows have the following projections:Year Amount ($)0 (66,000)1 21,0002 29,0003 36,0004 16,0005 8,000If the cost of capital is 10 percent, find the following:a. The PVBb. The NPVc. The IRRd. Paybacke. PI
Ivanhoe Industries management is planning to replace some existing machinery in its plant. The cost of the new equipment and the resulting cash flows are shown in the accompanying table. The firm uses an 18 percent discount rate for projects like this. Should management go ahead with the project? Year Cash Flow 0 -$3,046,900 1 803,710 2 889,200 3 1,247,600 4 1,285,160 5 1,576,500 What is the NPV of this project? - NPV $?