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.