Financial Modeler's Corner

Paul Barnhurst AKA The FP&A Guy
Financial Modeler's Corner

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. 

  1. Master The Secrets for Building Better Financial Models with The Co-founder of CFI - Tim Vipond

    3 DAYS AGO

    Master The Secrets for Building Better Financial Models with The Co-founder of CFI - Tim Vipond

    In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Tim Vipond who is a seasoned finance professional and co-founder of the Corporate Finance Institute (CFI). They discuss financial modeling nightmares, strategy’s vital role in modeling, and the importance of avoiding shortcuts. Tim also shares his unique entrepreneurial journey and offers practical advice for improving modeling and strategic decision-making. Tim Vipond began his career as an investment banking analyst and later transitioned to wealth management, corporate development, and e-commerce finance. As the co-founder of the Corporate Finance Institute, Tim has trained over 2 million students and introduced practical certifications that reshape how finance professionals develop their skills. Tim’s blend of financial expertise, entrepreneurial spirit, and focus on strategy makes him a compelling guest for this conversation. Expect to Learn: How to avoid and learn from common financial modeling mistakes.Why aligning financial models with business strategy is critical.The journey of building the Corporate Finance Institute and insights into e-learning success.The role of assumptions, execution, and scenario analysis in effective modeling.Tim’s advice on combining unique skills to propel your career. Here are a few quotes from the episode: “Never take shortcuts in your modeling. It’s tempting when you’re under pressure, but those shortcuts will come back to bite you later.”“Combining two or more unique skills is the best way to get significantly ahead in your career. It’s where you stand out and add the most value.”“Many scenarios in models are not grounded in strategy. Thoughtful, realistic scenarios tied to strategic goals are what add real value.” Tim Vipond highlighted the interplay between technical mastery and strategic insight in financial modeling. Tim provided actionable advice on avoiding pitfalls, validating assumptions, and connecting models to overarching business goals. His emphasis on skill stacking and execution underpins the value of continuous learning and adaptation in a rapidly evolving field. Follow Tim: LinkedIn - https://www.linkedin.com/in/timvipond/Website - https://vipond.com/Company - https://corporatefinanceinstitute.com/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376   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=7079020077076905984 Sign up for the a...

    44 min
  2. Why Losing My Dream Job Made Me the FP&A Tools Expert with Paul Barnhurst

    JAN 14

    Why Losing My Dream Job Made Me the FP&A Tools Expert with Paul Barnhurst

    In this special solo episode of Financial Modeler’s Corner, host Paul Barnhurst, known as the FP&A Guy, takes the spotlight to share his personal journey from a corporate financial analyst to an influential voice in financial modeling and FP&A. This episode is packed with career highlights, trends in financial modeling, and a mix of humor to kick off the new year. With over a decade of experience in corporate FP&A, Paul is a Microsoft MVP, a globally recognized trainer, and the founder of several successful podcasts. His personal story exemplifies persistence, continuous learning, and the value of building a personal brand. Expect to Learn: The career journey of Paul Barnhurst of creating a thriving business and gaining global recognition.Key lessons in financial modeling, including best practices in designing effective models.Trends shaping financial modeling and analytics for 2025, including the role of AI.Practical advice on building a personal brand and leveraging LinkedIn to grow professionally.A lighter side of finance with Paul’s humorous take on financial and Excel-related jokes. Here are a few quotes from the episode: "When I started my own business, I didn't have everything figured out, but I believed in taking the leap and figuring it out along the way.""The ability to build a personal brand is a career game changer, especially for financial professionals.""If you’re not having fun with what you do, find ways to bring your personality into your work—it makes all the difference." Paul Barnhurst takes us on a journey through his career by highlighting the lessons he’s learned and the challenges he’s faced. With light humor and practical advice, Paul inspires listeners to embrace growth, take risks, and build their own paths to success. Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376   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=7079020077076905984 Sign 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: [01:13] - Introduction and Context [02:14] - The Early Career Struggles [04:50] - The Pivot to FP&A [06:24] - Building Financial Modeling Expertise [08:44] - Starting His Own Business [15:54] - Career in Financial Modeling [17:24] - Humor and Fun [20:06] - Trends

    30 min
  3. AI vs. Human Insights in Financial Modeling to Build Accurate Models for Decision-Making

    JAN 7

    AI vs. Human Insights in Financial Modeling to Build Accurate Models for Decision-Making

    In the second part of "The Great Debate," expert financial modelers from around the globe discuss controversial and thought-provoking questions about the art and science of financial modeling. The discussion focuses on the enduring relevance of Excel, the role of AI and Power BI in shaping the future of modeling. This episode highlights the nuances, complexities, and future of financial modeling as a discipline. This episode features Giles Male, co-founder of Full Stack Modeler and an Excel MVP, Will Wardle, an independent financial modeler with over two decades of experience, Carolina Lago, founder of Classic Financial, specializing in FP&A and financial restructuring for SMEs, Hedieh Kianyfard, a project finance expert from Iran, known for her practical solutions to complex modeling challenges, Oz du Soleil, a YouTube star and Excel MVP, renowned for his engaging tutorials and insights, Rishi Sapra, a former accountant turned Power BI advocate, and David Brown, a seasoned financial modeler with 27 years of experience, excelling in blending Excel with Power BI. Expect to Learn: The role of circular references in financial models.Why named ranges in Excel can either simplify or complicate financial models.The impact of AI on the future of financial modeling.How Power BI complements financial modeling by enhancing data visualization and storytelling.The debate on the most important financial statement and how it informs decision-making. Here are a few quotes from the episode: "Dynamic arrays offer huge improvements, and we should aspire to use them more effectively as a community." - Giles Male"A three-statement model is the universal language of finance, connecting operations and strategy for decision-making." - Carolina Lago"Power BI complements financial models by adding context, automation, and storytelling, making it a must-learn tool." - Rishi Sapra This episode of The Great Debate offers a lively exploration of financial modeling. The expert panelists highlight how financial modeling combines art and science, requiring technical mastery, critical thinking, and creativity. The discussions underscored the importance of balancing simplicity with complexity, leveraging technology without losing sight of foundational principles.  Follow Giles: LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/ Follow Will: LinkedIn - https://www.linkedin.com/in/will-wardle-3396259/ Follow Carolina: LinkedIn - https://www.linkedin.com/in/s-carolinalago/ Follow Hedieh : LinkedIn - https://www.linkedin.com/in/hediehkianyfard/ Follow Oz: LinkedIn - https://www.linkedin.com/in/ozdata/ Follow Rishi: LinkedIn - https://www.linkedin.com/in/rsaprano/ Follow David: Website - a href="https://www.dbrownconsulting.net/" rel="noopener noreferrer"...

    1h 2m
  4. How to Simplify Data Integration for Finance Teams with Adam Rakich

    2024-12-31

    How to Simplify Data Integration for Finance Teams with Adam Rakich

    In this episode, host Paul Barnhurst talks about data integration, focusing on how finance professionals can streamline data processes and optimize workflows. The conversation also explores the balance between spreadsheets and specialized tools in financial modeling. He provides practical guidance for professionals navigating data challenges in the modern financial landscape.  Adam Rakich is an experienced professional in financial planning and analysis (FP&A) software and data integration solutions. With career spanning tools like Adaptive Insights, OneStream, and DataBlend, Adam brings a unique perspective on how accountants and finance teams can leverage technology to overcome data-related inefficiencies. Expect to Learn: Why assumptions in financial models can make or break their reliability.The key factors that determine when to move from spreadsheets to planning tools.How to make data integration less intimidating for finance professionals.Practical solutions for accessing data across multiple systems, including API usage and hybrid approaches.Insights into the evolving role of Excel and Google Sheets in modern financial modeling. Here are a few quotes from this episode: “Spreadsheets are not multi-user, and anyone trying to make them that way is spending more time than they should.” - Adam Rakich“For fractional CFOs, marketplaces like Zero and QuickBooks can be lifesavers with cost-effective integrations.” - Adam Rakich“Every small automation reduces time and errors, even if the entire process can’t be automated.” - Adam Rakich Adam Rakich shares the challenges and opportunities in data integration and financial modeling. He offers practical solutions to approach data integration without fear, and the evolving roles of tools like Excel, Google Sheets, and APIs. Follow Adam: LinkedIn - https://www.linkedin.com/in/rakich/Business User’s Guide to Data Integration - https://a.co/d/5xSL3g4 Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376   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=7079020077076905984 Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit a href="https://bit.ly/497oAqW" rel="noopener noreferrer"...

    54 min
  5. How Excel Competitions Transform Data Professionals into Experts Using Power Query and VBA

    2024-12-24

    How Excel Competitions Transform Data Professionals into Experts Using Power Query and VBA

    In this episode of Financial Modeler’s Corner, host Paul Barnhurst aka The FP&A Guy talks about the electrifying world of Excel Esports at the Financial Modeling World Cup (FMWC) in Las Vegas. This special episode captures the energy and innovation of the event, showcasing interviews with top competitors, including Excel MVPs and data enthusiasts, while exploring how Excel competitions push the boundaries of modeling expertise. The episode features Josh Aharonoff: Microsoft MVP, "Your CFO Guy," specializing in dynamic financial modeling and consulting. David Fortin: Excel expert, Microsoft MVP, and creator of the World of Warcraft-themed FMWC case study. Jaq Kennedy: UK-based actuarial consultant and Excel enthusiast, sharing personal stories and insights from the event. Amber Johnson: Industrial engineer turned Excel champion, known for her creative modeling approach. Expect to Learn: Insights into the competitive world of the Financial Modeling World Cup and the role of Excel Esports.Unique perspectives on the creative use of Excel, from real-world modeling to themed case studies.How Excel innovations like Power Query, dynamic arrays, and VBA are transforming data work.Personal journeys of Excel enthusiasts and their favorite tips and tools.Why participating in competitions like FMWC can rapidly enhance your financial modeling skills. Here are a few quotes from this episode: "I’ve spent 24 years working in Excel, and competing here has tripled my knowledge in just two years." - Jaq Kennedy"Competing is less about beating others and more about seeing how much you’ve improved." - Amber Johnson"Creating a case with input from Blizzard Entertainment was surreal—it brought my gaming passion into Excel." - David Fortin The Financial Modeling World Cup is a celebration of creativity, community, and growth. Events like these provide an experience of learning from the best in the field, or simply embracing the love of Excel.  Follow Josh: LinkedIn - https://www.linkedin.com/in/joshaharonoff/Website - https://www.yourcfoguy.com/ Follow David: LinkedIn - https://www.linkedin.com/in/david-fortin-cpa-816b20b5/Website - https://linktr.ee/Piggybankaccountant Follow Jaq: LinkedIn - https://www.linkedin.com/in/jaqkennedy/ Follow Amber: LinkedIn - https://www.linkedin.com/in/ambernjohnsonwmu/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376   Follow Financial Modeler's Corner   LinkedIn Page-a...

    45 min
  6. Transforming Excel Competitions into Million-Dollar Events with Andrew Grigolyunovich

    2024-12-20

    Transforming Excel Competitions into Million-Dollar Events with Andrew Grigolyunovich

    This episode takes you to the heart of the Financial Modeling World Cup (FMWC) 2024, hosted at the HyperX Gaming Arena in Las Vegas. Known as the "Excel Esports Championship," this unique event blends competitive financial modeling with the energy of live sports entertainment. From electric arenas to engaging case competitions, discover how Excel enthusiasts and world-class modelers push the boundaries of what's possible in financial modeling. This episode features an exceptional lineup of guests, including Andrew Grigolyunovich, founder of the Financial Modeling World Cup and a pioneer in turning financial modeling into an esport; Michael Jarman, the 2024 FMWC World Champion known for his innovative modeling techniques and leadership at Operis; Giles Male, a commentator and self-proclaimed “Most Humble MVP”. Klinsmann Langhanz, founder of FMWC Brasil and a passionate advocate for Excel training and community-building; and appearances from Danielle Stein Fairhurst and Jaq Kennedy. Expect to Learn: How the FMWC is transforming financial modeling into an exciting esport.Insights from top modelers on preparing for high-pressure competitions.The role of networking and community in fostering innovation and growth in the Excel world.Practical advice for improving financial modeling skills through competitions.Behind-the-scenes from the HyperX Arena, including hilarious moments. Here are a few quotes from this episode: "Financial modeling competitions make you better at work and expand your career horizons." - Andrew Grigolyunovich"The FMWC community is about helping each other, not tearing each other down." - Giles Male"The unthinkable becomes possible when you network and collaborate." - Klinsmann Langhanz With the Financial Modeling World Cup 2024, we've seen how Excel has grown from a business tool to the centerpiece of a thriving global community. From the inspiring vision of Andrew Grigolyunovich to the insights of world champion Michael Jarman, this event celebrates the art, science, and camaraderie of financial modeling. Follow Andrew: LinkedIn - https://www.linkedin.com/in/andrewgrig/Company - https://fmworldcup.com/ Follow Michael: LinkedIn - https://www.linkedin.com/in/michael-jarman-excel/Email: mjarman@operis.com Follow Giles: LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/ Follow Danielle: LinkedIn - https://www.linkedin.com/in/daniellesteinfairhurst/ Follow Klinsmann: LinkedIn - https://www.linkedin.com/in/klinsmann-langhanz/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy...

    1h 10m
  7. Excel Hacks for Financial Modelers to Simplify Valuations and Save Hours with Charles Keepman

    2024-12-10

    Excel Hacks for Financial Modelers to Simplify Valuations and Save Hours with Charles Keepman

    In this episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes Charles Keepman, a seasoned financial modeler and valuation expert, to discuss the intricacies of financial modeling, best practices, and common pitfalls. They explore real-world scenarios, discuss the value of creating dynamic models, and delve into the art of valuing companies, focusing on how different industries and stages of business impact modeling strategies. Charles Keepman has spent years honing his skills in financial modeling, starting at Ernst & Young and later working at Economics Partners (now Ryan Valuation). With deep expertise in business valuation, Charles currently applies his modeling skills to help clients make strategic financial decisions. His career trajectory has been shaped by his passion for creating efficient and dynamic financial models that help businesses make informed, data-driven decisions. Expect to Learn: Key principles for building auditable, easy-to-follow financial models.Insights into business valuation: when to use different approaches like DCF, asset, and market-based methods.The role of qualitative factors in valuation and how they can drastically influence outcomes.The role of Excel and financial modeling software in today’s fast-paced financial world.Why simplicity often trumps complexity in financial modeling, and how to strike the right balance. Here are a few quotes from Charles Keepman: "I think AI will have a profound effect on financial modeling, but we need to make sure it’s auditable and understandable.""Financial models are great tools, but the true value lies in understanding the assumptions behind them.""You can get stuck in analysis paralysis if you overcomplicate your models with too many variables." From emphasizing the importance of simplicity and clear assumptions to his preference for using tools like XLOOKUP over complex formulas, Charles provides a wealth of practical advice. His perspective on AI in financial modeling highlights the balance between leveraging technology and maintaining human judgment, ensuring that models remain accurate and useful. Follow Charles: LinkedIn - https://www.linkedin.com/in/charles-keepman-58766a40/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376   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=7079020077076905984 Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visita...

    47 min
  8. The Great Debate on AI, Excel, and the Future of Financial Modeling

    2024-12-03

    The Great Debate on AI, Excel, and the Future of Financial Modeling

    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. This lively discussion promises insights, entertainment, and plenty of surprises as the panelists 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. The powerhouse panel of financial modeling experts include: Derek Baker, FP&A professional and co-founder of the FP&A Hub; Lance Rubin, CEO of Model Citizen and Chief Excel Officer at Excel 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; and Craig Thompson, former investment banker now innovating in software at Aleph. Expect to Learn: Why financial models are (or aren’t) the ultimate decision-making tool for businesses.The role of Excel in the future: is it here to stay, or will it be replaced by emerging technologies?Power BI, Power Query, and Python in financial modeling—are they worth learning?Controversial techniques: the debate on circular references and dynamic arrays.Whether AI will eventually replace human modelers—and how soon. Here are a few quotes from the episode: "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 From the future of Excel to the role of AI, the importance of financial statements, and the tools that modelers should master, this episode explored the evolving landscape of financial modeling. Follow Derek: LinkedIn - https://www.linkedin.com/in/derek-d-baker/ Follow Lance: LinkedIn - https://www.linkedin.com/in/financial-modelling/ Follow Diarmuid: LinkedIn - https://www.linkedin.com/in/diarmuidearly/ Follow Craig H: LinkedIn - https://www.linkedin.com/in/craig-hatmaker-4449879/ Follow David: Website - https://www.davidclaytonbrown.com/ Follow Danielle: LinkedIn - https://www.linkedin.com/in/daniellesteinfairhurst/ Follow Ian: LinkedIn - a...

    1h 3m
4
out of 5
4 Ratings

About

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. 

You Might Also Like

To listen to explicit episodes, sign in.

Stay up to date with this show

Sign in or sign up to follow shows, save episodes and get the latest updates.

Select a country or region

Africa, Middle East, and India

Asia Pacific

Europe

Latin America and the Caribbean

The United States and Canada