Week 2.1 – data – chocolat cordon rouge solution*****already a++
Chocolat Cordon Rouge
Corporate Finance
You are part of Marcel Arnaud’s team to analyze the 7 different projects under
consideration.
The table in the case describes the expected cash flows of the different projects. All
the costs and benefits of the projects have been taken into consideration except for
two potential costs:
1. John Hsu, the manager sponsoring the project to build a factory in the U.S.,
did not include the loss in output of the French plant in Years 4-10. He claims
that those cash flows are not part of his proposed project and as such should
not be included.
2. Bertrand Godard, who is proposing to expand capacity in Brittany, has not
included the cost of the land because he claims that the firm already owns it.
However, you should note that the cash flows of the project include the sale
of the land in year 10.
Before conducting your analysis, think about whether these decisions are correct
and, if not, adjust the cash flows accordingly.
Clarifications:
• The case gives you the WACC of each project. This is just the discount rate. As the case indicates, CCR has only €75M in its bank account to pay for the projects
investment costs.
Assignment Questions
1. Compute the NPV and IRR of each project. If there were no budget
constraint, which projects would you recommend?
2. Which projects would you recommend with the €75M budget? Assume first
that if CCR sells the land, it will NOT use the proceeds to increase its capital
budget.
CHOCOLAT CORDON-ROUGE (CCR) |
|
|
|
|
|
|
||
Free Cash Flows by Project |
|
|
|
|
|
|
|
|
Euros, Millions |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Project |
1 |
2 |
3 |
4 |
5 |
6 |
7 |
|
|
Build U.S. Factory |
Enter LATAM (Uruguay) |
Increase Capacity at current site (Brittany) |
Capacity Expansion for “Chocafe” |
“Green” / Carbon Footprint Reduction |
Greening Chinese Production Plant |
Purchase New Machinery from Bankrupt Competitor |
(1) French Plant Regular CF |
Total Investment |
55.00 |
37.50 |
14.50 |
6.50 |
10.00 |
8.20 |
29.50 |
|
|
|
|
|
|
|
|
|
|
EXPECTED FREE CASH FLOWS |
|
|
|
|
|
|
|
|
Year |
|
|
|
|
|
|
|
|
0 |
-55.00 |
-37.50 |
-14.50 |
-6.50 |
-10.00 |
-8.20 |
-29.50 |
72.50 |
1 |
3.00 |
0.40 |
1.74 |
1.05 |
2.05 |
0.75 |
0.00 |
76.13 |
2 |
5.80 |
0.90 |
4.94 |
1.33 |
2.05 |
0.75 |
5.85 |
79.93 |
3 |
12.00 |
1.75 |
4.94 |
1.33 |
2.05 |
1.35 |
5.85 |
83.93 |
4 |
14.50 |
3.80 |
4.94 |
1.33 |
2.05 |
1.35 |
5.85 |
88.12 |
5 |
17.50 |
7.40 |
4.94 |
1.33 |
2.05 |
1.35 |
5.85 |
92.53 |
6 |
21.30 |
9.20 |
4.94 |
1.33 |
2.05 |
1.55 |
5.85 |
97.16 |
7 |
26.30 |
16.10 |
4.94 |
1.33 |
2.05 |
2.25 |
5.85 |
102.01 |
8 |
29.10 |
20.40 |
4.94 |
1.33 |
2.05 |
2.25 |
5.85 |
107.12 |
9 |
29.60 |
22.60 |
4.94 |
1.33 |
2.05 |
2.25 |
5.85 |
112.47 |
10 |
29.60 |
22.60 |
17.14 |
1.33 |
2.05 |
0.08 |
5.85 |
118.09 |
|
|
|
|
|
|
|
|
|
Undiscounted Sum (years 1-10) |
133.70 |
67.65 |
43.90 |
6.48 |
10.50 |
5.73 |
23.15 |
1,029.99 |
|
||||||||
Project WACC |
10.0% |
12.5% |
7.0% |
10.0% |
12.5% |
12.5% |
10.0% |
|