Hero image

Cash Flow Forecasting and Modeling

New
·

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

Nothing's more vital than knowing where cash is coming from & where it's going.

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)

Who is this course for

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.

What you’ll get out of this course

Build a 13-week cash flow forecast step-by-step and integrate it into a longer term cash flow model.

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.

Guide a real-life company through a turnaround, restructuring, and refinancing

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.

Connecting cash flow forecast models to underlying financial data

Establishing digital connectivity and integration to underlying financial data and schedules for efficient cash flow forecasting, updating, and reforecasting

Cash flow management overview

Understanding the key elements and mindset needed in cash flow forecasting, including knowing the warning signs and remedies for strained cash flow.

Contrast the differences between liquidity management and working capital management

Understand what liquidity and cash flow management look like for distressed companies versus optimizing working capital in a normal or growing environment.

What people are saying

        Great course that covers the fundamentals and focuses on practical application instead of just theory. Not much to improve. Loved the instructor.
Diego Campos

Diego Campos

Senior Consultant (Deloitte)
        It was an effective building block to cash flow modeling. There was the practical example of building the actual model, but there was also a lot of analysis on the theory and how to use the model as a tool. I thought it was a good way to encompass the end to end application of this model.
Rob Hogue

Rob Hogue

Senior Financial Consultant (Deloitte)
        This was awesome! Probably the best virtual training I've had. Carl was a great speaker, really good at keeping us engaged, I learned a lot. 100% recommend.
Laura Chaves

Laura Chaves

Associate, Deloitte
        Presenter was very engaging, energetic and able to answer any questions with excellent examples. Carl is truly phenomenal!
Robert Haas

Robert Haas

Vice President (Deloitte)
        Informative, interactive, step-by-step guidance and explanation to be able to prepare a 13-week cash flow on your own in the future
Marie McLean

Marie McLean

Director, Transaction Execution (Accordion)
        I feel I learned everything I needed to and Carl is the man.
Blake Dittman

Blake Dittman

Associate (Accordion)
        Very much enjoyed the class, and understood the material clearly.
Cyndi Funes

Cyndi Funes

Vice President (Accordion)
        Carl is great - engaging, knows his stuff, and well prepared.
Jake Vosen

Jake Vosen

Vice President (Accordion)
        I rated this training "excellent" because it was able to keep my attention and the material was relevant to excelling in my current role.
Attendee

Attendee

Senior Associate (Management Consulting Firm)
        Very logical structure, highly relevant to work we do at CM. Carl articulately lays out the process of modelling and is an engaging speaker. This was much more applicable than the Austin based modeling training.
Attendee

Attendee

Senior Associate (Management Consulting Firm)
        This program was much better than the previous modeling course I've attended due to the call for thinking critically as well as the granularity covered.
Attendee

Attendee

Senior Associate (Management Consulting Firm)
        This program provided better tangible examples of distressed situations which apply more to our firm vs. past training that generalized financial modeling more for highly successful public companies like Apple. Carl's approach in this matter was highly relevant and greatly helpful. It was very informative and will provide a great reference.
Attendee

Attendee

Senior Associate (Management Consulting Firm)

Meet your instructor

Carl Seidman, CPA/CFF, CSP, CFE, CGMA, CIRA, AM, Certified Anaplan Model Builder

Carl Seidman, CPA/CFF, CSP, CFE, CGMA, CIRA, AM, Certified Anaplan Model Builder

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.

A pattern of wavy dots
Join an upcoming cohort

Cash Flow Forecasting and Modeling

June 2023

$899 USD

Dates

June 15 - 16, 2023

Payment Deadline

June 14, 2023

Course syllabus

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.

Course schedule

4 hours per session
  • Thursday (June 15th) and Friday (June 16th)

    Day 1: 1pm - 5pm | Day 2: 9am - 1pm EST

    We meet 2 times, for 4 hours each session with periodic breaks included:


    • Day 1: Thursday, June 15th
    • Day 2: Friday, June 16th


    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

Learning is better with cohorts

Learning is better with cohorts

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

Frequently Asked Questions

What happens if I can’t make a live session?
I work full-time, what is the expected time commitment?
What’s the refund policy?
What is the difference between this Cash Flow Forecasting program and all the other programs you offer?
How will the classes work?
What should I be expected to know coming into this course? How should I prepare in advance?
Do you offer any guarantees for success, starting a business, or getting promoted.
Does this course qualify for CPE (continuing professional education)?
A pattern of wavy dots
Join an upcoming cohort

Cash Flow Forecasting and Modeling

June 2023

$899 USD

Dates

June 15 - 16, 2023

Payment Deadline

June 14, 2023

$899 USD

New
·

2 Days