Financial Modeler's Corner

Quantrix Approach to Simplify Complex Financial Problems with Gilbert Hangartner


Listen Later

In this episode of the "Financial Modelers Corner," host Paul Barnhurst welcomes Gilbert Hangartner, a financial modeler with a background in science. The discussion delves into the intricacies of financial modeling, the importance of simplicity in model construction, and the application of Monte Carlo simulations to understand risk. Gilbert shares his insights on how to approach financial modeling by asking the right questions rather than having complex formulas.

Gilbert Hangartner is a seasoned financial modeler who transitioned from a career in science, specializing in chemistry and physics, to financial modeling and risk analysis. His scientific training gives him a unique perspective on financial modeling, treating it as both a creative process and a technical discipline. Gilbert emphasizes the importance of simplicity and clarity in building effective models and is an advocate for using models as tools for communication and strategic decision-making.


Key takeaways from this week's episode include:

  • Understanding the importance of simplicity in modeling 
  • The debate on whether financial modeling is more of an art or a science
  • Simplifying a problem and understanding the question before diving into model building.
  • Introduction to Monte Carlo simulations for risk management
  • A discussion on the limitations of Excel and future of financial modeling


Here are a few quotes from Gilbert Hangartner:

  • "A good model is not about complexity; it's about clarity and answering the right question." - Gilbert Hangartner
  • "For me, modeling is a creative act, much like writing a song or painting a picture." - Gilbert Hangartner
  • "Multi-dimensional modeling is key; real-world problems are never just two-dimensional." - Gilbert Hangartner
  • "The future of financial modeling lies beyond Excel; it’s time for more advanced, structured tools." - Gilbert Hangartner


In this episode, Gilbert Hangartner offers a fresh perspective on the world of financial modeling and challenges the conventional wisdom that financial models must be complex to be effective. Whether you're a seasoned modeler or just starting out, Gilbert's insights on Monte Carlo simulations provide valuable guidance on how to enhance your modeling skills and approach.


Follow Gilbert:

  • LinkedIn - https://www.linkedin.com/in/gilbert-hangartner-71754047/


 Follow Paul: 

  • Website - https://www.thefpandaguy.com   
  • LinkedIn - https://www.linkedin.com/in/thefpandaguy  
  • YouTube - https://www.youtube.com/@thefpaguy8376  


Follow Financial Modeler's Corner  

  • LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true 
  • Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984


Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.


Visit www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. 


In today’s episode:

[01:16] - Introduction to the episode and the guest, Gilbert Hangartner

[01:57] - The worst financial model horror story shared by Gilbert

[04:42] - Discussion on the importance of simplicity in financial modeling

[06:10] - Gilbert explains his transition from science to financial modeling

[10:11] - Art or Science? The nature of financial modeling

[13:45] - Strategies for asking the right questions when building a model

[17:16] - An overview of Monte Carlo simulations for risk modeling

[28:31] - The advantages of Quantrix over Excel 

[44:47] - A contrarian view on the future of Excel in financial modeling

[47:48] - Closing Remarks and Contact Information

...more
View all episodesView all episodes
Download on the App Store

Financial Modeler's CornerBy Paul Barnhurst AKA The FP&A Guy

  • 4.9
  • 4.9
  • 4.9
  • 4.9
  • 4.9

4.9

15 ratings


More shows like Financial Modeler's Corner

View all
Marketplace by Marketplace

Marketplace

8,801 Listeners

Pivot by New York Magazine

Pivot

9,724 Listeners

Capital Allocators – Inside the Institutional Investment Industry by Ted Seides – Allocator and Asset Management Expert

Capital Allocators – Inside the Institutional Investment Industry

797 Listeners

The Accounting Podcast by Blake Oliver & David Leary

The Accounting Podcast

347 Listeners

Inside the Strategy Room by McKinsey & Company

Inside the Strategy Room

176 Listeners

FP&A Today by Glenn Hopper

FP&A Today

48 Listeners

HBR On Leadership by Harvard Business Review

HBR On Leadership

170 Listeners

Run the Numbers by CJ Gustafson

Run the Numbers

58 Listeners

The Credit Edge by Bloomberg Intelligence by Bloomberg

The Credit Edge by Bloomberg Intelligence

36 Listeners

FP&A Unlocked by Paul Barnhurst

FP&A Unlocked

25 Listeners

Unpivot by UnpivotShow

Unpivot

7 Listeners

FinPod by Corporate Finance Institute

FinPod

6 Listeners