Financial Modeler's Corner

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 Brown

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

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