Financial Modeler's Corner

Paul Barnhurst AKA The FP&A Guy
  • 4,9 (15)
  • 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. CFM Certification Tips for Financial Modelers to Pass Without 100 Hours with Carolina Lago

    HÁ 1 DIA

    CFM Certification Tips for Financial Modelers to Pass Without 100 Hours with Carolina Lago

    In this episode of Financial Modeler’s Corner, host Paul Barnhurst and co-host Carolina Lago explore their experiences with financial modeling and the Advanced Financial Modeler (AFM) certification. They discuss the value of these certifications, the challenges of studying for them, and how these programs can improve financial modeling skills. They also provide helpful tips and insights into preparing for the Chartered Financial Modeler (CFM) certification. Carolina is a financial modeling and FP&A specialist with over 20 years of experience. She holds the Advanced Financial Modeler (AFM) certification from the Financial Modeling Institute (FMI) and is working toward the Elite Certified Financial Modeler (CFM) credential. Carolina is passionate about teaching financial modeling and helping professionals use financial models to make better strategic decisions. Her workshops focus on best practices, scenario analysis, and providing businesses with the tools needed to navigate financial challenges. Expect to Learn The definition of a financial model and how to differentiate it from other types of business models.Tips for studying for the AFM and CFM certifications, including managing time effectively and balancing models as you work.Carolina’s experience preparing for the AFM and how to build financial models quickly under pressure.The importance of practice in financial modeling and how to improve speed and efficiency.The differences between the AFM and CFM certifications and why both are valuable for financial modelers. Here are a few quotes from the episode: "Even if I don’t pass the first time, I will have already succeeded by learning new techniques and improving my skills." - Carolina Lago"You need to be resourceful and think quickly when preparing for the CFM. It’s about adapting to complexity in multiple areas." - Carolina Lago"A financial model is anything that has inputs, calculations, and outputs, but at the same time answers a business question." - Carolina Lago Follow Carolina: LinkedIn - https://www.linkedin.com/in/s-carolinalago?originalSubdomain=chWebsite - carolinalago.comCourse Tactic On-Demand: https://tacticfinancial.com/financial-model-for-you/newsletter:  https://pages.tacticfinancial.com/thetacticalroom Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguy 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"...

    46min
  2. How Finance Professionals Can Grow with Excel, Avoid Automation Traps, and Build a Brand with Jon Acampora

    24 DE JUN.

    How Finance Professionals Can Grow with Excel, Avoid Automation Traps, and Build a Brand with Jon Acampora

    In this episode of Financial Modeler's Corner, host Paul Barnhurst sits down with Jon Acampora to discuss the ever-evolving world of financial modeling, focusing on Excel. Jon shares about the importance of creating user-friendly models and the impact of Excel Esports on financial modeling skills. The conversation covers best practices for building efficient models, lessons from Excel competitions, and how new technologies like Power Query and AI are shaping the future of modeling. Jon is the founder of Excel Campus, a Microsoft MVP, and an expert in helping Excel users simplify and automate their workflows. With over 600,000 YouTube subscribers, Jon is passionate about making Excel both fun and efficient. He’s also a regular commentator for Excel Esports competitions, where Excel professionals compete to solve complex modeling challenges in real time. Jon’s mission is to help people leverage Excel to boost productivity and creativity, making financial modeling more accessible and enjoyable. Expect to Learn The importance of building financial models that are easy for others to understand and use.Jon's take on the role of Excel Esports in advancing modeling skills and fostering creativity.How Power Query can save you hours of data processing time in Excel.Why financial modelers should focus on simplicity and automation rather than over-complicating their models.Insights into the future of financial modeling with the integration of Python and AI tools. Here are a few quotes from the episode: “AI is great at generating code, but it’s the human creativity that still leads the way.” - Jon Acampora“As an Excel professional, it's important to make models that others can easily work with, even if they don't have the same technical skills you do.” - Jon Acampora“If you want to be great at Excel, you have to understand that learning never stops. There’s always something new to discover.” - Jon Acampora Follow Jon: LinkedIn - https://www.linkedin.com/in/jonacampora/YouTube - https://www.youtube.com/user/ExcelCampusWebsite - https://www.excelcampus.com/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguy 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...

    55min
  3. Excel SIM Method for Finance Students to Master Three Statement Models Fast with Drew Blazsik

    17 DE JUN.

    Excel SIM Method for Finance Students to Master Three Statement Models Fast with Drew Blazsik

    In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Drew Blazsik to dive into the evolving world of financial modeling in academia. Drew brings a fresh perspective on how students can better grasp complex concepts using structured, interactive learning. The conversation touches on practical teaching methods, the common pitfalls students face, and why blending creativity with structure is key to mastering the three-statement model. Drew Blazsik is an assistant professor at Adrian College, where he teaches finance and economics. With over a decade of teaching experience at institutions like the University of Toledo and Lourdes University, Drew has a passion for connecting academic finance theory with real-world applications. He is also the creator of the Structured Immediate Method (SIM), an innovative teaching tool designed to help students master financial modeling skills in a dynamic and engaging way. Drew hosts the Faith and Finance Podcast and runs the Logos and Markets YouTube channel, where he explores financial modeling, economic theory, and more. Expect to Learn Common mistakes students make in financial modeling and how to avoid them.How Drew’s Structured Immediate Method (SIM) enhances student learning.Why learning Python is crucial for modern financial modelers.The impact of gamification and interactive learning on mastering financial concepts.Drew's take on the future of financial modeling in the age of AI. Here are a few quotes from the episode: “Once you understand how to create a financial model, it all clicks and makes finance come together.” - Drew Blazsik“AI is awesome for creativity, but it starts with you, the human, being creative.” - Drew Blazsik“The SIM method helps students get instant feedback, which improves their learning and engagement.” -Drew Blazsik Follow Drew: LinkedIn - https://www.linkedin.com/in/drewblazsik/YouTube - https://www.youtube.com/drewblazsik Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguy Follow Financial Modeler's Corner   LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the...

    53min
  4. The Financial Failures in Startups for Founders to Fix Bad Data and Build Profit with Alyona Mysko

    10 DE JUN.

    The Financial Failures in Startups for Founders to Fix Bad Data and Build Profit with Alyona Mysko

    In this episode of Financial Modeler’s Corner, Alyona Mysko shares her journey from a PwC auditor to a fintech founder creating FuelFinance, a no-code financial planning tool tailored for startups and small businesses. She discusses common financial modeling challenges faced by first-time founders, the complexities of the manufacturing and fashion industries, and the importance of simplifying financial models for better decision-making. Alyona emphasizes the power of effective communication and scenario planning, helping entrepreneurs and modelers make sense of numbers to drive business success. Alyona Mysko is the Founder and CEO of FuelFinance, a fintech startup delivering no-code financial planning tools designed specifically for startups and small businesses. With a professional background starting as an auditor at PwC, Alyona transitioned into financial analysis and fractional CFO roles before launching her own company. She brings deep expertise in financial modeling and a passion for simplifying complex financial data to empower founders and entrepreneurs.  Expect to Learn How Alyona’s audit background influenced the creation of a finance platform for startupsWhy first-time founders struggle with financial modeling and how second-time founders differThe complexity behind manufacturing and fashion business models and modeling nuancesThe importance of simplified dashboards focusing on key metrics for decision-makingWhy communication and storytelling in financial modeling is essential for impact Here are a few quotes from the episode: “Finance is just like fuel for a business. If you understand your numbers, you can go fast.” - Alyona MyskoFirst-time founders don’t know what they don’t know. Second-time founders know to start with the financial model.” - Alyona Mysko“Communication is 50% of your success as a financial modeler.” - Alyona Mysko Follow Alyona : LinkedIn - https://www.linkedin.com/in/alyona-mysko/Website - https://fuelfinance.me/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguyYouTube - https://www.youtube.com/@thefpandaguy Follow Financial Modeler's Corner   LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the...

    48min
  5. How To Simplify Complex Financial Models And Save Time with Scott Powell

    3 DE JUN.

    How To Simplify Complex Financial Models And Save Time with Scott Powell

    In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Scott Powell, co-founder and board member of the Corporate Finance Institute (CFI), to discuss the principles and pitfalls of financial modeling. The conversation centers around how overcomplication, legacy models, and misused functions can undermine even the most polished models, and how thoughtful planning, stakeholder consideration, and service-oriented teaching can significantly enhance modeling effectiveness. Scott Powell brings over 25 years of global experience in corporate finance education and financial modeling. He is a founding member of the Corporate Finance Institute, where he has led the creation of impactful learning tools and courses. Based in Vancouver, Canada, Scott has worked with major financial institutions worldwide and is deeply passionate about practical finance education and the power of financial literacy to transform lives. Expect to Learn: Why financial models often fail and how to avoid those pitfalls.The importance of balancing technical precision with stakeholder usability.How teaching and empathy enhance modeling skills.Key Excel techniques and when to avoid overengineering.Scott’s insights into using AI and advanced Excel tools to stay current. Here are a few quotes from the episode: "Every time you're in Excel, try to learn just one new thing. In a year, you're going to have learned a ton." - Scott Powell"If you open your model three days later and can’t understand what you did, then you made it too complex." - Scott Powell"Don’t start building your model until you understand the end goal and the user’s needs." - Scott Powell Scott’s thoughtful and service-driven approach makes this episode a must-listen for anyone in the world of financial modeling. His real-world stories, practical Excel strategies, and emphasis on simplicity offer powerful insights. Whether you’re building your first model or refining your 100th, Scott’s advice will help you level up. A valuable guide for modelers who want to build with purpose and clarity. Follow Scott : LinkedIn - https://www.linkedin.com/in/scott-powell-cpa-fca-fmva-84baa71/overlay/photo/Website - corporatefinanceinstitute.com Company - learningstrategiesgroup.com Follow Paul:  Website - https://www.theFP&A ndaguy.com   LinkedIn - https://www.linkedin.com/in/theFP&A ndaguy  YouTube - https://www.youtube.com/@theFP&A ndaguy 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"...

    49min
  6. How Financial Modeling Errors in Real Estate and Biotech Cost Analysts Millions with Narek Grigorian

    27 DE MAI.

    How Financial Modeling Errors in Real Estate and Biotech Cost Analysts Millions with Narek Grigorian

    In this episode of Financial Modeler's Corner, host Paul Barnhurst talks with Narek Grigorian, a seasoned financial modeler and investment professional with deep experience across real estate, energy, and biotech sectors. Narek shares candid stories about the worst financial model he ever worked on, one that looked polished but was fundamentally flawed, missing key components like taxes, depreciation, and tenant turnover. He explains how these mistakes can mislead decision-makers and why it’s critical to understand not just the numbers but also the assumptions behind them. Narek Grigorian currently works at US Capital Global, a global investment banking firm focused on real estate and energy projects, particularly in the lower to middle market space. He holds degrees from Georgetown University and the University of Maryland and brings a passion for financial modeling, innovation, and teaching. Narek believes that while all models are inherently imperfect, they still provide valuable guidance, if built with thoughtful assumptions and continual refinement. Expect to Learn: Why can you never fully trust a model just because it looks polished.The critical real estate assumptions that are often overlooked, like tenant turnover and escalating costs.How to approach energy modeling with real-time data inputs and complex variables.Why biotech models are uniquely challenging due to regulatory and clinical uncertainties.Tips and shortcuts Narek uses in Excel to make modeling faster and more reliable. Here are a few quotes from the episode: ““The toughest part is you have the wardrobe of clothes but have to create the person.” - Narek Grigorian“Power Query and Power BI are essential tools for modern financial modelers.” - Narek Grigorian“Vacancy rates and market growth assumptions are the most common pitfalls in real estate models.” - Narek Grigorian Narek’s practical and approachable style makes this episode valuable for anyone involved in financial modeling whether you’re just starting out or have years of experience. His clear advice on key assumptions, Excel techniques, and industry-specific challenges offers useful takeaways to help you create more accurate and effective models. Follow Narek : LinkedIn - https://www.linkedin.com/in/narek-grigorian-8869a7254/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpandaguy 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...

    46min
  7. A Finance Horror Story: The Currency Conversion Catastrophe with Lauren Pearl

    20 DE MAI.

    A Finance Horror Story: The Currency Conversion Catastrophe with Lauren Pearl

    In this special episode of Financial Modeler's Corner, host Paul Barnhurst is joined by CFO and startup finance educator Lauren Pearl for a storytelling session that’s equal parts funny and terrifying. They walk through “The Currency Catastrophe,” a true finance horror story about a global company, a junior analyst, and a massive mistake involving currency conversions. As the story unfolds, Paul and Lauren react, unpack what went wrong, and share their own war stories from years working in finance. Lauren Pearl is a CFO, startup advisor, and finance educator who specializes in helping early-stage companies build strong financial foundations. With a career that spans startups, venture-backed firms, and a stint in top-tier management consulting, Lauren brings a unique blend of strategic thinking and practical execution. She's also known for her hands-on approach to teaching financial modeling and startup finance through courses, content, and mentorship. Expect to Learn: What happens when you skip currency conversion in a global revenue allocation.Why getting the basics right is just as important as the big strategy.How one mistake can ripple across budgets, teams, and trust.The value of transparency and ownership is when something goes wrong.Why it’s crucial to put checks in your models, especially when currencies are involved. Here are a few quotes from the episode: “The finance department was such a dumpster fire, it created cloud cover for the mistake.” - Lauren Pearl“Modelers: always put currency checks in your spreadsheets. This stuff happens more than you think.” - Paul Barnhurst“Apologize and overcorrect. That’s the CFO playbook when you make a mistake.” - Lauren Pearl Lauren and Paul share a story every finance professional can relate to, a small mistake that snowballs into something much bigger. Whether you’re new to finance or have been around the block, this episode is a reminder of why fundamentals matter and how a little humor can help you get through even the most stressful moments. If you've ever cringed at your own spreadsheet or scrambled to fix a report before a meeting, you'll feel right at home. Follow Lauren : LinkedIn - https://www.linkedin.com/in/laurenepearl/Website - https://www.laurenpearlconsulting.com/link-list Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpandaguy 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...

    36min
  8. Why Most Financial Models Fail for FP&A Pros to Build Business-Aligned Models with Maria Zlobina

    13 DE MAI.

    Why Most Financial Models Fail for FP&A Pros to Build Business-Aligned Models with Maria Zlobina

    In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Maria Zlobina, a finance professional with over a decade of experience in Big Four audit, FP&A, and business partnering roles across the US, Australia, and Russia. The conversation explores the importance of understanding the purpose behind financial models, the challenges of inheriting others’ models, and the value of continual learning in finance. Maria also shares insights into the Advanced Financial Modeler certification, her passion for efficiency, and her experience navigating the world of financial modeling. Maria, who has a rich background in financial modeling, discusses her journey in the finance industry, her love for continuous learning, and her adventures living in different countries. She offers practical advice for modelers and professionals, including tips on making financial models dynamic, understanding the business context, and utilizing the right tools like Power BI and XLOOKUP. Maria also touches on her passion for languages and learning, sharing how her diverse experiences contribute to her success as a financial modeler. Expect to Learn: Why financial models are critical for decision-making and how to avoid common pitfallsThe importance of understanding the context and objectives behind a modelTips for inheriting and improving existing financial modelsThe benefits of continuous learning, both professionally and personallyInsights on dynamic financial models and best practices for forecasting Here are a few quotes from the episode: "The magic of financial modeling isn’t in the model itself, but in how it helps guide decisions." - Maria Zlobina"It’s not about creating the perfect model, but the model that gives the best insight for decision-makers." - Maria Zlobina"The best financial models don’t just answer one question; they provide a range of answers." - Maria Zlobina In this insightful episode, Maria Zlobina emphasizes the importance of dynamic financial models and understanding the business context behind them. She highlights the value of continuous learning and staying curious to improve as a financial modeler. With practical advice on overcoming challenges in modeling and working with stakeholders, Maria reminds us that great models support better decision-making. Follow Maria : LinkedIn - https://www.linkedin.com/in/maria-zlobina-afm-4642576b/ Follow Paul:  Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpandaguy 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...

    46min
Ver tudo (86)

Trailer

4,9
de 5
15 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 - 2025
  • Episódios
    86
  • 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á