Discover
Financial Modeler's Corner
Financial Modeler's Corner
Author: Paul Barnhurst AKA The FP&A Guy
Subscribed: 53Played: 1,296Subscribe
Share
© Copyright 2024 All rights reserved.
Description
Financial Modeler's Corner is a podcast where we talk all about the art and science of financial modeling with distinguished Financial Modeler's from around the globe. Financial Modeler's Corner is hosted by Paul Barnhurst, aka The FP&A Guy, a global thought leader in the field of finance.
The Financial Modeler's Corner podcast is brought to you by Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling.
The Financial Modeler's Corner podcast is brought to you by Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling.
158 Episodes
Reverse
In this episode of Financial Modeler's Corner, host Paul Barnhurst speaks with Lance Rubin, Founder of Model Citizn, about how AI is changing financial modeling, accounting, and finance workflows. They explore why AI-generated models can look accurate while hiding flawed assumptions, why human oversight remains essential, and how finance professionals can use AI without compromising accuracy or trust.Expect to LearnWhy AI-generated models can contain hidden errors.Why human oversight is essential in finance.How AI skills and guardrails improve workflows.Why Excel and Power BI remain important.How to adopt AI without compromising accuracy.Here are a few quotes from the episode:“The human has to be in the loop. The human has to check it.” - Lance Rubin“If you don't use AI properly, it actually creates more human work rather than less.” - Lance RubinLance explains why AI adoption requires more than automation. Strong financial knowledge, clear processes, and human oversight are essential for reliable results.Follow Lance:LinkedIn - https://www.linkedin.com/in/financial-modelling/Website - https://www.modelcitizn.com/Disclosure: Portions of this episode (such as the introduction or promotional segments) use AI-generated voice narration produced under human editorial review.In Today's Episode[00:00] - Introduction[05:53] - Writing an AI Accounting Book[07:50] - AI Model Improvements[10:08] - Who Should Use AI-Powered Accounting?[13:11] - Five Levels of AI Accounting[14:19] - Autonomous Finance & Human Oversight[16:08] - Managing AI Hallucinations[18:56] - Why Excel Skills Matter[21:50] - Final Thoughts & Closing Remarks
In this episode of Financial Modeler's Corner, host Paul Barnhurst welcomes Lance Rubin, Founder of Model Citizn, to discuss how AI is transforming financial modeling, accounting, and FP&A. They explore the risks of AI-generated financial models, the importance of human oversight, and why strong financial modeling skills remain essential.Lance Rubin is a Chartered Accountant and financial modeling expert based in Melbourne, Australia. As the Founder of Model Citizn, he specializes in financial modeling, data analytics, AI-powered solutions, and data-driven decision-making. He also provides fractional CFO services and helps businesses improve their financial processes using Excel, Power BI, and AI.Expect to LearnWhy AI-generated financial models can look accurate while containing serious errors.How human oversight helps prevent costly financial mistakes.Why Excel and Power BI remain essential in AI-powered finance.How AI skills, workflows, and guardrails improve reliability.Why fully autonomous finance systems present significant risks.Here are a few quotes from the episode:“The human has to be in the loop. The human has to check it.” - Lance Rubin“I like to translate all AI work into formulas, into deterministic logic that I check, then I can trust it. Otherwise, I can't.” - Lance RubinLance shares insights from his AI-powered accounting book and training program, explaining how finance professionals can automate repetitive tasks, build reliable AI workflows, and improve productivity without sacrificing accuracy, transparency, or critical thinking.Follow Lance:LinkedIn - https://www.linkedin.com/in/financial-modelling/Website - https://www.modelcitizn.com/Disclosure: Portions of this episode (such as the introduction or promotional segments) use AI-generated voice narration produced under human editorial review.In Today's Episode:[00:00] - Introduction[03:50] - Career Corner[07:41] - Lance's Financial Modeling Career[14:35] - Writing an AI-Powered Accounting Book[21:52] - Five Levels of AI-Powered Accounting[28:12] - Why Excel Skills Still Matter[34:28] - The Risks of Uploading Financial Models to AI[40:46] - Rapid-Fire Financial Modeling Questions[47:43] - Closing Remarks & Thanks
In this episode of Financial Modeler’s Corner, Giles Male turns the tables on regular host Paul Barnhurst, also known as The FP&A Guy, to discuss Paul’s journey through FP&A, financial modeling, training, entrepreneurship, and the growing impact of AI on finance. They explore how Paul built his personal brand, transitioned from corporate finance into his own business, and developed a career centered around education, community, and connecting people across the FP&A ecosystem.Expect to LearnHow Paul built The FP&A Guy brand.Why entrepreneurship comes with different risks.What makes financial modeling training effective.How AI is changing financial modeling.Why human judgment still matters.Lessons from rebuilding a difficult model.Here are a few quotes from the episode:“What's the point of keeping a goal going for the sake of a goal if it doesn't make sense?” - Paul Barnhurst“AI is going to change it, but trust still matters, and there will be areas you want a human.” - Paul BarnhurstPaul explains how his career evolved from corporate FP&A into a business built around training, podcasts, software research, educational content, and professional connections. He also discusses how AI can help financial modelers work more efficiently while emphasizing that judgment, creativity, and an understanding of the business remain essential. Follow Giles:LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/Disclosure: Portions of this episode (such as the introduction or promotional segments) use AI-generated voice narration produced under human editorial review. In Today's Episode:[00:00] - Introduction[03:03] - A Week in the Life of The FP&A Guy[07:39] - How Paul Built His FP&A Brand[12:12] - Lessons From Posting Consistently on LinkedIn[15:42] - Leaving Corporate Life & Starting a Business[21:42] - What Makes Financial Training Effective[31:06] - Human Judgment & Creativity in Financial Modeling[35:14] - Paul’s Worst Financial Modeling Experience[42:17] - Rapid-Fire Financial Modeling Questions[47:37] - What’s Next for The FP&A Guy
In this episode of Financial Modeler's 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 LearnHow 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 don't 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 EarlyDiarmuid 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 Today's 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
In this episode of Financial Modeler's Corner, host Paul Barnhurst sits down with Taimour Zaman to discuss why AI-generated financial models often fail to convince lenders, what investors really look for when evaluating financing opportunities, and how financial modelers can build more credible models by focusing on risk, capital protection, and realistic exit strategies.Taimour is the Founder and Chief Capital Strategist of AltFunds Global, a financial advisory firm with offices in Canada and Switzerland. With more than 11 years of experience, he has advised operators and project sponsors on structured finance transactions ranging from $1 million to $500 million. He has developed 13 structured finance programs and built a network of more than 900 brokers.Expect to Learn:Why AI-generated financial models often fail to meet lenders' expectations.The three critical factors investors look for: capital protection, returns, and exit strategies.How to approach financial modeling from a lender's perspective rather than a borrower's.Why geopolitical risks, currency fluctuations, and unexpected events matter in financing decisions.Here are a few relevant quotes from the episode:“Put yourself in the lender banker's shoe. Know and understand the world is full of shocks and surprises and build me a model that protects and manages my risk.” — Taimour Zaman“So it's AI assisted model building rather than AI building the entire model.” — Taimour ZamanTaimour explains that a strong financial model is not simply about projecting growth or presenting impressive numbers. It must demonstrate how investors can protect their capital, receive their expected returns, and recover their investment when things do not go according to plan.Follow Taimour:Website: https://altfundsglobal.com/Substack: https://taimour1.substack.com/Follow Financial Modeler's Corner: LinkedIn: https://www.linkedin.com/company/financial-modeler-s-corner/Newsletter - Subscribe on LinkedIn: https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation today and get 15% off using the code “Podcast” at https://bit.ly/497oAqWDisclosure: Portions of this episode (such as the introduction or promotional segments) use AI-generated voice narration that has undergone human editorial review.In Today's Episode:[00:00] - Trailer[06:16] - Taimour's Journey Into Structured Finance[10:34] - Real Estate & Alternative Financing[16:55] - Building Models From an Investor's Perspective[19:57] - Managing Risk & Exit Strategies[22:20] - What Lenders Look for in Financial Models[27:17] - Real-World Financing Risks[32:14] - The Right Role for AI in Modeling[36:00] - Rapid Fire & Closing Advice








