In: Finance
Calculation of Present value | ||||||
Solution a | 10% | |||||
Year | Cash flow in EURO | Ex rate | Cash flow in USD | PV factor, 1/(1+r)^t | PV-Cash Flow-1 | |
0 | € (10.00) | $ 1.18 | $ (11.80) | 1.0000 | $ (11.80) | |
1 | € 1.00 | $ 1.15 | $ 1.15 | 0.9091 | $ 1.05 | |
2 | € 2.00 | $ 1.14 | $ 2.28 | 0.8264 | $ 1.88 | |
3 | € 3.00 | $ 1.13 | $ 3.39 | 0.7513 | $ 2.55 | |
3 | € 8.00 | $ 1.13 | $ 9.04 | 0.7513 | $ 6.79 | |
NPV | $ 0.47 | |||||
Since the NPV is positive, the plant should be built | ||||||
Solution b | 10% | |||||
Year | Cash flow in EURO | Ex rate | Cash flow in USD | PV factor, 1/(1+r)^t | PV-Cash Flow-1 | |
0 | € (10.00) | $ 1.18 | $ (11.80) | 1.0000 | $ (11.80) | |
1 | € 1.00 | $ 1.21 | $ 1.21 | 0.9091 | $ 1.10 | |
2 | € 2.00 | $ 1.23 | $ 2.46 | 0.8264 | $ 2.03 | |
3 | € 3.00 | $ 1.25 | $ 3.75 | 0.7513 | $ 2.82 | |
3 | € 8.00 | $ 1.25 | $ 10.00 | 0.7513 | $ 7.51 | |
NPV | $ 1.66 | |||||
Since the NPV is positive, the plant should be built. As compared to | ||||||
First option, the NPV is increased from $ 0.47 million USD to $ 1.66 million USD. | ||||||