Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Triton Metals is considering an expansion of its existing operations, which would require a purchase of a new machine, MACHINE A. While the life of
Triton Metals is considering an expansion of its existing operations, which would require a purchase of a new machine, MACHINE A. While the life of the expansion is indefinite, the machine has a useful life of 5 years and is expected to be replaced every 5 years with a new one of the same type. The incremental net cash flows from the expansion are listed in the table below. Assume 12% cost of capital. Please include written answers to all parts of the problem in a text box at the bottom of your Excel sheet. Year Cash Flow 0 -60,000 1 15,000 20,000 20,000 20,000 5 10,000 a) Use the present worth method to determine whether the expansion should be undertaken or not. Use the NPV function. Explain why you determined to accept/reject the expansion. b) Use the annual worth method to determine whether the expansion should be undertaken. Use the PMT function. Again, explain your answer. c) Use the internal rate of return method to determine whether the expansion should be undertaken. Use the IRR function. Again, explain your answer. d) Assume that an alternative machine model becomes available, MACHINE B, with the incremental net cash flows given below. Its useful life is 6 years, and it would be replaced every 6 years with a new machine of the same type, if purchased for the expansion project. Use the equivalent annual worth method to determine which of the two available machines should be selected for the project. Do not worry about accepting or rejecting the expansion itself, your task is only to determine which of the two machines should be used. Explain your answer. Cash Flow 0 -75,000 1 10,000 15,000 20,000 4 25,000 25,000 20,000 6
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started