Cash Flow Forecasting and Modeling with Carl Seidman

Cash Flow Forecasting and Modeling

Learn the step-by-step approach to 13-week cash flow modeling, helping healthy companies grow and getting troubled companies back on track.

Enroll Here Free Preview

Course curriculum

1. Why do companies struggle with the direct method for cash flow forecasting? - part 1
2. Why do companies struggle with the direct method for cash flow forecasting? - part 2
3. Introduction to the direct method for cash flow forecasting
  FREE PREVIEW
1. Accrual versus cash (intro) - part 1
2. Accrual versus cash (timing) - part 2
3. Accrual versus cash explained
4. How the financial statements connect and relate
1. Anomalies among reports, statements, and data
2. What information is needed to build a cash flow forecast?
3. What elements make up the cash flow forecast?
1. Reviewing the sales forecast and collection terms
2. The accounting treatment of AR, sales, and collections - part 1
3. The accounting treatment of AR, sales, and collections - part 2
4. Exercise: Calculating DSO
5. Solution: Calculating DSO
6. Exercise: Calculating Ending AR
7. Solution: Calculating Ending AR
8. Exercise files - AR, sales, and cash collections
9. Modeling AR, sales, and cash collections - part 1
10. Modeling AR, sales, and cash collections - part 2
11. Modeling AR, sales, and cash collections - part 3
12. Modeling AR, sales, and cash collections - part 4
13. Understanding the drivers of sales and AR
  FREE PREVIEW
1. Modeling payroll, benefits, payroll taxes, and layoffs - part 1
2. Exercise files - payroll, benefits, payroll taxes, and layoffs
3. Modeling payroll, benefits, payroll taxes, and layoffs - part 2
4. Modeling payroll, benefits, payroll taxes, and layoffs - part 3
5. Modeling payroll, benefits, payroll taxes, and layoffs - part 4
1. Modeling inventory categories - part 1
2. Modeling inventory categories - part 2
3. Modeling inventory rollforwards - part 1
4. Exercise: Calculating DIO
5. Solution: Calculating DIO
6. Modeling 3 categories of inventory
  FREE PREVIEW
7. Exercise files - inventory
8. Completing the inventory rollforward - part 1
9. Completing the inventory rollforward - part 2
10. Why does forecasting future inventory balances matter?
1. Understanding the different methods of payment
  FREE PREVIEW
2. The accounting treatment of AP, purchases, and payments
3. Calculating DPO | using purchases versus COGS for the calculation - part 1
4. Calculating DPO | using purchases versus COGS for the calculation - part 2
5. Exercise: Calculating ending AP
6. Exercise files - accounts payable (AP)
7. Modeling AP, purchases, and cash payments - part 1
8. Modeling AP, purchases, and cash payments - part 2
9. Demystifying prepaid expenses and payments
10. Exercise files - accrued expenses
11. Modeling other accrued expenses and payments
12. Interpreting cash flow from operations
  FREE PREVIEW
1. Exercise files - capital expenditures and related depreciation
2. Modeling capital expenditures (capex) and related depreciation - part 1
  FREE PREVIEW
3. Modeling capital expenditures (capex) and related depreciation - part 2
4. Exercise files - non-recurring professional fees
5. Modeling professional fees (non-recurring), expenses and payments
6. Exercise files - long-term debt and short-term financing
7. Introduction to long-term debt and short-term financing
8. The accounting treatment of interest expense and long-term debt
9. Modeling accrued interest expense and debt service
1. Assessing options for turnaround, restructuring, or reorganization
2. Evaluating liquidity needs based upon a favorable cash flow forecast
3. Evaluating liquidity needs based upon an unfavorable cash flow forecast
1. Introduction to the borrowing base and borrowing base certificate
  FREE PREVIEW
2. Understanding borrowing against eligible and ineligible A/R and inventory
3. Advance rates for borrowing against eligible A/R and inventory - part 1
  FREE PREVIEW
4. Exercise files - the borrowing base forecast
5. Advance rates for borrowing against eligible A/R and inventory - part 2
6. Advance rates for borrowing against eligible A/R and inventory - part 3
7. Exercise files - the revolving line of credit
8. Modeling the liquidity need and the revolving line of credit - part 1
9. Modeling the liquidity need and the revolving line of credit - part 2
10. Modeling the liquidity need and the revolving line of credit - part 3
1. Exercise files - EBITDA-to-cash bridge
2. Building the bridge between profitability and cash flow
3. Evaluating financial ratios and using metrics to assess financial health
4. Backing into weekly cash flows and building long-term monthly models
  FREE PREVIEW
5. Considering unique timing and nuances of cash flow activities
6. Weekly cash flow forecasting in distress and bankruptcy situations
1. Exploring the options for turnaround, restructuring, and reorganization - part 1
2. Exploring the options for turnaround, restructuring, and reorganization - part 2
3. Exploring the options for turnaround, restructuring, and reorganization - part 3
4. Exploring the options for turnaround, restructuring, and reorganization - part 4
5. Exploring the options for turnaround, restructuring, and reorganization - part 5
6. Final thoughts

About this course

92 lessons
5 hours of video content

FP&As and Consultants at these companies have trained:

Join 13,000+ finance professionals globally who have attended training programs, workshops, and seminars

What you'll get out of this course

This is the most comprehensive cash flow forecasting and modeling course available, designed and developed by a 20-year veteran in management consulting, FP&A advisory, turnaround/restructuring, and academia.

Build a robust 13-week cash flow forecast line-by-line and step-by-step that can be implemented immediately for your company or clients. Build a short-term cash flow forecast from the ground up, diving into sales, collections, costs, payments.
Understand the nuances of operating expenses and expenditures, accrued expenses, payroll, capex, financing, and all balance sheet roll-forwards. Guide a real-life company through a turnaround, restructuring, and refinancing.
Challenge yourself with modeling exercises, flexing business scenarios, and establishing connections to underlying data.
Dive into the mechanics of model-building and understand operating drivers behind distress and revitalization. Determine what's causing cash bleeding, prioritize and offer promising courses of action.
Connect the cash flow to supporting schedules, updating them as assumptions change for reforecasting.
Discover different ways entrepreneurs, portfolio company CFOs, FP&A professionals, management consultants, and business owners manage cash. Learn what effective cash management and presentation looks like to various stakeholders, recognizing that not every user sees cash flow the same way.
Master liquidity management for companies in distress and working capital management for companies in a phase of growth. Understand what liquidity and cash flow management look like for distressed companies, knowing the warning signs and remedies for strained cash flow.

What You Can Expect:

You're going to learn the nuances of business and the modeling techniques by doing the work, not by simply plugging numbers into a model

Learn from the expert who trains the top management consulting, turnaround, restructuring, and CPA firms

Get the education, modeling techniques, business acumen, templates, and coaching that the leading firms use to guide clients through growth and challenging times.

Enroll Here Free Preview

Meet Carl Seidman, your instructor and guide

The person Fortune 500s use for their financial leadership development programs | Microsoft MVP

Carl Seidman

Carl serves as a fractional CFO, FP&A advisor, adjunct professor in data analytics, and management consultant to entrepreneurial businesses throughout North America and Europe and assists them with strategic financial planning, value enhancement, and revitalization.

He's a Microsoft MVP and 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, Walmart, and Workday.

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

Contact: [email protected]

What Cash Flow Forecasting and Modeling Students Have to Say:

Don't take our word for the quality of the learning experience and transformation, take theirs.

Transform your mindset and elevate your skills

Enroll Here Free Preview

Additional Benefits

What else do you get with this course?

Model templates

You'll receive an unfinished template and a completed model, as well as exercise files for every lesson throughout the course.
Direct instructor contact

You have questions? He has answers. Every lesson has an open Q&A. Simply type a question and Carl will respond.
Lifetime access

Your enrollment in the course never expires, which means you can move forward at your own pace and revisit lessons as many times as you'd like.

Frequently Asked Questions

What modeling templates are included?

Students receive one blank cash flow model template, one completed cash flow model, and various others model templates used for each major exercise in the course.
I work full-time, what is the expected time commitment?

The course is 92 lessons and 5 hours in duration. The value of an on-demand, self-paced course is you can complete it on your own time. On average, the course takes approximately 8 hours to complete.
How much is this course?

The course is 399 USD.
What should I be expected to know coming into this course? How should I prepare in advance?

Prerequisites for the course include the following: (a) you should have basic-to-intermediate understanding of Microsoft Excel; (b) you should have a current version (2016 or later) or Microsoft Excel, ideally (though not necessary) on a PC; and (c) you should have at least a basic understanding of accounting and finance concepts.
Do you have other online courses?

Yes. I have more than 20 online courses which may be found through Maven.com, LinkedIn Learning, AICPA/CIMA, The Association for Financial Professionals, Rice University, the Corporate Finance Institute, Wall St Prep, Universal Business Team, Udemy, and more. I also offer deliver dozens of live virtual and in-person corporate training programs every year to companies of all sizes.
What is the difference between this Cash Flow Forecasting and Modeling course and the course you offer through Maven.com?

The Maven.com course is live with me and a group of other students. It is 9+ hours and qualifies for CPE. This online course is self-paced and 5 hours. It currently does not qualify for CPE.
Do you offer any guarantees for success, starting a business or getting promoted?

No, but I will offer you my promises. Every person who attends my courses comes from different backgrounds, experiences and aspirations which means they have different business models or jobs. My promise to to share with you my techniques, tools, and processes that will accelerate your finance career and make you far more confident in what you do.
Is there a refund policy?

Across hundreds of training, seminars, workshops, and conferences -- in person and virtual and to thousands of people -- I have never been asked once for a refund. For one in-person training program, there was a blizzard and my flight was cancelled. I offered a rescheduling option for a future date. While it is not customary for me to refund, if you have completed the course and found it to be subpar, your emailed request for a refund will be honored.
How does this cash flow course compare with others?

Most on-demand courses teach steps for plugging numbers into a basic model. They don't teach the nuances that you're likely to encounter across a wide range of instances. And most cash flow forecasting trainers don't come from FP&A or Fractional CFO backgrounds. According to course alumni, my cash flow forecasting and modeling courses are the best available.

Interested in Live Courses?

Join the premier FP&A and corporate finance cohorts

Explore the Live Cohorts

Ready to take your cash flow forecasting and modeling to the next level?

Enroll Here Free Preview