Financial Modeler's Corner

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

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-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:04] - Welcome to the Episode[03:21] - Horror Financial Model Story[07:02] - From Geography to Finance[11:33] - Love for FP&A and Business[14:26] - Starting 360 Finance[17:46] - Why Finance Gets Overlooked[23:32] - Building Investor-Ready Models[29:27] - The Financial Modeler as a Therapist[35:14] - Fun with Excel and Wedding Modeling[38:20] - Career Advice and Final Tips

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

In this episode of Financial Modeler's Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes Carl Olson, a seasoned finance leader with over two decades of experience in FP&A, consulting, and startup finance. Carl discusses the nuances of financial modeling in both startups and large companies, sharing war stories, practical frameworks, and the lessons learned from building models that drive real business decisions. Whether it's simplifying startup forecasts or navigating layers of corporate planning, Carl emphasizes the importance of context, communication, and staying aligned with business partners.Carl Olson is a finance consultant and strategic advisor with more than 20 years of experience in FP&A, startup modeling, and enterprise finance. His background includes roles at Jamba Juice, Yelp, Unity, and several startups. Carl specializes in building operating and strategic models, guiding fundraising efforts, and helping businesses link financial modeling to real-world execution.Expect to Learn:How financial models differ for startups vs. large companiesWhy listening to business partners is essential for model effectivenessHow to test assumptions when historical data is limitedThe danger of over-automation in modelingWhat makes a model usable vs. impressiveHere are a few quotes from the episode:“If your sales model shows unrealistic rep productivity, that’s a red flag.” - Carl Olson“Meet your business partners where they are, not where you want them to be.” - Carl Olson“Use industry benchmarks, but know your secret sauce.” - Carl OlsonCarl Olson shared honest and practical insights from years of building financial models across startups and large companies. He reminded us that the real value of a model comes from how well it supports decision-making and helps the team move forward. His approach to keeping things simple, clear, and business-focused is something every finance professional can learn from.Follow Carl:LinkedIn - https://www.linkedin.com/in/olsoncarl/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] - Introduction of Episode[02:02] - Carl’s Worst Modeling Experience[06:43] - Rebuilding a Model from Scratch[10:36] - Startup vs. Corporate Modeling[12:57] - Big Data to Startup Forecasting[15:09] - When Mistakes Go Unnoticed[22:42] - Finding Gaps Through Modeling[29:41] - Using Excel for Personal Life[30:47] - Carl’s Favorite Excel Shortcuts[33:32] - Rapid Fire: Tools, Preferences, and Advice[36:24] - Avoiding the VBA Trap and Growing in Your Career[40:38] - Carl’s Closing Advice for Financial Modelers

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

In this episode of Financial Modeler's Corner, host Paul Barnhurst welcomes Myles Arnott, co-founder of Full Stack Modeller and founder of Clarity Consultancy Services. Myles shares his 25+ year journey in Excel, his philosophy of keeping things simple, and how structured design and tools like Power Query have transformed his approach to modeling. He also opens up about taking the FMI Advanced Financial Modeler (AFM) exam and co-building a global modeling community.Myles Arnott is a CMA-qualified accountant, Excel trainer, and fractional finance director. He leads Clarity Consultancy Services and co-founded Full Stack Modeller, a platform built to provide finance professionals with a full toolkit of modern Excel and modeling skills. Myles blends operational finance experience with teaching, making complex modeling concepts accessible through real-world insights and practice.Expect to Learn:The power of simplicity in model designHow to effectively prepare for the AFM examBest practices for managing data flow in ExcelWhy Power Query is one of Excel’s most powerful toolsHow Full Stack Modeler is helping professionals level up in financeThe value of designing with clarity and reviewing with confidenceMyles’s journey from complex automation to clean, intuitive spreadsheetsHere are a few quotes from the episode:Spreadsheet risk skyrockets when models are messy and undocumented.”- Myles Arnott“If your data flows are poor, your insights will be too.”- Myles Arnott“Power Query changed everything for how we manage data in Excel.”- Myles ArnottIn this episode, Myles Arnott shares how clarity, consistency, and structure create better financial models. He emphasizes the importance of design thinking, simplifying complexity, and continuously developing your skills. Whether you're preparing for the AFM or just want to clean up your modeling, Myles’s advice will guide you toward modeling excellence.Follow Myles:LinkedIn - https://www.linkedin.com/in/mylesarnott/Website - https://www.fullstackmodeller.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:39] - Episode Introduction[02:49] - Worst Financial Model Mistakes [07:55] - Leadership and AFM[13:26] - Balancing Under Exam Pressure[19:17] - Full Stack Origins[23:01] - MVP Antics and Office Fun[27:04] - Simplifying Systems and Processes[31:13] - Power Query Tips[36:37] - Career Lessons Learned[46:09] - Advice to Aspiring Modelers

In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Emma Chieppor, founder of Excel Dictionary, a social media-driven Excel education platform with over 9 million followers. Emma shares her journey from being an actuary to becoming one of the most influential Excel educators online. She discusses the power of Excel, the challenges of running a business, and how short-form content transformed Excel learning for millions.Emma Chieppor started her career as an actuary before launching Excel Dictionary, a platform dedicated to providing quick and practical Excel tips. Through social media, Emma has built a massive following by sharing 30-second Excel tutorials. Her expertise has helped professionals worldwide enhance their Excel skills efficiently.Expect to Learn:How Emma transitioned from actuary to Excel influencerThe challenges of learning Excel while starting a corporate job during COVIDWhy pivot tables in financial models can be a nightmareHow Emma grew her social media following to over 9 million in less than a yearThe most underrated Excel shortcuts that can save hours of workHere are a few quotes from the episode:“I had never really used Excel before my first job, so I had to teach myself from scratch.”There’s no secret formula for social media. Just post good content and stay consistent.”“If you’re learning Excel, repetition and practice are key.”In this episode, Emma Chieppor shared her journey from actuary to Excel influencer, emphasizing consistency, hands on learning, and creativity in Excel. She highlighted the power of shortcuts, automation, and social media in making Excel more accessible. Excel is more than a tool; it is a platform for innovation and efficiency. Keep learning, stay curious, and master the skills that set you apart!Follow Emma Chieppor :LinkedIn - https://www.linkedin.com/in/emma-chieppor-excel-dictionary-261444235/Website - https://excel-dictionary.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:30] - Introduction to the episode[03:09] - Worst Financial Model Mistakes – Avoiding Pivot Tables[06:43] - Emma’s Background from an Actuary to an Excel Star[09:03] - How COVID Led to the Creation of Excel Dictionary[13:04] - Emma’s Journey to One Million Plus Followers[17:49] - The Importance of Consistency in Content Creation[28:23] - Rapid-Fire Excel Questions on Excel Features

In this episode of Financial Modeler’s Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes Sean Mooney, a senior financial consultant specializing in automated financial modeling for professional services. Sean shares his journey from accounting to financial modeling, the challenges of revenue forecasting for law firms, and the power of Excel automation. Sean Mooney is the founder of SJ Finance, a consultancy specializing in financial modeling automation for professional services firms. With 12+ years of executive finance experience in the UK and Australia, Sean has built financial models that have helped businesses secure millions in funding. He is an expert in Power Query, Excel automation, and M&A financial modeling, helping companies save up to 75% of reporting time through smart automation.Expect to Learn:How Sean transitioned from accounting to financial modelingThe role of Power Query in automating financial modeling processesKey revenue forecasting challenges in law firms and service businessesWhy scenario planning is critical for financial modelsHow financial modeling influences business strategy and decision-makingHere are a few quotes from the episode:“Law firms have long cash cycles, so tracking work-in-progress (WIP) is absolutely critical.”“Debt financing can sometimes be a better alternative to private equity, but many business owners don’t realize that.”“The biggest risk in a financial model? A black hole of stagnant WIP that never turns into revenue.”In this episode, Sean Mooney shared his expertise on how automation, Power Query, and strong forecasting techniques can transform financial models from static spreadsheets into dynamic decision-making tools. He advises financial modelers to stress-test their models, embrace automation, and always keep learning.Follow Sean:LinkedIn - http://www.linkedin.com/in/sean-mooney-sjfCompany - https://sjfinance.co.uk/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:24] Introduction to the Episode[06:55] Sean’s Passion for Financial Modeling [09:45] Guiding Clients on Financial Decisions [15:30] Revenue Forecasting for Law Firms[24:38] The Potential of Power Query [30:04] Sean’s Favorite Excel Shortcuts & Tips [31:39] Excel Nerd Moment[34:18] Rapid-Fire Questions[37:53] Final Advice for Financial Modelers

In this episode of Financial Modeler’s Corner, host Paul Barnhurst (aka the FP&A Guy) sits down with Frank David, an expert at the intersection of corporate strategy, clinical medicine, and biotech research. They discuss the unique challenges of financial modeling in the biopharma industry, the importance of understanding patient populations, and how drug development strategy influences financial decision-making.Frank David is the Founder and Managing Director of Pharmagellan, a consulting firm specializing in biotech financial modeling and valuation. With a background as a physician scientist, Frank has extensive experience advising biopharma teams and investors. He also teaches at Tufts University and is the lead author of The Pharmagellan Guide to Biotech Forecasting and Valuation and The Pharmagellan Guide to Analyzing Biotech Clinical Trials.Expect to Learn:The unique challenges of financial modeling in biotech and pharma.Why "small percent of a big market" is a flawed valuation approach.How patient segmentation impacts drug development strategy.The importance of risk-adjusted modeling and scenario planning.How financial modeling supports strategic decision-making in biotech investments.Here are a few quotes from the episode:"Most early-stage biotech entrepreneurs don’t realize they need to think about who their patients actually are and what alternative treatments exist.""In drug development, forecasting is about managing uncertainty, not predicting exact numbers.""The clinical strategy and commercial strategy in biotech are so intertwined that modeling them separately can be misleading."This episode explored the complexities of biotech financial modeling. Frank shared why traditional financial modeling approaches don’t always work in the biotech industry and how strategic decision-making relies heavily on understanding patient needs, regulatory pathways, and risk assessment.Follow Frank:LinkedIn - https://www.linkedin.com/in/frank-s-david/Company - https://www.pharmagellan.com/Email - [email protected] - https://a.co/d/gf8SwzIFollow 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:14] - Introduction to the Episode[02:02] - Meet Frank David [04:17] - Financial Modeling Horror Story [09:38] - Understanding Biotech Financial Models[13:57] - Biotech Forecasting and Valuation[18:15] - Where to Start When Analyzing a Drug Project [24:52] - Risk-Adjusted Modeling in Biotech [32:01] - Advice for Modelers in Biotech [40:56] - Fun & Rapid-Fire Questions[49:32] - How to Connect with Frank David

In this episode of Financial Modeler's Corner, host Paul Barnhurst sits down with Babatope Agbeyo, a corporate trainer with extensive experience in financial modeling, Excel, and valuation. Babatope shares about his "SIMPLE" modeling framework, experiences in financial advisory at Deloitte, and lessons from training over 3,000 professionals globally. He also discusses his passion for keeping financial models structured, logical, and error-free.Babatope Agbeyo is a financial modeling expert and corporate trainer who has worked across multiple industries, including telecom, manufacturing, oil & gas, and tech. With experience at Deloitte and D Brown Consulting, he has reviewed and audited countless financial models, refining his approach through his "SIMPLE" modeling framework. Babatope is a certified AFM and FMVA and is passionate about making financial modeling more structured and effective.Expect to Learn:The importance of keeping financial models simple and structuredBabatope’s SIMPLE modeling framework and how it improves modeling efficiencyCommon financial modeling mistakes and how to avoid themHow to effectively audit financial models using the PAINS approachThe best industries for financial modeling and which ones are the most challengingHere are a few quotes from the episode:"A great financial model should be modular, meaning each calculation block is distinct and easy to read.""Most errors I find in financial models come from poor calculations and linking mistakes.""A well-structured financial model should be easy to read, navigate, and troubleshoot."Financial modeling isn't just about crunching numbers, it's about telling a story with data, making informed decisions, and ensuring accuracy at every step. Babatope’s SIMPLE framework and PAINS approach remind us that clarity and structure are just as important as technical skill. If you’ve ever struggled with a model that just wouldn’t balance, or spent hours troubleshooting an error, this episode is a must-listen. Follow Babatope:LinkedIn - https://www.linkedin.com/in/babatopesamuelagbeyo/Email - [email protected] 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:18] Introduction to the Episode[03:39] Financial Modeling Horror Story[05:28] Lessons from Working with David Brown [07:15] What It’s Like Working at Deloitte [09:48] The SIMPLE Framework [14:06] The Art of Teaching Financial Modeling[16:16] Preparing for the AFM Exam [21:16] The PAINS Approach to Auditing Models [24:20] Excel Shortcuts & Unique Modeling Use Cases [26:08] Biggest Career Lesson [28:58] Rapid-Fire Questions [33:38] Final Advice [34:46] Where to Connect with Babatope

In this episode of Financial Modeler’s Corner, host Paul Barnhurst welcomes Andres Klaric, the co-founder and co-CEO of Fuse. In their conversation, Andres discusses common financial modeling mistakes, how startup models differ from corporate M&A models, and what investors truly look for when evaluating projections. He also shares firsthand experiences on navigating the fundraising process, balancing work ethic with personal life, and the strategic approach to scaling a company.Andres Klaric is the co-founder and co-CEO of Fuse, a next-generation loan origination system designed to streamline lending for financial institutions through self-serve customization, a low-code API builder, and personalized agent portfolios. Andres shares his journey from investment banking and private equity to launching a fintech startup that’s reshaping loan origination. He provides insights into financial modeling for startups, securing venture capital, and the critical lessons he’s learned from Wall Street.Expect to Learn:The biggest mistakes and horror stories in financial modeling.How startup financial models differ from corporate M&A models.The key factors venture capitalists look for in startup projections.Lessons from private equity and investment banking that shaped Andres as a CEO.The art of balancing complexity and simplicity in financial modeling.Here are a few quotes from the episode:“The biggest mistake in startup modeling? Overcomplicating things when simple assumptions will do.”“Modeling for investors and modeling for internal operations are two completely different things.”“A bad financial model won’t kill your startup, but a bad go-to-market strategy will.”This episode with Andres Klaric was packed with insights on financial modeling, fundraising, and the lessons learned from both Wall Street and the startup world. From the importance of keeping financial models simple to navigating investor expectations, Andres provided a masterclass on startup finance and strategic thinking. Hard work, strategy, and the ability to adapt will always outweigh an over-engineered spreadsheet. Follow Andres:LinkedIn - https://www.linkedin.com/in/andresklaric/Company: https://www.fusefinance.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: [02:59] - Worst Financial Model Horror Stories[08:57] - The Journey to Founding Fuse[11:53] - Lessons from Wall Street[18:07] - Financial Modeling for Startups[23:05] - How VCs Evaluate Startup Models[25:06] - Fundraising Strategies & Finding the Right Investors[32:07] - Rapid-Fire Financial Modeling Q&A[42:34] - Final Advice & Closing Thoughts

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with financial educator and author Brian Feroldi. They discuss the fundamentals of stock investing, financial modeling, and how to identify high-quality companies. Brian shares insights from his investing journey, his investing checklist, and his thoughts on valuation, competitive advantages, and the role of financial models in investment decisions.Brian Feroldi is a financial educator, investor, and author dedicated to demystifying the stock market. With nearly two decades of investing experience, Brian has written over 3,000 articles on stocks, personal finance, and investing. His best-selling book “Why Does the Stock Market Go Up?” explains market fundamentals in simple terms. Through his YouTube channel, social media presence, and educational content, Brian helps investors make smarter decisions by focusing on business quality, valuation, and long-term investing strategies.Expect to Learn:Why financial models depend on good assumptions and how they can be manipulatedThe biggest mistakes investors make and how to avoid themHow Brian analyzes financial statements and what metrics he prioritizesThe five key types of competitive advantages (EMOTs) in businessHow to build an investing checklist to guide stock selectionHere are a few quotes from the episode:“When I invest, I’m looking for businesses that can outperform even the most bullish expectations.”“Understanding where a company is in its business lifecycle is critical to valuation.”“The biggest mistake people make is using the wrong valuation model for the wrong type of company.”Brian’s emphasis on having a structured investing checklist, focusing on competitive advantages, and choosing the right valuation method for the right stage of a company’s lifecycle highlights the importance of strategy over speculation. If you're looking to improve your investing game, start by educating yourself, refining your process, and remembering that patience often wins the race. Follow Brian:LinkedIn - https://www.linkedin.com/in/brianferoldi/Website - https://www.brianferoldi.com/Email - [email protected] - https://www.youtube.com/brianferoldiytBook - https://a.co/d/3gS5JZLFollow 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:02] - Introduction to Guest Brian Feroldi[06:35] - Brian’s Investing Journey and Early Mistakes[10:19] - Brian’s Checklist for Evaluating Companies[15:41] - The Financial Statement Analysis[20:24] - Competitive Advantages (EMOTs)[29:50] - Advice to Begin Investing in the Market[31:20] - Common Investor Mistakes [33:51] - Valuation Models & Growth Cycles [41:36] - Final Advice & Book Recommendations [42:55] - Where to Find Brian

In this episode of Financial Modelers Corner, host Paul Barnhurst, aka The FP&A Guy, looks into the transformative impact of Artificial Intelligence on financial modeling. The discussion explores how AI is reshaping the industry, the challenges and opportunities it brings, and what financial modelers can expect in the coming years.Kenny Whitelaw-Jones who is the founding partner at Gridlines joins the show. As a leading expert in project finance modeling, Kenny has played a pivotal role in shaping financial modeling standards globally. With over a decade of experience training blue-chip clients and developing complex models, he brings invaluable insights into how AI is poised to revolutionize financial modeling.Expect to Learn:How AI is expected to significantly impact financial modeling, with Kenny's recent industry survey.The current limitations of AI tools like ChatGPT in financial modeling and where they excel.How project finance modeling differs from other types of financial modeling, and why Kenny finds it exciting.The importance of soft skills and communication in the evolving role of financial modelers.The future skills financial modelers will need to stay ahead in an AI-driven world.Here are a few quotes from the episode:"In the future, the routine tasks will be automated, and modelers will focus more on strategic, value-adding activities.""Being a good modeler isn’t just about Excel skills. It’s about interpreting data and communicating results effectively.""The change AI brings is inevitable because as soon as we can imagine it, someone will figure out how to make it happen."As AI continues to evolve, it's clear that financial modeling is on the brink of a major transformation. Kenny Whitelaw-Jones shared not just the technical impacts we can expect from AI, but also how the role of financial modelers will shift toward strategic thinking, business interpretation, and effective communication. While tools like ChatGPT and Copilot are making waves, it’s the human element that will remain irreplaceable.Follow Kenny:LinkedIn - https://www.linkedin.com/in/kennywhitelawjones/Website - https://www.gridlines.com/Email - [email protected] 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:46] – Meet Kenny Whitelaw-Jones[02:35] – The Worst Financial Model Encountered[05:43] – Why Project Finance and Renewables?[10:04] – Survey for AI in Financial Modeling[14:58] – ChatGPT vs. Copilot [18:57] – Excel Innovations & the Future of Modeling [22:34] – The Future of Financial Modeling with AI[26:50] – Soft Skills & the Evolving Role of Financial Modelers[33:51] – Rapid-Fire Round[40:51] – Life Beyond Financial Modeling[43:48] – Final Thoughts & How to Connect with Kenny

In this episode, host Paul Barnhurst aka The FP&A Guy looks into Excel expertise with Joel Steendam. Joel shares his global experiences, technical know-how, and practical advice to improve Excel proficiency and financial modeling outcomes. Their conversation covers Excel tools, design principles, and the importance of curiosity and cultural awareness in professional success.Joel Steendam is a global Excel expert and educator with a passion for helping professionals create better financial models. As a key member of PerfectXL, he develops software to improve spreadsheet quality, mitigate risks, and promote best practices in Excel. With a multicultural background and years of experience in financial modeling, Joel blends technical expertise with a deep understanding of how culture influences collaboration and problem-solving.Expect to Learn:Worst financial models and how to fix common spreadsheet issues.Why named ranges and documentation are essential in financial modeling.How Joel’s multicultural upbringing has shaped his professional approach and success.Practical advice on staying curious and learning new Excel skills.The role of tools like PerfectXL in auditing and improving spreadsheet quality for financial modeling.Here are a few quotes from the episode:"Even best practices, when misused, can have a massive negative impact on Excel models.""PerfectXL’s tools focus on mitigating risks and improving model quality by emphasizing structure and consistency.""If you build something on Monday that you don’t understand by Wednesday, you’re not building the right thing."Joel Steendam shared his expertise on improving Excel models, staying curious, and navigating the challenges of financial modeling. Financial models are powerful decision-making tools, but they’re only as effective as their structure and design allow them to be. Joel provided invaluable lessons for both beginners and experienced modelers on structure, documentation, and tools.Follow Joel:LinkedIn - https://www.linkedin.com/in/joel-steendam/Website - https://www.perfectxl.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:49] - Introduction and Meet the Guest[02:49] - Horror Stories in Financial Models[04:28] - Key Takeaways from Bad Models[06:45] - Joel’s Global Background[10:18] - PerfectXL and Best Practices in Excel[14:56] - Staying Updated on Excel[18:03] - Advice for Beginners in Excel[29:14] - Balancing Excel’s Flexibility and Risks[36:12] - Fun Projects in Excel[38:38] - Rapid-Fire Questions[48:26] - Final Advice for Financial Modelers

In this episode of Financial Modeler’s Corner, host Paul Barnhurst sits down with Tim Vipond who is a seasoned finance professional and co-founder of the Corporate Finance Institute (CFI). They discuss financial modeling nightmares, strategy’s vital role in modeling, and the importance of avoiding shortcuts. Tim also shares his unique entrepreneurial journey and offers practical advice for improving modeling and strategic decision-making.Tim Vipond began his career as an investment banking analyst and later transitioned to wealth management, corporate development, and e-commerce finance. As the co-founder of the Corporate Finance Institute, Tim has trained over 2 million students and introduced practical certifications that reshape how finance professionals develop their skills. Tim’s blend of financial expertise, entrepreneurial spirit, and focus on strategy makes him a compelling guest for this conversation.Expect to Learn:How to avoid and learn from common financial modeling mistakes.Why aligning financial models with business strategy is critical.The journey of building the Corporate Finance Institute and insights into e-learning success.The role of assumptions, execution, and scenario analysis in effective modeling.Tim’s advice on combining unique skills to propel your career.Here are a few quotes from the episode:“Never take shortcuts in your modeling. It’s tempting when you’re under pressure, but those shortcuts will come back to bite you later.”“Combining two or more unique skills is the best way to get significantly ahead in your career. It’s where you stand out and add the most value.”“Many scenarios in models are not grounded in strategy. Thoughtful, realistic scenarios tied to strategic goals are what add real value.”Tim Vipond highlighted the interplay between technical mastery and strategic insight in financial modeling. Tim provided actionable advice on avoiding pitfalls, validating assumptions, and connecting models to overarching business goals. His emphasis on skill stacking and execution underpins the value of continuous learning and adaptation in a rapidly evolving field.Follow Tim:LinkedIn - https://www.linkedin.com/in/timvipond/Website - https://vipond.com/Company - https://corporatefinanceinstitute.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: [02:53] Financial Modeling Horror Stories[06:03] Building the Corporate Finance Institute[11:18] The Role of Strategy in Modeling[19:07] Execution and Modeling Feasibility[22:11] Scenarios and Sensitivity Analysis[30:52] Tim’s Favorite Investments and Skill Stacking[34:48] Unique Modeling Stories[36:06] Rapid Fire Questions[41:14] Closing Thoughts and Advice

In this special solo episode of Financial Modeler’s Corner, host Paul Barnhurst, known as the FP&A Guy, takes the spotlight to share his personal journey from a corporate financial analyst to an influential voice in financial modeling and FP&A. This episode is packed with career highlights, trends in financial modeling, and a mix of humor to kick off the new year.With over a decade of experience in corporate FP&A, Paul is a Microsoft MVP, a globally recognized trainer, and the founder of several successful podcasts. His personal story exemplifies persistence, continuous learning, and the value of building a personal brand.Expect to Learn:The career journey of Paul Barnhurst of creating a thriving business and gaining global recognition.Key lessons in financial modeling, including best practices in designing effective models.Trends shaping financial modeling and analytics for 2025, including the role of AI.Practical advice on building a personal brand and leveraging LinkedIn to grow professionally.A lighter side of finance with Paul’s humorous take on financial and Excel-related jokes.Here are a few quotes from the episode:"When I started my own business, I didn't have everything figured out, but I believed in taking the leap and figuring it out along the way.""The ability to build a personal brand is a career game changer, especially for financial professionals.""If you’re not having fun with what you do, find ways to bring your personality into your work—it makes all the difference."Paul Barnhurst takes us on a journey through his career by highlighting the lessons he’s learned and the challenges he’s faced. With light humor and practical advice, Paul inspires listeners to embrace growth, take risks, and build their own paths to success.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:13] - Introduction and Context[02:14] - The Early Career Struggles[04:50] - The Pivot to FP&A[06:24] - Building Financial Modeling Expertise[08:44] - Starting His Own Business[15:54] - Career in Financial Modeling[17:24] - Humor and Fun[20:06] - Trends for 2025[25:43] - Rapid Fire Financial Modeling Opinions[28:14] - Closing Remarks

In the second part of "The Great Debate," expert financial modelers from around the globe discuss controversial and thought-provoking questions about the art and science of financial modeling. The discussion focuses on the enduring relevance of Excel, the role of AI and Power BI in shaping the future of modeling. This episode highlights the nuances, complexities, and future of financial modeling as a discipline.This episode features Giles Male, co-founder of Full Stack Modeler and an Excel MVP, Will Wardle, an independent financial modeler with over two decades of experience, Carolina Lago, founder of Classic Financial, specializing in FP&A and financial restructuring for SMEs, Hedieh Kianyfard, a project finance expert from Iran, known for her practical solutions to complex modeling challenges, Oz du Soleil, a YouTube star and Excel MVP, renowned for his engaging tutorials and insights, Rishi Sapra, a former accountant turned Power BI advocate, and David Brown, a seasoned financial modeler with 27 years of experience, excelling in blending Excel with Power BI.Expect to Learn:The role of circular references in financial models.Why named ranges in Excel can either simplify or complicate financial models.The impact of AI on the future of financial modeling.How Power BI complements financial modeling by enhancing data visualization and storytelling.The debate on the most important financial statement and how it informs decision-making.Here are a few quotes from the episode:"Dynamic arrays offer huge improvements, and we should aspire to use them more effectively as a community." - Giles Male"A three-statement model is the universal language of finance, connecting operations and strategy for decision-making." - Carolina Lago"Power BI complements financial models by adding context, automation, and storytelling, making it a must-learn tool." - Rishi SapraThis episode of The Great Debate offers a lively exploration of financial modeling. The expert panelists highlight how financial modeling combines art and science, requiring technical mastery, critical thinking, and creativity. The discussions underscored the importance of balancing simplicity with complexity, leveraging technology without losing sight of foundational principles. Follow Giles:LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/Follow Will:LinkedIn - https://www.linkedin.com/in/will-wardle-3396259/Follow Carolina:LinkedIn - https://www.linkedin.com/in/s-carolinalago/Follow Hedieh :LinkedIn - https://www.linkedin.com/in/hediehkianyfard/Follow Oz:LinkedIn - https://www.linkedin.com/in/ozdata/Follow Rishi:LinkedIn - https://www.linkedin.com/in/rsaprano/Follow David:Website - https://www.dbrownconsulting.net/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:23] - Introduction to the Panel[05:51] - Circular References in Models[10:14] - The Use of VBA[14:55] - Dynamic Arrays Debate[19:57] - Named Ranges in Excel[24:50] - Will Excel Ever Die?[33:43] - Can AI Build Models?[37:56] - Should Modelers Learn Power BI?[53:28] - Most Important Skill for Modelers[57:40] - Closing Remarks

In this episode, host Paul Barnhurst talks about data integration, focusing on how finance professionals can streamline data processes and optimize workflows. The conversation also explores the balance between spreadsheets and specialized tools in financial modeling. He provides practical guidance for professionals navigating data challenges in the modern financial landscape. Adam Rakich is an experienced professional in financial planning and analysis (FP&A) software and data integration solutions. With career spanning tools like Adaptive Insights, OneStream, and DataBlend, Adam brings a unique perspective on how accountants and finance teams can leverage technology to overcome data-related inefficiencies.Expect to Learn:Why assumptions in financial models can make or break their reliability.The key factors that determine when to move from spreadsheets to planning tools.How to make data integration less intimidating for finance professionals.Practical solutions for accessing data across multiple systems, including API usage and hybrid approaches.Insights into the evolving role of Excel and Google Sheets in modern financial modeling.Here are a few quotes from this episode:“Spreadsheets are not multi-user, and anyone trying to make them that way is spending more time than they should.” - Adam Rakich“For fractional CFOs, marketplaces like Zero and QuickBooks can be lifesavers with cost-effective integrations.” - Adam Rakich“Every small automation reduces time and errors, even if the entire process can’t be automated.” - Adam RakichAdam Rakich shares the challenges and opportunities in data integration and financial modeling. He offers practical solutions to approach data integration without fear, and the evolving roles of tools like Excel, Google Sheets, and APIs.Follow Adam:LinkedIn - https://www.linkedin.com/in/rakich/Business User’s Guide to Data Integration - https://a.co/d/5xSL3g4Follow 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:30] – Introduction to the Episode[07:18] – Adam’s Career Journey[09:38] – Moving Beyond Spreadsheets[16:56] – Why Data Integration Matters[21:03] – Common Methods of Accessing Data[32:35] – SQL vs. Modern Tools[37:46] – The Business User’s Guide to Data Integration[44:32] – Rapid-Fire Questions[52:47] – Closing Thoughts

In this episode of Financial Modeler’s Corner, host Paul Barnhurst aka The FP&A Guy talks about the electrifying world of Excel Esports at the Financial Modeling World Cup (FMWC) in Las Vegas. This special episode captures the energy and innovation of the event, showcasing interviews with top competitors, including Excel MVPs and data enthusiasts, while exploring how Excel competitions push the boundaries of modeling expertise.The episode features Josh Aharonoff: Microsoft MVP, "Your CFO Guy," specializing in dynamic financial modeling and consulting. David Fortin: Excel expert, Microsoft MVP, and creator of the World of Warcraft-themed FMWC case study. Jaq Kennedy: UK-based actuarial consultant and Excel enthusiast, sharing personal stories and insights from the event. Amber Johnson: Industrial engineer turned Excel champion, known for her creative modeling approach.Expect to Learn:Insights into the competitive world of the Financial Modeling World Cup and the role of Excel Esports.Unique perspectives on the creative use of Excel, from real-world modeling to themed case studies.How Excel innovations like Power Query, dynamic arrays, and VBA are transforming data work.Personal journeys of Excel enthusiasts and their favorite tips and tools.Why participating in competitions like FMWC can rapidly enhance your financial modeling skills.Here are a few quotes from this episode:"I’ve spent 24 years working in Excel, and competing here has tripled my knowledge in just two years." - Jaq Kennedy"Competing is less about beating others and more about seeing how much you’ve improved." - Amber Johnson"Creating a case with input from Blizzard Entertainment was surreal—it brought my gaming passion into Excel." - David FortinThe Financial Modeling World Cup is a celebration of creativity, community, and growth. Events like these provide an experience of learning from the best in the field, or simply embracing the love of Excel. Follow Josh:LinkedIn - https://www.linkedin.com/in/joshaharonoff/Website - https://www.yourcfoguy.com/Follow David:LinkedIn - https://www.linkedin.com/in/david-fortin-cpa-816b20b5/Website - https://linktr.ee/PiggybankaccountantFollow Jaq:LinkedIn - https://www.linkedin.com/in/jaqkennedy/Follow Amber:LinkedIn - https://www.linkedin.com/in/ambernjohnsonwmu/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] - Introduction and Event Overview[03:39] - Interview with Josh Aharonoff and David Fortin[10:12] - Horror Stories and Excel Lessons[12:25] - Excel Preferences [23:04] - Interview with Jaq Kennedy[30:14] - Rapid Fire with Jaq[33:27] - Interview with Amber Johnson[42:22] - Closing Thoughts and FMWC Invitation[43:02] - Giles Male's Anthem

This episode takes you to the heart of the Financial Modeling World Cup (FMWC) 2024, hosted at the HyperX Gaming Arena in Las Vegas. Known as the "Excel Esports Championship," this unique event blends competitive financial modeling with the energy of live sports entertainment. From electric arenas to engaging case competitions, discover how Excel enthusiasts and world-class modelers push the boundaries of what's possible in financial modeling.This episode features an exceptional lineup of guests, including Andrew Grigolyunovich, founder of the Financial Modeling World Cup and a pioneer in turning financial modeling into an esport; Michael Jarman, the 2024 FMWC World Champion known for his innovative modeling techniques and leadership at Operis; Giles Male, a commentator and self-proclaimed “Most Humble MVP”. Klinsmann Langhanz, founder of FMWC Brasil and a passionate advocate for Excel training and community-building; and appearances from Danielle Stein Fairhurst and Jaq Kennedy.Expect to Learn:How the FMWC is transforming financial modeling into an exciting esport.Insights from top modelers on preparing for high-pressure competitions.The role of networking and community in fostering innovation and growth in the Excel world.Practical advice for improving financial modeling skills through competitions.Behind-the-scenes from the HyperX Arena, including hilarious moments.Here are a few quotes from this episode:"Financial modeling competitions make you better at work and expand your career horizons." - Andrew Grigolyunovich"The FMWC community is about helping each other, not tearing each other down." - Giles Male"The unthinkable becomes possible when you network and collaborate." - Klinsmann LanghanzWith the Financial Modeling World Cup 2024, we've seen how Excel has grown from a business tool to the centerpiece of a thriving global community. From the inspiring vision of Andrew Grigolyunovich to the insights of world champion Michael Jarman, this event celebrates the art, science, and camaraderie of financial modeling.Follow Andrew:LinkedIn - https://www.linkedin.com/in/andrewgrig/Company - https://fmworldcup.com/Follow Michael:LinkedIn - https://www.linkedin.com/in/michael-jarman-excel/Email: [email protected] Giles:LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/Follow Danielle:LinkedIn - https://www.linkedin.com/in/daniellesteinfairhurst/ Follow Klinsmann: LinkedIn - https://www.linkedin.com/in/klinsmann-langhanz/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: [00:01:42] - Host Paul Barnhurst sets the stage[00:03:59] - A recap of the event's atmosphere[00:07:13] - Interview: Andrew Grigolyunovich[00:12:14] - Vision for the Future of FMWC[00:22:54] - Creating FMWC Case Studies[00:34:13] - Michael Jarman's Journey[00:49:50] - Commentary with Giles Male[00:56:22] - Jaq Kennedy and Danielle Stein Fairhurst [00:58:24] - Interview: Klinsmann Langhanz[01:08:38] - Closing Thoughts

In this episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes Charles Keepman, a seasoned financial modeler and valuation expert, to discuss the intricacies of financial modeling, best practices, and common pitfalls. They explore real-world scenarios, discuss the value of creating dynamic models, and delve into the art of valuing companies, focusing on how different industries and stages of business impact modeling strategies.Charles Keepman has spent years honing his skills in financial modeling, starting at Ernst & Young and later working at Economics Partners (now Ryan Valuation). With deep expertise in business valuation, Charles currently applies his modeling skills to help clients make strategic financial decisions. His career trajectory has been shaped by his passion for creating efficient and dynamic financial models that help businesses make informed, data-driven decisions.Expect to Learn:Key principles for building auditable, easy-to-follow financial models.Insights into business valuation: when to use different approaches like DCF, asset, and market-based methods.The role of qualitative factors in valuation and how they can drastically influence outcomes.The role of Excel and financial modeling software in today’s fast-paced financial world.Why simplicity often trumps complexity in financial modeling, and how to strike the right balance.Here are a few quotes from Charles Keepman:"I think AI will have a profound effect on financial modeling, but we need to make sure it’s auditable and understandable.""Financial models are great tools, but the true value lies in understanding the assumptions behind them.""You can get stuck in analysis paralysis if you overcomplicate your models with too many variables."From emphasizing the importance of simplicity and clear assumptions to his preference for using tools like XLOOKUP over complex formulas, Charles provides a wealth of practical advice. His perspective on AI in financial modeling highlights the balance between leveraging technology and maintaining human judgment, ensuring that models remain accurate and useful.Follow Charles:LinkedIn - https://www.linkedin.com/in/charles-keepman-58766a40/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:24] - Introduction to Charles Keepman[02:03] - The "Worst Financial Model" Horror Story[05:57] - A Rundown of Charles’ Career[09:04] - The Favorite Part of Financial Modeling[14:53] - The Most Unique Uses of Excel in Personal Life[17:26] - Valuing a Company: The First Steps[21:43] - The Most Unique Business Models[23:41] - Excel vs. Deal Work[27:03] - The Simplicity vs. Complexity Debate[32:49] - Excel's Evolution: Favorite Features[36:20] - Rapid Fire Segment[45:27] - Final Advice and Closing

In this special debate episode, host Paul Barnhurst aka The FP&A Guy is joined by an all-star panel of modeling experts to tackle some of the most contentious questions in the financial modeling world. This lively discussion promises insights, entertainment, and plenty of surprises as the panelists bring their expertise and humor to the table. Together, they bring decades of experience, fresh perspectives, and a shared passion for the art and science of financial modeling.The powerhouse panel of financial modeling experts include: Derek Baker, FP&A professional and co-founder of the FP&A Hub; Lance Rubin, CEO of Model Citizen and Chief Excel Officer at Excel Cloud; Diarmuid "Dim" Early, founder of Early Days Consulting; Craig Hatmaker, retired founder of Beyond Excel and advocate for modern modeling techniques; Dr. David Brown, finance professor at the University of Arizona and founder of the Microsoft Excel Collegiate Challenge; Danielle Stein Fairhurst, Sydney-based financial modeling trainer, author, and Microsoft MVP; Ian Bennett, leader of PwC's global financial modeling practice and Master Financial Modeler; and Craig Thompson, former investment banker now innovating in software at Aleph. Expect to Learn:Why financial models are (or aren’t) the ultimate decision-making tool for businesses.The role of Excel in the future: is it here to stay, or will it be replaced by emerging technologies?Power BI, Power Query, and Python in financial modeling—are they worth learning?Controversial techniques: the debate on circular references and dynamic arrays.Whether AI will eventually replace human modelers—and how soon.Here are a few quotes from the episode:"Excel’s modern tools, like Power Query and lambdas, are setting the stage for AI to change how we build models." - Lance Rubin"AI can process data, but it lacks the creativity and business acumen needed for financial modeling." - Danielle Stein Fairhurst"Excel is the foundation of the financial system, and its adaptability ensures it will last for years to come." - Dr. David BrownFrom the future of Excel to the role of AI, the importance of financial statements, and the tools that modelers should master, this episode explored the evolving landscape of financial modeling.Follow Derek:LinkedIn - https://www.linkedin.com/in/derek-d-baker/Follow Lance:LinkedIn - https://www.linkedin.com/in/financial-modelling/Follow Diarmuid:LinkedIn - https://www.linkedin.com/in/diarmuidearly/Follow Craig H:LinkedIn - https://www.linkedin.com/in/craig-hatmaker-4449879/Follow David:Website - https://www.davidclaytonbrown.com/Follow Danielle:LinkedIn - https://www.linkedin.com/in/daniellesteinfairhurst/Follow Ian:LinkedIn - https://www.linkedin.com/in/ianrbennett/Follow Craig T:LinkedIn - https://www.linkedin.com/in/cfthompson/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:42] - Introduction to the Episode[04:16] - The Debate Battle Starts [07:12] - Should Financial Modelers Learn Python?[11:15] - Dynamic Arrays vs. Traditional Models[16:52] - Will Excel Ever Die?[20:55] - Should Financial Modelers Learn Power BI?[26:21] - Will AI Build Financial Models?[32:09] - Circular References: Useful or Evil?[39:27] - VBA in Financial Models[44:41] - Number One Corporate Decision Making Tool[52:58] - Which Financial Statement is Most Important? [59:50] - Conclusion and Audience Poll

In this episode of Financial Modelers Corner, Paul Barnhurst aka The FP&A Guy dives deep into the intersection of corporate development and financial modeling, focusing on mergers and acquisitions (M&A). Sean Corcoran, a seasoned expert with over 20 years in corporate development, shares his insights on navigating complex transactions, building effective financial models, and driving strategic growth through acquisitions.Sean Corcoran is the Head of Corporate Development at DigiCert and has an illustrious career spanning Fortune 50 companies, private equity-backed ventures, and public firms. With experience leading over 60 acquisitions worth billions, Sean has a comprehensive understanding of the M&A lifecycle, strategic planning, and financial modeling.Expect to LearnWhy simplicity and strategy are vital in corporate development financial models.Common pitfalls in financial models and how to avoid them.The importance of aligning strategic intent and integration during acquisitions.How FP&A professionals can transition into corporate development roles.The evolving tools and techniques in M&A due diligence and decision-making.Here are a few quotes from Sean Corcoran:"Culture is one of the key criteria for successful acquisitions; the only way to assess it is to spend time with the prospective target.""A strategic partnership often evolves into an acquisition when both sides see value and alignment.""From a corporate development perspective, simplicity is king when building financial models.""AI is starting to play a role in M&A, especially in reviewing contracts and highlighting potential red flags."From understanding the nuances of culture in acquisitions to navigating the challenges of carve-outs and earnouts, this episode offers an insightful conversation that highlights the complexity and opportunity within corporate development and the critical role of financial modeling.Follow Sean:LinkedIn - https://www.linkedin.com/in/sean--corcoran/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:19] - Introduction to the Episode and Guest[05:37] - Sean’s Background and Career Journey[08:09] - Key Lessons from M&A Experience[12:43] - Responsibilities in Corporate Development[17:10] - Favorite Deals and Lessons Learned[21:37] - Building Effective Financial Models[30:11] - Ensuring Alignment in Financial Modeling[34:36] - Lessons from a Career in Corporate Development[37:39] - Rapid-Fire Questions[42:59] - Closing and Networking

In this engaging episode of Financial Modelers Corner, host Paul Barnhurst, aka "The FP&A Guy," sits down with Liam Bastick, Managing Director of Sum Product and a highly respected figure in financial modeling and Excel expertise. Known for his complex modeling work, quirky sense of humor, and love for a good challenge, Liam shares insights into the nuances of financial modeling, discusses his favorite Excel tips, and reveals his fascination with the evolving role of AI in modeling. Liam Bastick is a seasoned corporate trainer, author, and financial modeling expert, with a focus on Excel, Power BI, and AI applications. With a career that includes awards like Microsoft’s Most Valuable Professional and the inaugural Lifetime Achievement, international recognition, and extensive teaching, Liam provides listeners with both practical advice and fascinating anecdotes from his career.Expect to Learn:Excel optimization tips and learn how to effectively use Quick Access toolbar Circular references and financial modeling horror story insightsChallenges and advantages of modeling in Power BIHow AI is changing financial modeling and what the future might holdLiam’s approach to problem solving to stay at the forefront of innovationHere are a few quotes from Liam Bastick:“The best tip I can give is to put the tools you use most often on the Quick Access toolbar. It’s underused but incredibly helpful.”“If you've got circular references in your model, you’re already on thin ice. They can lead to wrong answers and complete chaos.”“With AI, you can do the front-end and back-end work in financial modeling, but it’s still not there yet for the mechanics in the middle.”In this insightful episode, Liam Bastick shared his passion for financial modeling, bringing both humor and depth to complex topics in Excel, Power BI, and AI. His reflections on adaptability, continuous learning, and challenging the limits of traditional tools serve as powerful reminders for anyone in finance or data analysis. Follow Liam:Website - https://www.sumproduct.com/LinkedIn - https://www.linkedin.com/in/liam-bastick-73a39114/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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:52] – Introduction to guest Liam Bastick[03:44] – Liam’s Modeling Horror Stories[08:32] – Liam’s Professional Journey and Challenges[14:17] – Running a Business and Reinvention[16:05] – Discussing AI’s Impact on Financial Modeling[20:39] – Books and Teaching Tips[35:50] – Rapid Fire: Excel Best Practices[46:57] – Advanced Modeling Techniques and Final Tips[54:16] – Contact Information and Wrap Up

In this insightful episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) welcomes financial modeling expert Rachit Jain. They delve into the nuances of financial modeling, exploring the art of building accurate, reliable models and the importance of critical thinking and lifelong learning in finance. Rachit shares real-world horror stories from his early career, reflects on the challenges of predictive modeling, and emphasizes the human elements that make models truly effective.Rachit Jain is a seasoned financial modeler with extensive experience in finance, auditing, and quantitative modeling. Having worked with firms like Hewlett Packard and Deloitte, Rachit brings a wealth of knowledge on creating models that inform decision-making and avoid critical pitfalls. His expertise spans FP&A, data science, and quantitative finance, making him an authority on building dynamic, real-world financial models.Expect to Learn:How to build trust in financial models through transparency and sound designWhy critical thinking and communication skills are crucial in financial modelingRachit’s career journey and his transition from audit to financial modelingThe role of data science in enhancing financial modeling capabilitiesStrategies for applying financial modeling in personal decision-makingHere are a few quotes from Rachit Jain:"The first step in financial modeling is critical thinking – you need to know what you want to achieve before you start building.""In financial modeling, curiosity is everything. It’s what drives you to improve and learn beyond the basics.""Before starting in financial modeling, understand what part of FP&A suits your skills. Not everyone is a ‘numbers person,’ and that’s okay."In this episode, Rachit Jain highlights financial modeling as both an art and science, emphasizing the importance of accuracy, clarity, and storytelling. Rachit’s approach shows that great financial modeling goes beyond numbers; it requires curiosity, critical thinking, and a balance between simplicity and sophistication.Follow Rachit:LinkedIn - https://www.linkedin.com/in/jainrachit1008/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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:15] - Introduction to the Episode and Guest[05:26] - Rachit’s Background and Career Path[09:00] - Advice for Transitioning to Financial Modeling[11:01] - Lifelong Learning in Finance[13:17] - Financial Modeling as a Way of Thinking[18:15] - Unique Applications of Financial Modeling[22:23] - Building Models for Decision Making Process[26:57] - The Intersection of Data Science and Financial Modeling[33:40] - Rapid-Fire Financial Modeling Preferences[38:53] - Closing Advice and Wrap Up

In this episode, Paul Barnhurst, host of Financial Modeler’s Corner, is joined by Carl Seidman, an experienced financial consultant and financial modeling expert. Together, they explore the intricacies of financial modeling, discuss the art and strategy of dynamic cash flow modeling, and touch on the unique challenges and lessons Carl has gathered from his years in turnaround consulting. They also discuss the broader skills and mindset shifts required for modelers who aim to excel in the complex field of financial analysis and corporate finance.Carl Seidman is the founder of Seidman Financial and a recognized expert in financial planning, forecasting, and modeling. With experience in turnaround consulting and as a fractional CFO, Carl has worked extensively with underperforming companies and complex restructuring cases. He brings an in-depth understanding of the strategic nuances in financial modeling and cash flow management, which he shares in this episode.Key takeaways from this week's episode include:The importance of long-term, flexible thinking in financial modeling and planning.Carl’s top lesson learned from a modeling “horror story” and how it shaped his approach to dynamic modeling.How dynamic arrays are transforming cash flow modeling and how to implement them.Why operational knowledge is crucial for effective financial modeling in turnaround situations.The value of networking and formal certifications in restructuring and financial advisory roles.Here are a few quotes from Carl Seidman:"Financial modeling in complex situations is about facilitating discussions, not just presenting numbers." "A good model tells you the ‘what,’ but the analysis and conversations that follow tell you the ‘so what’ and ‘now what.’""It's important to know when to push the boundaries of what a model can do and when to keep things simple."In this insightful episode, Carl Seidman leaves listeners with practical advice and a fresh perspective on financial modeling’s role in modern business. He highlights the value of flexibility, clear communication, and a long-term mindset, particularly in the complex terrain of turnaround consulting. Follow Carl:Website - https://seidmanfinancial.com/LinkedIn - http://linkedin.com/in/carlseidmanFollow 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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:12] – Introduction to the episode and guest[05:44] – Key Lessons in Modeling and Long-Term Strategy[10:36] – From PwC to Turnaround Consulting[16:02] – Certified Insolvency and Restructuring Advisor (CIRA)[20:20] – Diagnosing Cash Flow Issues in Underperforming Companies[28:52] – Embracing Dynamic Arrays for Efficient Cash Flow Modeling[32:40] – Modeling Mindset: Curiosity and Continuous Improvement[37:57] – Rapid-Fire Q&A: Financial Modeling Preferences[41:59] – Advice for Aspiring Modelers: Practice and Experiment[43:30] – Closing Remarks and Where to Connect

In this episode of Financial Modelers Corner, host Paul Barnhurst (aka The FP&A Guy) is joined by guest Mark Proctor. Together, they delve into the intricacies of financial modeling and data analysis, with a focus on building efficient models and leveraging automation in Excel. Mark shares his deep expertise on why structure is key, how to automate tedious tasks, and how Excel continues to evolve to meet the demands of modern financial professionals.Mark Proctor is a seasoned financial professional with a background in accounting and finance, an Excel MVP, and the founder of Excel Off the Grid, a platform dedicated to improving efficiency and effectiveness in Excel. With decades of experience, Mark's insights are invaluable for anyone looking to optimize their use of Excel for financial modeling and beyond. He has helped countless professionals streamline their work through better data structure and automation techniques.Key takeaways from this week's episode include:Key differences between financial modeling and data analysisImportance of automation in Excel and how tools like Power Query and Power Pivot can drastically improve efficiency.Why traditional tools like Vlookup aren’t ideal for modern data analysis and what functions you should be using instead.How to approach building models that are flexible and easy to use, even when multiple stakeholders are involved.Practical strategies for reducing manual processes and eliminating the need for repetitive tasks in Excel.Here are a few quotes from Mark Proctor:"Hard coding is the enemy of a flexible financial model. Once you start hard coding, you lose the ability to see what's really driving the model.""One of the key takeaways from bad models is that manual adjustments should always be documented and trackable.""Automation should be about freeing up your time to focus on high-value tasks, not just about making things faster."As Excel continues to evolve with powerful features like dynamic arrays and advanced automation, the tools discussed in this episode are essential for anyone looking to keep pace with the future of financial modeling. Mark’s emphasis on mastering the basics and thinking structurally will help you work faster and more effectively.Follow Mark:Website - https://exceloffthegrid.com/LinkedIn - https://www.linkedin.com/in/markstephenproctor/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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:54] - Financial Modeling Horror Stories[04:55] - Lessons from Bad Models[06:28] - Mark's Career Journey and Background[12:59] - Data Analysis vs. Financial Modeling[19:17] - Excel as a Data Analysis Tool: Key Innovations[22:55] - Automation in Excel and Practical Tips[33:59] - The Importance of Mastering Excel Basics[44:19] - Wrap-Up and Closing Remarks

In this episode of Financial Modeler’s Corner, host Paul Barnhurst dives into the evolution of financial modeling with guest Chase Wright. The discussion focuses on modern financial modeling tools and workflows, particularly a new spreadsheet tool called Equals, and how it compares to Excel and Google Sheets. Wright shares his journey from a finance background to working at startups, where he developed innovative methods to streamline financial operations using cutting-edge tools.Chase Wright is a seasoned finance executive with a decade of experience across startups and tech companies like GitLab, Instabug, and Red Hat. Currently the Head of Finance and Data at Uniqode, Chase has a unique blend of corporate finance, data science, and business management expertise. He’s also an advisor to Cacheflow and a limited partner at FOG Ventures. With an engineering background and deep experience in finance, Chase brings a fresh perspective on the challenges and innovations in financial modeling.Key takeaways from this week's episode include:How Chase Wright’s career journey led him to innovate in financial modelingThe role of modern spreadsheet tools like Equals in finance and data teamsHow to use tools like Equals to automate reporting and financial analysisThe importance of balancing curiosity and necessity when developing career skillsThe pros and cons of traditional modeling tools like Excel and Google Sheets versus newer alternativesHere are a few quotes from Chase Wright:“Equals is a modern spreadsheet for data and finance teams, connecting directly to your data sources.” - Chase Wright“Financial models are incredibly helpful, but at the end of the day, it's the intuition behind the model that really matters.” - Chase Wright“Slack integration in Equals makes communicating insights across the company incredibly simple.” - Chase Wright“AI in Equals acts as a copilot, making things like summing columns or adding borders incredibly intuitive.” - Chase WrightIn this episode, Chase Wright shares his journey from struggling with complex models in Excel to embracing the automation and connectivity that Equals offers highlights the growing need for more intuitive and efficient financial tools. He emphasizes that the right tools, combined with critical thinking, can not only improve workflows but also provide deeper insights that drive business success.Follow Chase:Website - https://www.uniqode.com/LinkedIn - https://www.linkedin.com/in/chasewright/Blog - https://medium.com/uniqode-secret-sauce/an-operators-guide-for-managing-your-saas-startup-s-cash-flow-c1dbfc3a1e71Follow 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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:45] – Introduction to Chase Wright and his journey[02:54] – The nightmare of VBA models and lessons[04:24] – Educational Path: Finance to Engineering[07:01] – Equals: The modern spreadsheet tool[15:13] – How Equals Simplifies Data Integration[20:02] – Financial modeling: Critical Thinking in Action[31:03] – Rapid Fire Segment: Excel and Equals [39:37] – Conclusion and Final Thoughts

In this innovative episode, Paul Barnhurst experiments with Google’s AI tool, Notebook LM, and transforms previous guest interviews into an AI-generated episode. He explores the insights and best practices in financial modeling, as shared by veterans Scott Rostan, founder of Training the Street, and Ian Bennett, a PwC Australia leader with extensive experience in managing large modeling teams. By leveraging AI, this episode explores how technology can recreate meaningful conversations with industry leaders, providing an interactive look at best practices, common pitfalls, and the evolving landscape of financial modeling. Paul explores advanced technical skills and the human elements that are essential to successful financial modeling.Key takeaways from this week's episode include:Four essential key pillars for excelling in financial modelingStrategies for maintaining simplicity and auditability in financial modelsEmerging tools in Excel and functionality of traditional financial modelingHow financial modeling expertise goes beyond technical skills Insights on the potential future of financial modeling with AI advancements Quotes from the Episode:"Even in the world of complex finance, sometimes the simplest approach is the best approach." - Scott Rostan"It’s about seeing the big picture, understanding your client’s needs and using your modeling skills to craft a solution, not just a spreadsheet." - Ian Bennett"AI will get really good at those technical tasks, cleaning up data, maybe running some basic forecasts, but that just frees us humans up to focus on the stuff that requires creativity, critical thinking, and emotional intelligence." - AIIn this special AI-driven episode, Paul Barnhurst invites listeners to consider how the field of financial modeling is both grounded in foundational skills and evolving with new technologies. It’s about connecting with clients, asking the right questions, and using your skills to drive better business decisions.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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:17] Introduction to the episode[03:57] Lessons from modeling mistakes[06:29] Four key pillars of financial modeling[08:51] Managing large-scale models[13:40] Excel’s power stack and future enhancements[15:14] Modeling standards and best practices[19:38] Excel’s longevity and AI’s role[22:44] The World of fractional FP&A [27:38] AI’s place in financial modeling[33:16] Wrap-up and invitation for feedback

In this episode of Financial Modelers Corner, host Paul Barnhurst dives deep into the world of Quality of Earnings (QofE) with expert guest Patrick McMillan, a seasoned CFO and transaction advisor. The conversation explores the intricacies of QofE, its importance in financial transactions, and the role it plays in assessing a company's financial health during mergers and acquisitions. Patrick shares real-world examples and insights into how financial professionals can use QofE to make informed decisions.Patrick McMillan is a fractional CFO and transaction advisor at Amplēo, a Utah-based firm specializing in providing executive support to growing companies. With over two decades of experience in guiding businesses through periods of growth and M&A transactions, Patrick is known for his expertise in Quality of Earnings analysis. He brings a dynamic and passionate approach to finance, blending technical skill with strong storytelling abilities to help businesses navigate complex financial landscapes.Key takeaways from this week's episode include:The role of Quality of Earnings (QofE) in mergers and acquisitions, and how it differs from an audit.How to differentiate between non-recurring and operating items when analyzing financial statements.The importance of normalizing earnings for better understanding of a company’s performance.Why soft skills like communication and storytelling are crucial in financial analysis.Insights into how personal finance modeling can improve your financial modeling skills.Here are a few quotes from Patrick McMillan:"Quality of earnings isn't just an audit; it shows you how and why a company is performing in a certain way." - Patrick McMillan"Understanding non-operating and non-recurring items is crucial to a quality of earnings report." - Patrick McMillan"Patience is the most important lesson I’ve learned in my career, especially in communication." - Patrick McMillan"Modeling your own personal finances is a great way to practice financial modeling skills." - Patrick McMillanWith actionable advice on financial modeling, transaction strategies, and lessons learned from his personal experiences, Patrick’s insights will resonate with professionals looking to sharpen their financial skills and improve decision-making in dynamic business environments.Follow Patrick:Website - https://ampleo.com/contact/LinkedIn - https://www.linkedin.com/in/patrickmcmillan/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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:10] - Introduction to Patrick McMillan [04:25] - Worst Financial Model Story[07:30] - Quality of Earnings vs. Audits[09:30] - Identifying Non-Recurring vs. Operating Items[13:31] - Patrick’s Journey to Becoming the "QofE Guy"[17:57] - The technical understanding of QofE[24:51] - Patrick’s decision for MBA[29:56] - Importance of soft skills in QofE[35:20] - Rapid-Fire Financial Modeling Tips[38:44] - Personal Insights: Mountain Biking and Life Lessons

In this episode of Financial Modelers Corner, host Paul Barnhurst welcomes Ruby Liu, Director at KPMG Australia’s Valuation Team, to dive into intricacies of financial modeling. Having led KPMG Australia’s Sydney modeling team and worked as the head of corporate finance in the energy sector, Ruby’s vast experience spans from transactional modeling for infrastructure assets to advising clients on valuation and capital raising. Ruby Liu brings over 16 years of professional expertise in corporate finance, financial modeling, and valuations. This episode offers practical insights on managing complex financial models, optimizing processes, and the challenges of transitioning models from transactional to operational use. Ruby’s guidance provides a valuable learning opportunity on how to build efficient and user-friendly financial models. Her deep knowledge and hands-on experience make her a key voice in the field of financial modeling. Key takeaways from this week's episode include:The key differences between transactional and operational models and how to adapt them for long-term use.Why keeping the model user in mind is crucial for building effective financial models.Ruby’s top strategies for creating models that are simple, visually appealing, and efficient in calculation speed.Insights into the challenges of working with large, complex models and how to manage issues.How Ruby’s experiences at KPMG shaped her understanding of the financial modeling landscape.Here are a few quotes from Ruby Liu:"The most efficient model isn’t the one with the most complex formulas, but the one that’s easy to understand and use." - Ruby Liu"In financial modeling, the goal is to fit the user’s purpose, not dazzle them with complexity." - Ruby Liu"I think AI can help build models, but we’ll still need human oversight to interpret the results." - Ruby LiuIn this insightful episode, Ruby Liu offers a masterclass in financial modeling. From her candid reflections on the pitfalls of overly complex models to the importance of keeping the end user in mind, Ruby’s practical advice is invaluable for both novice and seasoned modelers alike. Follow Ruby Liu:LinkedIn - https://www.linkedin.com/in/liurubyFollow 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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:13] - Introduction to the episode and guest[03:01] - Worst financial model and lessons learned[08:28] - Ruby reflects on her evolving perspective on the industry [12:47] - Ruby’s leadership experience at KPMG’s Sydney team[16:47] - Insights into Ruby’s current role in valuations[22:14] - Different valuation methods; income and market approaches[25:57] - Converting transactional models into operational ones [41:16] - Rapid fire questions segment with Ruby[47:49] - Advice for modelers and contact information

In this special solo episode, host Paul Barnhurst, also known as "The FP&A Guy," reflects on key insights gathered from past episodes of Financial Modeler’s Corner. With over 40 episodes under his belt, Paul dives into recurring rapid-fire questions posed to expert financial modelers worldwide. From circular references to VBA use and Excel's future, this episode offers valuable wisdom on the art and science of financial modeling.Paul Barnhurst, an accomplished financial modeling professional and host of the podcast, takes center stage. Paul is the founder of “The FP&A Guy” and has earned the prestigious Advanced Financial Modeler (AFM) certification from the Financial Modeling Institute (FMI). His wealth of experience and insights makes this solo episode both engaging and informative.Key takeaways from this week's episode include:The most common preferences of expert financial modelers on key technical decisions.Why dynamic arrays and other Excel functions are becoming increasingly important, and the pace of their adoption.Insights into how artificial intelligence (AI) could impact financial modeling and whether it will replace human modelers.The importance of good design principles in financial models, as shared by leading financial modeling experts.Fun and practical Excel shortcuts used by seasoned modelers to boost efficiency and accuracy.Here are a few quotes from Paul in this episode:"Circular references are dangerous because most people don’t really understand what’s going on, and it can lead to other errors in your model." - Paul Barnhurst"If at all possible, don’t use VBA in your model. The less you use it, the simpler the model is." - Paul Barnhurst"I’m of the belief that AI will build models for us. It’s a question of when, not if." - Paul BarnhurstIn this special solo episode, Paul Barnhurst takes a moment to reflect on the lessons learned from over 40 episodes of Financial Modeler’s Corner. He shares key takeaways from the rapid-fire questions posed to some of the top financial modelers in the world, offering a wealth of advice on best practices, common pitfalls, and emerging trends in financial modeling. As always, he invites listeners to reach out with feedback, questions, and guest suggestions, reinforcing the show's commitment to fostering a global community of financial modeling enthusiasts.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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:09] - Introduction and background[03:18] - Circular references in models[04:55] - VBA in financial models[06:45] - Dynamic arrays: the future of excel?[16:50] - Will excel ever die?[18:16] - AI and financial modeling[20:31] - Financial models as corporate decision-making tools[22:26] - Favorite excel shortcuts from top financial modelers[30:34] - Closing thoughts and invitation to audience

In this episode of Financial Modelers Corner, host Paul Barnhurst welcomes Paul Medici, founder and CEO of Medici Financial Modeling. They dive into the art and science of financial modeling, sharing horror stories, insights, and practical tips on how to avoid common pitfalls. The discussion revolves around the importance of simplicity and structure, and how mastering the fundamentals can save time and deliver better results.Today’s guest is Paul Medici, the Founder and CEO of Medici Financial Modeling. With over a decade of experience, Paul specializes in building bespoke financial models and custom data automation tools for corporate clients across the US, Canada, and Europe. His expertise spans a wide range of industries, including financial services, healthcare, manufacturing, mining, real estate, retail, technology, and even charitable organizations. He holds an MBA from the University of Toronto and a Master’s in Geological Science and Engineering from Queen’s University.Key takeaways from this week's episode include:The most common mistakes in bad financial models and how to avoid them.How a background in geology led Paul Medici to a career in financial modeling.The importance of understanding revenue and cost build-ups in different industries.Why practicing financial modeling on personal projects can enhance your skills.Key shortcuts and techniques to speed up your Excel modeling process.Here are a few quotes from Paul Medici:"All bad models have one thing in common: they're not user-friendly, difficult to update, and time-consuming." - Paul Medici"Most corporate models start simple but turn into 'Frankenstein' models over time as people add complexity." - Paul Medici"If you're thinking about financial modeling, practice by building models for everyday tasks like personal budgets." - Paul Medici"The key to mastering financial modeling is understanding how the financial statements and supporting schedules link together." - Paul MediciFrom his early career in geology to teaching advanced Excel at top investment banks, Paul brings a wealth of knowledge to the conversation. He emphasizes the importance of building user-friendly models, practicing regularly, and finding the right balance between complexity and functionality. Follow Paul Medici:Website - https://medicifinancialmodeling.com/LinkedIn - https://www.linkedin.com/in/paulmedici/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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:27] - Introduction to the episode and guest [03:15] - The worst financial model story and lessons learned.[07:17] - Career transition from Geology to Finance[12:40] - Challenges in modeling different industries[19:22] - Favorite industries and financial models[22:17] - Bespoke data automation tools[25:47] - Teaching Excel and financial modeling courses[34:29] - Advice for FMI Certification[39:03] - Rapid fire: financial modeling preferences[44:13] - Final advice and contact information

In this episode of the "Financial Modelers Corner," host Paul Barnhurst welcomes Gilbert Hangartner, a financial modeler with a background in science. The discussion delves into the intricacies of financial modeling, the importance of simplicity in model construction, and the application of Monte Carlo simulations to understand risk. Gilbert shares his insights on how to approach financial modeling by asking the right questions rather than having complex formulas.Gilbert Hangartner is a seasoned financial modeler who transitioned from a career in science, specializing in chemistry and physics, to financial modeling and risk analysis. His scientific training gives him a unique perspective on financial modeling, treating it as both a creative process and a technical discipline. Gilbert emphasizes the importance of simplicity and clarity in building effective models and is an advocate for using models as tools for communication and strategic decision-making.Key takeaways from this week's episode include:Understanding the importance of simplicity in modeling The debate on whether financial modeling is more of an art or a scienceSimplifying a problem and understanding the question before diving into model building.Introduction to Monte Carlo simulations for risk managementA discussion on the limitations of Excel and future of financial modelingHere are a few quotes from Gilbert Hangartner:"A good model is not about complexity; it's about clarity and answering the right question." - Gilbert Hangartner"For me, modeling is a creative act, much like writing a song or painting a picture." - Gilbert Hangartner"Multi-dimensional modeling is key; real-world problems are never just two-dimensional." - Gilbert Hangartner"The future of financial modeling lies beyond Excel; it’s time for more advanced, structured tools." - Gilbert HangartnerIn this episode, Gilbert Hangartner offers a fresh perspective on the world of financial modeling and challenges the conventional wisdom that financial models must be complex to be effective. Whether you're a seasoned modeler or just starting out, Gilbert's insights on Monte Carlo simulations provide valuable guidance on how to enhance your modeling skills and approach.Follow Gilbert:LinkedIn - https://www.linkedin.com/in/gilbert-hangartner-71754047/ 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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:16] - Introduction to the episode and the guest, Gilbert Hangartner[01:57] - The worst financial model horror story shared by Gilbert[04:42] - Discussion on the importance of simplicity in financial modeling[06:10] - Gilbert explains his transition from science to financial modeling[10:11] - Art or Science? The nature of financial modeling[13:45] - Strategies for asking the right questions when building a model[17:16] - An overview of Monte Carlo simulations for risk modeling[28:31] - The advantages of Quantrix over Excel [44:47] - A contrarian view on the future of Excel in financial modeling[47:48] - Closing Remarks and Contact Information

In this episode of Financial Modelers Corner, host Paul Barnhurst is joined by Giles Male, who brings his unique perspective on the rapidly changing landscape of financial modeling. Together, they explore how the latest advancements in Excel—such as dynamic arrays and Lambda functions—are revolutionizing the way financial models are built and used. Giles also provides invaluable advice on the importance of simplicity, adaptability, and effective communication in modeling.Giles Male is a CMA-qualified accountant and a seasoned financial modeler with extensive experience in bid analysis and complex financial modeling. As a co-founder of Full Stack Modeler, Giles is passionate about training and mentoring the next generation of financial modelers. He holds the prestigious Master Financial Modeler (MFM) accreditation from the Financial Modeling Institute, making him one of only seven individuals worldwide to have achieved this honor. Giles brings a wealth of knowledge on modern Excel and its application in financial modeling.Key takeaways from this week's episode include:The importance of embracing modern Excel techniques, including dynamic arrays and Lambda functions.Insights into the changing landscape of financial modeling and why simplicity is often more effective than complexity.The challenges and rewards of transitioning from traditional modeling methods to modern approaches.How Giles's experiences in ultra-marathon running have influenced his approach to problem-solving and pushing beyond perceived limits in both personal and professional contexts.Practical advice on maintaining model integrity, including the use of structured standards like FAST or SMART while adapting to specific project needs.Here are a few quotes from Giles Male:"Simplicity is the biggest lesson I’ve learned in my career. Complex models might seem impressive, but they’re often impractical." - Giles Male"A good financial model should be as complex as it needs to be, but as simple as possible." - Giles Male"There’s a visibility fog when reviewing your own models. Stepping away and coming back later is essential." - Giles MaleIn this episode, Giles Male offers a wealth of insights into the evolving world of financial modeling. He emphasizes the importance of simplicity, the transformative power of modern Excel, and the critical need for clear communication in model design. As the industry continues to evolve, Giles’s focus on adaptability, continuous learning, and user-centric design serves as a guide for both seasoned professionals and newcomers alike.Follow Giles:Website - https://www.fullstackmodeller.com/LinkedIn - https://www.linkedin.com/in/giles-male-30643b15/ 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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode: [01:18] - Introduction to the topic and guest Giles Male[05:31] - Lessons from complex models[07:12] - Giles shares his career journey into financial modeling[16:10] - Achieving master financial modeler accreditation[17:19] - Giles shares practical project insights[28:42] - Defining advanced modeling skills[34:00] - The future of excel and financial modeling[41:50] - Excel shortcuts and best practices[47:47] - Conclusion and contact information

In this episode of Financial Modelers Corner, Paul Barnhurst dives into the intricacies of financial modeling, focusing on cash flow forecasting and continuous planning with FP&A expert Randy Brown. Randy shares his unique journey from music school to becoming a financial consultant and emphasizes the importance of practical financial strategies, especially in volatile markets.Randy Brown is a seasoned financial consultant with a rich background in FP&A, corporate finance, and financial modeling. After initially pursuing a career in music, Randy transitioned into finance, where he has built a successful career, particularly in cash flow management and continuous planning. His approach blends technical financial skills with real-world business acumen, making him a sought-after consultant in the industry.Key takeaways from this week's episode include:The critical importance of cash flow forecasting for business stability.Practical steps to build a 13-week cash flow forecast.Why continuous planning is more effective than traditional annual budgeting.Common pitfalls in financial modeling, including the dangers of circular references and external workbook links.Randy’s insights on managing finances for small to medium-sized businesses, especially in distressed situations.Here are a few quotes from Randy Brown:"The minute you create a budget, it’s meaningless. The business environment changes too fast for a static plan." - Randy Brown"For cash flow forecasting, it’s all about identifying your sources and uses of cash and laying them out on a calendar." - Randy Brown"The flexibility of working from home and being my own boss was the number one driver for becoming an independent consultant." - Randy Brown"Learn relational data structures; understanding how data relates will improve every analytical task you do." - Randy BrownIn this insightful episode, Randy Brown shared his wealth of knowledge on financial modeling, continuous planning, and the critical importance of cash flow forecasting. His emphasis on the importance of relationships, the simplicity of effective cash forecasting, and the pitfalls of traditional budgeting methods offers a fresh perspective for financial professionals striving to improve their modeling practices.Follow Randy:Website - https://www.instagram.com/randy_brown/LinkedIn - https://www.linkedin.com/in/randyjbrown/ 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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register.  In today’s episode:[01:28] - Introduction to the episode and guest Randy Brown[07:27] - Insights into Randy’s background and career journey[13:17] - Continuous planning vs. annual budgeting[20:36] - The benefits of fractional consulting[23:37] - The Importance of cash flow forecasting[28:01] - Building a 13-Week Cash Flow Forecast[34:53] - Key considerations for cash flow management[42:48] - Rapid fire financial modeling questions[48:28] - Final advice and closing thoughts

In this episode of Financial Modelers Corner, host Paul Barnhurst delves into the intricacies of financial modeling in the e-commerce industry with guest Drew Fallon, a seasoned e-commerce entrepreneur and co-founder of Iris, a cutting-edge FP&A tool for e-commerce businesses. The discussion offers valuable insights into the unique challenges of financial modeling in a rapidly evolving digital landscape, particularly in direct-to-consumer (DTC) businesses.Drew Fallon is an experienced entrepreneur in the e-commerce and CPG sectors. He began his career in equity research, working on high-profile IPOs like Airbnb and Corsair. Drew later co-founded and served as CFO for Mad Rabbit, an e-commerce brand that achieved significant growth under his leadership. Currently, he is the co-founder and CEO of Iris, a financial modeling platform that integrates AI to help e-commerce businesses automate their financial forecasting and analysis.Key takeaways from this week's episode include:The key components of effective financial modeling for e-commerce businesses.How cohort forecasting and customer retention play crucial roles in revenue prediction.The importance of understanding fulfillment costs and their impact on gross margins.Why many e-commerce brands fail due to poor financial modeling and how tools like Iris can help.Insights into Drew's journey from equity research to building successful startups in the e-commerce space.Here are a few quotes from Drew Fallon:"The number one thing to focus on with these e-comm businesses is the returning revenue number. If you mess up the forecast for your returning customer, it's the easiest way to mess up the gross profit forecast." - Drew Fallon"E-commerce is a tough business on working capital. It can be really challenging if you don't model out your cash flow accurately." - Drew Fallon"If you get the gross profit wrong, then you get the CAC wrong. And then all of a sudden you're losing money, and you die." - Drew FallonIn this insightful episode, Drew Fallon emphasizes the critical importance of precise financial modeling in the e-commerce sector, particularly in managing customer retention, fulfillment costs, and the dynamics of working capital. His experience in scaling e-commerce brands and developing Iris underscores the need for specialized tools and methodologies to navigate the complexities of this industry. Whether you're an entrepreneur, financial modeler, or simply interested in the intersection of finance and technology, this episode offers valuable lessons on how to build sustainable, profitable e-commerce businesses.Follow Drew:Website - https://www.irisfinance.co/LinkedIn - https://www.linkedin.com/in/drew-f-74947b117/  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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register.  In today’s episode: [01:10] - Introduction to the episode and guest Drew Fallon.[04:44] - Drew’s background and E-commerce journey[11:52] - Discussion on Drew’s passion for startups and its challenges and rewards[17:04] - Key elements of financial modeling specific to e-commerce[28:16] - Operational metrics and cost assumptions and how they affect overall financial health.[35:06] - The advantages of using Iris in e-commerce financial modeling.[41:53] - Quick insights into Drew's financial modeling preferences[47:08] - Drew’s advice for aspiring financial modelers[49:30] - Final thoughts and how to connect with Drew

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 this episode, Paul Barnhurst delves into the intricate world of data integration, especially within financial modeling and FP&A. The discussion revolves around the practical challenges and solutions for accessing and automating data flows, a topic crucial for finance professionals who often grapple with multiple data sources and complex modeling tasks. The episode offers insights into the evolving landscape of data management tools and how they can streamline processes for businesses.Adam Rakich, a seasoned expert in the world of FP&A tools and data integration, joins the show. With a diverse background spanning social media marketing software, FP&A consultancy, and leadership roles at companies like Workday and OneStream, Adam now focuses on making data integration more accessible through his work at Data Blend. His deep understanding of the challenges accountants and financial modelers face with data management makes him a valuable resource for listeners looking to optimize their processes.Key takeaways from this week's episode include:The common pitfalls and solutions in financial modeling and data integration.When and why businesses should transition from spreadsheets to specialized planning tools.Practical strategies for automating data workflows, even when dealing with outdated or diverse systems.The importance of understanding APIs, SQL, and other technical aspects of data integration.How to build a business case for investing in data integration solutions.Follow Adam:LinkedIn - https://www.linkedin.com/in/rakich/Click the link below to claim your free book (For a limited time only): The Business User’s Guide to Data Integrationhttps://www.amazon.com/Business-Users-Guide-Data-Integration-ebook/dp/B0CMBMDCJ2/https://www.amazon.co.uk/dp/B0CMBMDCJ2/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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register. In today’s episode:[01:30] - Introduction and worst financial model experiences[07:18] - Adam shares his career path from economist to data integration expert[09:38] - Transitioning from spreadsheets to planning tools[16:56] - The challenges of data integration[26:01] - Hybrid approaches to data automation[28:55] - Tools and strategies for freelancers and small businesses[37:46] - Adam talks about his book and the key takeaways for readers.[44:32] - Rapid fire questions on financial modeling tools and techniques.[52:47] - Final thoughts and contact information

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 this episode of Financial Modelers Corner, host Paul Barnhurst sits down with David Benaim, an Excel MVP and data consultant based in Cambodia. They delve into a comparative analysis of two of the most popular spreadsheet tools—Excel and Google Sheets. The discussion covers the strengths and weaknesses of each platform, providing listeners with insights into when and how to use these tools effectively in their financial modeling and data analysis work.David Benaim is a chartered accountant and Excel MVP who has made a name for himself as an expert in both Excel and Google Sheets. Originally from the UK, David now runs a data consulting firm in Cambodia, where he specializes in Excel training and data solutions. With a deep passion for spreadsheets, David is uniquely positioned to discuss the nuances of both platforms, making this episode a must-listen for anyone looking to optimize their use of Excel or Google Sheets.Key takeaways from this week's episode include:Key differences between Excel and Google Sheets, including tables, functions and data entry features.The strengths of Google Sheets in collaborative environments and its data validation capabilities.How to decide whether to use Excel or Google Sheets for different types of projects.Insights into the new table features in Google Sheets and how they compare to Excel’s tables.David’s tips on getting started with Google Sheets for those accustomed to Excel.Follow David:Website - https://www.xlconsulting-asia.com/LinkedIn - https://www.linkedin.com/in/davebenaim/ 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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register.  In today’s episode:[01:21] - Introduction to the episode and guest David Benaim.[03:52] - David shares his unique global background and career journey from Deloitte to founding his own firm in Cambodia.[07:00] - Discussion about David’s transition from working at Deloitte to starting his own business in Cambodia and the challenges he faced.[14:38] - In-depth comparison of functions unique to Google Sheets, like “COUNTUNIQUE”, “FLATTEN”, and others not found in Excel.[23:35] - Criteria and scenarios where Google Sheets is the better tool, particularly in collaborative environments and data entry tasks.[30:25] - A look at the newly implemented table features in Google Sheets and how they stack up against Excel’s tables.[38:54] - David shares his decision-making process for choosing between Excel and Google Sheets based on project needs.[43:56] - Quick-fire questions where David shares his preferences on various Excel and Google Sheets functionalities.[49:31] - Tips and resources for users looking to improve their skills in Google Sheets.[50:47] - Final thoughts and how to connect with David Benaim.

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 this episode of the Financial Modelers Corner, host Paul Barnhurst delves into the intricate world of financial modeling with returning guest Christopher Reilly. The conversation centers around what is necessary to build robust financial models, highlighting the importance of three-statement models and cash flow forecasting. The episode is filled with practical insights, advanced techniques, and professional experiences that underscore the significance of simplicity, accuracy, and best practices in financial modeling.Christopher Reilly is a seasoned financial modeler with extensive experience in consulting, private equity, and financial modeling education. Starting his career during the financial crisis, Christopher worked on high-profile bankruptcies such as Lehman Brothers and Rescap. His journey took him from a senior analyst role at Hilton Worldwide to middle-market private equity, and eventually to founding his own financial modeling education business. Today, he focuses on teaching and building financial models, with his work being featured by Wharton Online, Wall Street Prep, and LinkedIn Learning among others.Key takeaways from this week's episode include:The importance of simplicity in financial models and how over-complicating can hinder their effectiveness.Practical steps and considerations for building robust three-statement financial models.Tips for auditing models to ensure accuracy and integrity.How to use advanced Excel functions and shortcuts to enhance modeling efficiency.Insights into the role of AI in financial modeling and how it may shape the future of the profession.Follow Christopher:Website - https://www.financialmodelingeducation.com/LinkedIn - https://www.linkedin.com/in/chris-reilly-mission-capital/  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 www.fminstitute.com/podcast and use the code “Podcast” to save 15% when you register.  In today’s episode:[01:11] - Paul introduces the episode and welcomes back Christopher Reilly.[02:31] - Christopher shares a story about a complex healthcare deal model that required significant simplification.[03:55] - Discussion on the importance of keeping models simple and useful.[05:01] - Christopher talks about his career journey and experiences over the past year.[08:31] - Christopher explains why he is passionate about teaching financial modeling.[11:43] - Why every finance professional should understand how to build a three-statement model.[14:20] - Steps to take when beginning to build a three-statement model.[22:17] - Tips on structuring models vertically and building essential checks to ensure accuracy.[28:07] - How to effectively use support schedules and detailed assumptions in modeling.[32:36] - Essential tips for error checking, building support schedules, and maintaining model integrity.[39:10] - Key Excel formulas and functions necessary for building financial models.[46:58] - Discussion on the potential impact of AI on financial modeling and its future integration.[49:53] - Final thoughts and details on Christopher Reilly’s courses and where to find them.

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 this episode, Paul Barnhurst sits down with Ken Puls, a renowned expert in financial modeling and Excel. The discussion delves into the intricacies of financial modeling, the evolution of tools like Power Query and PowerPivot, and how they are revolutionizing data management and reporting. Ken shares insights from his extensive experience and offers practical advice for both novice and seasoned financial modelers.Ken Puls is a Chartered Professional Accountant (CPA) and a Microsoft Excel MVP. He is the founder of Excel Guru, a platform dedicated to Excel-based solutions, and the co-founder of Skill Wave Training, which offers comprehensive courses on Power Query, PowerPivot, and Power BI. With a career that bridges both finance and IT, Ken has become a leading voice in the world of financial modeling and data analysis.Key takeaways from this week's episode include:Ken's personal journey and how he became a leading figure in Excel and financial modeling.The importance of simplifying data entry and reducing errors through automation.Key features and benefits of Power Query and PowerPivot.Practical tips for financial modelers, including the use of VBA and dynamic arrays.Insights into the future of AI in financial modeling and its current limitations.Follow Ken:Website - http://www.excelguru.ca/LinkedIn - https://www.linkedin.com/in/kenpuls/Level up Your Skill with Ken’s book - https://excelguru.ca/master-your-data/ 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=7079020077076905984In today’s episode:[01:15] - Introduction to the show [01:55] - Welcome to the guest[02:15] - Horror Stories in Financial Modeling: Ken and Paul share their worst financial modeling experiences.[04:50] - Lessons Learned: Key takeaways from those early modeling experiences.[06:02] - Ken’s Background: Detailed overview of Ken’s career and expertise.[08:24] - Current Projects: Ken discusses his current ventures, including Excel Guru and Skill Wave Training.[12:14] - Technology in Accounting: How being tech-savvy has benefited Ken in his accounting career.[16:04] - Discovery of Power Query: Ken shares how he first learned about Power Query and its impact on his work.[26:04] - Getting Started with Power Query: Recommendations for beginners on how to learn and use Power Query.[29:00] - Building Financial Statements with PowerPivot: Overview of Ken’s course and its benefits.[37:46] - Rapid Fire Questions: Ken answers quick questions about financial modeling preferences.[46:47] - AI and Financial Modeling: Discussion on the role of AI in the future of financial modeling. [48:59] - Conclusion: Final thoughts and where to find more information about Ken’s work.

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.Lyndsey Weber, a seasoned expert in financial and supply chain modeling join us this week for a lively conversatio on both financial and supply chain modeling. She recounts her experience with some of the worst models she has encountered, the lessons learned, and the importance of organization and design in creating effective models. Lyndsey shares her journey from ExxonMobil to Quantrix, offering a deep dive into the art and science of financial modeling.Key takeaways from this week's episode include:Having a well-defined structure and approach is crucial for creating and maintaining effective financial models. Poorly organized models can lead to significant challenges and inefficiencies. A horror story about inheriting a model filled with bad practices, including hidden reference cells and broken VBA code. The experience teaches her the value of starting over and building a model from scratch with best practices.The importance of understanding stakeholder needs, both emotional and practical, and designing models that cater to these needs. This approach helps in building models that are not only functional but also user-friendly.The benefits of using Quantrix over traditional Excel, highlighting features like always-on pivoting, natural language formulas, and role-based access, which enhance efficiency and collaboration.One of Lyndsey's key pieces of advice is to prototype models on paper before building them. Mapping out inputs, outputs, and key calculations in plain English helps in creating a clear and effective model structure.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"This model that I inherited had, I feel every bad practice in the book, I vividly recall a couple of formulas where they just pointed to what I would call a cell island.”-Lyndsey Weber“Having a defined structure and approach that can be repeated, I think is essential.”-Lyndsey WeberIn this episode, Lyndsey provides valuable insights into the complexities of financial and supply chain modeling. She sheds light on the best practices and tools that can make a significant difference in model-building. This episode will help you enhance your modeling skills and create more effective and user-friendly models.Sign up for the Advanced Financial Modeler Accreditation 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. Follow Lyndsey:LinkedIn - https://www.linkedin.com/in/lyndsey-weber/ 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=7079020077076905984In today’s episode:[00:55] - Introduction;[03:57] - Worst spreadsheet model horror story[04:43] - Key takeaway: Importance of organization in modeling[06:57] - Guest Backgrounds[12:10] - Evolution of modeling roles at ExxonMobil[14:20] - Differences between supply chain and financial modeling[20:30] - Overview of Quantrix as a modeling tool[22:00] - Advantages of Quantrix over Excel[28:40] - Areas for improvement in Quantrix[35:27] - Considerations for scalability and collaboration in modeling[38:50] - Excel Discusssion[44:58] - Rapid Fire Section[52:23] - Importance of prototyping models[53:00] - Get to know our guests personally and Conclusion

Welcome to a special episode of Financial Modeler’s Corner! Today, we're thrilled to bring you an exciting Podswap from FP&A Tomorrow. Stay tuned for an engaging conversation with Carl Seidman that you won't want to miss. Here are the show notes from our previous episode.Welcome to FP&A Tomorrow, where we discuss financial planning and analysis, examining its current state and future prospects, with your host Paul Barnhurst. In today’s episode, Paul engages in a conversation with Carl Seidman to discuss why mastering presentation skills, and understanding the needs of the audience is crucial for excelling in your FP&A career.Carl is a premier FP&A and Fractional CFO expert, providing financial advisory and leadership development services to top companies including Deloitte, Verizon, and Walmart. Carl is known for his impactful training programs and advisory work that drive success in financial planning and analysis.Key takeaways from this week's episode include: :Here is a concise summary of the key points from the discussion:In FP&A, the ability to distill complex information into a concise, impactful message is paramount. It's not about how much you know, but what you can communicate effectively.The ability to distill complex information into a concise, impactful message is paramount. It's not about how much you know, but what you can communicate effectively.FP&A isn't just about numbers, it's about storytelling with data, painting a vivid picture of the financial landscape that guides strategic decisions and drives organizational successAnticipating potential disruptions or changes in the business environment is a fundamental aspect of FP&A. By identifying risks and developing strategies to mitigate them, FP&A professionals can help the organization stay ahead and adapt effectively.Quotes: Here are a few relevant quotes from the episode about FP&A mastery:"You're not going to go to a nice restaurant and pay a lot of money for a delicious dish, and then have it be delivered in a greasy brown paper bag. Right. So the deliverable matters a whole lot. It can actually significantly dismiss the credibility or value of everything that came up before at that point in time."-Carl Seidman"I think that Great FP&A looks like a team of people who are equipped, from a technical standpoint, to be able to execute the kinds of requests that are being asked of them."-Carl Seidman“The demands in business, the increasingly fast-moving environment, competition, the risks of getting some of this planning wrong are pushing the need of FP&A to be a whole lot more proactive, a lot more agile, a lot more well rounded and thinking instead of just being about financial planning and reporting."-Carl SeidmanFollow Carl:  LinkedIn - https://www.linkedin.com/in/carlseidmanWebsite - https://seidmanfinancial.coFor CPE credit please go to earmarkcpe.com, listen to the episode, download the app, and answer a few questions.  For AFP FPAC certification answer the questions and contact Paul Barnhurst for further details. In today’s episode:  [01:25] Carl introduction;[02:42] Changing FP&A trend over the next five years:[10:00] Carl’s background:[12:05] Carl’s passion for presenting and communication[15:44] Favorite voice Carl can impersonate?[20:42] Becoming better speakers and why presentation matters[33:44] How you can be better at influencing[40:44] Most important skills for FP&A professionals[45:00] Carl’s LinkedIn learning course[47:15] Rapid Fire[51:35] Carl’s book recommendation[55:51] Parting words

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.George Mount, Excel MVP and data analytics expert, with an extensive background in finance and data science, shares his insights into the evolution of Excel, the integration of Python, and the importance of data analytics for financial modelers.Key takeaways from this week's episode include:Excel's flexibility is both its greatest strength and weakness. While it allows for complex modeling, this same flexibility can lead to chaotic and error-prone spreadsheets if not managed properly.Today's Excel is vastly different from the Excel of a decade ago. With features like Dynamic Arrays, Power Query, and the integration of Python, Excel has become a powerful tool for modern data analysis and financial modeling.Python’s capabilities in handling time series analysis, data visualization, and complex computations complement Excel’s functionalities, making it a valuable skill for modelers.Excel excels in prototyping and wireframing due to its immediate data visibility and user-friendly interface. This makes it ideal for quickly iterating models and understanding data before moving on to more complex tools when necessary.George shares advice on how to get started learning Python and other analytical tools to take your analysis and modeling to new heights. A core principle for George is the importance of sharing what you know about Excel and data analytics. He emphasizes building a culture of knowledge sharing to foster growth and efficiency within teams.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"Excel’ greatest strength and weakness is its flexibility.”-George Mount“Excel is not the Excel of ten, 15 years ago. I often like to kind of think of it as modern Excel with Power "Query, Power Pivot, now Python, Dynamic Arrays, LAMBDA, LET, and other things.”-George Mount“The first rule of knowing Microsoft Excel is not to tell anyone that you're good at it.”-George MountIn this enlightening episode, George Mount provides valuable insights into the evolving world of Excel and data analytics. By integrating new tools like Python and embracing the advanced features of modern Excel, financial modelers can significantly enhance their analytical capabilities.Sign up for the Advanced Financial Modeler Accreditation 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. Follow George:LinkedIn - https://www.linkedin.com/in/gjmount/ 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 In today’s episode:[01:06] - Introduction;[02:14] - Worst spreadsheet model horror story[04:49] - Importance of achievable modeling in Excel[05:16] - Guest Backgrounds[08:57] - Combining data science and data analytics in Excel[11:01] - Necessity of learning Python and R[17:19] - Recommended resources for learning Python[20:27] - Exciting new features in Excel[22:25] - AI's role in Excel and financial modeling[25:55] - Favorite function in Excel[29:00] - Rapid fire;[37:08] - Get to know the guest and Conclusion

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.Raphael Benhamou, an independent consultant and fractional CFO explores the art and science of financial modeling. Raphael shares his experiences, insights, and a few horror stories from his extensive career, highlighting the importance of operational understanding and the advantages of using modern tools like Causal for financial modeling.Sample Causal Financial models if you want to review how Causal works:Subscription Model - https://www.benhamouconsulting.com/subscription-saas-revenuesPipeline Model - https://www.benhamouconsulting.com/pipeline-saas-revenuesKey takeaways from this week's episode include:Raphael emphasizes the critical need for regular audits of financial models to prevent errors and ensure accuracy. He shares a horror story about a model that wasn't audited for five years, leading to significant financial discrepancies.While Excel is known for its flexibility, Raphael discusses the trade-offs of using more structured tools like Causal, which can help reduce errors and provide more insightful analysis through its object-oriented approach and natural language variables.The importance of integrating operational data with financial models to provide actionable insights. He stresses that understanding business operations is crucial for building effective and useful models.Raphael shares his journey from using traditional Excel spreadsheets to adopting Causal, a modern financial modeling tool. He explains how Causal's dynamic dashboarding, probability distribution modeling, and seamless integration with other systems offer significant advantages over Excel.The discussion focuses on the potential of AI in financial modeling, Raphael notes that while AI can build models, the real question is whether it should. He also touches on the importance of human judgment and expertise in interpreting and using these models effectively.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"My perspective on this is what I was saying earlier about operating connecting to finance. I think to be a good financial modeler, you need to have a good understanding of what what's going on in the business as well, not just at the finance level.”- Raphael Benhamou“It gave me a great grounding in best practices for modeling across all modeling platforms, especially Excel. Because one of my big nitpicks with Excel and Google Sheets is that it's too freeform.”- Raphael BenhamouThis episode provides valuable insights into the evolving landscape of financial modeling. The discussion sheds light on the benefits of modern financial modeling tools like Causal, the necessity of regular audits, and the critical role of understanding business operations. Whether you're a seasoned financial modeler or just starting, this episode offers practical advice and thought-provoking perspectives on how to enhance your financial modeling practices.Sign up for the Advanced Financial Modeler Accreditation 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. Follow Raphael:LinkedIn - https://www.linkedin.com/in/raphaelmibenhamou/Website - https://www.benhamouconsulting.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=7079020077076905984In today’s episode:[00:03] - Introduction[01:01] - Guest Introduction[03:47] - Key Takeaways from the Horror Story[04:55] - Guests’ Background[07:13] - Introduction to Causal[08:03] - Transition to Finance[12:29] - Love for Modeling[14:00] - Early Career and Tools[17:46] - Flexibility vs. Structure[23:50] - Types of Models Built in Causal[39:43] - Rapid-Fire Session[48:12] - Get to know the guest[49:46] - Conclusion

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 a conversation with Brian Vaddan.Brian Vaddan is a distinguished financial modeler with a rich background in investment banking and financial engineering. His emphasis on intellectual curiosity, the need for simplicity, and the creative nature of financial modeling provide listeners with a fresh perspective on the discipline.Key takeaways from this week's episode include:A distinction between those who use spreadsheets casually and those who build models as a core discipline. He emphasizes the importance of creating models that are understandable and usable by others, akin to the difference between a sketch artist and an architect.Intellectual curiosity, an almost obsessive desire to solve problems, and the ability to bring structure out of chaos are highlighted as key traits for successful financial modelers. Brian stresses that these traits are more critical than technical skills alone.One of the profound insights shared is the importance of simplifying complex problems. Brian believes that the true measure of a modeler’s intellect is their ability to present complex ideas in a straightforward and understandable manner.Financial modeling is described as a deeply creative exercise. Brian compares it to art, where each model reflects the modeler’s thought process and experiences, much like an artist’s painting.Brian shares his experience transitioning from being a modeler to managing a team. He discusses the challenges of letting go and empowering others, and the iterative learning process involved in both building and reviewing models.Quotes:Here are a few relevant quotes from the episode on financial analysis and modeling:"I guess, the easiest way for me to describe it is the difference between somebody who sketches on paper and someone who's an architect, or someone who has a hammer and someone who's an actual carpenter.”- Brian Vaddan“One of the primary differences is that you will do it for someone else. So when I built a lot of the initial models from the earlier part of my career, it was for me. It was to derive an answer that I needed to a question that was asked of me.”- Brian Vaddan“The way you display the depth of your intellect, to me, is not the complexity in the formula that you build, but how you take that complex formula and simplify it into a manner that anyone with just a basic understanding can understand.”- Brian Vaddan“Never stop learning and don't quench that intellectual curiosity that will make your modeling experience and career so much richer and so much more rewarding.”- Brian VaddanIn this engaging episode of Financial Modeler's Corner, Brian Vaddan shares his insights on the intricacies of financial modeling. He recounts his journey from investment banking to EY, emphasizing the importance of intellectual curiosity and perseverance. He advises aspiring modelers to maintain a growth mindset and continually seek learning opportunities, providing valuable insights into the discipline of financial modeling.Sign up for the Advanced Financial Modeler Accreditation 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. View and download the Financial Modeling Code at financial-modelling-code.ashx (icaew.com)Follow Brian:LinkedIn - https://www.linkedin.com/in/brian-vaddan-62ba7325/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=7079020077076905984In today’s episode:[00:03] - Introduction[01:00] - Guest Introduction[01:14] - Horror Story[03:40] - Rule of Thumb[04:10] - Guests’ Background[06:28] - Spreadsheets vs. Modeling[10:16] - Essential Traits for Modelers[13:30] - Modeling as a Discipline[19:00]  - Simplicity in Complexity[24:00] - Modeling as a Creative Exercise[28:10] - Transition to Team Leadership[33:00] - Rapid-Fire Session and Guests’ Contact Information[38:10] - Conclusion