In the second part of "The Great Debate," expert financial modelers from around the globe discuss controversial and thought-provoking questions about the art and science of financial modeling. The discussion focuses on the enduring relevance of Excel, the role of AI and Power BI in shaping the future of modeling. This episode highlights the nuances, complexities, and future of financial modeling as a discipline.
This episode features Giles Male, co-founder of Full Stack Modeler and an Excel MVP, Will Wardle, an independent financial modeler with over two decades of experience, Carolina Lago, founder of Classic Financial, specializing in FP&A and financial restructuring for SMEs, Hedieh Kianyfard, a project finance expert from Iran, known for her practical solutions to complex modeling challenges, Oz du Soleil, a YouTube star and Excel MVP, renowned for his engaging tutorials and insights, Rishi Sapra, a former accountant turned Power BI advocate, and David Brown, a seasoned financial modeler with 27 years of experience, excelling in blending Excel with Power BI.
Expect to Learn:
- The role of circular references in financial models.
- Why named ranges in Excel can either simplify or complicate financial models.
- The impact of AI on the future of financial modeling.
- How Power BI complements financial modeling by enhancing data visualization and storytelling.
- The debate on the most important financial statement and how it informs decision-making.
Here are a few quotes from the episode:
- "Dynamic arrays offer huge improvements, and we should aspire to use them more effectively as a community." - Giles Male
- "A three-statement model is the universal language of finance, connecting operations and strategy for decision-making." - Carolina Lago
- "Power BI complements financial models by adding context, automation, and storytelling, making it a must-learn tool." - Rishi Sapra
This episode of The Great Debate offers a lively exploration of financial modeling. The expert panelists highlight how financial modeling combines art and science, requiring technical mastery, critical thinking, and creativity. The discussions underscored the importance of balancing simplicity with complexity, leveraging technology without losing sight of foundational principles.
Follow Giles:
Follow Will:
Follow Carolina:
Follow Hedieh :
Follow Oz:
Follow Rishi:
Follow David:
Follow Paul:
Follow Financial Modeler's Corner
Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.
Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.
In today’s episode:
[01:23] - Introduction to the Panel
[05:51] - Circular References in Models
[10:14] - The Use of VBA
[14:55] - Dynamic Arrays Debate
[19:57] - Named Ranges in Excel
[24:50] - Will Excel Ever Die?
[33:43] - Can AI Build Models?
[37:56] - Should Modelers Learn Power BI?
[53:28] - Most Important Skill for Modelers
[57:40] - Closing Remarks
