Reference no: EM13965145
Investment Detective Instructions
a. The text of the Investment Detective Case is in your Harvard pack. There isn't a lot of info there besides the cash flow forecasts for the investment projects (which are also recreated in the template). However there is a bit of contextual info.
b. The discount rate you should use for your NPV computations is 10%.
c. Rank the projects from 1-8 (with 1 being the best). If you think your ranking need some explanation, feel free to provide it in the spreadsheet.
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, therefore, is necessarily a detective who must winnow bad evidence from good. Much of the challenge is in 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 Exhibit 1. 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 firm's weighted average cost of capital has never been estimated. In the past, analysts have simply assumed that 10% 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?
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?
4. What kinds of real investment projects have cash flows similar to those in Exhibit 1?
Instructions
1. Compute NPV and IRR for each project.
2. Rank the projects from 1 to 8 with 1 being the best project
3. Use the shaded green cells below for your computations and rankings
4. If necessary or desired you can provide further computations or explanation under the rankings.
Discount Rate 10.00%
Exhibit 1
The Investment Detective
Project's Free Cash Flows(dollars in thousands)
Year |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
8 |
0 |
(2000) |
(2000) |
(2000) |
(2000) |
(2000) |
(2000) |
(2000) |
(2000) |
1 |
330 |
1666 |
|
160 |
280 |
2200 |
1200 |
(350) |
2 |
330 |
334 |
|
200 |
280 |
|
900 |
(60) |
3 |
330 |
165 |
|
350 |
280 |
|
300 |
60 |
4 |
330 |
|
|
395 |
280 |
|
90 |
350 |
5 |
330 |
|
|
432 |
280 |
|
70 |
700 |
6 |
330 |
|
|
440 |
280 |
|
|
1200 |
7 |
330 |
|
|
442 |
280 |
|
|
2250 |
8 |
1000 |
|
|
444 |
280 |
|
|
|
9 |
|
|
|
446 |
280 |
|
|
|
10 |
|
|
|
448 |
280 |
|
|
|
11 |
|
|
|
450 |
280 |
|
|
|
12 |
|
|
|
451 |
280 |
|
|
|
13 |
|
|
|
451 |
280 |
|
|
|
14 |
|
|
|
452 |
280 |
|
|
|
15 |
|
|
10000 |
(2000) |
280 |
|
|
|
|
|
|
|
|
|
|
|
|
Sum of Cash Inflows |
3310 |
2165 |
10000 |
3561 |
4200 |
2200 |
2560 |
4150 |
Excess of Cash Inflow over Initial Investment |
1310 |
165 |
8000 |
1561 |
2200 |
200 |
560 |
2150 |
Formulate-solve integer program between integer-non-integer
: The athletic boosters club for Beaconville has planned a 2-day fund-raising drive to purchase uniforms for al the local high schools and to improve facilities. Donations will be solicited during the day and night by telephone and personal contact. Fo..
|
Analysis of the case
: How should Radisson (p 25 of case ) define and implement their service guarantee? What role should information technology play in accelerating the drive to improve service quality? How should Radisson measure and improve customer satisfaction and em..
|
Cross-border transfer of competencies and capabilities
: Discuss why a company desirous of competing in foreign country markets needs to pay clse attention to the advantages of cross-border transfer of competencies and capabilities. Are these transfers often a key to competitive advantage? why or why not?
|
What kinds of real investment projects have cash flows
: 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 - Can you rank the projects simply by inspecting the cash flows?
|
Geographic rather than a product basis is referred
: A structure under which global operations are organized on a geographic rather than a product basis is referred to as a(n): A. Country division structure B. Global geographic structure C. Regional matrix structure D. Emerging markets structure
|
Show sample calculations for one or the fluids measured
: Show sample calculations (including all steps for finding ρ, γ, and SG starting fmm raw data) for ONE or the fluids or objects measured during this laboratory.
|
Foreign government intervention in product pricing decision
: A foreign government intervention in the product pricing decisions of a specific foreign company is an example of: A. Micro risk factors B. Marketing risk factors C. Macro risk factors D. Nationalizing risk factors
|
Bracket assembly requires one base two springs-four clamps
: Use Excel to solve the problem and submit the file through the eLearning system. A bracket assembly requires one base, two springs and four clamps. The base is assembled from one clamp and two housings. Each clamp has one handle and one casting. Each..
|