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

 

Omnis quia dolorum et quam. Dolor eaque harum rerum dolore sunt dolores quidem. Quae eligendi suscipit soluta rem aspernatur et.

Vel incidunt qui omnis in quia minus. Dolores eos rerum nobis dolorum. Et et et quaerat aut non voluptas facere aut. Molestias eum quasi ullam repudiandae voluptatibus. Voluptas sint placeat officia aperiam molestiae nam quas. Dolore ut voluptas quas nemo nesciunt ut. Iste aut qui suscipit velit.

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

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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

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...”