The Great Debate on AI, Excel, and the Future of Financial Modeling

In this special debate episode, host Paul Barnhurst aka The FP&A Guy is joined by an all-star panel of modeling experts to tackle some of the most contentious questions in the financial modeling world. This lively discussion promises insights, entertainment, and plenty of surprises as the panelists bring their expertise and humor to the table. Together, they bring decades of experience, fresh perspectives, and a shared passion for the art and science of financial modeling.

The powerhouse panel of financial modeling experts include: Derek Baker, FP&A professional and co-founder of the FP&A Hub; Lance Rubin, CEO of Model Citizen and Chief Excel Officer at Excel Cloud; Diarmuid "Dim" Early, founder of Early Days Consulting; Craig Hatmaker, retired founder of Beyond Excel and advocate for modern modeling techniques; Dr. David Brown, finance professor at the University of Arizona and founder of the Microsoft Excel Collegiate Challenge; Danielle Stein Fairhurst, Sydney-based financial modeling trainer, author, and Microsoft MVP; Ian Bennett, leader of PwC's global financial modeling practice and Master Financial Modeler; and Craig Thompson, former investment banker now innovating in software at Aleph.

Expect to Learn:

• Why financial models are (or aren’t) the ultimate decision-making tool for businesses.
• The role of Excel in the future: is it here to stay, or will it be replaced by emerging technologies?
• Power BI, Power Query, and Python in financial modeling—are they worth learning?
• Controversial techniques: the debate on circular references and dynamic arrays.
• Whether AI will eventually replace human modelers—and how soon.

Here are a few quotes from the episode:

• "Excel’s modern tools, like Power Query and lambdas, are setting the stage for AI to change how we build models." - Lance Rubin
• "AI can process data, but it lacks the creativity and business acumen needed for financial modeling." - Danielle Stein Fairhurst
• "Excel is the foundation of the financial system, and its adaptability ensures it will last for years to come." - Dr. David Brown

From the future of Excel to the role of AI, the importance of financial statements, and the tools that modelers should master, this episode explored the evolving landscape of financial modeling.

Follow Derek:

• LinkedIn - https://www.linkedin.com/in/derek-d-baker/

Follow Lance:

• LinkedIn - https://www.linkedin.com/in/financial-modelling/

Follow Diarmuid:

• LinkedIn - https://www.linkedin.com/in/diarmuidearly/

Follow Craig H:

• LinkedIn - https://www.linkedin.com/in/craig-hatmaker-4449879/

Follow David:

• Website - https://www.davidclaytonbrown.com/

Follow Danielle:

• LinkedIn - https://www.linkedin.com/in/daniellesteinfairhurst/

Follow Ian:

• LinkedIn - https://www.linkedin.com/in/ianrbennett/

Follow Craig T:

• LinkedIn - https://www.linkedin.com/in/cfthompson/

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 https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register. 

In today’s episode:

[01:42] - Introduction to the Episode

[04:16] - The Debate Battle Starts

[07:12] - Should Financial Modelers Learn Python?

[11:15] - Dynamic Arrays vs. Traditional Models

[16:52] - Will Excel Ever Die?

[20:55] - Should Financial Modelers Learn Power BI?

[26:21] - Will AI Build Financial Models?

[32:09] - Circular References: Useful or Evil?

[39:27] - VBA in Financial Models

[44:41] - Number One Corporate Decision Making Tool

[52:58] - Which Financial Statement is Most Important?

[59:50] - Conclusion and Audience Poll