Financial Modeler's Corner

Scott Powell, co-founder of the Corporate Finance Institute, shares his 25 years of expertise in financial modeling. He dives into common pitfalls, emphasizing the dangers of overcomplication and legacy models. Scott advocates for a balance between technical precision and stakeholder usability, highlighting empathetic teaching as crucial to effective financial training. Listeners gain insights into essential Excel techniques, the importance of clear documentation, and the value of continuous learning to enhance financial modeling skills. Expect practical tips and inspiration!

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 GrigorianNarek’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/@thefpandaguyFollow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.  In today’s episode: [01:12] - Welcome To The Episode [06:00] - About Narek and US Capital Global[08:25] - Market Outlook: Inflation, Tariffs, and Stagflation[10:33] - Narek’s Journey from Armenia to the US[14:49] - Favorite Industry to Model: Energy[17:42] - Real Estate Modeling Insights[25:34] - Common Mistakes in Real Estate Models[27:19] - Biopharma and Modeling Challenges[31:42] - Excel Shortcuts and Tools[38:22] - Power Query, Power BI, and Future of Excel[44:18] - How to Connect with Narek and Closing

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 PearlLauren 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-listFollow Paul: Website - https://www.thefpandaguy.com   LinkedIn - https://www.linkedin.com/in/thefpandaguy  YouTube - https://www.youtube.com/@thefpandaguyFollow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.  In today’s episode: [00:00] - Trailer[01:43] - Welcome & Intro to the Horror Story [03:01] - Meet Lauren Pearl[06:07] - The Story of the Currency Catastrophe[09:54] - When Meetings Could Just Be Emails[13:52] - Accounting Chaos and Rising Tension[16:59] - The Currency Blunder Uncovered[20:00] - Why the Mistake Mattered So Much[24:33] - Quiet Fixes and Avoiding Fallout[27:34] - Paul’s Own Finance Mishap[30:13] - Lauren’s Pricing Error [34:19] - Final Lessons for Modelers [35:07] - Closing Thoughts 

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 ZlobinaIn 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/@thefpandaguyFollow Financial Modeler's Corner  LinkedIn Page- https://www.linkedin.com/company/financial-modeler-s-corner/?viewAsMember=true  Newsletter - Subscribe on LinkedIn-https://www.linkedin.com/build-relation/newsletter-follow?entityUrn=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.  In today’s episode: [01:13] - Introduction to the Episode [03:52] - Worst Financial Model[06:37] - The value of continuous learning[10:24] - That One Defining Moment[13:09] - From Curiosity to Certification[17:49] - Starting with the Goal in Modeling[25:17] - Transparency in Modeling[31:07] - XLOOKUP Time Saver[34:24] - Rapid-fire questions[38:16] - AI and Tools in Modeling[43:56] - Final thoughts on modeling

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 SchnoorIan 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=caWebsite - 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.  In today’s episode: [01:27] - Welcome back to the Episode [04:04] - Financial modeling during market volatility [08:01] - Updates from FMI and its global growth [11:47] - Accreditation and why it matters [16:41] - Partnerships in China and India [22:02] - Excel World Cup and the global community [24:22] - CFA Institute collaboration [28:23] - Global expansion stories [32:34] - Three principles for business success [37:23] - Real-life Excel project: Baby blanket logistics [42:48] - Rapid-fire: tools and trends in modeling [47:37] - Final advice for modelers

Join Arta Ramaj, co-founder of 360 Finance, as she shares her unusual journey from geography to finance consultancy. She emphasizes the importance of solid foundations in financial modeling, revealing how adaptability and self-belief are crucial for entrepreneurs. Arta discusses viewing finance as a growth partner rather than a mere reporting function. Listeners will learn about the combination of technical and soft skills necessary for building investor-ready models, along with practical tips for applying these skills effectively in real-world scenarios.

In this episode of Financial Modeler’s Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes David Perla, Vice Chair of Burford Capital and a pioneering voice in the legal finance industry. David discusses how financial modeling plays a central role in evaluating and funding high-stakes litigation, offering a behind-the-scenes look at how his team monetizes legal risk with structured financial strategies. From managing long litigation timelines to leveraging Monte Carlo simulations and AI tools, David shares how Burford builds sophisticated models to guide investment decisions and mitigate risk. David Perla has an extraordinary background at the intersection of law, entrepreneurship, and finance. He’s a former president of Bloomberg Law, co-founder of legal outsourcing pioneer Pangea3 (acquired by Thomson Reuters), and was named a top 50 innovator by The American Lawyer. At Burford Capital, David is helping reshape how the legal world accesses and deploys capital.Expect to Learn:What legal finance actually is and how it worksHow Burford structures deals and evaluates legal riskThe modeling techniques used to forecast legal outcomesWhy Monte Carlo simulations are central to their underwriting processHow AI is used (and misused) in legal financeHere are a few quotes from the episode:“Behavior that’s irrational but predictable? We can model that. Idiosyncratic behavior? We avoid it.” - David PerlaModeling helps us decide not only how to price a deal, but how to structure incentives.” - David PerlaEverything we do depends on modeling.” - David PerlaDavid Perla gave us a fascinating look into the world of legal finance and how modeling plays a critical role in managing complex litigation risk. His knowledge revealed how finance principles, AI tools, and human judgment all intersect in this unique investment space. From non-recourse funding to Monte Carlo simulations, this episode showcased the depth of modeling required in high-stakes legal decision-making.Follow Dave:LinkedIn - https://www.linkedin.com/in/davidperla/Website - https://www.burfordcapital.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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.  In today’s episode: [01:12] - Welcome to the episode[03:37] - Defining Legal Finance[04:53] - Typical Legal Finance Timeline[07:56] - Structuring Deals with Non-Recourse Funding[11:17] - Modeling Risk with Monte Carlo Simulations[16:32] - High-Stakes Legal Deal Sizes[21:34] - Predictable vs. Rational Behavior in Modeling[26:02] - Data Transparency in Insurance vs. Legal Finance[32:31] - Tools of the Trade: Excel, Python & More[39:44] - Future of Excel, AI, and Model Confidence[41:32] - Strategic Decision-Making and Wrap-Up

In this special episode of Financial Modeler's Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes Karan Sood, a global pricing expert with over a decade of experience in revenue management and pricing strategies. Karan shares his knowledge on the impact of tariffs on global trade and pricing models. He talks about the complexities of tariffs, offering advice on how businesses can effectively manage the financial implications and adapt their pricing strategies during these uncertain times. Karan discusses the importance of collaboration across departments and creating flexible models that can quickly adjust to changing market conditions.Karan Sood is a global pricing expert and the Director of Sales Operations with a wealth of experience overseeing revenue management for over $6 billion across a wide range of industries. He is passionate about using pricing as a powerful tool to drive profitability and improve business performance. Karan has worked across industries including automotive, digital marketing, consumer goods, and more, developing pricing strategies that create real business value.Expect to Learn:How tariffs impact different industries and pricing strategies.Why a one-size-fits-all approach to tariffs is flawed and the importance of tailored strategies.The role of cross-functional collaboration in managing tariff impacts.How to create flexible pricing models that can quickly adjust to shifting market conditions.The importance of transparency with customers when adjusting prices due to tariffs.Here are a few quotes from the episode:"Every industry is different; you can’t use the same assumptions for all goods under tariffs." - Karan Sood"Stay calm, don’t make decisions too quickly. Information is constantly changing." - Karan Sood"The key to managing tariffs is creating a flexible pricing model that can adapt quickly to new developments." - Karan SoodKaran Sood shared meaningful strategies for managing the complexities of tariffs in today’s global trade environment. His advice to stay calm, work collaboratively, and prioritize flexibility in pricing models is invaluable for finance professionals looking to navigate the challenges posed by tariffs. By emphasizing the importance of cross-departmental communication and transparency with customers, Karan offers actionable steps that can help businesses succeed in a volatile market.Follow Karan:LinkedIn - https://www.linkedin.com/in/soodkaran/?originalSubdomain=caWebsite - https://substack.com/@karansoodFollow 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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.  In today’s episode: [02:08] - Introduction of Episode[03:05] - Karan’s Journey into Pricing[06:45] - The Global Impact of Tariffs[12:05] - Why One-Size-Fits-All Doesn’t Work[16:00] - Managing the Impact of Tariffs[20:04] - Building Flexible Pricing Models[23:09] - Transparency with Consumers[28:46] - Short-Term vs. Long-Term Strategy[34:34] - Cross-Department Collaboration[39:06] - Book recommended by Karan

Carl Olson, a finance consultant with over 20 years of experience across startups and large corporations, shares valuable insights on financial modeling. He explores the critical differences between startup and corporate financial models, emphasizing the importance of context and communication. Carl recounts lessons from his journey, including the risk of over-automation and the need to listen to business partners. He also highlights effective ways to test assumptions when data is scarce, making his advice essential for any financial modeler.

In this episode of Financial Modeler's Corner, host Paul Barnhurst is joined by Dave Hallwood, a finance director and certified financial modeler, for a practical and candid conversation about real-world modeling in the retail industry. From managing day-to-day operations in a fast-growing fashion retail group to navigating insolvency and restructuring, Dave shares the hard-earned lessons that have shaped his approach to modeling, decision-making, and leadership. Dave Hallwood is the Finance Director of a group of independent fashion retailers in the UK. After spending years in retail and hospitality management, Dave transitioned into finance in his 30s, becoming a fellow of ACCA and earning his Certified Financial Modeler (CFM) designation from the Financial Modeling Institute. With a passion for practical financial modeling, Dave has built and managed models for nearly every scenario a small retailer can face, from budgeting and forecasting to store openings, closings, and insolvency planning. Expect to Learn:How to model retail cash flow when weather drives salesThe importance of simplicity and storytelling in financial modelsWhat it’s like to manage an insolvency and restructure a businessWhy Dave believes gut instinct still plays a big role in decision-makingHow Dave uses modeling to support store openings, closures, and growthPractical advice for switching into a finance career later in lifeHere are a few quotes from the episode:"Financial models help guide the business, but people and relationships still make it work.""The best decision is often a balance between what the model says and what feels right.""No matter how great the numbers look, if your gut says no, listen."Dave Hallwood shares what it’s really like to model for a retail business. From managing cash flow swings to making tough calls during insolvency, he brings a grounded, real-world perspective. Dave reminds us that models should support decisions, not replace them. It’s a must-listen for anyone juggling numbers and navigating uncertainty.Follow Dave:LinkedIn - https://www.linkedin.com/in/david-hallwood-fcca-cfm-87270449/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=7079020077076905984Sign up for the Advanced Financial Modeler Accreditation Today and receive 15% off by using the special show code ‘Podcast’. Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register.  In today’s episode: [01:31] - Welcome to the episode[03:45] - Inheriting a messy Excel model[06:17] - Why Dave switched careers in his 30s[10:13] - Life as a finance lead in retail[14:16] - Forecasting cash flow in a seasonal business[18:54] - How to model each store differently[26:58] - Lessons from an insolvency and business rescue[32:59] - Why Dave supports the FMI community[40:01] - Horizontal or Vertical Modeling Preferences[42:23] - Gut vs. model: what really drives decisions[44:36] - Closing Reflections with Dave