
Set up the cash forecast model in Excel by building a 13-week layout for Juliana Foods’ Chase operating account, using week formulas and labeling actual forecast, year-to-date, and totals.
Finish loading vendors and their accounts for the cash flow forecasting model, assign disbursement accounts like marketing expense and warehouse fees, and prep the cash forecast for the next session.
Students will employ basic excel formatting tools
Continue formatting and clean up the cash forecast report by bolding key lines, adjusting layout, adding borders and color fills, and mirroring the format to the payroll tab for clarity.
Apply formulas to link beginning balances across operating and payroll accounts, calculate miscellaneous deposits and cash disbursements, and use sumifs to total weekly expenses.
Learn to calculate line of credit balance outstanding, line of credit availability, and total funds available as cash plus available credit, using weekly forecasts.
Sort vendors alphabetically to preserve data integrity, add Mesa Engineering as a consulting vendor, and reflect the change in the dressings summary tab.
Master the 13 Week Cash Flow Financial Model and Advance your Career – Better Yet, Save Your Company!
Almost 30% of businesses fail due to cash flow problems. Are you a business owner, financial manager, or office manager struggling to figure out how much cash is needed to run your business? If so, you’ve come to the right place!
My name is Buzz Floyd, and I’m a veteran financial manager and consultant with a passion for learning and teaching. Throughout my career, I’ve worked with a wide variety of privately held businesses, many of which are small or midsize, and highly leveraged (a significant portion of their cash was being used to pay down loans). I’ve collaborated with some of the brightest entrepreneurial minds in manufacturing, software development, construction, real estate development, distribution, and various service and retail sectors. With decades of experience as a controller, CFO, and consultant, I’ve seen it all.
Early in my career, I learned the importance of understanding a company’s cash position the hard way. I partnered with a division president of a Fortune 500 company to buy out a division of the company. Suddenly, the responsibility for making payroll and managing cash flow fell squarely on my shoulders. Gone were the days simply requesting funds from the corporate headquarters. After some sleepless nights and close calls, I realized the critical need for effective cash management tools.
While there are great courses on Microsoft Excel and financial modeling, I couldn’t find a resource that was specifically tailored toward managing cash flow. Out of necessity, I developed tools to manage working capital and learned how to navigate the complexities of cash flow management for privately held companies.
I am here to show you the steps to gain control of your company’s finances.
This course is designed to share those tools with you and help you gain control of your company’s finances. After years of working closely with business owners and managers, I’ve identified a common concern:
“What tools do I need to assess where we stand on our ability to meet our obligations, decide whether to borrow, or determine if can we make that critical upgrade or purchase?”
This course provides clear, practical answers to that question.
The 13 week cash flow financial model is a proven tool that has stood the test of time. It evolves and adapts to meet a company’s unique needs, becoming the “go to” report for management. In this course I will take you step by step in preparing the model AND as a bonus provide you with the fully finished template at completion of this course!
No matter your company’s situation, take this course and get your cash under control quickly and efficiently.
Looking forward to seeing you in class!