Financial Modeler’s Corner Podcast
Deepen your knowledge of the Art and Science of Financial Modeling from distinguished Modeler's across the globe. Hosted by Paul Barnhurst, aka The FP&A Guy, this podcast is brought to you by Financial Modeling Institute (FMI), offering the most respected accreditation in financial modeling.
How Excel AI Agents Actually Work for Financial Modelers to Understand LLMs & Tools with Tim Jacks
Tim Jacks is the founder of Taglo, a company dedicated to improving financial modeling with AI technology. His career journey spans financial consulting and software development, including building financial modeling tools. Over time, Tim's interest in artificial intelligence grew, and he delved into how AI, particularly Large Language Models (LLMs), could be used to enhance financial modeling processes.
Expect to Learn
How AI is revolutionizing financial modeling and the specific ways it’s being used today.
The technical components behind AI agents and how they differ from simple chatbots.
The importance of context and system prompts when working with LLMs in financial tasks.
Insights into the memory limitations of LLMs and how agents work around this challenge.
What 2025 Taught Us About Excel AI and Where Financial Modeling Is Heading in 2026
In this special episode of Financial Modeler’s Corner, host Paul Barnhurst recaps an exciting 2025 and outlines what's ahead for 2026. Paul reflects on the top five most downloaded episodes of the year, shares insights from key guests, and highlights major developments in financial modeling, including Excel's newest features and the growing role of AI.
We Tested 7 AI Tools in Excel for Financial Modeling, and None Could Build a Reliable Model
Tea Kuseva is the Community Manager at the Financial Modeling Institute (FMI), the only global accreditation body dedicated to financial modeling. With her deep involvement in the modeling community and her role supporting professionals worldwide, Tea Kuseva brings thoughtful questions and provides structure to the discussion, helping translate technical insights into practical takeaways for finance professionals.
Expect to Learn
How leading AI tools perform on real financial modeling tasks
Common issues like unbalanced sheets and flawed formulas
Key differences between Excel-based and standalone tools
Practical ways AI can assist with analysis and reportingWhy Excel and modeling expertise still matter in an AI-driven workflow
What Happens When the AI Tools Fail Basic Math and More with Ian and Giles
Expect to Learn
What Subset promises to do and how it performs in real-world testing
The challenges of importing Excel files into non-Excel environments
Why basic accounting logic still breaks many AI modeling tools
The risks of using outdated or unsupported AI tools found online
What it would actually take for professionals to move away from Excel
The Reality of AI Excel Tools for Finance Teams to Understand Formula Complexity with Ian and Giles
Expect to Learn
A detailed review of Melder’s features for Excel-based financial modeling.
How Melder compares to other tools previously tested by the team.
Challenges faced when using Melder for tasks like building formulas and financial schedules.
The pros and cons of using Melder, especially when it comes to its unique features and limitations.
Insights into the tools’ development process, especially when still in beta.
TrufflePig AI vs Excel for Finance Teams from Building Models to Real-Time DCFs with Ian Schnoor
Expect to Learn
A review of Trufflepig, an AI-powered spreadsheet tool.
How Trufflepig performs on real-world financial tasks.
The benefits and limitations of AI tools in financial modeling.
Insights into how Trufflepig compares with other financial modeling tools.
Elkar AI Put to the Test in Live Financial Modeling with Honest Results for Modellers - Ian & Giles
Expect to Learn
What Elkar gets right: speed, formatting, and a sleek interface
Where it breaks down: logic errors, disconnected assumptions, and unreliable outputs
How Elkar stacks up against other AI tools like TabAI and Agent
Why using AI without understanding modeling fundamentals can be dangerous
What it takes to turn a promising AI output into a reliable financial model
Testing Shortcut AI's bold claims: Did it live up to the hype with Giles Male
Expect to Learn
Where Shortcut impresses with formatting, speed, and usability
Where it fails, especially with modeling logic and financial accuracy
How Shortcut compares to Excel Agent and TabAI across key modeling tasks
Why reversing formatting to hide modeling errors is a huge red flag
What to consider when investing in premium AI tools for modeling
How TabAI stacks up as an Excel AI Agent for Financial Modeling Pros, with Ian and Giles
Expect to Learn
Where TabAI shines in helping analysts and where it needs improvement.
How does it compare to Excel Agent in terms of speed, usability, and accuracy?
Why finance pros still need to understand what’s going on under the hood.What to watch for when relying on tools that promise “done-for-you” modeling.
How AI Excel Tools Stackup Against the Hype and How Excel Agent Has Disrupted the Marketplace with Ian and Giles
In Episode 5 of The ModSquad on Financial Modeler’s Corner, Paul Barnhurst, Ian Schnoor, and Giles Male take a hard look at the changing landscape of financial modeling in the wake of Microsoft’s release of Excel Agent. Since launching at the end of September to coincide with Excel’s 40th birthday, Excel Agent has quickly changed the competitive dynamics for AI-powered modeling tools. The team explores the implications: how Excel Agent’s capabilities compare to other tools, why third-party platforms are shutting down, and what all this means for the future of work in modeling-heavy industries like investment banking.
Expect to Learn
Why Excel Agent is pushing competing modeling tools like Rosie AI out of the market.
What makes Excel Agent a “magnifier” of both modeling skill and error.
How fast AI is evolving inside Excel and what that means for modelers today.
Why AI won’t reduce hours in finance, despite speeding up modeling work.
What OpenAI’s Project Mercury reveals about the next phase of automation in investment banking.
Testing The New Microsoft Excel Agent for Finance Pros with Ian and Giles
In this episode of The ModSquad on Financial Modeler's Corner, Paul Barnhurst, Ian Schnoor, and Giles Male explore Microsoft’s newly released Excel Agent, a beta tool designed to bring AI into Excel Online. The team compares its performance to Rosie AI, running both through a range of tasks, including formula building, audit reviews, and a full five-year model forecast. Along the way, they test the tools against real modeling challenges like the Excel Esports case and a creative custom case, "The Humble MVP." This isn’t just about flashy tech. It’s a deeper conversation on where AI can help, where it falls short, and why core financial modeling skills still matter.
Expect to Learn
What happened when Excel Agent tried to build a full five-year forecast model?
Why solid modeling skills still beat "one-click" AI hype.
Where AI tools succeed, and fail, in reviewing formulas and detecting issues.
Why you should never fully trust AI without understanding what it’s doing.
How Excel AI Agents Like Rosie Work for FP&A Tasks but Fail at Building Models with Giles and Ian
In this episode of the ModSquad series on Financial Modeler’s Corner, host Paul Barnhurst is joined by modeling experts Ian Schnoor and Giles Male to evaluate Rosie AI, a new tool that integrates with both Excel and Google Sheets. Together, they test its capabilities in building financial models, solving complex FP&A tasks, and performing real-world use cases. They push Rosie through a series of tests, from basic formula creation to building full three-statement models, and discuss where it excels, where it needs improvement, and its potential future in the world of financial modeling.
Expect to Learn
How Rosie AI performs in real-world financial modeling tasks
The strengths and weaknesses of Rosie in building models and formulas
Key insights into how AI tools are evolving in financial modeling
The importance of knowing how to validate AI-generated models
How Rosie compares with other AI tools and traditional financial modeling techniques
Testing Excel AI Software Tracelight on Excel Esports, Financial Modeling, and FP&A with Ian And Giles
Expect to Learn
How Tracelight performs across different financial modeling scenarios
The impact of LLM selection and prompt design on tool output
Where Tracelight excels, and where it falls short, in building models and running checks
How Excel eSports challenges expose strengths and weaknesses in formula logic
When these tools can save time, and when they create more work
Introducing the ModSquad: Testing AI Financial Modeling Tools, So You Don't Have To... with Ian and Giles.
Paul, Giles, and Ian bring decades of combined experience across FP&A, corporate finance, Excel training, and financial modeling accreditation. This introductory episode sets the tone for a candid, unscripted, and deeply analytical journey into the practical realities of AI in finance.
Expect to Learn
Why AI won't replace financial modelers, but will transform the way they work
How AI tools are being developed to serve finance professionals specifically
The importance of judgment, communication, and scoping in effective modeling
What The Mod Squad plans to test: from three-statement models to Excel esports
How to prepare your career for the AI revolution in modeling
Financial Modeling for Finance Pros to Fix Real-World Mistakes Using Balance Sheets - Scott Strachan
Scott Strachan is a Chartered Accountant and Chartered Financial Modeler who has worked across the UK, the Arabian Gulf, and now serves clients in Qatar and London. He has built and reviewed complex financial models for deals worth hundreds of millions of dollars, and now contributes to the Financial Modeling Institute as a content developer and exam writer. Scott is known for applying practical thinking to modeling and helping bridge the gap between theory and real-world execution.
Expect to Learn
Why annual models are often inappropriate for startups and small businesses
The difference between one-time-use models and those built for regular updates
How poor modeling leads to funding gaps and business failure
Why EBITDA can be misleading in deal evaluationHow preparing for the CFM exam can improve your modeling skills
Why Finance Students Must Learn Discipline Before AI Replaces Their Jobs with David Stangeland
David has been teaching at the University of Manitoba’s Asper School of Business since 1991. He has a PhD from the University of Alberta and is both a CPA and a CMA. His research focuses on corporate governance and performance and has been published in top finance journals. He’s co-authored two corporate finance textbooks and currently advises the school’s $2.8 million student-managed investment fund.
Expect to Learn
The most common mistakes students make when building models
How Excel helps students better understand what they're doing
Why structure and layout matter in a financial model
The importance of combining modeling with real-world context
How the FMI curriculum is used in teaching valuation and asset management
From Classic Cars to Aircraft: The Art of Modeling Distressed Companies with Vaughan Grandin
Vaughan Grandin is the Managing Director and Head of Financial Modelling at Teneo in London. He is a Chartered Accountant with the South African Institute of Chartered Accountants and has more than 20 years of experience in corporate advisory, finance, and restructuring. He leads Teneo’s financial modelling team, which supports clients and other advisory teams by creating reliable models for distressed companies, transactions, and stakeholder analysis.
Disclaimer: All examples and stories shared in this video are from Vaughan Grandin’s previous roles and do not reflect his current employer.
Expect to Learn
Why empathy matters in financial modeling
How to approach modeling in distressed situations
The role of entity priority models and circular references
Key principles for building robust financial models
Lessons from real-world modeling cases across industries
Why Spreadsheets Will Stay, but Financial Modeling Workflow and Version Control Must Be Rebuilt with Matt Lee
Matt is the Co-Founder and CEO of Nummo, an AI co-pilot for financial modeling that he wished he had during his time in finance. Before Nummo, Matt worked as an investment banker at Lazard, helping to execute sell-side and buy-side M&A deals totaling around $6 billion in enterprise value. He also served as CFO at a digital product studio, overseeing financial planning for emerging tech products launched by Fortune 500 firms and early-stage ventures. With over 40,000 hours in Excel, Matt built Nummo to deliver a banker-grade modeling platform that runs fully on-device, maintains cell-level accuracy, and automates workflows like DCFs, LBOs, comps, and fairness opinions.
Expect to Learn
Why financial models still need human input
Where tools like Nummo can improve modeling workflows
Why version control and hidden hard codes cause major issues
How to balance automation with accuracy and narrative
Why it’s critical to never outsource your understanding of a model
How Finance Modelers and Professionals Align Stakeholders and Support M&A Success with Morten
Morten Lykke Pedersen, CFA, CFM, is a financial expert with over a decade of experience. He specializes in mergers and acquisitions (M&A), providing strategic insights that empower businesses to optimize their strategies through forecasting and risk assessment. Morten's career spans notable roles, including his tenure at PwC, where he managed valuation and modeling services. At Deloitte, Morten is dedicated to guiding businesses through complex transactions and strategic initiatives, helping them navigate industry dynamics and execute transformative transactions successfully. He holds a CFA charter and certifications in financial modeling, and his educational journey includes advanced degrees from Aarhus University, Saint Mary’s University, and the CFA Institute.
Expect to Learn
The critical role of collaboration in transaction modeling
How to build financial models that communicate a company’s story and manage risk
The importance of scenario analysis in M&A transactions
Why financial models should reflect business realities, not just numbers
How formal training programs, like the Chartered Financial Modeler (CFM), can elevate modeling skills and team capabilities
The 40th Anniversary of Excel: Unlocking the fascinating History, Easter Eggs, Excel humor, and more
In this episode of Financial Modeler's Corner, host Paul Barnhurst celebrates the 40th anniversary of Microsoft Excel, a tool that has revolutionized the financial modeling industry and many others. Paul explores Excel’s fascinating history, its evolution over four decades, and shares interesting facts, hidden Easter eggs, and fun surprises that Excel enthusiasts will appreciate. From the first graphical interface to modern-day features like dynamic arrays, this episode showcases how Excel has shaped the way we work and how it continues to be an essential tool for financial modelers.
Expect to Learn
The fascinating origin story of Excel and its early days on the Mac.
Fun facts about Excel’s features, including its secret limitations and quirky surprises.
Excel's functionality has evolved over the years to include over 500 functions.
Hidden Easter eggs and games that were embedded in older versions of Excel.
Creative and unique Excel projects, including games and pixel art, showcase the limitless possibilities within Excel.