Reference no: EM132940787
The High Flier Corporation is a shuttle service that provides transportation from Provo, Utah to the Salt Lake City Airport. Currently the company uses one van that can transport up to six people at a time. The owner of the business is considering the purchase of a bigger van that could transport more people and would also have more room for luggage and ski equipment. He has determined that he can invest $135,000 in a used van that would last about three years, or he could invest in new van that would provide a useful life of five years. The used van is larger than the existing van and the new van, but would not last as long as the new van. The new van would result in $230K in cash flows over 5 years, while the used van would result in $185K in cash flows over 3 years. Use a discount rate of 9%.
Assume the following information for High Flier Corporation: A $135,000 investment yields the following inflows of cash:
Year 1 Investment A 70000 Investment B 28000
Year 2 Investment A 70000 Investment B 32000
Year 3 Investment A 45000 Investment B 45000
Year 4 Investment A Investment B 55000
Year 5 Investment A Investment B 70000
Using the information above, do the following
Problem 1. Calculate the payback.
Problem 2. Calculate the NPV using Excel or a Financial Calculator.
Problem 3. Calculate the IRR using Excel or a Financial Calculator.
Problem 4. Which project is the better investment? Explain your reasoning.
Problem 5. Compare and contrast the use of the NPV versus the IRR for evaluating a project. What are the limitations of each method?