Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Problem 12-18 Net present value and internal rate of return methods [LO4] The Pa

ID: 2645938 • Letter: P

Question

Problem 12-18 Net present value and internal rate of return methods [LO4]
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? (Do not round intermediate calculations and round your final answer to 2 decimal places.)
  
Net present value   $   
  

b.  
What is the internal rate of return? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.)
  

Internal rate of return   %
  

c.   Should the project be accepted?
      
   
   Yes
   No

Explanation / Answer

IRR = 23.75%

The project having positive NPV and IRR greater than cost of capital should be accepted

year 1 2 3 4 5 cash flows 23000 26000 29000 15000 8000 p.v.f @ 13% 0.885 0.783 0.693 0.613 0.543 Present Value 20353.98 20361.81 20098.45 9199.781 4342.079 Total Present value of cash inflows 74356.11 Cash outflow 60000 NPV 14356.11 Calculation of NPV @ 23.75% year 1 2 3 4 5 cash flows 23000 26000 29000 15000 8000 p.v.f @ 23.75% 0.808 0.653 0.528 0.426 0.345 Present Value 18585.86 16977.86 15302.5 6396.029 2756.538 Total Present value of cash inflows 60018.78 Cash outflow 60000 NPV 18.78437
Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote