Hosted by
Carl Seidman CPA | Microsoft MVP
The person Fortune 500s use for their financial leadership development programs
Cash Flow Mastery: Deep Dive Modeling – Level 2
4.9 (17 Ratings) · 5 Weeks · Cohort-based Course
- 💸 The encore to Carl's Level 1 Cash Flow Forecasting course, this course dives into data management, dynamic processes, and deeper thinking
Course Overview
Here’s What You Can Expect From This Course
This is Level 2 of the Cash Flow Forecasting and Modeling Series:
- Level 1 - Cash Flow Forecasting and Liquidity Modeling
- Level 2 - Cash Flow Mastery: Deep Dive Modeling
In Cash Flow Forecasting and Liquidity Modeling – Level 1, you learned:
1️⃣ Structuring of the cash flow model
2️⃣ Determining liquidity needs and excess
3️⃣ Nuances of every major forecast line item
4️⃣ Different approaches for managing working capital
5️⃣ Various methods for reconciling weekly and monthly forecasts
6️⃣ How cash flow forecasting compares across treasury, FP&A, and restructuring
In Cash Flow Mastery: Deep Dive Modeling – Level 2, finance professionals build upon the foundational skills from Level 1, deep diving into advanced techniques and processes necessary for maintaining a comprehensive cash flow management process. deepen expertise and tackle the complexities of cash flow forecasting and comprehensive model management.
You’ll learn:
1️⃣ Methods to predict future sales more accurately
2️⃣ Advanced aging and rollforward techniques for accounts receivable and payable
3️⃣ Payroll components and schedules to forecast more effectively
4️⃣ Capex investment with planning and precision
5️⃣ Debt schedules and optimization of payment strategies
6️⃣ Variance analyses to drive decision-making
7️⃣ How to roll forecasts forward, update them with actuals, and integrate your 13-week cash flow forecast with a 12-month strategic outlook
Who Should Enroll:
This course is designed for professionals in corporate finance, financial planning & analysis (FP&A), private equity, turnaround and restructuring, and distressed investing looking to elevate their financial modeling capabilities and strategic decision-making.
Course Features:
Interactive Sessions: Engage with scenarios that simulate real-world challenges.
Expert-Led Tutorials: Learn from seasoned professionals with deep industry knowledge.
Practical Applications: Apply what you learn immediately to your current role with hands-on exercises and comprehensive case studies.
* Disclaimer: While attendance in Cash Flow Forecasting and Modeling – Level 1 (or the on-demand self-paced cash flow forecasting and modeling course) is not required or a prerequisite to enroll, it is strongly encouraged.
If you are interested in joining Cash Flow Forecasting and Modeling (Level 1) with Carl Seidman, you can learn more about that program below.
Seidman Financial is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit. Complaints regarding registered sponsors may be submitted to the National Registry of CPE Sponsors through its website: www.NASBARegistry.org.
Seidman Financial is a division of Seidman Global LLC.
COHORT STRUCTURE:
- 10 Sessions, 2 hours each
- Tuesdays and Fridays, 1pm - 3pm CDT
- Total Live Commitment: 20.0 hours
- Total CPE: 20.0 credits
Who Is This Course For
What You’ll Get Out of This Course
-
Develop Robust Sales Forecasting Techniques
» Gain the ability to create more accurate and nuanced sales forecasts using market analysis, various segmenting and formulaic methods. -
Master Accounts Receivable Management
Learn how to demystify detailed receivables aging reports and rollforwards by customer, date, term, and treatment -- improving cash collection processes and reducing days sales outstanding (DSO). -
Analyze and Forecast Payroll Expenses
Develop skills in analyzing payroll components and forecasting future payroll expenses with greater accuracy, considering variables such as overtime, bonuses, and benefits. -
Plan and forecast capital expenditures (capex) accurately and defensibly
Understand how to forecast capital expenditures precisely, incorporating strategic planning and budget alignment for future investments. -
Manage debt service and financing strategies
Enhance your ability to manage debt service schedules, including the implications of refinancing or restructuring existing debt. -
Integrate and update long-term operating forecasts
Learn to dynamically integrate short-term cash flow forecasts with longer-term financial plans, updating them regularly with actual results to ensure continuous accuracy. -
Conduct thorough variance analyses
Acquire the skills to perform detailed variance analyses between forecasted and actual figures, identifying root causes of discrepancies and making informed decisions to correct course.
This Course Includes
Live sessions
Learn directly from Carl Seidman CPA | Microsoft MVP in a real-time, interactive format.
Access to recordings
Go back to course content and recordings whenever you need to.
Community of peers
Stay accountable and share insights with like-minded professionals.
Certificate of completion and CPE credits
Share your new skills with your employer or on LinkedIn.
Course Syllabus
Week 1: Jan 13—Jan 18
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Jan 13 | 1pm (CDT)
- Aging Analysis Techniques: Learn how to perform detailed aging analysis to categorize receivables by their due dates, which helps in identifying trends in customer payments and prioritizing collection efforts. Set up aging buckets and interpret the implications of aging trends on overall cash flow.
- Rollforward Reports Creation: Gain proficiency in constructing rollforward reports for accounts receivable, which track changes from the beginning balance to the ending balance over a specific period.
📄 The accounts receivable accounting equation
📄 Analyzing the accounts receivable aging report
📄 Analyzing historical trends, terms, and anticipated receipts
📄 Data automation and rolling the receivables forecast
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Fri. Jan 16 | 1pm (CDT)
- Detailed Payroll Cost Analysis: Learn to conduct an in-depth analysis of payroll costs, breaking down expenses by types such as salaries, wages, bonuses, and benefits. This module will teach techniques for understanding the implications of each component on overall cash flow and forecasting future payroll liabilities.
Forecasting Payroll Expenses: Develop skills to forecast payroll expenses accurately, considering factors such as seasonal hiring, contractual raises, and policy changes.
📄 Analyzing payroll schedules
📄 Analyzing the impact of different payroll cycles
📄 Contemplating raises and COLA adjustments
📄 Restructuring compensation
📄 Analyzing layoffs, severance, and related contingencies
📄 Integrating payroll into comprehensive cash flow models
Week 2: Jan 19—Jan 25
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Jan 20 | 1pm (CDT)
- Optimal Payment Timing Strategies: Learn to strategically time payments to manage cash outflows effectively, balancing early payment discounts against cash retention priorities. This includes techniques for assessing the financial benefits of various payment terms and optimizing cash flow through payment scheduling.
- Accounts Payable Aging Analysis: Develop skills in conducting a detailed aging analysis of accounts payable to identify payment patterns and prioritize payments.
📄 The accounts payable accounting equation
📄 Analyzing the accounts payable aging report
📄 Analyzing terms, critical relationships, and payment strategies
📄 Contemplating early-pay discounts and tradeoffs
📄 Data automation and rolling the payables forecast
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Jan 23 | 1pm (CDT)
- Developing a Roll-Forward Process: Establish a recurring process and low-code experience for incorporating new data into the financial model.
- Utilize Power Query and Raw Data to Populate the Model: Connect the weekly cash flow model to supporting schedules through the use of Power Query.
- Learn the basics of data cleaning and reformatting: Familiarize yourself with Power Query’s transformation tools to build smarter data sets that can be easily mapped into the cash flow model.
📄 Updating the Cash Flow Model for New Data
📄 Connecting Back-End Financial Data into the Cash Flow Model
📄 Overview of Data Mapping
📄 Introduction to Microsoft Power Query
Week 3: Jan 26—Feb 1
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Jan 27 | 1pm (CDT)
- Compare and contrast near-term cash flow forecasting with long-term needs: Examine long-term planning assumptions and bridge the weekly cash flow model to the longer-term operating and financial model.
📄 How a Long-Term Planning Model Differs from a Near-Term Cash Flow Model
📄 Excel Functionality for Seamless Integration Between Weekly and Monthly Forecast
📄 Connecting the Weekly Forecast to the Monthly Forecast
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Jan 30 | 1pm (CDT)
- Capex Planning and Budgeting: Learn the principles of strategic CapEx planning and budgeting, focusing on aligning investments with long-term business goals. This includes methods for evaluating the potential returns on investment (ROI), assessing risk, and prioritizing capital projects based on strategic objectives.
- Scenario Analysis for Capex Decisions: Gain expertise in conducting scenario analyses to explore different capex strategies and their potential financial outcomes.
📄 Analyzing historical maintenance capex
📄 Planning for investment capex and major projects
📄 Scenario analysis for capex decisions and contingency planning
Week 4: Feb 2—Feb 8
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Feb 3 | 1pm (CDT)
- Understanding Debt Structures and Terms: Analyze various debt structures and their terms, including fixed vs. variable interest rates, maturity periods, and amortization schedules.
Scenario Analysis for Debt Management: Performing scenario analysis to assess the impact of different financial and economic conditions on financing and debt service requirements.
📄 Credit agreements and terms
📄 Integrating financing and amortization schedules
📄 Automating debt service
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Feb 6 | 1pm (CDT)
- Comprehensive Scenario Modeling: Build robust scenario management functionality allowing the model to contemplate multiple scenarios with ease.
- Advanced Concepts in Cash Flow Forecasting: Consider more nuanced topics including consolidation across multiple business units, bankruptcy, and fundraising.
📄 Comprehensive scenario management
📄 Advanced concepts in cash flow forecasting and liquidity management
Week 5: Feb 9—Feb 13
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Feb 10 | 1pm (CDT)
- Forecast-to-actual variances: Update the cash flow forecast for actuals and compare it to expectations, assessing favorable and unfavorable variances and rolling it forward for new assumptions.
- Forecast version to forecast version variances: Evaluate current weekly cash flow forecasts against prior versions, discovering what has changed, why, and to what extent.
📄 Forecast-to-actual variances
📄 Forecast version to forecast version variances
📄 Interpreting variances and rolling the forecast
✨ Advanced Cash Flow Forecasting and Modeling - Level 2 ✨
Tues, Feb 13 | 1pm (CDT)
What Students Are Saying
Carl's live, hands-on course was very engaging as well as instructional. Rather than simply viewing a how-to, our group was working with a live model and creating functionality during our sessions. The sessions were also facilitated as a zoom meeting rather than a webinar, so we interacted as if we were in a classroom setting. On top of all this, we earned CPE credits! I highly recommend Carl's sessions and look forward to the next one.
Christine
CFO and Business Advisor Count | Financial Consulting
Very robust course on cashflow modeling with ability to determine which parts are appropriate for your own use case.
Tim
Founder FP&A Operators
Very helpful course with very helpful examples. It is also very helpful that you get copies of the recordings. Carl is a great instructor!
Forrest
Fractional CFO, Watchpoint Group
Carl's Cash Flow Mastery Level 2 course is top notch! He does an incredible job walking through the steps of building a robust cash flow that can be adapted to the individual users' needs. Carl is engaging and truly has a gift of teaching. The cohort format further enhances the course discussion because of the participants' real life experiences.
Talia
CAS Manager Miller Cooper
Very insightful course. It was also very challenging. I learned many different ways to model the TWCF that could be very helpful.
Roberto
CFO, Commosa
This is one of the most outstanding courses I've ever taken. And Carl is the most gifted teacher/professor I've ever had - and possibly the very best professional communicator I've ever encountered. This is a very advanced course and taught superbly. 10/10 recommend.
Student
The class is extremely powerful...upon final mastery of this material I will be thoroughly a head and shoulders above my peers with respect to cash flow forecasting and modeling. I will be confident enough to handle a majority of the real world scenarios I may encounter. Should I need help, then Carl, the instructor, is an available resource!
-- James
Founder, Paradigm Shift Capital, LLC
Meet Carl, Your Instructor and Guide
Carl Seidman CPA | Microsoft MVP
Principal, Seidman Financial | Microsoft MVP
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 is 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, Dominium, Express Scripts, EY, FS Investments, EVRAZ, Genentech, Healthpeak, Heartland Financial, Hewlett Packard Enterprise, Hostess, IGT, KPMG, Marsh & McLennan, Michelin, NerdWallet, Radisson, Rapid7, Sol Petroleum, Spotify, Triple-S, Telus, Santander, United Technologies (RTX), UBT, 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 serves as an Adjunct Professor in data analytics at the Jones School of Business at Rice University. He 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.
Join an upcoming cohort
Cash Flow Mastery: Deep Dive Modeling – Level 2
COST
$1,497 USD
UPCOMING
MSP T2C1 (Jan 2026)
DATES
Jan 13—Feb 13, 2026
PAYMENT DEADLINE
Jan 13, 2026
Frequently Asked Questions
You are strongly encouraged not to miss live sessions, as a great part of the experience is both the live-reveals and the participant interaction.
In other words, you get to:
- learn in real-time
- apply in real-time, and
- reflect in real time
Yes, sessions are recorded and you can go through them on your own, but learning may be more limited.
We meet for 5 weeks, 4 hours each session. It is intentionally spaced out over a number of days and weeks so you can work your schedule around it.
That’s 20 hours all in: content, discussion, reflection, cases, and Q&A.
There is occasional pre-work and post-session work but it is minimal.
It is not customary for me to offer refunds. Across hundreds of training, seminars, workshops, and conferences — in person and virtual — 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 canceled. I offered a rescheduling option for a future date.
I offer more than a dozen training programs and immersive development experiences across a wide range of finance and accounting topics.
Here are the other programs I offer in partnership with Maven.
This program is designed for finance professionals who want to advance their skills and understanding specifically in cash flow forecasting.
We meet live on Zoom for 4.5 hours 2x per week.
Each session consists of half the modules of the course. Each module ties into prior and future modules, so it is vital to try to avoid missing classes.
The structure of the session begins with an intro, a tie-in to a real example, exercises, discussion, and reflections.
Prerequisites for the course include the following:
- You should have a basic-to-intermediate understanding of Microsoft Excel
- You should have a current version (2016 or later) of Microsoft Excel, ideally (though not necessary) on a PC.
- You should have at least an basic understanding of accounting and finance concepts.
No, but I will offer you my promises.
Everyone who attends this course will have different backgrounds, experience, and aspirations which means they have different business models or jobs.
My promise is 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.
Yes, it qualifies for 9.0 CPE credits.
Seidman Financial is registered with the National Association of State Boards of Accountancy (NASBA) as a sponsor of continuing professional education on the National Registry of CPE Sponsors. State boards of accountancy have final authority on the acceptance of individual courses for CPE credit.
Yes. You get all of the template models, clean and completed.
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 and CFO backgrounds.
According to alumni, this is the best cash flow forecasting and modeling course available.
