This course shows you how to build a fuel hedging simulation model for the airline industry using Monte Carlo Simulation.
We first begin with an overview of the model context and background:
Next, we look at the actual model building process, i.e. a step by step walkthrough of how the Monte Carlo simulator is built in EXCEL. As a first step crude oil prices are simulated:
After obtaining the path of prices the simulator is linked to the projected financial statements of the airline in order to obtain distributions for jet fuel expenses and operating margins. These distributions will aid in creating an effective hedging strategy for the airline: