Financial Modeler's Corner

Paul Barnhurst AKA The FP&A Guy
  • 4.9（15則評分）
  • 管理
  • 隔週更新
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. How Finance Professionals Can Grow with Excel, Avoid Automation Traps, and Build a Brand with Jon Acampora

    4 天前

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

    55 分鐘
  2. Excel SIM Method for Finance Students to Master Three Statement Models Fast with Drew Blazsik

    6月17日

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

    53 分鐘
  3. The Financial Failures in Startups for Founders to Fix Bad Data and Build Profit with Alyona Mysko

    6月10日

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

    48 分鐘
  4. How To Simplify Complex Financial Models And Save Time with Scott Powell

    6月3日

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

    49 分鐘
  5. How Financial Modeling Errors in Real Estate and Biotech Cost Analysts Millions with Narek Grigorian

    5月27日

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

    46 分鐘
  6. A Finance Horror Story: The Currency Conversion Catastrophe with Lauren Pearl

    5月20日

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

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

    5月13日

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

    46 分鐘
  8. How FMI and Ian Schnoor Are Helping Financial Professionals Build Better Models Around the Globe

    5月6日

    How FMI and Ian Schnoor Are Helping Financial Professionals Build Better Models Around the Globe

    In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Ian Schnoor, Executive Director of the Financial Modeling Institute. The conversation focuses on the growing role of financial modeling in uncertain markets, the expanding reach of FMI, and the importance of structure, clarity, and accreditation in building better business decisions. Ian shares practical insights from his global work, recent collaborations, and lessons from building multiple businesses. Ian Schnoor is the Executive Director of the Financial Modeling Institute (FMI), the only organization offering globally recognized financial modeling accreditation. He founded The Marquee Group, which was acquired by Training the Street in 2023. Ian has trained thousands of professionals in modeling, valuation, and Excel. He teaches at Queen’s University, holds a CFA charter, and began his career in investment banking with Citigroup and BMO. He’s focused on raising the standard of modeling across the world through education and certification. Expect to Learn: Why financial modeling is essential during market volatilityHow FMI is earning global recognition from top firmsThe impact of adding financial modeling to the CFA programInsights from FMI’s expansion into China and IndiaThree principles for building a successful businessA creative use of Excel to solve a real-world inventory challenge Here are a few quotes from the episode: “A good model helps you ask the right ‘what if’ questions, not deliver perfect answers.” - Ian Schnoor“The true purpose of a model is to give decision-makers confidence in uncertain times.” - Ian Schnoor“Getting the AFM means you’ve shown up, done the work, and proved your skills under pressure.” - Ian Schnoor Ian Schnoor shared powerful insights on the role of modeling in today’s uncertain world. He emphasized clarity, structure, and the value of accreditation in building trust and better decisions. His global work is helping elevate modeling into a true professional discipline. A strong reminder that great models lead to great leadership. Follow Ian Schnoor: LinkedIn - https://www.linkedin.com/in/ianschnoor/?originalSubdomain=ca Website - https://fminstitute.com/ Follow Paul:  Website - https://www.thefpandaguy.com    LinkedIn - https://www.linkedin.com/in/thefpandaguy   YouTube - https://www.youtube.com/@thefpaguy8376  Follow Financial Modeler's Corner   LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true   Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984 Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visita...

    50 分鐘
顯示全部 (85)

預告片

4.9
（滿分 5 顆星）
15 則評分

簡介

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. 

資訊

  • 創作者
    Paul Barnhurst AKA The FP&A Guy
  • 活躍年代
    2023年 - 2025年
  • 集數
    85
  • 年齡分級
    兒少適宜
  • 版權
    © Copyright 2024 All rights reserved.
  • 節目網站
    Financial Modeler's Corner

你可能也會喜歡

若要收聽兒少不宜的單集，請登入帳號。

隨時掌握此節目最新消息

登入或註冊後，即可追蹤節目、儲存單集和掌握最新資訊。
選取國家或地區

非洲、中東和印度

亞太地區

歐洲

拉丁美洲與加勒比海地區

美國與加拿大