

Financial Modeler's Corner
Paul Barnhurst AKA The FP&A Guy
Financial Modeler's Corner is a podcast where we talk all about the art and science of financial modeling with distinguished Financial Modeler's from around the globe. Financial Modeler's Corner is hosted by Paul Barnhurst, aka The FP&A Guy, a global thought leader in the field of finance.
The Financial Modeler's Corner podcast is brought to you by Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling.
The Financial Modeler's Corner podcast is brought to you by Financial Modeling Institute. FMI offers the most respected accreditations in financial modeling.
Episodes
Mentioned books

Jan 21, 2025 • 44min
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=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:53] Financial Modeling Horror Stories[06:03] Building the Corporate Finance Institute[11:18] The Role of Strategy in Modeling[19:07] Execution and Modeling Feasibility[22:11] Scenarios and Sensitivity Analysis[30:52] Tim’s Favorite Investments and Skill Stacking[34:48] Unique Modeling Stories[36:06] Rapid Fire Questions[41:14] Closing Thoughts and Advice

Jan 14, 2025 • 30min
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=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: [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 for 2025[25:43] - Rapid Fire Financial Modeling Opinions[28:14] - Closing Remarks

Jan 7, 2025 • 1h 2min
AI vs. Human Insights in Financial Modeling to Build Accurate Models for Decision-Making
Will Wardle, a seasoned financial modeler, Carolina Lago, an expert in financial restructuring, and Rishi Sapra, a Power BI advocate, engage in a dynamic discussion on the future of financial modeling. They tackle the ongoing relevance of Excel and debate the impact of AI on creativity versus efficiency in modeling. The conversation also highlights the merits of Power BI for enhanced data visualization and storytelling. Packed with insights, this dialogue reveals the critical skills necessary for modern financial modelers in a rapidly evolving landscape.

Dec 31, 2024 • 54min
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 RakichAdam 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/5xSL3g4Follow 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=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: [01:30] – Introduction to the Episode[07:18] – Adam’s Career Journey[09:38] – Moving Beyond Spreadsheets[16:56] – Why Data Integration Matters[21:03] – Common Methods of Accessing Data[32:35] – SQL vs. Modern Tools[37:46] – The Business User’s Guide to Data Integration[44:32] – Rapid-Fire Questions[52:47] – Closing Thoughts

Dec 24, 2024 • 45min
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 FortinThe 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/PiggybankaccountantFollow 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- 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: [01:27] - Introduction and Event Overview[03:39] - Interview with Josh Aharonoff and David Fortin[10:12] - Horror Stories and Excel Lessons[12:25] - Excel Preferences [23:04] - Interview with Jaq Kennedy[30:14] - Rapid Fire with Jaq[33:27] - Interview with Amber Johnson[42:22] - Closing Thoughts and FMWC Invitation[43:02] - Giles Male's Anthem

Dec 20, 2024 • 1h 10min
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 LanghanzWith 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.comFollow 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 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=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: [00:01:42] - Host Paul Barnhurst sets the stage[00:03:59] - A recap of the event's atmosphere[00:07:13] - Interview: Andrew Grigolyunovich[00:12:14] - Vision for the Future of FMWC[00:22:54] - Creating FMWC Case Studies[00:34:13] - Michael Jarman's Journey[00:49:50] - Commentary with Giles Male[00:56:22] - Jaq Kennedy and Danielle Stein Fairhurst [00:58:24] - Interview: Klinsmann Langhanz[01:08:38] - Closing Thoughts

Dec 10, 2024 • 47min
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=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: [01:24] - Introduction to Charles Keepman[02:03] - The "Worst Financial Model" Horror Story[05:57] - A Rundown of Charles’ Career[09:04] - The Favorite Part of Financial Modeling[14:53] - The Most Unique Uses of Excel in Personal Life[17:26] - Valuing a Company: The First Steps[21:43] - The Most Unique Business Models[23:41] - Excel vs. Deal Work[27:03] - The Simplicity vs. Complexity Debate[32:49] - Excel's Evolution: Favorite Features[36:20] - Rapid Fire Segment[45:27] - Final Advice and Closing

Dec 3, 2024 • 1h 3min
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 BrownFrom 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 - https://www.linkedin.com/in/ianrbennett/Follow Craig T:LinkedIn - https://www.linkedin.com/in/cfthompson/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=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: [01:42] - Introduction to the Episode[04:16] - The Debate Battle Starts [07:12] - Should Financial Modelers Learn Python?[11:15] - Dynamic Arrays vs. Traditional Models[16:52] - Will Excel Ever Die?[20:55] - Should Financial Modelers Learn Power BI?[26:21] - Will AI Build Financial Models?[32:09] - Circular References: Useful or Evil?[39:27] - VBA in Financial Models[44:41] - Number One Corporate Decision Making Tool[52:58] - Which Financial Statement is Most Important? [59:50] - Conclusion and Audience Poll

Nov 26, 2024 • 45min
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 LearnWhy 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=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: [01:19] - Introduction to the Episode and Guest[05:37] - Sean’s Background and Career Journey[08:09] - Key Lessons from M&A Experience[12:43] - Responsibilities in Corporate Development[17:10] - Favorite Deals and Lessons Learned[21:37] - Building Effective Financial Models[30:11] - Ensuring Alignment in Financial Modeling[34:36] - Lessons from a Career in Corporate Development[37:39] - Rapid-Fire Questions[42:59] - Closing and Networking

Nov 19, 2024 • 57min
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 innovationHere 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:52] – Introduction to guest Liam Bastick[03:44] – Liam’s Modeling Horror Stories[08:32] – Liam’s Professional Journey and Challenges[14:17] – Running a Business and Reinvention[16:05] – Discussing AI’s Impact on Financial Modeling[20:39] – Books and Teaching Tips[35:50] – Rapid Fire: Excel Best Practices[46:57] – Advanced Modeling Techniques and Final Tips[54:16] – Contact Information and Wrap Up