+353-1-416-8900REST OF WORLD
+44-20-3973-8888REST OF WORLD
1-917-300-0470EAST COAST U.S
1-800-526-8630U.S. (TOLL FREE)

How To Dynamically Model Cash Flow Projections For Rapid Changing Assumptions - Webinar (Recorded)

  • Webinar

  • 60 Minutes
  • April 2019
  • Compliance Online
  • ID: 4899776
Why Should You Attend:

Cash is King. Cash flow forecasting is one of the most critical aspects of running a business of any size. This is also a key skill every accountant, budget manager and financial analyst must possess. You will leave this webinar with the knowledge and skills needed to construct a classic cash flow template using state-of-the-art technology.

Knowing when money is coming in or going out, how much is being exchanged and communicating this accurately is often the deciding factor when it comes to making key business decisions.

Whether your organization is in growth mode, status quo, losing ground or survival mode, cash flow forecasting is critical to your success. Are you confident in your current forecasting strategy? This course can help you but is also ideal for the staff accountant who could use a clear, roadmap for cash flow forecasting.

Inadequate cash flow forecasting management is one of the leading causes of business failure. Many organizations only begin to focus on cash flow management during bad times. Having a good system in place to manage cash flow during good times contributes to an organization's success, allowing it to take advantage of opportunities for growth and providing a competitive edge.

Excel has tools that can give cash flow projections a certain sizzle when presented to bank lending officers and potential investors. We conclude this course illustrating the best way to communicate competent cash flow forecasting to a banker or board of directors. You will leave this course with the skill to construct a classic cash flow model using the latest Excel techniques displaying a special degree of financial professionalism.

Areas Covered in the Webinar:

Understanding the Statement of Cash Flows
Three Primary Sources and Uses of Cash
Cash Flow Planning: Cash Flow from Operations v. Free Cash Flow
Overview of the Corporate Treasury Function
Accrual vs. Cash Accounting: Cash Flow Timing
Understanding the Business Operating Cycle and Bridge Loans or “Gap” Financing
Service Industry v. Retail and Manufacturing
Sales, Receivables, Collections and Cash Flow Timing
Inventory, Payables, Disbursements and Cash Flow Timing
Expenses v. Cash Flow
Constructing a Basic Excel Cash Flow Template
Overview: Assumptions, Receipts, Disbursements, Net, Beginning Balance, Ending Balance
Connecting the Sales Forecast to Bad Debt and Collections and Cash Flow Timing via Cell References
Connecting the Expenses Forecast to Disbursements and Cash Flow Timing via Cell References
Incorporating Timing into Assumptions via Cell References
Simple Necessary Formulas
Constructing Excel Spinners for Professional Polish
Form Control and Excel Spin Button
Cell References to Tie the Spin Button to the Assumptions for the Cash Flow Statement
Communicating and Solving Forecasted Problems – Banker Communications
Charting Techniques for Easy Communication
Dealing with Seasonality Timings
Forecasting Borrowing Needs and Repayment
Integrating Spinners and Charts for a Professional Presentation


Joe Weil, CPA, M. Acc., is the president of the National Center for Continuing Education (NCCE), a Tallahassee based nationwide financial training firm. With over 25 years’ experience, Mr. Weil has led over 400 seminars on Excel and financial topics and several highly acclaimed webinars on the same topics. He is a former corporate controller, former state agency director of auditing, and a former municipal CFO.

Mr. Weil earned his Master of Accounting Degree at Florida State University. His training clientele include Harley-Davidson, Hewlett-Packard, Oracle, Deloitte, Florida Power and Light, Motorola, National Institute of Science and Technology, and many others.