Financial Modeler's Corner

Paul Barnhurst AKA The FP&A Guy
  • 4,9 (11)
  • ADMINISTRAÇÃO
  • QUINZENAL
Financial Modeler's Corner

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

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

    HÁ 3 DIAS

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

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

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

    5 DE NOV.

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

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

    46min
  3. The Secrets to Automating Data Integration and Reporting in Excel With Mark Proctor

    29 DE OUT.

    The Secrets to Automating Data Integration and Reporting in Excel With Mark Proctor

    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/@thefpaguy8376   Follow Financial Modeler's Corner   LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-a href="https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984" rel="noopener noreferrer"...

    48min
  4. Next-Level Financial Modeling with AI and Automation for CFOs with Chase Wright

    22 DE OUT.

    Next-Level Financial Modeling with AI and Automation for CFOs with Chase Wright

    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 alternatives Here 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 Wright In 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-c1dbfc3a1e71 Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376   Follow Financial Modeler's Corner   LinkedIn Page-a href="https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true" rel="noopener...

    42min
  5. A Ground Breaking AI Generated Podcast on Financial Modeling with Paul Barnhurst

    15 DE OUT.

    A Ground Breaking AI Generated Podcast on Financial Modeling with Paul Barnhurst

    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 advancements  Quotes 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." - AI In 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/@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:17] Introduction to the episode [03:57] Lessons from modeling mistakes [06:29] Four key pillars of financial modeling [08:51] Managing large-scale...

    35min
  6. How to Build Superior Financial Models for M&A With Patrick McMillan

    8 DE OUT.

    How to Build Superior Financial Models for M&A With Patrick McMillan

    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 McMillan With 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/@thefpaguy8376   Follow Financial Modeler's Corner   LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-a href="https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984" rel="noopener noreferrer"...

    45min
  7. The Future of Financial Modeling with AI Usability and Best Practices featuring Ruby Liu

    1 DE OUT.

    The Future of Financial Modeling with AI Usability and Best Practices featuring Ruby Liu

    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 Liu In 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/liuruby Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpaguy8376   Follow Financial Modeler's Corner   LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visita...

    52min
  8. VBA, AI, and Excel - Paul Barnhurst’s Key Takeaways from 40 Episodes

    24 DE SET.

    VBA, AI, and Excel - Paul Barnhurst’s Key Takeaways from 40 Episodes

    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 Barnhurst In 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/@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’....

    32min
Ver tudo (53)

Trailer

4,9
de 5
11 avaliações

Sobre

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. 

Informações

  • Criado por
    Paul Barnhurst AKA The FP&A Guy
  • Anos de atividade
    2023 - 2024
  • Episódios
    53
  • Classificação
    Livre
  • Copyright
    © Copyright 2024 All rights reserved.
  • Site do podcast
    Financial Modeler's Corner

Você também pode gostar de

Para ouvir episódios explícitos, inicie sessão.

Fique por dentro deste podcast

Inicie sessão ou crie uma conta para seguir podcasts, salvar episódios e receber as atualizações mais recentes.
Selecionar um país ou região

África, Oriente Médio e Índia

Ásia‑Pacífico

Europa

América Latina e Caribe

Estados Unidos e Canadá