Working Capital & Asset Modelling Course

The Working Capital & Asset Modelling course is designed to provide participants with a comprehensive understanding of Working Capital & Asset spreadsheet modelling, including Operating Receivables, Operating Payables, Capital Payables, Book Assets/Intangibles and Tax Assets/Intangibles. A mix of theoretical and practical exercises will ensure participants walk away with a thorough understanding of Working Capital & Asset modelling concepts and have the ability to perform detailed and efficient Working Capital and Asset analysis within Microsoft Excel.

The Working Capital & Asset Course addresses the following areas:

  • working capital analysis - overview and fundamental concepts;
  • a modular approach to working capital modelling;
  • operating receivables;
  • operating payables;
  • capital payables;
  • the impact of working capital modelling on financial statements;
  • working capital modelling precedents & dependants;
  • asset analysis - overview and fundamental concepts;
  • a modular approach to asset modelling;
  • depreciation methods;
  • timing of capital expenditure;
  • book assets versus tax assets;
  • the impact of asset modelling on financial statements;
  • asset modelling precedents and dependants; and
  • using bpmModules to quickly and efficiently develop working capital and asset spreadsheet models.

Contact BPM to book this course.Book this training course.

Course Information

Intended Audience
Beginner to advanced Excel users

Course Type
Practical

Complexity
Basic

Pre-Requisites
None

Duration
4 hours

Price
View prices

Course Materials
Presentation materials; annotated "Working Capital & Assets Modelling" reference guide; example models; self training exercises.