Capital Budgeting

Selecting only projects that are profitable for yourself or a company is an important financial responsibility. Being able to identify the most profitable projects will help lead you to greater success.

Instructions

Below is a hypothetical situation that will allow you to compare two investment options. Your assignment is to review both options and determine which is better and explain why.

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 $100,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 $160K in cash flows over 5 years, while the used van would result in $120K in cash flows over 3 years.

Assume the following information for High Flier Corporation: A $100,000 investment yields the following inflows of cash:

*Chart Attached

Calculate the payback.Using the information above, do the following:

1. Calculate the NPV using Excel or a Financial Calculator.
2. Calculate the IRR using Excel or a Financial Calculator.
3. Which project is the better investment? Explain your reasoning.
4. Compare and contrast the use of the NPV versus the IRR for evaluating a project. What are the limitations of each method?