Financial Modeler's Corner

Paul Barnhurst AKA The FP&A Guy
  • 5.0 (1)
  • MANAGEMENT
  • EVERY TWO WEEKS
Financial Modeler's Corner Podcast

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 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. VBA, AI, and Excel - Paul Barnhurst’s Key Takeaways from 40 Episodes

    2 DAYS AGO

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

    32 min
  2. The Power of Data Automation in Financial Models and Tools for Corporate Success with Paul Medici

    17 SEPT

    The Power of Data Automation in Financial Models and Tools for Corporate Success with Paul Medici

    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 Medici From 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/@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"...

    48 min
  3. Quantrix Approach to Simplify Complex Financial Problems with Gilbert Hangartner

    10 SEPT

    Quantrix Approach to Simplify Complex Financial Problems with Gilbert Hangartner

    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 modeling Here 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 Hangartner In 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/@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 a href="https://fminstitute.com/afm/" rel="noopener noreferrer"...

    49 min
  4. Discover the Power of Simplicity in Financial Modeling With Giles Male

    3 SEPT

    Discover the Power of Simplicity in Financial Modeling With Giles Male

    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 Male In 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/@thefpaguy8376   Follow Financial Modeler's Corner   LinkedIn Page-...

    49 min
  5. Continuous Planning vs. Annual Budgets | Randy Brown’s Game-Changing FP&A Insights

    27 AUG

    Continuous Planning vs. Annual Budgets | Randy Brown’s Game-Changing FP&A Insights

    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 Brown In 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/@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"...

    52 min
  6. E-Commerce Growth vs. Profit – Drew Fallon's Insights.

    20 AUG

    E-Commerce Growth vs. Profit – Drew Fallon's Insights.

    In this episode of Financial Modelers Corner, host Paul Barnhurst delves into the intricacies of financial modeling in the e-commerce industry with guest Drew Fallon, a seasoned e-commerce entrepreneur and co-founder of Iris, a cutting-edge FP&A tool for e-commerce businesses. The discussion offers valuable insights into the unique challenges of financial modeling in a rapidly evolving digital landscape, particularly in direct-to-consumer (DTC) businesses. Drew Fallon is an experienced entrepreneur in the e-commerce and CPG sectors. He began his career in equity research, working on high-profile IPOs like Airbnb and Corsair. Drew later co-founded and served as CFO for Mad Rabbit, an e-commerce brand that achieved significant growth under his leadership. Currently, he is the co-founder and CEO of Iris, a financial modeling platform that integrates AI to help e-commerce businesses automate their financial forecasting and analysis. Key takeaways from this week's episode include: The key components of effective financial modeling for e-commerce businesses.How cohort forecasting and customer retention play crucial roles in revenue prediction.The importance of understanding fulfillment costs and their impact on gross margins.Why many e-commerce brands fail due to poor financial modeling and how tools like Iris can help.Insights into Drew's journey from equity research to building successful startups in the e-commerce space. Here are a few quotes from Drew Fallon: "The number one thing to focus on with these e-comm businesses is the returning revenue number. If you mess up the forecast for your returning customer, it's the easiest way to mess up the gross profit forecast." - Drew Fallon"E-commerce is a tough business on working capital. It can be really challenging if you don't model out your cash flow accurately." - Drew Fallon"If you get the gross profit wrong, then you get the CAC wrong. And then all of a sudden you're losing money, and you die." - Drew Fallon In this insightful episode, Drew Fallon emphasizes the critical importance of precise financial modeling in the e-commerce sector, particularly in managing customer retention, fulfillment costs, and the dynamics of working capital. His experience in scaling e-commerce brands and developing Iris underscores the need for specialized tools and methodologies to navigate the complexities of this industry. Whether you're an entrepreneur, financial modeler, or simply interested in the intersection of finance and technology, this episode offers valuable lessons on how to build sustainable, profitable e-commerce businesses. Follow Drew: Website - https://www.irisfinance.co/LinkedIn - https://www.linkedin.com/in/drew-f-74947b117/    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-...

    50 min
  7. The Art of Financial Modeling and Data Management with Adam Rakich

    13 AUG

    The Art of Financial Modeling and Data Management with Adam Rakich

    Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally. In this episode, Paul Barnhurst delves into the intricate world of data integration, especially within financial modeling and FP&A. The discussion revolves around the practical challenges and solutions for accessing and automating data flows, a topic crucial for finance professionals who often grapple with multiple data sources and complex modeling tasks. The episode offers insights into the evolving landscape of data management tools and how they can streamline processes for businesses. Adam Rakich, a seasoned expert in the world of FP&A tools and data integration, joins the show. With a diverse background spanning social media marketing software, FP&A consultancy, and leadership roles at companies like Workday and OneStream, Adam now focuses on making data integration more accessible through his work at Data Blend. His deep understanding of the challenges accountants and financial modelers face with data management makes him a valuable resource for listeners looking to optimize their processes. Key takeaways from this week's episode include: The common pitfalls and solutions in financial modeling and data integration.When and why businesses should transition from spreadsheets to specialized planning tools.Practical strategies for automating data workflows, even when dealing with outdated or diverse systems.The importance of understanding APIs, SQL, and other technical aspects of data integration.How to build a business case for investing in data integration solutions. Follow Adam: LinkedIn - https://www.linkedin.com/in/rakich/Click the link below to claim your free book (For a limited time only): The Business User’s Guide to Data Integrationhttps://www.amazon.com/Business-Users-Guide-Data-Integration-ebook/dp/B0CMBMDCJ2/https://www.amazon.co.uk/dp/B0CMBMDCJ2/ 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’....

    54 min
  8. Learn Best Practices with Excel and Google Sheets - David Benaim

    6 AUG

    Learn Best Practices with Excel and Google Sheets - David Benaim

    Welcome to the Financial Modeler's Corner (FMC), where we discuss the Art and Science of Financial Modeling with your host Paul Barnhurst. Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally. In this episode of Financial Modelers Corner, host Paul Barnhurst sits down with David Benaim, an Excel MVP and data consultant based in Cambodia. They delve into a comparative analysis of two of the most popular spreadsheet tools—Excel and Google Sheets. The discussion covers the strengths and weaknesses of each platform, providing listeners with insights into when and how to use these tools effectively in their financial modeling and data analysis work. David Benaim is a chartered accountant and Excel MVP who has made a name for himself as an expert in both Excel and Google Sheets. Originally from the UK, David now runs a data consulting firm in Cambodia, where he specializes in Excel training and data solutions. With a deep passion for spreadsheets, David is uniquely positioned to discuss the nuances of both platforms, making this episode a must-listen for anyone looking to optimize their use of Excel or Google Sheets. Key takeaways from this week's episode include: Key differences between Excel and Google Sheets, including tables, functions and data entry features.The strengths of Google Sheets in collaborative environments and its data validation capabilities.How to decide whether to use Excel or Google Sheets for different types of projects.Insights into the new table features in Google Sheets and how they compare to Excel’s tables.David’s tips on getting started with Google Sheets for those accustomed to Excel. Follow David: Website - https://www.xlconsulting-asia.com/LinkedIn - https://www.linkedin.com/in/davebenaim/  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:21] - Introduction to the episode and guest David Benaim. [03:52] - David shares his unique global background and career journey from Deloitte to founding his own firm in...

    53 min
See All (46)

Trailer

About

Financial Modeler's Corner is a podcast where we talk all about the art and science of financial modeling with distinguished Financial Modeler's from around the globe. Financial Modeler's Corner is hosted by Paul Barnhurst 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. 

Information

  • Creator
    Paul Barnhurst AKA The FP&A Guy
  • Years Active
    2023 - 2024
  • Episodes
    46
  • Rating
    Clean
  • Copyright
    © Copyright 2024 All rights reserved.
  • Show Website
    Financial Modeler's Corner

You Might Also Like

To listen to explicit episodes, sign in.

Stay up to date with this show

Sign in or sign up to follow shows, save episodes and get the latest updates.
Select a country or region

Africa, Middle East, and India

Asia Pacific

Europe

Latin America and the Caribbean

The United States and Canada