Investment Detective
Autor: Siddu Siddarth • December 28, 2015 • Case Study • 514 Words (3 Pages) • 2,301 Views
Investment Detective
- Can we rank the project simply by inspecting the cash flows ??
Ans : No. We cannot rank the project simply by inspecting the cash flows. This is because it ignores the Time value of Money and the opportunity cost of capital. The capital budgeting decision should be made by making use of different criteria like NPV, IRR, Profitability index, Payback & Discounted Payback period and Accounting rate of return. By using these tools it can be concluded if the sum of the cash flows of a project exceeds expected return rate or cost of capital of a company . The company decides to make an investment into the project only if the project is deemed to be profitable down the line. Because most of the cash flows are estimated in most of the projects, quality of estimation is another factor to be considered besides numerical capital budgeting tool.
- What Criteria might you use to rank the project?? Which Quantitative rankings methods are better?? why??
Ans : The Capital Budgeting criteria that can be used to rank the project are NPV, IRR, Profitability index, Payback & Discounted Payback period and Accounting rate of return.
Out of the available criteria, NPV & IRR can be used to make the investment decisions as they are the better tools available. In case of independent projects, both NPV & IRR can be used to make out the decision, whereas in case of mutually exclusive project NPV stands out, as it is the superior criterion compared to IRR. This is because IRR does not consider the realistic reinvestment assumption.
Apart from these criteria, others like Profitability index, Payback & Discounted Payback period and MIRR can also be used to supplement the decision carved out using NPV & IRR.
Q3 : What is the ranking you found using quantitative methods ?? Does this ranking differ from the one obtained by simple inspection of the cash flows ??
Ans:
Projects | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |
Investments | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 |
Sum of cash flows | 3310 | 2165 | 10000 | 3561 | 4200 | 2200 | 2560 | 4150 |
|
|
|
|
|
|
|
|
|
cash flow excess | 1310 | 165 | 8000 | 1561 | 2200 | 200 | 560 | 2150 |
|
|
|
|
|
|
|
|
|
NPV | 73.09 | ($85.45) | $393.20 | $228.22 | $129.70 | $0.00 | $165.04 | $182.98 |
|
|
|
|
|
|
|
|
|
IRR | 11% | 6% | 11% | 12% | 11% | 10% | 15% | 11% |
|
|
|
|
|
|
|
|
|
Profitability Index | 1.0365 | 0.9573 | 1.1966 | 1.1141 | 1.0649 | 1.0000 | 1.0825 | 1.0915 |
|
|
|
|
|
|
|
|
|
Payback period | 6.06 | 2 | 15 | 6.05 | 6.14 | 1 | 1.89 | 6.04 |
|
|
|
|
|
|
|
|
|
Discounted Pay back | 7.84 | >3 | 15 | 9.1 | 13.14 | 1 | 2.73 | 6.83 |
Ranking by inspecting the cash flows | 5 | 8 | 1 | 4 | 2 | 7 | 6 | 3 |
Ranking by quantitative methods ( NPV & IRR) | 6 | 8 | 1 | 2 | 5 | 7 | 4 | 3 |
...