Financial Modeler's Corner

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

  --------  

  46:03
• 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 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...

  --------  

  36:07
• 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 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...

  --------  

  45:50
• 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 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

  --------  

  50:16
• How Startup Founders Can Build Investor Ready Models to Win VC Trust with Arta Ramaj

  In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Arta Ramaj, co-founder of 360 Finance, for a discussion into the real-world challenges and nuances of financial modeling. Arta shares her journey from a geography degree to a thriving career in finance and entrepreneurship. Together, they explore the art and science of building robust financial models, the entrepreneurial mindset, and the evolving role of finance as a strategic business partner.Arta Ramaj is the co-founder of 360 Finance, a boutique consultancy specializing in financial modeling, FP&A, and finance system implementations for private equity and venture-backed companies. With a background in private equity and a passion for bridging financial data with strategic execution, Arta brings a unique entrepreneurial perspective to the finance world. She’s dedicated to creating investor-ready financial solutions and scaling businesses through dynamic, data-driven insights.Expect to Learn:How Arta transitioned from studying geography to founding a financial consulting firm.The critical importance of structure and design in financial modeling.Key strategies for building "investor-ready" financial models.The role of soft skills and storytelling in becoming a great finance business partner.Why simplifying assumptions and focusing on key metrics are essential for early-stage modeling success.Here are a few quotes from the episode:“If you're scaling and your finance function isn't solid, you're really scaling on shaky foundations." - Arta Ramaj”Credibility and clarity are the north stars for building investor-ready financial models." - Arta Ramaj“Modeling for a startup is often more about flexibility and storytelling than creating a perfect spreadsheet." - Arta RamajArta Ramaj gave us a fascinating look into the world of financial modeling for startups and private equity-backed businesses, showing how structure, clarity, and strategic insight shape high-impact financial decision-making. Her experiences revealed how finance principles, business partnering skills, and storytelling all intersect to build trust with investors and stakeholders. From building investor-ready models to navigating the entrepreneurial journey, this episode showcased the critical role financial modelers play in driving growth, strategic planning, and value creation.Follow Arta:LinkedIn - https://www.linkedin.com/in/artaramaj/Website - https://www.three6ixtyfinance.comFollow 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-

  --------  

  46:18

Más podcasts de Economía y empresa

Podcasts a la moda de Economía y empresa

Acerca de Financial Modeler's Corner