Financial Modeler's Corner

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

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 for 2025

[25:43] - Rapid Fire Financial Modeling Opinions

[28:14] - Closing Remarks

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 - https://www.dbrownconsulting.net/

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:23] - Introduction to the Panel

[05:51] - Circular References in Models

[10:14] - The Use of VBA

[14:55] - Dynamic Arrays Debate

[19:57] - Named Ranges in Excel

[24:50] - Will Excel Ever Die?

[33:43] - Can AI Build Models?

[37:56] - Should Modelers Learn Power BI?

[53:28] - Most Important Skill for Modelers

[57:40] - Closing Remarks

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

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- 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: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

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: [email protected]

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  
• 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:

[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

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’.

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

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 - 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=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: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

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

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 insights
• Challenges and advantages of modeling in Power BI
• How AI is changing financial modeling and what the future might hold
• Liam’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’.

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