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

Financial Modeler's Corner

Content provided by Paul Barnhurst AKA The FP&A Guy, Paul Barnhurst AKA The FP, and A Guy. All podcast content including episodes, graphics, and podcast descriptions are uploaded and provided directly by Paul Barnhurst AKA The FP&A Guy, Paul Barnhurst AKA The FP, and A Guy or their podcast platform partner. If you believe someone is using your copyrighted work without your permission, you can follow the process outlined here https://staging.podcastplayer.com/legal.

11d ago 46:03

MP3•Episode home

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

82 episodes

#MBA #Business #Podcasting Education #Paul Barnhurst AKA The FP&A Guy #Guys #Paul Barnhurst AKA The FP #Paul Barnhurst