Reference no: EM133367605
Case: Aluminum Building Products Company (ABPC) is considering investing in either of the two mutually exclusive projects described as follows: Project 1. Buying a new set of roll-forming tools for its existing roll forming line to introduce a new cladding product. After its introduction, the product will need to be promoted. This means that cash inflows from additional production will start sometime after and will gradually pick up in subsequent periods. Modifying its existing roll-forming line to increase productivity of its available range of cladding products. Cash inflows from additional production will start immediately and will reduce over time as the products move through their life cycle.
Sarah Brown, project manager of ABPC, has requested that you do the necessary financial analysis and give your opinion about which project ABPC should select. The projects have the following net cash flow estimates:
Year |
Project 1 |
Project 2 |
0 |
($200,000) |
($200,000) |
1 |
0 |
90,000 |
2 |
0 |
70,000 |
3 |
20,000 |
50,000 |
4 |
30,000 |
30,000 |
5 |
40,000 |
10,000 |
6 |
60,000 |
10,000 |
7 |
90,000 |
10,000 |
8 |
100,000 |
10,000 |
Both these projects have the same economic life of eight years and average risk characteristics. ABPC's weighted average cost of capital, or hurdle rate, is 7.2 percent.
1. Which project would you recommend Ms. Brown accept to maximize value of the firm? (Hint: Calculate and compare NPVs of both projects.)
2. What are the IRRs of each project? Which project should be chosen using IRR as the selection criterion?
3. Draw the NPV profiles of both projects. What is the approximate discount rate at which both projects would have the same NPV? What is that NPV?
4. Further market survey research indicates that both projects have lower-than- average risk and, hence, the risk-adjusted discount rate should be 5 percent. What happens to the ranking of the projects using NPV and IRR as the selection criteria? Explain the conflict in ranking, if any.
5. Answer questions (1) and (4) again, assuming the projects are independent of each other. What are the Payback Period of each project?
YEAR |
Project 1 |
Project 2 |
PBP-1 |
PBP-2 |
NPV-2 |
|
Rate |
7.20% |
0 |
($200,000) |
($200,000) |
|
|
|
|
|
|
1 |
0 |
90,000 |
($200,000) |
($110,000) |
$83,955 |
|
|
|
2 |
0 |
70,000 |
($200,000) |
($40,000) |
$60,913 |
|
|
|
3 |
20,000 |
50,000 |
($180,000) |
$10,000 |
$40,587 |
|
|
|
4 |
30,000 |
30,000 |
($150,000) |
$40,000 |
$22,717 |
|
|
|
5 |
40,000 |
10,000 |
($110,000) |
$50,000 |
$7,064 |
|
|
|
6 |
60,000 |
10,000 |
-50,000 |
$60,000 |
$6,589 |
|
|
|
7 |
90,000 |
10,000 |
40,000 |
$70,000 |
$6,147 |
|
|
|
8 |
100,000 |
10,000 |
140,000 |
$80,000 |
$5,734 |
|
|
|
PBP |
|
|
7 |
2.78 |
$233,704.61 |
|
|
|
NPV |
$19,398.25 |
$33,704.61 |
|
|
$33,704.61 |
|
|
|
NPV @ 5% |
$49,717.05 |
$46,251.93 |
|
|
|
|
|
|
IRR |
9% |
14% |
|
|
|
|
|
|
MIRR |
8% |
9% |
|
|
|
|
|
|
This is what I came up with. Need help with formulas and don't know if I did this correct?
1.) Which project would you recommend Ms. Brown accept to maximize value of the firm? (Hint: Calculate and compare NPVs of both projects.)
The Project 2 is more suitable in terms of NPV when discounted at 7.2%
2.) What are the IRRs of each project? Which project should be chosen using IRR as the selection criterion?
The IRR for Project 1 is around 9% where the NPV is almost equal to 0. The IRR for Project 2 is around 14%, where the NPV becomes 0, so Project 1 could be chosen because the lower IRR.
3.) Draw the NPV profiles of both projects. What is the approximate discount rate at which both projects would have the same NPV? What is that NPV?
The NPV discounted at 5.4% shows almost the same NPV for both projects. Project 1 at $43, 840.71 and Project 2 at $43,877.91.
4.) Further market survey research indicates that both projects have lower-than- average risk and, hence, the risk-adjusted discount rate should be 5 percent. What happens to the ranking of the projects using NPV and IRR as the selection criteria? Explain the conflict in ranking, if any.
If the discount rate of 5% is used, the NPV of Project 1 ($49717.05) is higher than Project 2 ($46,251.93).
5.) Answer questions (1) and (4) again, assuming the projects are independent of each other. What are the Payback Period of each project?
The payback period for Project 1 would be 7 years, where the payback period for Project 2 would be around 3 years.
Ontario human rights commission
: Having completed the OHRC e-Learning module, why is human rights legislation critical in addressing discrimination?
|
Would farmers go into town to do errands
: Why, on a rainy day, would farmers go into town to do errands, while a business person who lives in town, will forego their errands and choose to stay at home
|
Do you believe is most accurate for social gospel theology
: Which view, of these three groups, do you believe is most accurate for social gospel theology and liberation theology? Why?
|
Surviving founders of sociology are product of constructions
: Explain the thinking behind the assertion that the surviving founders of sociology are a product of our constructions.
|
Which project would you recommend ms. brown accept
: Which project would you recommend Ms. Brown accept to maximize value of the firm? (Hint: Calculate and compare NPVs of both projects.)
|
Introduction to critical sexuality studies
: I suggest posting a link to the film clip/music video/news story/etc. that is relevant to our course content (Introduction to Critical Sexuality Studies).
|
Explain the benefits of formative assessments
: Explain the benefits of formative assessments and how you can make the most out of formative assessments in your classroom. How can you help students
|
Discuss transcultural psychiatry
: Discusses Transcultural Psychiatry. The author provides several case studies of culture-bound syndromes.
|
Describe main differences between results of business plan
: describe the main differences between the results of the business plan of the first, second, third, fourth and fifth years.
|