Uploaded July 2026 | Updated November 2026, 2 days ago
In this episode of FP&A Unlocked, host Paul Barnhurst welcomes Alok Ajmera to explore how AI is reshaping forecasting, budgeting, planning, and the future role of FP&A teams.
Most finance leaders trust AI to explain numbers.
But many still refuse to let AI interact with them.
That's an interesting contradiction.
If AI can analyze your forecast, summarize your board pack, and identify trends faster than any team member...
Why does budgeting suddenly become off-limits?
The real challenge isn't the technology. It's trust.
Finance has always been built on control, accuracy, and accountability.
š§ Listen to the full episode on @thefpandaguy
#FPandA #FinanceLeadership #CFO #FinancialPlanning #Budgeting #Forecasting #ArtificialIntelligence #FinanceTransformation #OfficeOfTheCFO #CorporateFinance #FPACommunity #FutureOfFinance
In this episode of FP&A Unlocked, host Paul Barnhurst welcomes Alok Ajmera to explore how AI is reshaping forecasting, budgeting, planning, and the future role of FP&A teams.
Most finance leaders trust AI to explain numbers.
But many still refuse to let AI interact with them.
That's an interesting contradiction.
If AI can analyze your forecast, summarize your board pack, and identify trends faster than any team member...
Why does budgeting suddenly become off-limits?
The real challenge isn't the technology. It's trust.
Finance has always been built on control, accuracy, and accountability.
š§ Listen to the full episode on @thefpandaguy
#FPandA #FinanceLeadership #CFO #FinancialPlanning #Budgeting #Forecasting #ArtificialIntelligence #FinanceTransformation #OfficeOfTheCFO #CorporateFinance #FPACommunity #FutureOfFinance
![Excel LAMBDA and Dynamic Arrays: Benefits and Limits for Financial Models with Diarmuid Early
In this episode of Financial Modelers Corner: The ModSquad, Ian Schnoor, Paul Barnhurst, and Giles Male welcome Diarmuid Early to discuss how modern Excel features are changing financial modeling. They explore the benefits of dynamic arrays, LET and LAMBDA functions, and how these tools can make financial models more flexible, consistent, and efficient.
Diarmuid Early is the Founder of Early Days Consulting and an expert in Excel and financial modeling. He is an accomplished competitive Excel esports participant and an active contributor to the Excel community. He shares practical approaches to using dynamic arrays, LET, and LAMBDA functions to build more flexible, efficient, and reliable financial models.
Expect to Learn
How dynamic arrays improve flexibility and consistency in financial models.
How LET and LAMBDA functions simplify complex calculations.
Why Power Query is useful for connecting Excel workbooks.
How custom functions can improve model accuracy and auditability.
When modern Excel features create compatibility and modeling challenges.
Here are a few quotes from the episode:
āLambdas can do crazy things, but you dont need them to do crazy things to be useful.ā - Diarmuid Early
āFor the guts of 40 years, one Excel formula returned one result, and now one Excel formula can return many results.ā - Diarmuid Early
Diarmuid explains how dynamic arrays and LAMBDA functions can reduce repetitive work and help financial modelers build more adaptable models. He also highlights their limitations, particularly when dealing with circular dependencies, complex calculations, and older Excel versions.
Follow Ian:
LinkedIn - https://www.linkedin.com/in/ianschnoor/
Follow Giles:
LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/
Follow Diarmuid:
LinkedIn - https://www.linkedin.com/in/diarmuidearly/
Disclosure: Portions of this episode (such as the introduction or promotional segments) use AI-generated voice narration produced under human editorial review.
In Todays Episode:
[00:00] - Introduction
[10:44] - Modern Excel & Financial Modeling
[12:41] - Understanding Dynamic Arrays
[19:15] - Understanding LAMBDA Functions
[24:35] - Practical LAMBDA Applications
[33:16] - Benefits of Reusable Functions
[34:49] - LAMBDA Limitations & Compatibility
[38:48] - Making LAMBDA Models Easier to Audit
[43:10] - When Small Model Changes Become Big Problem
[46:21] - Resources for Learning LAMBDA Excel LAMBDA and Dynamic Arrays: Benefits and Limits for Financial Models with Diarmuid Early](https://i.ytimg.com/vi/EmesAFVc0-s/mqdefault.jpg)



![What Separates an Excellent Financial Modeler From a Technically Good One with Diarmuid Early
In this episode of Financial Modelerās Corner, Paul Barnhurst speaks with Diarmuid Early about what separates great financial modelers from technically capable ones, the rise of AI in financial modeling, and why judgment remains essential. Diarmuid shares lessons from his career, his experience as a three-time World Financial Modeling Champion, and why understanding what a model actually means matters more than simply building it correctly.
Diarmuid Early is the founder of Early Days Consulting, a data analytics and financial modeling consultancy. He previously worked at Boston Consulting Group and spent nearly a decade in Deutsche Bankās Origination and Advisory division. He holds a PhD in computer science and is a three-time World Financial Modeling Champion, Excel MVP, and Master Financial Modeler
Expect to Learn:
Why great modelers think beyond simply building the model
How assumptions and business understanding drive valuable financial models
Where AI currently fits into financial modeling
Why AI-generated models still require careful human review
Why continuous learning remains essential for financial modelers
Here are a few relevant quotes from the episode:
āThe hard part is getting everybody aligned. What are the assumptions?ā - Diarmuid Early
āThere is a smart way to do it. And so if youre banging your head against it, go find the smart way.ā - Diarmuid Early
AI will continue to take on more of the technical work involved in financial modeling, but speed alone does not make a model useful or reliable. Strong modelers will continue to stand out through their ability to develop credible assumptions, interpret results, exercise judgment, and understand the decisions a model is meant to support.
Follow Diarmuid:
LinkedIn: https://www.linkedin.com/in/diarmuidearly/
YouTube: https://www.youtube.com/@DimEarly
Follow Financial Modelers Corner:āÆ
LinkedIn: https://www.linkedin.com/company/financial-modeler-s-corner/
Join FMIās Global Conference:
Take your financial modeling skills to the next level with FMIās Global Financial Modeling Conference. Experience 24 hours of learning, networking, and practical insights from leading experts across the finance community.
Register today: https://fminstitute.com/conference/
Disclosure: Portions of this episode (such as the introduction or promotional segments) use AI-generated voice narration produced under human editorial review.
Newsletter - Subscribe on LinkedIn: https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984
Sign up for the Advanced Financial Modeler Accreditation today and get 15% off using the code āPodcastā at https://bit.ly/497oAqW
In Todays Episode:
[00:00] - Trailer
[03:31] - Diarmuidās Journey Into Financial Modeling
[06:00] - Financial Modeler Stereotypes
[08:20] - Career Advice for Aspiring Modelers
[12:46] - Financial Modeling Competitions
[14:59] - Consulting, Coaching, and Career Evolution
[18:25] - Meeting Microsoft CEO Satya Nadella
[21:08] - AI and the Future of Financial Modeling
[25:41] - Why AI-Generated Models Still Need Review
[31:09] - Financial Modeling Standards and Best Practices
[35:19] - Diarmuidās Most Challenging Modeling Case
[39:28] - Excel Shortcuts and Modeling Tools
[41:38] - Rapid-Fire Modeling Questions
[46:01] - Continuous Learning and Final Advice What Separates an Excellent Financial Modeler From a Technically Good One with Diarmuid Early](https://i.ytimg.com/vi/FVLkvLBWBqc/mqdefault.jpg)





![Pitch Anythings Oren Klaff: From Spreadsheet to Deal Table
In this episode of Financial Modelerās Corner, Paul Barnhurst speaks with Oren Klaff about how financial modeling can become a powerful tool for deal-making, investment decisions, and career growth. Oren explains why modelers should focus on identifying key sensitivities, communicating insights effectively, and helping buyers and sellers find ways to make deals work rather than simply pointing out flaws.
Oren Klaff is a Private Equity Fund Manager and the bestselling author of Pitch Anything. Based in Beverly Hills, California, he focuses on recruiting smart people to join his portfolio companies. Oren began his career as a financial analyst in private equity before moving into deal-making and capital raising. His experience in financial modeling has played a key role in his approach to deal-making and raising capital.
Expect to Learn:
How financial modeling can help you transition into deal-making and capital raising.
Why identifying sensitive assumptions is more valuable than simply finding errors.
How analysts can avoid antagonizing other parties and instead help move deals forward.
What makes a financial model professional, usable, and trustworthy.
Why simplicity and structure matter when building models for business users.
Here are a few relevant quotes from the episode:
Excel will never die. Rock and roll will never die, and Excel will never die. - Oren Klaff
The shortest path to high status is finding something wrong. - Oren Klaff
Oren explains that the real value of a modeler goes beyond building technically complex spreadsheets. The best modelers help decision-makers understand what matters, communicate uncertainty, and find practical ways to move a deal forward. A strong model should also be simple enough for business users to operate and robust enough to withstand scrutiny.
Join FMIās Global Conference:
Take your financial modeling skills to the next level with FMIās Global Financial Modeling Conference. Experience 24 hours of learning, networking, and practical insights from leading experts across the finance community.
Register today: https://fminstitute.com/conference/
Follow Oren:
LinkedIn: https://www.linkedin.com/in/orenklaff/
Follow Financial Modelers Corner:āÆ
LinkedIn: https://www.linkedin.com/company/financial-modeler-s-corner/
Newsletter - Subscribe on LinkedIn: https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984
Sign up for the Advanced Financial Modeler Accreditation today and get 15% off using the code āPodcastā at https://bit.ly/497oAqW
Disclosure: Portions of this episode (such as the introduction or promotional segments) use AI-generated voice narration produced under human editorial review.
In Todays Episode:
[00:00] - Trailer
[05:20] - Finding Insight in the Numbers
[07:28] - Moving From Analyst to Deal Maker
[10:58] - Using Modeling Without Antagonizing the Other Side
[15:26] - Price, Terms, and Making Deals Work
[20:11] - Real-World Applications of Modeling in Deals
[23:24] - Modeling Horror Stories & What Good Models Look Like
[31:25] - Building Models That Help Raise Money
[35:20] - Storytelling With Numbers
[40:13] - Pitch Anything and the Role of Status
[43:24] - Rapid Fire: Excel, AI, Sensitivity Analysis & More
[44:53] - Final Advice for Advancing Your Modeling Career Pitch Anythings Oren Klaff: From Spreadsheet to Deal Table](https://i.ytimg.com/vi/GJt-7PFPLWg/mqdefault.jpg)