How To Dynamically Model Cash Flow Projections For Rapid Changing Assumptions

Instructor: Joe Weil
Product ID: 706002
  • 29
  • March 2019
    Friday
  • 10:30 AM PDT | 01:30 PM EDT
    Duration: 100 Min
This Microsoft Excel training will help attendees to understand how to build a dynamic Cash Flow forecasting model in Excel. Also attendees will learn how to design and construct the classic cash flow template and implementation of Excel spinners for dynamic display and calculation of changing assumptions.

Live Online Training
March 29, Friday 10:30 AM PDT | 01:30 PM EDT | Duration: 100 Min

$129.00
One Dial-in One Attendee
$349.00
Group-Max. 10 Attendees/Location
(For Multiple Locations Contact Customer Care)
Super Deal - Get CD/USB Drive Free!

recorded version

$149.00
1x Person - Unlimited viewing for 6 Months
(For multiple locations contact Customer Care)
Recorded Link and Ref. material will be available in My CO Section 48 hrs after completion of Live training

Training CD / USB Drive

$199.00
One CD/USB is for usage in one location only.
(For multiple locations contact Customer Care)
CD/USB and Ref. material will be shipped within 15 business days after completion of Live training

Combo Offers

Live + Recorded Version

$249.00

Live + Training CD/USB

$299.00

Customer Care

Fax: +1-650-362-2367

Email: customercare@complianceonline.com

Read Frequently Asked Questions

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.

Learning Objectives:

  • Build a simple yet effective Cash Flow forecasting model in Excel
  • Understand, design and construct the classic cash flow template
  • Follow the ebb and flow of cash flow in either a service or retail business
  • Cutting-edge techniques for predicting cash excess and shortfalls
  • How to implement Excel spinners for dynamic display and calculation of changing assumptions
  • Effectively chart cash flow projects to highlight times of needed borrowing vs. periods of investment of excess funds
  • Accrual vs Cash accounting and how to establish the relationship of receipts and disbursements as related to appropriate timing
  • How to establish and improve banking relationships
  • Key takeaway – a classic Excel cash flow template for every situation

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

Who Will Benefit:

  • Accountant
  • Budget Manager
  • Financial Analyst
  • Auditor
  • Business Owner
  • Bookkeeper
  • Controller
  • CFO
  • Division Director
  • General Manager
Instructor Profile:
Joe Weil

Joe Weil
CEO, NCCE

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.

Follow us :
Computer System Validation - Reduce Costs and Avoid 483s
FDA's GMP Expectations for Phase I and First-in-Man Clinical Trials

Refund Policy

Registrants may cancel up to two working days prior to the course start date and will receive a letter of credit to be used towards a future course up to one year from date of issuance. ComplianceOnline would process/provide refund if the Live Webinar has been cancelled. The attendee could choose between the recorded version of the webinar or refund for any cancelled webinar. Refunds will not be given to participants who do not show up for the webinar. On-Demand Recordings can be requested in exchange.

Webinar may be cancelled due to lack of enrolment or unavoidable factors. Registrants will be notified 24hours in advance if a cancellation occurs. Substitutions can happen any time.

If you have any concern about the content of the webinar and not satisfied please contact us at below email or by call mentioning your feedback for resolution of the matter.

We respect feedback/opinions of our customers which enables us to improve our products and services. To contact us please email customercare@complianceonline.com call +1-888-717-2436 (Toll Free).

Product Reviews

This product hasn't received any reviews yet. Be the first to review this product! Write review

Best Sellers
You Recently Viewed
    Loading