File Name: Risk Hedging – Foreign Exchange Cash Flow Model
Location: Modeling Toolkit | Risk Hedging | Foreign Exchange Cash Flow Model
Brief Description: This model illustrates how to use Risk Simulator for simulating foreign exchange rates to determine if the value of a hedged fixed exchange rate or floating unhedged rate is worth more
Requirements: Modeling Toolkit, Risk Simulator
This is a cash flow model used to illustrate the effects of hedging foreign exchange rates (Figure 2.25). The tornado sensitivity analysis illustrates that foreign exchange rate, or forex, has the highest effects on the profitability of the project (shown in the Excel model). Suppose for the moment that the project undertaken is in a foreign country (FC) and the values obtained are denominated in FC currency, and the parent company is in the United States (U.S.) and requires that the net revenues be repatriated back to the U.S. The question we try to ask here is what is the appropriate forex rate to hedge at and the appropriate costs for that particular rate? Banks will be able to provide your firm with the appropriate pricing structure for various exchange forward rates but by using the model here, we can determine the added value of the hedge and, hence, can decide if the value added exceeds the cost to obtain the hedge. This model is already preset for you to run a simulation on.
The Forex Data worksheet shows historical exchange rates between the FC and U.S. Dollar. Using these values, we can create a custom distribution (we simply used the rounded values in our illustration), which is already preset in this example model.
However, should you wish to replicate creating the simulation model, you can follow the steps below:
- Start a new profile (Risk Simulator | New Profile) and give it an appropriate name.
- Go to the Forex Data worksheet and select the data in cells K6:K490 and click on Edit | Copy or Ctrl + C.
- Select an empty cell (e.g., cell K4) and click on Risk Simulator | Set Input Assumption and select Custom Distribution.
- Click on Paste to paste the data into the custom distribution, then Update Chart to view the results on the chart. Then, File | Save and save the newly created distribution to your hard drive. Close the set assumption dialog.
- Go to the Model worksheet and select the Forex cell (J9) and click on Risk Simulator | Set Input Assumption, and choose Custom, then click on Open a distribution and select the previously saved custom distribution.
- You may continue to set assumptions across the entire model, and set the NPV cell (G6) as a forecast (Risk Simulator | Set Output Forecast).
- RUN the simulation with the custom distribution to denote an unhedged position. You can then rerun the simulation but this time, delete the custom distribution (use the Delete Simulation Parameter icon and not Excel’s delete function nor hitting the keyboard’s delete key) and enter in the relevant hedged exchange rate, indicating a fixed rate. You may create a report after each simulation to compare the results.
From the sample analysis, we see the following:
From this table, several things are evident:
- The higher the hedged exchange rate is, the more profitable the project (e.g., 0.85 USD/FC is worth more than 0.80 USD/FC).
- The relative risk ratio, computed as the coefficient of variation(CV, or the standard deviation divided by the mean) is the same regardless of the exchange rate, as long as it is hedged.
- The CV is lower for hedged positions than unhedged positions, indicating that the relative risk is reduced by hedging.
- It seems that the exchange rate hedge should be above 0.80, such that the hedged position is more profitable than the unhedged.
- In comparing a hedged versus unhedged position, we can determine the amount of money the hedging is worth, for instance, going with a 0.85 USD/FC means that, on average, the hedge is worth $115,990,000 (computed as $2,408.81 – $2,292.82 denominated in thousands). This means that as long as the cost of the hedge is less than this amount, it is a good idea to pursue the hedge.
Figure 2.25: Hedging Foreign Exchange Risk Cash Flow Model