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 modeling
The role of Power Query in automating financial modeling processes
Key revenue forecasting challenges in law firms and service businesses
Why scenario planning is critical for financial models
How financial modeling influences business strategy and decision-making

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