How to build a fuel hedging simulation model

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:

• Simulation Model – Fuel Hedge – Model Groundwork

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:

• Simulation Models – Fuel Hedge – Model Building – First Pass

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:

• Simulation Models – Fuel Hedge – Linking Simulator & Financials