Financial Modeler's Corner

Financial Modeling in Retail, managing Insolvency & How Finance Can Master Cash Flow - Dave Hallwood


Listen Later

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 sales
  • The importance of simplicity and storytelling in financial models
  • What it’s like to manage an insolvency and restructure a business
  • Why Dave believes gut instinct still plays a big role in decision-making
  • How Dave uses modeling to support store openings, closures, and growth
  • Practical advice for switching into a finance career later in life


Here 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=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: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

...more
View all episodesView all episodes
Download on the App Store

Financial Modeler's CornerBy Paul Barnhurst AKA The FP&A Guy

  • 4.9
  • 4.9
  • 4.9
  • 4.9
  • 4.9

4.9

15 ratings


More shows like Financial Modeler's Corner

View all
Economist Podcasts by The Economist

Economist Podcasts

4,287 Listeners

HBR IdeaCast by Harvard Business Review

HBR IdeaCast

177 Listeners

The McKinsey Podcast by McKinsey & Company

The McKinsey Podcast

381 Listeners

CFO THOUGHT LEADER by The Future of Finance is Listening

CFO THOUGHT LEADER

120 Listeners

Trumponomics by Bloomberg

Trumponomics

349 Listeners

Wall Street Breakfast by Seeking Alpha

Wall Street Breakfast

1,029 Listeners

Inside the Strategy Room by McKinsey & Company

Inside the Strategy Room

171 Listeners

Dry Powder: The Private Equity Podcast by Hugh MacArthur, Bain & Company

Dry Powder: The Private Equity Podcast

146 Listeners

The Private Equity Podcast, by Raw Selection by Alex Rawlings

The Private Equity Podcast, by Raw Selection

32 Listeners

Coaching Real Leaders by Harvard Business Review / Muriel Wilkins

Coaching Real Leaders

652 Listeners

FP&A Today by Glenn Hopper

FP&A Today

47 Listeners

HBR On Strategy by Harvard Business Review

HBR On Strategy

84 Listeners

Rise Above The Numbers by FP&HEY

Rise Above The Numbers

5 Listeners

FP&A Tomorrow by Paul Barnhurst

FP&A Tomorrow

24 Listeners

Unpivot by UnpivotShow

Unpivot

5 Listeners