2019 - How To Dynamically Model Cash Flow Projections For Rapid Changing Assumptions

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