Financial Modeler's Corner Quantrix Approach to Simplify Complex Financial Problems with Gilbert Hangartner
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:
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