Modeling of Different Derivates for Hedging?

Dear WSO,

As part of a project I am working on as an intern right now I was planning on comparing the effects of different derivatives to hedge the price risk of the main commodity a company would buy (think fuel for an airline or steel for an intermediate goods producer). I am currently designing my approach and am unsure about the ideal way to model this. My idea is to use a Monte Carlo Simulation to first model (in Excel, probably with the help of @risk) the commodity price and then the resulting outcome of using either futures or options. However, I have never used a model for such an analysis and thus I am unsure about the feasibility or the common practice on this in general. Also, my experience with financial modelling is existing but limited to valuation.

What do you guys think? Wrong approach or doable? How would you approach this? Any samples? Any literature you can recommend?

Best regards, Lamer

1 Comments
 

Saepe corrupti accusantium ut dolorem est. Molestias quam rerum sapiente quisquam sint doloribus. Deleniti quia sed autem quisquam voluptatem. Impedit nisi minima porro tempore veniam perferendis laborum.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”