In: Finance
Company X is setting up capacity in Europe and North America for the next three years. Annual demand in each market is 2 million kilograms (kg) and is likely to stay at that level. The two choices under consideration are building 4 million units of capacity in North America or building 2 million units of capacity in each of the two locations. Building two plants will incur an additional one-time cost of $2 million. The variable cost of production in North America (for either a large or a small plant) is currently $10/kg, whereas the cost in Europe is 9 euro/kg. The current exchange rate is 1 euro for U.S. $1.33. Over each of the next three years, the dollar is expected to strengthen (NOT rise) by 10 percent, with a probability of 0.5, or weaken(NOT drop) by 5 percent, with a probability of 0.5. Assume a discount factor of 10 percent.
What is the Year 0 net present value of building 2 million units of capacity in each of Europe AND North America?
| Change in Eur /USD rate | Probability | % Increase /(Decrease ) | Probability Weighted % Increase /(Decrease ) |
| 0.5 | 10% | 5.00% | |
| 0.5 | -5% | -2.50% | |
| Total | 2.50% | ||
| So the expected increase in exchnage rate increase is 2.5% per annum | |||
| Year 1 | Year 2 | Year 3 | |
| Eur /USD rate with 2.5% strengthening of USD ( USD value reduces by 2.5% each year against USD) | 1.297 | 1.264 | 1.233 |
| Variable cost Comparison | Year 1 | Year 2 | Year 3 |
| Option 1 | |||
| Making 4M units in NA @$10/kg | $ 40,000,000 | $ 40,000,000 | $ 40,000,000 |
| Option 2 cost | |||
| Making 2 M units in Europe @Euo 9/kg converted to USD at the respective years rate | $ 23,341,500 | $ 22,757,963 | $ 22,189,013 |
| Making 2 M units @$10/kg in NA | $ 20,000,000 | $ 20,000,000 | $ 20,000,000 |
| Total Variable cost in Option 2 | $ 43,341,500 | $ 42,757,963 | $ 42,189,013 |
| Incremental Variable cost in Option 2 | $ 3,341,500 | $ 2,757,963 | $ 2,189,013 |
| NPV of of buildining 2M units in NA and 2M units in Europe. | ||||
| Initial Investment | Year 0 | Year 1 | Year 2 | Year 3 |
| Incremental One time cost | $ (2,000,000) | |||
| Incremental Variable cost | $ (3,341,500) | $ (2,757,963) | $ (2,189,013) | |
| Total Incremental cost | $ (2,000,000) | $ (3,341,500) | $ (2,757,963) | $ (2,189,013) |
| Discount factor @10% | $ 1 | $ 1 | $ 1 | $ 1 |
| PV of Incremental cost | $ (2,000,000) | $ (3,037,758) | $ (2,279,180) | $ (1,644,606) |
| NPV =sum of PV of discounted incremental cost | $ (8,961,544) | |||
| So the NPV of building 2 million units of capacity in each of NA and Eurpoe is = | $ (8,961,544) |