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:

build a fuel hedging simulation 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:

build a fuel hedging simulation model - price path

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:

build a fuel hedging simulation model - financial statements