Financial Modeling Techniques for Global FP&A Success with Carolina Lago

Financial Modeler's Corner

Welcome to the Financial Modeler's Corner (FMC), where we discuss the art and science of financial modeling with your host Paul Barnhurst.

Financial Modeler's Corner is sponsored by the Financial Modeling Institute (FMI), the most respected accreditation in Financial Modeling globally.

In today’s episode, Paul engages in an interaction with Carolina Lago and discusses the essential tips for transforming data into actionable insights and the strategic approach to avoiding common modeling pitfalls. This discussion offers valuable wisdom that will enhance your analytical skills and financial acumen.

Carolina, a seasoned FP&A professional with over 15 years of international experience, shares profound insights from her extensive career, including her role in a significant IPO and leading software implementation across global departments.

Key takeaways from this week's episode include:

• An early career encounter with a poorly designed financial model, filled with hard-coded numbers, underscores the necessity for creating flexible and dynamic financial models that can adapt to changing business needs.

• The discussion highlights the critical need to avoid hardcoded data and external links in financial models, which can lead to rigidity and errors.

• Insights from the financial modeling newsletter and courses show a wide range of professionals benefiting, from newcomers to seasoned directors. This variety demonstrates the widespread need for improved modeling skills.

• The discussion focuses on the importance of transforming data into actionable insights. It's stressed that without the ability to analyze and interpret data effectively, its value is minimal.

• The conversation sheds light on techniques for deriving actionable insights from complex data, crucial for any financial modeler. It also discusses the value of formal certifications like the Advanced Financial Modeler Certification as tools for professional development and skill validation.

Quotes: 

Here are a few relevant quotes from the episode on financial analysis and modeling:

• “I inherited one, and I had to try to change it. I spent probably a couple of weeks trying to make it better, and I couldn't. It was just too full of hardcoded numbers and I had to find everything the way around and no design at all.”

• “The first thing I learned about financial modeling was not to use hard codes and don't link outside of the spreadsheet.”

• “Data is only useful if it can be transformed into actionable insights.”

• “The TACTIC is (Targets, Assets, Calculations, Tools, Insights, and Correlations.) You start with the target which is the question that you need to answer with that financial model.”

• “That's why I like financial modeling so much because it can transform data into something. So you can make decisions on top of that data.”

Sign up for the Advanced Financial Modeler Accreditation or FMI Fundamentals Today and receive 15% off by using the special show code ‘Podcast’.

Visit www.fminstitute.com/podcast and use code Podcast to save 15% when you register. 

Go to https://earmarkcpe.com, download the app, take the quiz and you can receive CPE credit. 

Follow Carolina:

• LinkedIn - https://www.linkedin.com/in/s-carolinalago
• Website - https://www.tacticfinancial.com

Follow Paul:

• Website - https://www.thefpandaguy.com  
• LinkedIn - https://www.linkedin.com/in/thefpandaguy 
• TikTok - https://www.tiktok.com/@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 

In today’s episode: 

(00:04) Introduction

(00:50) Guest Introduction

(01:00) Horrifying Financial Models

(02:00) Insights from Guest’s Early Career Challenges

(03:10) Guest’s Career Journey and Global Experience

(05:00) Turning Data into Actionable Insights

(07:30) Introduction of the Tactic Framework

(09:50) Audience Engagement and Learning Opportunities

(20:00) Certification and Continuing Education

(22:40) Rapid-Fire Round

(24:50) Advice for Aspiring Financial Modelers

(26:00) Contact information to learn more about various modeling techniques and tools.