Cash Flow Forecasting and Modeling
2 Days
·Cohort-based Course
Learn the step-by-step approach to 13-week cash flow modeling, helping healthy companies grow and getting troubled companies back on track.
Hosted by
Carl Seidman, CPA/CFF, CSP, CFE, CGMA, CIRA, AM, Certified Anaplan Model Builder
The person Fortune 500s use for their financial leadership development programs
Course overview
Now more than ever, a thorough understanding of company cash flow, working capital, and finance is essential to financial health and prosperity of the business.
It’s vital to understand the causes of cash bleeding and remedies for improving working capital.
In this program, attendees will discover the various causes of cash flow constraints and how to address them, learn the step-by-step process for building a direct approach 13-week cash flow forecast model, and integrate it with a longer-term financial forecast.
They didn't teach this in your MBA.
They don't teach this at your company.
They aren't teaching it in public training.
Don't wait for cash flow challenges to arise. The time to learn how to manage them is now.
This program is CPE- accredited by the National Association of State Boards of Accountancy (NASBA).
Next Cohort: June 15th and 16th 2023
Day 1: 1pm - 5pm EST
Day 2: 9am - 1pm EST
(Seidman Financial is a division of Seidman Global LLC)
01
Finance and accounting professionals with a responsibility for cash flow forecasting, liquidity management, and working capital.
02
Finance and strategy professionals working in management consulting, turnaround, restructuring, bankruptcy, M&A, and corporate development.
03
CFOs, Directors of Finance, Controllers, business owners, AR/AP analysts and clerks, FP&A analysts.
04
Investment professionals working in private equity (PE), venture capital (VC), hedge funds, lender workout groups, and family offices.
You will build a short-term cash flow forecast from the ground up, diving into sales, collections, costs, payments, operating expenses, accrued expenses, payroll, capex, financing, and all balance sheet rollforwards. You'll tie all of these elements into a longer term model.
Cash flow modeling isn't just about the mechanics of building the model. It's about understanding the operating drivers behind distress and revitalization.
You'll go through the modeling exercises and determine what's causing cash bleeding the right courses of action.
Establishing digital connectivity and integration to underlying financial data and schedules for efficient cash flow forecasting, updating, and reforecasting
Understanding the key elements and mindset needed in cash flow forecasting, including knowing the warning signs and remedies for strained cash flow.
Understand what liquidity and cash flow management look like for distressed companies versus optimizing working capital in a normal or growing environment.
Diego Campos
Rob Hogue
Laura Chaves
Robert Haas
Marie McLean
Blake Dittman
Cyndi Funes
Jake Vosen
Attendee
Attendee
Attendee
Attendee
Carl serves as a fractional CFO, FP&A advisor, and management consultant to entrepreneurial businesses throughout North America and Europe and assists them with strategic financial planning, value enhancement, and revitalization.
He's one of the preeminent trainers and facilitators in strategic finance and FP&A, with more than 13,000 participants attending his financial training programs, seminars, workshops, and masterminds. Notable clients include:
ABM Industries, Accordion, AlixPartners, Allscripts, Broadridge, CHEP, Choice Hotels, CIBC, Cigna, Cox Enterprises, Crawford & Company, Deloitte, Dexcom, Discover Financial Services, Dominium, Express Scripts, EY, FS Investments, EVRAZ, Genentech, HCP, Inc., Heartland Financial, Hewlett Packard Enterprise, IGT, KPMG, Marsh & McClennan, Michelin, NerdWallet, Radisson, Rapid7, Sol Petroleum, Spotify, Triple-S, Telus, Santander, United Technologies, Universal Business Team, Verizon, and Walmart.
Carl is masterful at making the complex amazingly simple, engaging his audiences, building confidence, and facilitating a welcoming and transformative group experience. His content is rich and relatable, used in financial leadership development programs (FLDPs) at Fortune 500 companies, and is utilized or licensed by 6 of the top global financial training companies.
Carl is a Certified Public Accountant (CPA) has earned other professional credentials including the CIRA, CFF, CFE, CGMA, AM (Accredited Member in Business Valuation), CSP (Certified Speaking Professional), Certified Anaplan Model Builder, and was a National Association of Certified Valuators and Analysts (NACVA) 40 Under Forty honoree. He holds a BA in finance and economics and an MS in managerial accounting.
He's been where you want to be and does the work you want to do.
June 2023
$899 USD
Dates
June 15 - 16, 2023
Payment Deadline
June 14, 2023
01
Direct vs. Indirect Cash Flows
Indirect cash flows involve an understanding of cash flows from operations, investing, and financing activities. Direct cash flows involve isolating cash inflows from cash outflows.
In this introduction to cash flow forecast and liquidity management, we'll explore the differences and benefits of each approach.
02
Cash Flow Modeling Practices
We'll go through a crash course of intelligent and powerful Excel (and Google Sheets) functionality that will be leveraged to build a dynamic forecast model.
We cover commonly-used functions as well as some of the new dynamic array functions and lookups that can be used to save time and eliminate mistakes.
03
Structuring the Cash Flow Forecast Model
After learning the nuances of direct vs. direct cash flow modeling and the functions necessary to build them, we'll cover the smart practices to implement for managing, presenting, and sensitizing models.
We'll cover the different cash flow models you may see in turnaround, restructuring, bankruptcy, FP&A, treasury, M&A, and management consulting.
04
Introduction to the Business Case
Research shows that people learn best by doing. We'll roll up our sleeves and introduce a real-life business case that will serve as the foundation for our financial model, supporting schedules, and financial and operating recommendations.
We won't just play around with made up exercises. We'll go through scenarios you may encounter in your work.
05
Modeling Sales and Collections
We'll examine the sales team's revenue forecast and challenge their assumptions. We'll review customer types and determine the right way to model them, considering their risk, terms, and the need for accuracy.
Then we'll model collections of credit sales based upon agreed-upon-terms, anticipated collections of AR aging, and doubtful accounts.
06
Modeling Direct Costs and Payments
We'll analyze direct costs, inclusive of materials, labor, fixed and variable overheads. We'll determine what the forecast needs to look like given expectation of sales and operating improvements.
We'll then make assumptions about payments to vendors based upon agreed-upon terms, classification of critical vendors, and payment negotiations.
07
Modeling Inventory Categories
Next, based upon the growth or contraction of the business, we'll forecast inventory activity from raw material acquired, to work-in-process, to finished goods and sale through COGS.
We'll address changes the company can make to improve its inventory conversion process as well as alternatives for more effective purcha
08
Modeling Prepaid and Accrued Expenses
More nuanced line-item categories, including prepaid and accrued expenses, require an understanding of how certain expenses are paid for in cash and accounted for in the financial statements.
We'll explore prepaid expenses, such as software and insurance, and accrued expenses, such as professional fees, and how to model them correctly.
09
Modeling Payroll, Benefits, and Payroll Taxes
Payroll, benefits, and payroll taxes can be challenging to model due to their timing. We'll discuss the different ways payroll, benefits, bonuses, and taxes are accrued and paid out.
10
Modeling Indirect Operating Expenses
We'll review the P&L forecast for expenses such as rent, auto expenses, professional fees, insurance, utilities, and more and how they are paid.
We'll model them in cash and affirm that any updates to the P&L forecast will be correctly coded to the cash flow forecast.
11
Modeling Debt and Equity
One of the key reasons for forecasting cash flow is to ensure the company is on a path of healthy liquidity. In the event of default, the company may find itself in a forbearance, Chapter 11, or Chapter 7.
Modeling term debt, a revolving line of credit, interest expense, and other forms of financing ensures the company know it isn't exposed.
12
Modeling Operating Improvements and Changes to Working Capital
Once the model is pieced together, we'll review what it tells us about the business. We'll identify the sources of distress and opportunity. We'll agree upon courses of action to remedy the situation.
By running scenarios, we can go to the lenders and investors and share with them the plan for right-sizing the business and getting back on track.
13
Tying it All Together
It's one thing to put together a 13-week cash flow model. But it's another to build it so well that it can be seamlessly updated for new data, new time periods, and extended into the future with little concern for breakage.
We'll integrate the 13-week cash flow with a long-term forecast model and discuss the ways we can maintain their integrity.
14
ENCORE: The Seidman Financial Network
Networking doesn't stop there. You'll join Carl's private CFO and FP&A community where you can keep in touch with other attendees, ask and answer a wide array of questions, share techniques and best practices, and refer business. This community is only open to former clients and attendees of Carl's programs.
Day 1: 1pm - 5pm | Day 2: 9am - 1pm EST
We meet 2 times, for 4 hours each session with periodic breaks included:
Each half-day is content-rich inclusive of discussion, reflection, and Q&A. I often stay after each session to answer content- or career-specific questio
Active hands-on learning
This course builds on live workshops and hands-on projects
Interactive and project-based
You’ll be interacting with other learners through breakout rooms and project teams
Learn with a cohort of peers
Join a community of like-minded people who want to learn and grow alongside you
June 2023
$899 USD
Dates
June 15 - 16, 2023
Payment Deadline
June 14, 2023