Bölümler
-
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 SapraThis 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 - -
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/@thefpaguy8376Follow 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
-
Eksik bölüm mü var?
-
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/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- -
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: [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... -
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/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.
Visit
-
In this 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 - -
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/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.
Visit https://bit.ly/497oAqW and use the code “Podcast” to save...
-
In this 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/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.
Visit
-
In this 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-makingHere 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/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.
Visit...
-
In this episode, 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/carlseidmanFollow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow 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
-
In this episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) is joined by guest Mark Proctor. Together, they delve into the intricacies of financial modeling and data analysis, with a focus on building efficient models and leveraging automation in Excel. Mark shares his deep expertise on why structure is key, how to automate tedious tasks, and how Excel continues to evolve to meet the demands of modern financial professionals.
Mark Proctor is a seasoned financial professional with a background in accounting and finance, an Excel MVP, and the founder of Excel Off the Grid, a platform dedicated to improving efficiency and effectiveness in Excel. With decades of experience, Mark's insights are invaluable for anyone looking to optimize their use of Excel for financial modeling and beyond. He has helped countless professionals streamline their work through better data structure and automation techniques.
Key takeaways from this week's episode include:
Key differences between financial modeling and data analysisImportance of automation in Excel and how tools like Power Query and Power Pivot can drastically improve efficiency.Why traditional tools like Vlookup aren’t ideal for modern data analysis and what functions you should be using instead.How to approach building models that are flexible and easy to use, even when multiple stakeholders are involved.Practical strategies for reducing manual processes and eliminating the need for repetitive tasks in Excel.Here are a few quotes from Mark Proctor:
"Hard coding is the enemy of a flexible financial model. Once you start hard coding, you lose the ability to see what's really driving the model.""One of the key takeaways from bad models is that manual adjustments should always be documented and trackable.""Automation should be about freeing up your time to focus on high-value tasks, not just about making things faster."As Excel continues to evolve with powerful features like dynamic arrays and advanced automation, the tools discussed in this episode are essential for anyone looking to keep pace with the future of financial modeling. Mark’s emphasis on mastering the basics and thinking structurally will help you work faster and more effectively.
Follow Mark:
Website - https://exceloffthegrid.com/LinkedIn - https://www.linkedin.com/in/markstephenproctor/Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn- -
In this episode of Financial Modeler’s Corner, host Paul Barnhurst dives into the evolution of financial modeling with guest Chase Wright. The discussion focuses on modern financial modeling tools and workflows, particularly a new spreadsheet tool called Equals, and how it compares to Excel and Google Sheets. Wright shares his journey from a finance background to working at startups, where he developed innovative methods to streamline financial operations using cutting-edge tools.
Chase Wright is a seasoned finance executive with a decade of experience across startups and tech companies like GitLab, Instabug, and Red Hat. Currently the Head of Finance and Data at Uniqode, Chase has a unique blend of corporate finance, data science, and business management expertise. He’s also an advisor to Cacheflow and a limited partner at FOG Ventures. With an engineering background and deep experience in finance, Chase brings a fresh perspective on the challenges and innovations in financial modeling.
Key takeaways from this week's episode include:
How Chase Wright’s career journey led him to innovate in financial modelingThe role of modern spreadsheet tools like Equals in finance and data teamsHow to use tools like Equals to automate reporting and financial analysisThe importance of balancing curiosity and necessity when developing career skillsThe pros and cons of traditional modeling tools like Excel and Google Sheets versus newer alternativesHere are a few quotes from Chase Wright:
“Equals is a modern spreadsheet for data and finance teams, connecting directly to your data sources.” - Chase Wright“Financial models are incredibly helpful, but at the end of the day, it's the intuition behind the model that really matters.” - Chase Wright“Slack integration in Equals makes communicating insights across the company incredibly simple.” - Chase Wright“AI in Equals acts as a copilot, making things like summing columns or adding borders incredibly intuitive.” - Chase WrightIn this episode, Chase Wright shares his journey from struggling with complex models in Excel to embracing the automation and connectivity that Equals offers highlights the growing need for more intuitive and efficient financial tools. He emphasizes that the right tools, combined with critical thinking, can not only improve workflows but also provide deeper insights that drive business success.
Follow Chase:
Website - https://www.uniqode.com/LinkedIn - https://www.linkedin.com/in/chasewright/Blog - https://medium.com/uniqode-secret-sauce/an-operators-guide-for-managing-your-saas-startup-s-cash-flow-c1dbfc3a1e71Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- -
In this innovative episode, Paul Barnhurst experiments with Google’s AI tool, Notebook LM, and transforms previous guest interviews into an AI-generated episode. He explores the insights and best practices in financial modeling, as shared by veterans Scott Rostan, founder of Training the Street, and Ian Bennett, a PwC Australia leader with extensive experience in managing large modeling teams.
By leveraging AI, this episode explores how technology can recreate meaningful conversations with industry leaders, providing an interactive look at best practices, common pitfalls, and the evolving landscape of financial modeling. Paul explores advanced technical skills and the human elements that are essential to successful financial modeling.
Key takeaways from this week's episode include:
Four essential key pillars for excelling in financial modelingStrategies for maintaining simplicity and auditability in financial modelsEmerging tools in Excel and functionality of traditional financial modelingHow financial modeling expertise goes beyond technical skills Insights on the potential future of financial modeling with AI advancementsQuotes from the Episode:
"Even in the world of complex finance, sometimes the simplest approach is the best approach." - Scott Rostan"It’s about seeing the big picture, understanding your client’s needs and using your modeling skills to craft a solution, not just a spreadsheet." - Ian Bennett"AI will get really good at those technical tasks, cleaning up data, maybe running some basic forecasts, but that just frees us humans up to focus on the stuff that requires creativity, critical thinking, and emotional intelligence." - AIIn this special AI-driven episode, Paul Barnhurst invites listeners to consider how the field of financial modeling is both grounded in foundational skills and evolving with new technologies. It’s about connecting with clients, asking the right questions, and using your skills to drive better business decisions.
Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow 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:17] Introduction to the episode
[03:57] Lessons from modeling mistakes
[06:29] Four key pillars of financial modeling
[08:51] Managing large-scale...
-
In this episode of Financial Modelers Corner, host Paul Barnhurst dives deep into the world of Quality of Earnings (QofE) with expert guest Patrick McMillan, a seasoned CFO and transaction advisor. The conversation explores the intricacies of QofE, its importance in financial transactions, and the role it plays in assessing a company's financial health during mergers and acquisitions. Patrick shares real-world examples and insights into how financial professionals can use QofE to make informed decisions.
Patrick McMillan is a fractional CFO and transaction advisor at Amplēo, a Utah-based firm specializing in providing executive support to growing companies. With over two decades of experience in guiding businesses through periods of growth and M&A transactions, Patrick is known for his expertise in Quality of Earnings analysis. He brings a dynamic and passionate approach to finance, blending technical skill with strong storytelling abilities to help businesses navigate complex financial landscapes.
Key takeaways from this week's episode include:
The role of Quality of Earnings (QofE) in mergers and acquisitions, and how it differs from an audit.How to differentiate between non-recurring and operating items when analyzing financial statements.The importance of normalizing earnings for better understanding of a company’s performance.Why soft skills like communication and storytelling are crucial in financial analysis.Insights into how personal finance modeling can improve your financial modeling skills.Here are a few quotes from Patrick McMillan:
"Quality of earnings isn't just an audit; it shows you how and why a company is performing in a certain way." - Patrick McMillan"Understanding non-operating and non-recurring items is crucial to a quality of earnings report." - Patrick McMillan"Patience is the most important lesson I’ve learned in my career, especially in communication." - Patrick McMillan"Modeling your own personal finances is a great way to practice financial modeling skills." - Patrick McMillanWith actionable advice on financial modeling, transaction strategies, and lessons learned from his personal experiences, Patrick’s insights will resonate with professionals looking to sharpen their financial skills and improve decision-making in dynamic business environments.
Follow Patrick:
Website - https://ampleo.com/contact/LinkedIn - https://www.linkedin.com/in/patrickmcmillan/Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn- -
In this episode of Financial Modelers Corner, host Paul Barnhurst welcomes Ruby Liu, Director at KPMG Australia’s Valuation Team, to dive into intricacies of financial modeling. Having led KPMG Australia’s Sydney modeling team and worked as the head of corporate finance in the energy sector, Ruby’s vast experience spans from transactional modeling for infrastructure assets to advising clients on valuation and capital raising. Ruby Liu brings over 16 years of professional expertise in corporate finance, financial modeling, and valuations.
This episode offers practical insights on managing complex financial models, optimizing processes, and the challenges of transitioning models from transactional to operational use. Ruby’s guidance provides a valuable learning opportunity on how to build efficient and user-friendly financial models. Her deep knowledge and hands-on experience make her a key voice in the field of financial modeling.
Key takeaways from this week's episode include:
The key differences between transactional and operational models and how to adapt them for long-term use.Why keeping the model user in mind is crucial for building effective financial models.Ruby’s top strategies for creating models that are simple, visually appealing, and efficient in calculation speed.Insights into the challenges of working with large, complex models and how to manage issues.How Ruby’s experiences at KPMG shaped her understanding of the financial modeling landscape.Here are a few quotes from Ruby Liu:
"The most efficient model isn’t the one with the most complex formulas, but the one that’s easy to understand and use." - Ruby Liu"In financial modeling, the goal is to fit the user’s purpose, not dazzle them with complexity." - Ruby Liu"I think AI can help build models, but we’ll still need human oversight to interpret the results." - Ruby LiuIn this insightful episode, Ruby Liu offers a masterclass in financial modeling. From her candid reflections on the pitfalls of overly complex models to the importance of keeping the end user in mind, Ruby’s practical advice is invaluable for both novice and seasoned modelers alike.
Follow Ruby Liu:
LinkedIn - https://www.linkedin.com/in/liurubyFollow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’.
Visit
-
In this special solo episode, host Paul Barnhurst, also known as "The FP&A Guy," reflects on key insights gathered from past episodes of Financial Modeler’s Corner. With over 40 episodes under his belt, Paul dives into recurring rapid-fire questions posed to expert financial modelers worldwide. From circular references to VBA use and Excel's future, this episode offers valuable wisdom on the art and science of financial modeling.
Paul Barnhurst, an accomplished financial modeling professional and host of the podcast, takes center stage. Paul is the founder of “The FP&A Guy” and has earned the prestigious Advanced Financial Modeler (AFM) certification from the Financial Modeling Institute (FMI). His wealth of experience and insights makes this solo episode both engaging and informative.
Key takeaways from this week's episode include:
The most common preferences of expert financial modelers on key technical decisions.Why dynamic arrays and other Excel functions are becoming increasingly important, and the pace of their adoption.Insights into how artificial intelligence (AI) could impact financial modeling and whether it will replace human modelers.The importance of good design principles in financial models, as shared by leading financial modeling experts.Fun and practical Excel shortcuts used by seasoned modelers to boost efficiency and accuracy.Here are a few quotes from Paul in this episode:
"Circular references are dangerous because most people don’t really understand what’s going on, and it can lead to other errors in your model." - Paul Barnhurst"If at all possible, don’t use VBA in your model. The less you use it, the simpler the model is." - Paul Barnhurst"I’m of the belief that AI will build models for us. It’s a question of when, not if." - Paul BarnhurstIn this special solo episode, Paul Barnhurst takes a moment to reflect on the lessons learned from over 40 episodes of Financial Modeler’s Corner. He shares key takeaways from the rapid-fire questions posed to some of the top financial modelers in the world, offering a wealth of advice on best practices, common pitfalls, and emerging trends in financial modeling. As always, he invites listeners to reach out with feedback, questions, and guest suggestions, reinforcing the show's commitment to fostering a global community of financial modeling enthusiasts.
Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow 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’....
-
In this episode of Financial Modelers Corner, host Paul Barnhurst welcomes Paul Medici, founder and CEO of Medici Financial Modeling. They dive into the art and science of financial modeling, sharing horror stories, insights, and practical tips on how to avoid common pitfalls. The discussion revolves around the importance of simplicity and structure, and how mastering the fundamentals can save time and deliver better results.
Today’s guest is Paul Medici, the Founder and CEO of Medici Financial Modeling. With over a decade of experience, Paul specializes in building bespoke financial models and custom data automation tools for corporate clients across the US, Canada, and Europe. His expertise spans a wide range of industries, including financial services, healthcare, manufacturing, mining, real estate, retail, technology, and even charitable organizations. He holds an MBA from the University of Toronto and a Master’s in Geological Science and Engineering from Queen’s University.
Key takeaways from this week's episode include:
The most common mistakes in bad financial models and how to avoid them.How a background in geology led Paul Medici to a career in financial modeling.The importance of understanding revenue and cost build-ups in different industries.Why practicing financial modeling on personal projects can enhance your skills.Key shortcuts and techniques to speed up your Excel modeling process.Here are a few quotes from Paul Medici:
"All bad models have one thing in common: they're not user-friendly, difficult to update, and time-consuming." - Paul Medici"Most corporate models start simple but turn into 'Frankenstein' models over time as people add complexity." - Paul Medici"If you're thinking about financial modeling, practice by building models for everyday tasks like personal budgets." - Paul Medici"The key to mastering financial modeling is understanding how the financial statements and supporting schedules link together." - Paul MediciFrom his early career in geology to teaching advanced Excel at top investment banks, Paul brings a wealth of knowledge to the conversation. He emphasizes the importance of building user-friendly models, practicing regularly, and finding the right balance between complexity and functionality.
Follow Paul Medici:
Website - https://medicifinancialmodeling.com/LinkedIn - https://www.linkedin.com/in/paulmedici/Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn- -
In this episode of the "Financial Modelers Corner," host Paul Barnhurst welcomes Gilbert Hangartner, a financial modeler with a background in science. The discussion delves into the intricacies of financial modeling, the importance of simplicity in model construction, and the application of Monte Carlo simulations to understand risk. Gilbert shares his insights on how to approach financial modeling by asking the right questions rather than having complex formulas.
Gilbert Hangartner is a seasoned financial modeler who transitioned from a career in science, specializing in chemistry and physics, to financial modeling and risk analysis. His scientific training gives him a unique perspective on financial modeling, treating it as both a creative process and a technical discipline. Gilbert emphasizes the importance of simplicity and clarity in building effective models and is an advocate for using models as tools for communication and strategic decision-making.
Key takeaways from this week's episode include:
Understanding the importance of simplicity in modeling The debate on whether financial modeling is more of an art or a scienceSimplifying a problem and understanding the question before diving into model building.Introduction to Monte Carlo simulations for risk managementA discussion on the limitations of Excel and future of financial modelingHere are a few quotes from Gilbert Hangartner:
"A good model is not about complexity; it's about clarity and answering the right question." - Gilbert Hangartner"For me, modeling is a creative act, much like writing a song or painting a picture." - Gilbert Hangartner"Multi-dimensional modeling is key; real-world problems are never just two-dimensional." - Gilbert Hangartner"The future of financial modeling lies beyond Excel; it’s time for more advanced, structured tools." - Gilbert HangartnerIn this episode, Gilbert Hangartner offers a fresh perspective on the world of financial modeling and challenges the conventional wisdom that financial models must be complex to be effective. Whether you're a seasoned modeler or just starting out, Gilbert's insights on Monte Carlo simulations provide valuable guidance on how to enhance your modeling skills and approach.
Follow Gilbert:
LinkedIn - https://www.linkedin.com/in/gilbert-hangartner-71754047/Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow 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
-
In this episode of Financial Modelers Corner, host Paul Barnhurst is joined by Giles Male, who brings his unique perspective on the rapidly changing landscape of financial modeling. Together, they explore how the latest advancements in Excel—such as dynamic arrays and Lambda functions—are revolutionizing the way financial models are built and used. Giles also provides invaluable advice on the importance of simplicity, adaptability, and effective communication in modeling.
Giles Male is a CMA-qualified accountant and a seasoned financial modeler with extensive experience in bid analysis and complex financial modeling. As a co-founder of Full Stack Modeler, Giles is passionate about training and mentoring the next generation of financial modelers. He holds the prestigious Master Financial Modeler (MFM) accreditation from the Financial Modeling Institute, making him one of only seven individuals worldwide to have achieved this honor. Giles brings a wealth of knowledge on modern Excel and its application in financial modeling.
Key takeaways from this week's episode include:
The importance of embracing modern Excel techniques, including dynamic arrays and Lambda functions.Insights into the changing landscape of financial modeling and why simplicity is often more effective than complexity.The challenges and rewards of transitioning from traditional modeling methods to modern approaches.How Giles's experiences in ultra-marathon running have influenced his approach to problem-solving and pushing beyond perceived limits in both personal and professional contexts.Practical advice on maintaining model integrity, including the use of structured standards like FAST or SMART while adapting to specific project needs.Here are a few quotes from Giles Male:
"Simplicity is the biggest lesson I’ve learned in my career. Complex models might seem impressive, but they’re often impractical." - Giles Male"A good financial model should be as complex as it needs to be, but as simple as possible." - Giles Male"There’s a visibility fog when reviewing your own models. Stepping away and coming back later is essential." - Giles MaleIn this episode, Giles Male offers a wealth of insights into the evolving world of financial modeling. He emphasizes the importance of simplicity, the transformative power of modern Excel, and the critical need for clear communication in model design. As the industry continues to evolve, Giles’s focus on adaptability, continuous learning, and user-centric design serves as a guide for both seasoned professionals and newcomers alike.
Follow Giles:
Website - https://www.fullstackmodeller.com/LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page-... -
In this episode of Financial Modelers Corner, Paul Barnhurst dives into the intricacies of financial modeling, focusing on cash flow forecasting and continuous planning with FP&A expert Randy Brown. Randy shares his unique journey from music school to becoming a financial consultant and emphasizes the importance of practical financial strategies, especially in volatile markets.
Randy Brown is a seasoned financial consultant with a rich background in FP&A, corporate finance, and financial modeling. After initially pursuing a career in music, Randy transitioned into finance, where he has built a successful career, particularly in cash flow management and continuous planning. His approach blends technical financial skills with real-world business acumen, making him a sought-after consultant in the industry.
Key takeaways from this week's episode include:
The critical importance of cash flow forecasting for business stability.Practical steps to build a 13-week cash flow forecast.Why continuous planning is more effective than traditional annual budgeting.Common pitfalls in financial modeling, including the dangers of circular references and external workbook links.Randy’s insights on managing finances for small to medium-sized businesses, especially in distressed situations.Here are a few quotes from Randy Brown:
"The minute you create a budget, it’s meaningless. The business environment changes too fast for a static plan." - Randy Brown"For cash flow forecasting, it’s all about identifying your sources and uses of cash and laying them out on a calendar." - Randy Brown"The flexibility of working from home and being my own boss was the number one driver for becoming an independent consultant." - Randy Brown"Learn relational data structures; understanding how data relates will improve every analytical task you do." - Randy BrownIn this insightful episode, Randy Brown shared his wealth of knowledge on financial modeling, continuous planning, and the critical importance of cash flow forecasting. His emphasis on the importance of relationships, the simplicity of effective cash forecasting, and the pitfalls of traditional budgeting methods offers a fresh perspective for financial professionals striving to improve their modeling practices.
Follow Randy:
Website - https://www.instagram.com/randy_brown/LinkedIn - https://www.linkedin.com/in/randyjbrown/Follow Paul:
Website - https://www.thefpandaguy.com LinkedIn - https://www.linkedin.com/in/thefpandaguy YouTube - https://www.youtube.com/@thefpaguy8376Follow Financial Modeler's Corner
LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true Newsletter - Subscribe on LinkedIn- - Daha fazla göster
