
The future of financial modeling was the focus of this panel debate on AI, Excel and the skills modellers will need next. Panellists share their perspectives on where the future of financial modeling is heading and how AI will change the way models are built, checked and used.
The Future of Financial Modeling could not be a more controversial and important debate that needs to be had in the industry. There is a lot of hype around where the technology is heading and how soon we will see AI building financial models.
The reality is not always so clear.
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.
The Future of Financial Modeling is a topic that keeps coming up amongst industry experts and one that will continue to be a hot topic as the technology become more advanced and really changes the way accounting, finance and financial modellers do their work.
This lively discussion promises insights, entertainment, and plenty of surprises as the panellists 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.
Powerhouse Panel of Experts
- Derek Baker, FP&A professional and co-founder of the FP&A Hub
- Lance Rubin, CEO of Model Citizn and Chief Excel Officer at EXL 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
- Craig Thompson, former investment banker now innovating in software at Aleph
I’ll fetch the Spotify podcast episode to see what information is available about it.## Podcast Summary: The Great Debate on AI, Excel, and the Future of Financial Modeling
Panelists & Their Perspectives:
Lance Rubin (CEO of Model Citizn, Chief Excel Officer at EXL Cloud)
- Emphasised that Excel’s modern tools like Power Query and LAMBDAs are preparing the groundwork for AI to transform model building
Danielle Stein Fairhurst (Financial modeling trainer, author, Microsoft MVP)
- Argued that while AI can process data efficiently, it fundamentally lacks the creativity and business acumen essential for financial modeling
Dr. David Brown (Finance professor, University of Arizona)
- Championed Excel’s enduring relevance, noting it forms the foundation of the financial system and its adaptability ensures longevity
Derek Baker (FP&A professional, co-founder of FP&A Hub)
Diarmuid “Dim” Early (Founder of Early Days Consulting)
Craig Hatmaker (Retired founder of Beyond Excel)
Ian Bennett (Leader of PwC’s global financial modeling practice)
Craig Thompson (Former investment banker, software innovator at Aleph)
Key Debate Topics:
- Financial models as decision-making tools – Whether they’re essential for business decisions
- Excel’s future – Will it survive or be replaced by emerging technologies?
- New tools adoption – The value of learning Power BI, Power Query, and Python for financial modeling
- Controversial techniques – Debate around circular references and dynamic arrays
- AI replacing modelers – Timeline and likelihood of AI taking over human modeling roles
Key Quotes
- “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
Expect to learn about the role of financial models in decision-making, the future of Excel, the impact of Power BI, Power Query, and Python, and whether AI will replace human modelers.
Don’t fall too far behind on the debate on the Future of Financial Modeling by keeping this Podcast saved in your favourites or library.
Visit the links below to follow the panellists and dive deeper into the discussion!
Follow Ian: https://www.linkedin.com/in/ianbennettpwc/
Follow Derek: https://www.linkedin.com/in/derek-d-baker/
Follow Lance: https://www.linkedin.com/in/financial-modelling/
Follow Diarmuid: https://www.linkedin.com/in/diarmuidearly/
Follow Craig H: https://www.linkedin.com/in/craig-hatmaker-4449879/
Follow David: https://www.davidclaytonbrown.com/
Follow Danielle: https://www.linkedin.com/in/daniellesteinfairhurst/
We put this into practice in EXL Cloud, our own SaaS modelling platform. It connects Xero to Excel and adds a library of Claude skills that build, check and report on driver-based financial models, so the AI works on a structured model instead of guessing.
Frequently asked questions
What does the future of financial modeling debate cover?
The episode puts an expert panel through the contested questions in financial modeling: the role of models in decision-making, whether Excel survives or is replaced, whether modelers should learn Power BI, Power Query and Python, contested techniques such as circular references and dynamic arrays, and how likely AI is to replace human modelers.
Will AI replace financial modelers?
The panel disagreed. Lance Rubin argued that newer Excel tools such as Power Query and LAMBDA are laying the groundwork for AI to change how models are built. Other panellists argued that AI processes data efficiently but lacks the creativity and business acumen modeling needs, and that the hype is louder than the reality.
Will Excel survive in the future of financial modeling?
One view on the panel was that Excel underpins the financial system and that its adaptability should keep it relevant for years. The debate weighs that against newer technologies and asks whether modelers should add Power BI, Power Query and Python to their Excel skills.
Where can I keep learning about the future of financial modeling?
Model Citizn runs the Future of Finance Lab, a free session held every two weeks on these topics, with past sessions available, including one on building SaaS financial modeling skills for a career. The Financial Modelling Institute is also a useful reference for modeling standards and certification.
If you want to stay up to speed with the Future of Financial Modelling, consider joining the Future of Finance Lab held each fortnight. The session will particularly focus on this topic and is free to join.
Below is a link to some past sessions.

/Future of Finance Lab – Session #1
Ready to automate manual finance work or put AI to use in your team? See our Financial Automation services.
Further reference: Financial Modelling Institute.
About the Author
Lance Rubin is CEO and Founder of Model Citizn, and founder and Chief Excel Officer of EXL Cloud, the SaaS platform that connects Xero to Excel with driver-based financial models, dashboards and Claude AI skills. He is a Chartered Accountant, FMI Certified Trainer, co-author of the CA ANZ Financial Modelling Study Guide, and creator of the AI-Powered Accountant programme on Maven, currently live at Level 1 with Level 2 in design, and author of the companion book “AI-Powered Accounting with Excel and Power BI” (Packt). He has worked at PwC, KPMG, Investec, and NAB, and is based in Melbourne, Australia.

