The Investment Detective The essence of capital budgeting and resource allocation is a search for good investments in which to place the firm’s capital. The process can be simple when viewed in purely mechanical terms, but a number of subtle issues can obscure the best investment choices. The capital-budgeting analyst is necessarily, therefore, a detective who must winnow good evidence from bad. Much of the challenge is knowing what quantitative analysis to generate in the first place.
Suppose you are a new capital-budgeting analyst for a company considering investments in the eight projects listed in the table below. The chief financial officer of your company has asked you to rank the projects and recommend the "four best" that the company should accept.
In this assignment, only the quantitative considerations are relevant. No other project characteristics are deciding factors in the selection, except that management has determined that projects 7 and 8 are mutually exclusive.
All the projects require the same initial investment, $2 million. Moreover, all are believed to be of the same risk class. The weighted-average cost of capital of the firm has never been estimated. In the past, analysts have simply assumed that 10 percent was an appropriate discount rate (although certain officers of the company have recently asserted that the discount rate should be much higher).
To stimulate your analysis, consider the following questions:
1. Can you rank the projects simply by inspecting the cash flows? Show your ranking?
2. What criteria might you use to rank the projects? Which quantitative ranking methods are better? Why?
3. What is the ranking you found by using quantitative methods? Does this ranking differ from the ranking obtained by simple inspection of the cash flows?
Note:
You can use an excel sheet for the calculation.
For each Quantitative method you have to write the formula explain how you made the calculations