Why Law Firm Revenue & Cash Flow Forecasting Is a Nightmare (and How to Solve It) with Sean Mooney

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.

Follow Sean:

• LinkedIn - http://www.linkedin.com/in/sean-mooney-sjf
• Company - 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=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 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