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.
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.

