Financial Modeler's Corner

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 LearnWhy 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.Here are a few quotes from the episode:“You can't hit a prompt, go get a coffee, and expect a working model.” – Giles Male“If you don’t understand what the AI just built, you’re in trouble.” – Ian SchnoorThis episode makes it clear: AI is not a replacement for skill; it’s a multiplier. Excel Agent may be setting the new standard, but success still comes down to human understanding, judgment, and accountability. As the modeling world evolves rapidly, professionals who stay informed and upskill will thrive. The Mod Squad isn’t slowing down either; more tool reviews and sharp conversations are coming.Follow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [05:29] - AI Tools Recap[07:26] - AI Hype and Hidden Risks[10:23] - AI as a Skill Magnifier[13:48] - Microsoft’s Impact on AI Startups[16:15] - Rapid Evolution of Excel AI[21:29] - OpenAI’s Role in Financial Modeling[29:17] - Understanding Assumptions and Calculations[31:53] - Final Thought

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 LearnWhat 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.Here are a few quotes from the episode:“Building a model is like flying a plane; you don’t want a rookie in charge when something breaks.” - Ian Schnoor“You can’t hit a prompt, go get a coffee, and expect a working model.” - Giles MaleFollow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [02:21] - What is an Excel Agent and why does it matter?[05:37] - Sharpen Your Modeling Skills[06:51] - Modeling Requires Human Judgment[09:27] - Esports Case: Rosie AI vs Excel Agent Test[19:39] - Excel Agent Hangs in Beta Mode[25:26] - Testing PVM in the Smoothie Business Case[30:01] - Ian Takes Over: Testing Excel Agent on AFM Model[44:11] - Building a five-year forecast model from scratch[55:19] - Adding a revolver to the model[01:00:12] - Why the balance sheet doesn’t balance[01:03:46] - Final thoughts and takeaways

Note: This episode was recorded and scheduled for release before the recent announcement that Rosie AI is shutting down.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 LearnHow Rosie AI performs in real-world financial modeling tasksThe strengths and weaknesses of Rosie in building models and formulasKey insights into how AI tools are evolving in financial modelingThe importance of knowing how to validate AI-generated modelsHow Rosie compares with other AI tools and traditional financial modeling techniquesHere are a few quotes from the episode:“AI can’t replace the need for modelers to understand the logic, but it can help speed up certain tasks.” - Giles Male“If you know what you’re doing, these tools can save you time. If you don’t, you need to double-check everything.” - Ian SchnoorFollow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/Rosie AI: https://www.askrosie.ai/In today’s episode: [02:23] - Excel Turns 40[07:29] - Microsoft’s AI Agent vs. Modeling Tools[16:18] - Exploring Rosie’s Website and Features[25:35] - Real-World FP&A Test: Trial Balance Summary[35:53] - Deferred Revenue Schedule Test[50:54] - Detecting Inconsistent Formulas in Financial Models[01:00:53] - Testing Rosie AI on a Five-Year Forecast Model Build[01:08:31] - Final Thoughts: Where AI Helps and Where It Doesn’t

Disclaimer: This episode is best experienced in video format. Since we’re testing new tools like Tracelight, the visuals add valuable context and make everything much clearer. We highly recommend watching the video for the full experience.In this episode of the ModSquad series on Financial Modelers’ Corner, host Paul Barnhurst is joined by modeling experts Ian Schnoor and Giles Male to evaluate Tracelight, a new Excel-based modeling tool. Together, they explore how well it performs across real-world use cases in FP&A, Excel eSports, and corporate finance. From auditing balance sheets to solving Excel battle cases and building five-year forecast models, the ModSquad puts Tracelight through a comprehensive test to assess what it gets right, what it gets wrong, and where it still needs improvement.Expect to LearnHow Tracelight performs across different financial modeling scenariosThe impact of LLM selection and prompt design on tool outputWhere Tracelight excels, and where it falls short, in building models and running checksHow Excel eSports challenges expose strengths and weaknesses in formula logicWhen these tools can save time, and when they create more workHere are a few quotes from the episode:"If you don't know your stuff, you're going to learn the wrong things; or worse, think it's right when it’s not." - Giles Male"The best Excel modellers aren’t the fastest, they’re the most thoughtful."-  Ian Schnoor Follow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/Tracelight: https://tracelight.ai/In today’s episode: [02:22] - Tracelight Overview & Positioning[09:46] - Giles vs. Excel eSports Battle Case[18:00] - Reviewing Tracelight’s Logic and Output[28:04] - Advanced Test: Championship-Level Modeling[33:59] - AI Tools and the Learning Curve[41:49] - Deferred Revenue Schedule Test[56:26] - Why Doesn’t the Balance Sheet Balance?[1:02:21] - Fixing Balance Sheet Errors Using Cloud Opus[1:316:00] - Episode Wrap-Up and Final Thoughts

In this special launch episode of The Mod Squad, host Paul Barnhurst is joined by co-hosts Giles Male and Ian Schnoor to explore the evolving intersection of artificial intelligence and financial modeling. Together, they introduce a new podcast series, The ModSquad, designed to test AI tools built for financial modelers, FP&A professionals, and analysts. The trio shares their excitement, cautious optimism, and the pressing questions they hope to answer through hands-on experimentation with cutting-edge tools that promise to transform the modeling landscape. 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 LearnWhy AI won't replace financial modelers, but will transform the way they workHow AI tools are being developed to serve finance professionals specificallyThe importance of judgment, communication, and scoping in effective modelingWhat The Mod Squad plans to test: from three-statement models to Excel esportsHow to prepare your career for the AI revolution in modelingHere are a few quotes from the episode:“Just because it looks cool doesn’t mean it gives you a finished product.” - Giles Male“Modeling is just as much the journey as it is the destination.” - Ian SchnoorFollow Ian Schnoor:LinkedIn -  https://www.linkedin.com/in/ianschnoor/Follow Giles Male:LinkedIn -  https://www.linkedin.com/in/giles-male-30643b15/In today’s episode: [01:21] - Introduction of the Episode[04:57] - Why This Series? Helping Modelers Cut Through the AI Noise  [09:14] - Fear & Job Security: Will AI Replace Financial Modelers?  [14:14]- The Human Element in Modeling: Judgment, Communication, Scoping  [21:03] - Series Format: Tools We’ll Test & Why  [26:03] - Testing Assignments: Who’s Doing What?  [29:03] - FP&A Use Cases Paul Will Explore  [35:21] - What to Expect: Raw Prompts, Real Results  [36:52] - Closing: Why This Series Matters & How You Can Engage

In this episode of Financial Modeler’s Corner, host Paul Barnhurst speaks with financial modeling expert Scott Strachan about the role of financial models in business planning and decision-making. Scott shares lessons from over 30 years of experience in accounting, consulting, private equity, and corporate finance. The discussion covers the importance of modeling for startups, the problems with annual models, the risks of overrelying on EBITDA, and how the FMI certification has helped him stay sharp in a changing industry. 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 LearnWhy annual models are often inappropriate for startups and small businessesThe difference between one-time-use models and those built for regular updatesHow poor modeling leads to funding gaps and business failureWhy EBITDA can be misleading in deal evaluationHow preparing for the CFM exam can improve your modeling skillsHere are a few quotes from the episode:“A model is just an appendix to a business plan. If you don’t understand your market or product, no model will save you.” - Scott Strachan“EBITDA is a fantasy land metric. It ignores reality and tells you what you want to hear, not what you need to know.” - Scott Strachan“Every business fails because of bad management, and that often starts with not modeling your cash needs properly.” - Scott StrachanFollow Scott:LinkedIn - https://www.linkedin.com/in/scott-strachan-ca-a795851a4/?utm_source=share&utm_campaign=share_via&utm_content=profile&utm_medium=ios_appFollow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign 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

In this episode of Financial Modeler’s Corner, Host Paul Barnhurst sits down with David Stangeland, a finance professor at the University of Manitoba, to talk about teaching financial modeling, how students learn best, and the tools that have changed over the years, from PV tables to Excel. David shares what he's learned from more than 30 years in the classroom, why planning is so important in modeling, and how he uses real money investing through a student-managed fund to teach hands-on skills. He also talks about the value of the FMI curriculum, the role of judgment in modeling, and why he still learns something new every time he teaches. 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 LearnThe most common mistakes students make when building modelsHow Excel helps students better understand what they're doingWhy structure and layout matter in a financial modelThe importance of combining modeling with real-world contextHow the FMI curriculum is used in teaching valuation and asset managementHere are a few quotes from the episode:“There’s no one right answer in valuation. It’s about making good assumptions and thinking through your logic to build a credible story.” - David Stangeland“Don’t think you know it all. Always be open to learning and improving. That mindset will take you further than any formula.” - David Stangeland“Spreadsheets aren’t going anywhere. Whether it’s Excel or something else, that flexible grid is still the best way to work with data.” - David StangelandFollow David:LinkedIn - https://www.linkedin.com/in/david-stangeland-phd-cpa-cma-b-comm-29773946/?originalSubdomain=caFollow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign 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:...

In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Vaughan Grandin, Managing Director and Head of Financial Modeling at Teneo. They discuss his experiences building financial models in distressed situations, the importance of empathy in working with clients, and provide examples of complex models, including those from the airline, aircraft leasing, and classic car dealership industries.Vaughan Grandin is the Managing Director and Head of Financial Modeling 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 LearnWhy empathy matters in financial modelingHow to approach modeling in distressed situationsThe role of entity priority models and circular referencesKey principles for building robust financial modelsLessons from real-world modeling cases across industriesHere are a few quotes from the episode:“Empathy is a word I think about a lot in modeling, especially in distressed situations.” - Vaughan Grandin“A good model should be able to take whatever inputs you give it and actually use them to solve a problem.” - Vaughan Grandin“In distressed situations, time pressure is real; sometimes, a company only has weeks of cash left.” - Vaughan GrandinFollow Vaughan:LinkedIn - https://www.linkedin.com/in/vgrandin/?originalSubdomain=ukCompany - https://www.teneo.com/person/vaughan-grandin/Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign 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: [03:22] - Model Horror Stories [06:52] - Empathy in Modeling [07:55] - Inside Teneo’s Team [12:50] - Classic Car Dealership Model [21:16] -...

In this episode of Financial Modeler's Corner, host Paul Barnhurst is joined by Matthew Lee, Co-Founder and CEO of Nummo, a software tool built to help analysts and bankers build financial models more efficiently. Matt explains why he started the company after years in investment banking and as a CFO, and what he sees as the real opportunities and limits of automation in financial modeling. The conversation covers the pressure of dealing with work, common modeling mistakes, and where tools like Nummo can help speed things up without replacing analysts. Matt also shares thoughts on what makes a good model and why hands-on understanding still matters most.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 LearnWhy financial models still need human inputWhere tools like Nummo can improve modeling workflowsWhy version control and hidden hard codes cause major issuesHow to balance automation with accuracy and narrativeWhy it’s critical to never outsource your understanding of a modelHere are a few quotes from the episode:We’re about 30% of the way there. AI can help, but it can’t yet build a fully detailed, nuanced model.” - Matthew Lee“Even with automation, you still need to check for hidden hard codes and make sure your model tells the right narrative.” - Matthew Lee“Formatting, standardization, and QA are where AI is already adding value today.”- Matthew LeeFollow Matthew:LinkedIn - https://www.linkedin.com/in/matthew-m-lee/Company - https://www.nummo.xyz/Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit

In this episode of Financial Modeler's Corner, host Paul Barnhurst is joined by Morten Lykke Pedersen, a seasoned financial expert and Partner at Deloitte, where he leads the financial modeling division within the Strategy, Risk, and Transaction Advisory group. Morten discusses his extensive experience in mergers and acquisitions (M&A), strategic financial modeling, and how financial models can empower businesses to make informed, data-driven decisions. He also shares insights on the importance of collaboration during the modeling process, tips for ensuring client engagement, and the role of financial models in presenting a company’s equity story.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 LearnThe critical role of collaboration in transaction modelingHow to build financial models that communicate a company’s story and manage riskThe importance of scenario analysis in M&A transactionsWhy financial models should reflect business realities, not just numbersHow formal training programs, like the Chartered Financial Modeler (CFM), can elevate modeling skills and team capabilitiesHere are a few quotes from the episode:“Financial modeling is about understanding the business, not just crunching numbers.” - Morten Lykke Pedersen“A financial model should only do what it’s supposed to do, keep it simple and fit for purpose.” - Morten Lykke Pedersen“It’s not about the formulas; it’s about making sure the people who own the numbers understand what’s going on in the model.” - Morten Lykke PedersenFollow Morten:LinkedIn -  https://www.linkedin.com/in/mortenlykkepedersen/?originalSubdomain=dkCompany - https://www.linkedin.com/company/deloitte/Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign up for the a...

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 LearnThe 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.Here are a few quotes from the episode:"The first version of Excel only had 150 functions, and now we’re up to 516! That’s quite a leap over 40 years." - Paul Barnhurst"Sometimes, the most creative projects come from using Excel in ways you never thought possible, like pixel art or creating a full video game." - Paul Barnhurst"The tool of choice for modelers is Excel, and it has a lot more to offer than meets the eye." - Paul BarnhurstFollow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign 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: [02:17] - 16 Fun Facts About Excel[08:11] - Excel's Evolution[14:58] - Excel Easter Eggs[16:55] - Excel Jokes to Lighten the Mood[19:13] - Epic Excel Creations: Stunning Art[23:11] - Wrapping Up and Final Thoughts

In this republished episode of the Financial Modeler’s Corner, host Paul Barnhurst revisits the intricate world of financial modeling with returning guest Christopher Reilly. The conversation centers around what is necessary to build robust financial models, highlighting the importance of three-statement models and cash flow forecasting. The episode is filled with practical insights, advanced techniques, and professional experiences that underscore the significance of simplicity, accuracy, and best practices in financial modeling.Christopher Reilly is a seasoned financial modeler with extensive experience in consulting, private equity, and financial modeling education. Starting his career during the financial crisis, Chris worked on high-profile bankruptcies such as Lehman Brothers and Rescap. His journey took him from a senior analyst role at Hilton Worldwide to a middle-market private equity firm, and eventually led to founding his own financial modeling education business. Today, he focuses on teaching and building financial models, with his work being featured by Wharton Online, Wall Street Prep, and LinkedIn Learning, among others.Expect to Learn:The importance of simplicity in financial models and how over-complicating can hinder their effectiveness.Practical steps and considerations for building robust three-statement financial models.Tips for auditing models to ensure accuracy and integrity.How to use advanced Excel functions and shortcuts to enhance modeling efficiency.Insights into the role of AI in financial modeling and how it may shape the future of the profession.Here are a few quotes from the episode:“All models are wrong, some are useful, and if it’s too complicated, it’s not useful.” - Chris Reilly“AI won’t replace modelers, but it will complement us by improving assumption accuracy and reducing bias.” - Chris Reilly“Use the BASE structure: Beginning, Addition, Subtraction, Ending, it’s the easiest way to audit support schedules.” - Chris ReillyFollow Christopher:Website - https://www.financialmodelingeducation.com/LinkedIn - https://www.linkedin.com/in/chris-reilly-mission-capital/  Follow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and...

In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Sarah Schlott, founder of The Schlott Company. Sarah shares her perspective on why financial models often fail, not because of bad math, but because they don’t reflect how real businesses work. She talks about what it takes to earn trust as a finance partner, how to clean up messy data without losing momentum, and the importance of getting the right people involved in the process. Sarah and Paul also dive into how finance teams can shift from reactive number-crunchers to proactive business partners that bring clarity and confidence to decision-making.Sarah Schlott is a strategic finance leader with over 18 years of experience guiding companies through growth, M&A, and operational change. She’s worked across corporate finance, forecasting, budgeting, and reporting infrastructure. Sarah is the founder of The Schlott Company, where she helps founders bring order to financial chaos. Her approach blends classic FP&A with modern tools and a deep understanding of real-world business dynamics. She believes finance should bring clarity, not confusion.Expect to LearnWhy overly complex models usually create more confusion than insightWhat it means to be “battle-tested” as a finance leaderHow to build models that reflect business reality, not just spreadsheetsWhat to do when the data is unreliable or inconsistentWhy involving department heads early leads to better models and better outcomesHere are a few quotes from the episode:"When you’re constantly fighting about the numbers, you’re not ready to present the model." - Sarah Schlott"If the people who own the numbers don’t see themselves in the model, you should probably just chuck it." - Sarah Schlott"Stop being the cop. Be the radio tower that keeps everything aligned."  Sarah SchlottFollow Sarah:LinkedIn - https://www.linkedin.com/in/sarahschlott/Website - http://www.sarahgschlott.com/Company - https://theschlottco.com/Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit

In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Nico Christie, co-founder of Fundamental Research Labs and creator of Shortcut, the superhuman Excel agent. Nico shares insights into his fascinating journey, from being a professional athlete to leading groundbreaking AI projects. Together, they explain how AI is revolutionizing financial modeling and making Excel smarter than ever before. Nico also discusses his work at Fundamental Research Labs, where they aim to build digital humans using AI, and the development of Shortcut, which aims to streamline the way we use Excel for financial modeling tasks. Nico Christie is the co-founder of Fundamental Research Labs and the CEO of Shortcut, a cutting-edge AI tool designed to supercharge Excel. Nico’s diverse background spans professional athletics, corporate finance, and AI research. His work at Fundamental Research Labs focuses on building AI that mimics human-like qualities, such as emotional experiences and consciousness. Nico has a passion for both technology and the real-world applications of AI in tools like Excel, making complex tasks faster and more intuitive.Expect to LearnHow Shortcut is revolutionizing Excel for financial modeling with AI.The process behind building digital humans at Fundamental Research Labs.Nico’s journey from professional dunker to AI innovator.How AI tools like Shortcut are transforming the financial modeling landscape.Insights on the future of AI in Excel and the response from companies like Microsoft.Here are a few quotes from the episode:"I just think Excel is the most beautiful design software ever created by humans." - Nico Christie"The goal of the company is to build digital humans, giving AI all of the fundamental human qualities, not just intelligence." - Nico Christie"People who were initially afraid of AI are no longer afraid once they see how it can be used in software engineering." - Nico ChristieFollow Nico:LinkedIn - https://www.linkedin.com/in/nicochristie/Twitter - https://x.com/nicochristie Follow Paul: Website - https://www.thefpandaguy.com  LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguy                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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visita...

In this episode of Financial Modeler's Corner, host Paul Barnhurst sits down with Patrick Daguet, a seasoned finance professional, educator, and structured finance expert for a thoughtful and inspiring conversation about the real-world side of financial modeling. With over four decades in the industry, Patrick shares what he's learned from years of building models, working on massive infrastructure deals, and teaching the next generation of finance professionals. From navigating the challenges of project finance to celebrating those satisfying “balance sheet balances” moments in the classroom, Patrick offers a grounded, practical perspective on how modeling works beyond the spreadsheet.Patrick is the President of Sharklets, a training company specializing in CFA, FRM, and CAIA prep, and a Senior Professor at IÉSEG School of Management. With a background in structured finance, infrastructure projects, and model design, he bridges academic rigor with practical experience. He has helped train thousands of finance professionals across the globe and continues to lead CFM study groups. Patrick’s love for teaching is matched by his real-world expertise, having worked on major infrastructure deals, including France’s national stadium.Expect to LearnWhy financial models should be treated as decision-making tools, not just math.What makes project finance models more complex than corporate ones.The real-world impact of financial models, from runways to stadiums.How teaching has shaped Patrick’s understanding of modeling.Why lifelong curiosity is the key to staying relevant in finance.Here are a few quotes from the episode:“A financial model is a decision tool that incorporates all the information necessary to form your own judgment." - Patrick Daguet"I fell into teaching when people told me I had a talent for explaining the complex clearly." - Patrick Daguet"You are sentenced to lifelong learning when you choose a career in finance." - Patrick DaguetFollow Patrick:LinkedIn - https://www.linkedin.com/in/patrickdaguet/Email - p.daguet@ieseg.frFollow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit

In this episode of Financial Modeler's Corner, host Paul Barnhurst invites "Your Average Finance Bro," for a light-hearted and humorous conversation about financial modeling. The episode takes a comedic spin on the often serious world of finance, diving into the importance of Excel, the art of building memorable models, and even how Excel proficiency can play a role in dating. Expect a mix of fun and insight, with Finance Bro offering his unconventional wisdom about financial modeling, presenting with confidence, and making your work stand out in the finance world.Your Average Finance Bro, is a renowned figure in the financial modeling world. He has built a reputation not just for his financial modeling skills but also for his humorous take on the profession. He's a self-proclaimed founder of Goldman Sachs, inventor of the discounted cash flow model, and someone who has been involved in some of the most memorable (and fictional) moments in finance history. Finance Bro brings a fun and unconventional approach to the world of finance, often blending humor with expert insights.Expect to LearnThe importance of memorability in financial modeling and how it can impact your career.Why Excel continues to dominate financial modeling and how Finance Bro contributed to its popularity.The lighter side of financial modeling, including hilarious pranks and Excel jokes.How to present financial models with confidence, even if the numbers are questionable.The essential skills and mindset needed for financial modelers to stand out, especially in high-pressure situations.Here are a few quotes from the episode:"Memorability is extremely important in financial modeling. If you screw up, people will remember that forever." - Your Average Finance Bro"The ability to present a model is more important than the model itself." - Your Average Finance Bro"If you can't teach someone how to build a model, you’re not teaching them anything at all." - Your Average Finance BroFollow Finance Bro :LinkedIn - https://www.linkedin.com/in/your-average-finance-bro/Instagram - https://www.instagram.com/youraveragefinancebro/?hl=enWebsite - linktr.ee/financebroYouTube - youtube.com/@youraveragefinancebroFollow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-

In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Dr. Stephen Horan to discuss the fundamentals of financial modeling, the challenges and rewards of teaching finance, and how curiosity and simplicity are central to both education and professional modeling. Dr. Horan draws on his extensive experience as a finance professor and former Managing Director at CFA Institute, offering unique insights into the intersection of academia, practical modeling, and credentialing.Dr. Stephen is a finance professor at UNC Wilmington and former Managing Director at the CFA Institute. He has over 30 years of experience in academia and industry, has authored award-winning research, and co-wrote Strategic Value Investing, featured on Warren Buffett’s reading list. His work bridges theory and practice in finance education. Dr. Horan is also a sought-after speaker and serves on editorial boards for leading finance journals.Expect to LearnWhat makes a model readable and useful and why fundamentals matter.How to teach financial modeling in a way that’s active and practical.The difference between book knowledge and real-world application in finance.Insights into CFA Institute’s evolution toward practical skills and global relevance.The mindset and skills students need to transition from learning to doing.Here are a few quotes from the episode:"Curiosity is the skill I had to learn and it’s the one that’s helped me most in my career." - Stephen Horan"Give someone the experience of building a model and solving problems. That’s the real education." - Stephen Horan"The ability to explain how you built a model is more powerful in an interview than listing courses on a résumé."  Stephen HoranFollow Stephen:LinkedIn - https://www.linkedin.com/in/stephenhoranphd/Twitter - http://twitter.com/StephenHoranCFAFollow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign 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: [02:07] - Guest Introduction [04:19] - Modeling Horror Story [10:41] - Bridging Theory and...

In this episode of Financial Modeler’s Corner, host Paul Barnhurst speaks with Janice Shade and Michael Tapia about the intersection of sustainability, financial modeling, and education. They share the behind-the-scenes creation of a unique MBA course focused on sustainable finance and modeling at Bard College. The episode dives into horror stories from the modeling trenches, highlights the challenges of teaching complex topics in an accessible way, and explores the future of financial education and tools.Janice is a systems entrepreneur and finance educator with over 30 years of experience. She has worked with both for-profit and nonprofit ventures, focusing on democratic access to capital and economic justice. Janice is also the author of Moving Mountains and teaches finance at Bard’s MBA in Sustainability program. Michael transitioned from the fitness industry into sustainable finance. With an MBA in Impact Finance from Bard, he co-developed and co-taught a financial modeling course that incorporates ESG data and sustainability into traditional financial analysis. Michael is passionate about inclusive, community-driven investment strategies and financial education.Expect to LearnWhat makes a financial model “fit for purpose”, and why complexity isn’t always better.How financial modeling can support sustainability and social impact.Tips for teaching finance to non-finance students and building curriculum from the ground up.The importance of scenario and sensitivity analysis in forecasting.Practical insights on bridging theory and hands-on financial modeling in academia.Here are a few quotes from the episode:"Finance shouldn't feel mystical or exclusive, our goal is to make it approachable and relevant." - Janice Shade"As a former trainer, I saw how performance metrics drove change. Now I see capital can do the same, if used with purpose." - Michael Tapia"Forecasting is hard, and no forecast is ever right. We're just trying to make it less wrong." - Janice ShadeFollow Janice:LinkedIn - https://www.linkedin.com/in/janice-shade/Website - https://innovatecapital.org/teamFollow Michael:LinkedIn - https://www.linkedin.com/in/michael-tapia-Follow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign up for the Advanced Financial...

In this episode of Financial Modeler’s Corner, host Paul Barnhurst and co-host Carolina Lago explore their experiences with financial modeling and the Advanced Financial Modeler (AFM) certification. They discuss the value of these certifications, the challenges of studying for them, and how these programs can improve financial modeling skills. They also provide helpful tips and insights into preparing for the Chartered Financial Modeler (CFM) certification.Carolina is a financial modeling and FP&A specialist with over 20 years of experience. She holds the Advanced Financial Modeler (AFM) certification from the Financial Modeling Institute (FMI) and is working toward the Elite Certified Financial Modeler (CFM) credential. Carolina is passionate about teaching financial modeling and helping professionals use financial models to make better strategic decisions. Her workshops focus on best practices, scenario analysis, and providing businesses with the tools needed to navigate financial challenges.Expect to LearnThe definition of a financial model and how to differentiate it from other types of business models.Tips for studying for the AFM and CFM certifications, including managing time effectively and balancing models as you work.Carolina’s experience preparing for the AFM and how to build financial models quickly under pressure.The importance of practice in financial modeling and how to improve speed and efficiency.The differences between the AFM and CFM certifications and why both are valuable for financial modelers.Here are a few quotes from the episode:"Even if I don’t pass the first time, I will have already succeeded by learning new techniques and improving my skills." - Carolina Lago"You need to be resourceful and think quickly when preparing for the CFM. It’s about adapting to complexity in multiple areas." - Carolina Lago"A financial model is anything that has inputs, calculations, and outputs, but at the same time answers a business question." - Carolina LagoFollow Carolina:LinkedIn - https://www.linkedin.com/in/s-carolinalago?originalSubdomain=chWebsite - carolinalago.comCourse Tactic On-Demand: https://tacticfinancial.com/financial-model-for-you/newsletter:  https://pages.tacticfinancial.com/thetacticalroomFollow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-

In this episode of Financial Modeler's Corner, host Paul Barnhurst sits down with Jon Acampora to discuss the ever-evolving world of financial modeling, focusing on Excel. Jon shares about the importance of creating user-friendly models and the impact of Excel Esports on financial modeling skills. The conversation covers best practices for building efficient models, lessons from Excel competitions, and how new technologies like Power Query and AI are shaping the future of modeling.Jon is the founder of Excel Campus, a Microsoft MVP, and an expert in helping Excel users simplify and automate their workflows. With over 600,000 YouTube subscribers, Jon is passionate about making Excel both fun and efficient. He’s also a regular commentator for Excel Esports competitions, where Excel professionals compete to solve complex modeling challenges in real time. Jon’s mission is to help people leverage Excel to boost productivity and creativity, making financial modeling more accessible and enjoyable.Expect to LearnThe importance of building financial models that are easy for others to understand and use.Jon's take on the role of Excel Esports in advancing modeling skills and fostering creativity.How Power Query can save you hours of data processing time in Excel.Why financial modelers should focus on simplicity and automation rather than over-complicating their models.Insights into the future of financial modeling with the integration of Python and AI tools.Here are a few quotes from the episode:“AI is great at generating code, but it’s the human creativity that still leads the way.” - Jon Acampora“As an Excel professional, it's important to make models that others can easily work with, even if they don't have the same technical skills you do.” - Jon Acampora“If you want to be great at Excel, you have to understand that learning never stops. There’s always something new to discover.” - Jon AcamporaFollow Jon:LinkedIn - https://www.linkedin.com/in/jonacampora/YouTube - https://www.youtube.com/user/ExcelCampusWebsite - https://www.excelcampus.com/Follow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguyFollow 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visita...