The Investment Detective Case
Case Analysis
Actually, we can rank the projects by simply inspecting the cash flows. However, it is not a good method to rank the projects. In order to ensure that the investment projects selected have the best chance of increasing the value of the firm, we need tools to evaluate the merits of individual projects and to rank competing investments. In this case, our group using some tools which are Payback Period, Net Present Value (NPV) , Profitability Index (PI), and Internal Rate of Return (IRR). We are only using quantitative considerations that we think to be relevant and no other project characteristics are deciding factors in our selection of the best four projects.
Payback Period
NPV
PI
IRR
Sum of Cash Flow Benefits
Excess of cash flow over initial investment
Project 1
6 years 22 days
$ 73.09
104%
10.87%
3310
1310
Project 2
2 years
($ 85.45)
96%
6.31%
2165
165
Project 3
15 years
$ 393.92
120%
400%
10000
8000
Project 4
6 years 18 days
$ 228.82
111%
12.33%
3561
1561
Project 5
7 years 1 month 20 days
$ 129.70
106%
11.12 %
4200
2200
Project 6
1 year
0
100%
10%
2200
200
Project 7
1 year 10 months 20 days
$ 165.04
108%
15.26%
2560
560
Project 8
6 years 14 days
$ 182.98
109%
11.41%
4150
2150
When coming up with our calculations to rank the four best projects we have to take into account that each project is going to require an initial investment of two million dollars and in using historical data from other capital budgeting analysts in the firm, we assume that the appropriate discount rate is ten percent for our calculations. After calculating it, we have found the number for every tool on every project, and rank the projects.
Cash Flows
Payback Period
NPV
PI
IRR
Ranking 1
Project 3
Project 6
Project 3
Project 3
Project 3
Ranking 2
Project 5
Project 7
Project 4
Project 4
Project 7
Ranking 3
Project 8
Project 2
Project 8
Project 8
Project 4
Ranking 4
Project 4
Actually, we can rank the projects by simply inspecting the cash flows. However, it is not a good method to rank the projects. In order to ensure that the investment projects selected have the best chance of increasing the value of the firm, we need tools to evaluate the merits of individual projects and to rank competing investments. In this case, our group using some tools which are Payback Period, Net Present Value (NPV) , Profitability Index (PI), and Internal Rate of Return (IRR). We are only using quantitative considerations that we think to be relevant and no other project characteristics are deciding factors in our selection of the best four projects.
Payback Period
NPV
PI
IRR
Sum of Cash Flow Benefits
Excess of cash flow over initial investment
Project 1
6 years 22 days
$ 73.09
104%
10.87%
3310
1310
Project 2
2 years
($ 85.45)
96%
6.31%
2165
165
Project 3
15 years
$ 393.92
120%
400%
10000
8000
Project 4
6 years 18 days
$ 228.82
111%
12.33%
3561
1561
Project 5
7 years 1 month 20 days
$ 129.70
106%
11.12 %
4200
2200
Project 6
1 year
0
100%
10%
2200
200
Project 7
1 year 10 months 20 days
$ 165.04
108%
15.26%
2560
560
Project 8
6 years 14 days
$ 182.98
109%
11.41%
4150
2150
When coming up with our calculations to rank the four best projects we have to take into account that each project is going to require an initial investment of two million dollars and in using historical data from other capital budgeting analysts in the firm, we assume that the appropriate discount rate is ten percent for our calculations. After calculating it, we have found the number for every tool on every project, and rank the projects.
Cash Flows
Payback Period
NPV
PI
IRR
Ranking 1
Project 3
Project 6
Project 3
Project 3
Project 3
Ranking 2
Project 5
Project 7
Project 4
Project 4
Project 7
Ranking 3
Project 8
Project 2
Project 8
Project 8
Project 4
Ranking 4
Project 4