Course curriculum

  • 1

    Introduction

    • Course introduction

    • Download exercise files

    • The importance of cash

    • Why business fails at cash management

    • Short term vs long term cash flow
  • 2

    Operating Cash Flow Cycle

    • Session overview

    • Total working capital and operating working capital

    • Inventory

    • Accounts receivable

    • Accounts payable

    • Working capital cycle

    • Working capital funding gap

    • Funding gap and operating line calculator overview

    • Calculate receivable days, inventory days, and payable days

    • Calculate operating line required and allowed

    • Download completed funding gap and operating line calculation

    • Improving the working capital cycle - accounts payable

    • Improving the working capital cycle - accounts receivable

    • Improving the working capital cycle - inventory

    • Working capital objectives

    • Streamline efficiency

    • Optimize liquidity
  • 3

    Investing Cash Flow Cycle

    • Working capital vs investing capital

    • Capital investment (capex)

    • Types of capital investments

    • Long term capital investment cycle

    • Payback and return on investment

    • Download completed payback and ROI calculation

    • Making capital investments work for you

    • Capital investment objectives
  • 4

    Cash Flow Cycles and Analysis in Excel

    • Case study overview

    • Balance sheet

    • Cash flow from operating activities

    • Investing activities

    • Financing activities

    • End of year cash and equivalents

    • Cash flow analysis

    • Download completed cash flow cycles demonstration
  • 5

    Conclusion

    • Course conclusion
  • 6

    Qualified Assessment

    • Qualified assessment