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. How Excel Competitions Transform Data Professionals into Experts Using Power Query and VBA

    8 HRS AGO

    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
  2. Transforming Excel Competitions into Million-Dollar Events with Andrew Grigolyunovich

    4 DAYS AGO

    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
  3. Excel Hacks for Financial Modelers to Simplify Valuations and Save Hours with Charles Keepman

    DEC 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
  4. The Great Debate on AI, Excel, and the Future of Financial Modeling

    DEC 3

    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
  5. How Aligning Strategy with Modeling Transforms Corporate Deals with Sean Corcoran

    NOV 26

    How Aligning Strategy with Modeling Transforms Corporate Deals with Sean Corcoran

    In this episode of Financial Modelers Corner, Paul Barnhurst aka The FP&A Guy dives deep into the intersection of corporate development and financial modeling, focusing on mergers and acquisitions (M&A). Sean Corcoran, a seasoned expert with over 20 years in corporate development, shares his insights on navigating complex transactions, building effective financial models, and driving strategic growth through acquisitions. Sean Corcoran is the Head of Corporate Development at DigiCert and has an illustrious career spanning Fortune 50 companies, private equity-backed ventures, and public firms. With experience leading over 60 acquisitions worth billions, Sean has a comprehensive understanding of the M&A lifecycle, strategic planning, and financial modeling. Expect to Learn Why simplicity and strategy are vital in corporate development financial models.Common pitfalls in financial models and how to avoid them.The importance of aligning strategic intent and integration during acquisitions.How FP&A professionals can transition into corporate development roles.The evolving tools and techniques in M&A due diligence and decision-making. Here are a few quotes from Sean Corcoran: "Culture is one of the key criteria for successful acquisitions; the only way to assess it is to spend time with the prospective target.""A strategic partnership often evolves into an acquisition when both sides see value and alignment.""From a corporate development perspective, simplicity is king when building financial models.""AI is starting to play a role in M&A, especially in reviewing contracts and highlighting potential red flags." From understanding the nuances of culture in acquisitions to navigating the challenges of carve-outs and earnouts, this episode offers an insightful conversation that highlights the complexity and opportunity within corporate development and the critical role of financial modeling. Follow Sean: LinkedIn - https://www.linkedin.com/in/sean--corcoran/ 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...

    45 min
  6. Excel Problem-Solving Strategies for Financial Modelers to Build Robust Models with Liam Bastick

    NOV 19

    Excel Problem-Solving Strategies for Financial Modelers to Build Robust Models with Liam Bastick

    In this engaging episode of Financial Modelers Corner, host Paul Barnhurst, aka "The FP&A Guy," sits down with Liam Bastick, Managing Director of Sum Product and a highly respected figure in financial modeling and Excel expertise. Known for his complex modeling work, quirky sense of humor, and love for a good challenge, Liam shares insights into the nuances of financial modeling, discusses his favorite Excel tips, and reveals his fascination with the evolving role of AI in modeling. Liam Bastick is a seasoned corporate trainer, author, and financial modeling expert, with a focus on Excel, Power BI, and AI applications. With a career that includes awards like Microsoft’s Most Valuable Professional and the inaugural Lifetime Achievement, international recognition, and extensive teaching, Liam provides listeners with both practical advice and fascinating anecdotes from his career. Expect to Learn: Excel optimization tips and learn how to effectively use Quick Access toolbar Circular references and financial modeling horror story insightsChallenges and advantages of modeling in Power BIHow AI is changing financial modeling and what the future might holdLiam’s approach to problem solving to stay at the forefront of innovation Here are a few quotes from Liam Bastick: “The best tip I can give is to put the tools you use most often on the Quick Access toolbar. It’s underused but incredibly helpful.”“If you've got circular references in your model, you’re already on thin ice. They can lead to wrong answers and complete chaos.”“With AI, you can do the front-end and back-end work in financial modeling, but it’s still not there yet for the mechanics in the middle.” In this insightful episode, Liam Bastick shared his passion for financial modeling, bringing both humor and depth to complex topics in Excel, Power BI, and AI. His reflections on adaptability, continuous learning, and challenging the limits of traditional tools serve as powerful reminders for anyone in finance or data analysis.  Follow Liam: Website - https://www.sumproduct.com/LinkedIn - https://www.linkedin.com/in/liam-bastick-73a39114/ 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...

    57 min
  7. Why Skills & Storytelling Matter More Than Degrees in Financial Modeling – Rachit Jain

    NOV 12

    Why Skills & Storytelling Matter More Than Degrees in Financial Modeling – Rachit Jain

    In this insightful episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes financial modeling expert Rachit Jain. They delve into the nuances of financial modeling, exploring the art of building accurate, reliable models and the importance of critical thinking and lifelong learning in finance. Rachit shares real-world horror stories from his early career, reflects on the challenges of predictive modeling, and emphasizes the human elements that make models truly effective. Rachit Jain is a seasoned financial modeler with extensive experience in finance, auditing, and quantitative modeling. Having worked with firms like Hewlett Packard and Deloitte, Rachit brings a wealth of knowledge on creating models that inform decision-making and avoid critical pitfalls. His expertise spans FP&A, data science, and quantitative finance, making him an authority on building dynamic, real-world financial models. Expect to Learn: How to build trust in financial models through transparency and sound designWhy critical thinking and communication skills are crucial in financial modelingRachit’s career journey and his transition from audit to financial modelingThe role of data science in enhancing financial modeling capabilitiesStrategies for applying financial modeling in personal decision-making Here are a few quotes from Rachit Jain: "The first step in financial modeling is critical thinking – you need to know what you want to achieve before you start building.""In financial modeling, curiosity is everything. It’s what drives you to improve and learn beyond the basics.""Before starting in financial modeling, understand what part of FP&A suits your skills. Not everyone is a ‘numbers person,’ and that’s okay." In this episode, Rachit Jain highlights financial modeling as both an art and science, emphasizing the importance of accuracy, clarity, and storytelling. Rachit’s approach shows that great financial modeling goes beyond numbers; it requires curiosity, critical thinking, and a balance between simplicity and sophistication. Follow Rachit: LinkedIn - https://www.linkedin.com/in/jainrachit1008/ 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...

    42 min
  8. Fractional CFO Insights on Financial Modeling and Business Turnaround with Carl Seidman

    NOV 5

    Fractional CFO Insights on Financial Modeling and Business Turnaround with Carl Seidman

    In this episode, Paul Barnhurst, host of Financial Modeler’s Corner, is joined by Carl Seidman, an experienced financial consultant and financial modeling expert. Together, they explore the intricacies of financial modeling, discuss the art and strategy of dynamic cash flow modeling, and touch on the unique challenges and lessons Carl has gathered from his years in turnaround consulting. They also discuss the broader skills and mindset shifts required for modelers who aim to excel in the complex field of financial analysis and corporate finance. Carl Seidman is the founder of Seidman Financial and a recognized expert in financial planning, forecasting, and modeling. With experience in turnaround consulting and as a fractional CFO, Carl has worked extensively with underperforming companies and complex restructuring cases. He brings an in-depth understanding of the strategic nuances in financial modeling and cash flow management, which he shares in this episode. Key takeaways from this week's episode include: The importance of long-term, flexible thinking in financial modeling and planning.Carl’s top lesson learned from a modeling “horror story” and how it shaped his approach to dynamic modeling.How dynamic arrays are transforming cash flow modeling and how to implement them.Why operational knowledge is crucial for effective financial modeling in turnaround situations.The value of networking and formal certifications in restructuring and financial advisory roles. Here are a few quotes from Carl Seidman: "Financial modeling in complex situations is about facilitating discussions, not just presenting numbers." "A good model tells you the ‘what,’ but the analysis and conversations that follow tell you the ‘so what’ and ‘now what.’""It's important to know when to push the boundaries of what a model can do and when to keep things simple." In this insightful episode, Carl Seidman leaves listeners with practical advice and a fresh perspective on financial modeling’s role in modern business. He highlights the value of flexibility, clear communication, and a long-term mindset, particularly in the complex terrain of turnaround consulting. Follow Carl: Website - https://seidmanfinancial.com/LinkedIn - http://linkedin.com/in/carlseidman 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

    46 min
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