Excel Hacks for Financial Modelers to Simplify Valuations and Save Hours with Charles Keepman

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

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

Visit https://bit.ly/497oAqW and use the code “Podcast” to save 15% when you register. 

In today’s episode:

[01: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