Treasury Management - Use of Excel
General Objectives:
The course aims to highlight the main instruments of treasury management, both in the planning aspect and in the analysis and evaluation aspect of the financial instruments themselves.
Specific Objectives:
At the end of this Course participants will be able to:
- Identify the benefits of efficient treasury management;
- Define financial balance;
- Analyze cash flows;
- Differentiate cash management, customers and suppliers;
- Prepare and analyze treasury budgets;
- Managing receivables;
- Define, measure and manage liquidity;
- Identify various types of liquidity;
- Manage assets and liabilities;
- Manage working capital;
- Manage the float of credits and stocks;
- Manage financial investments;
- Elaborate and analyze monetary dashboards.
CONTENTS
Module I - The Treasury: Benefits of its efficient management;
Module II - Notion of financial balance: working capital and working capital required;
Module III - Cash flow analysis;
Module IV - Treasury management: management of cash, customers and suppliers;
Module V - Budgeting and cash control systems;
Module VI - Elaboration and analysis of the execution of treasury budgets;
Module VII - Management of receipts;
Module VIII - Bank reconciliations;
Module IX - The operating cycle and the management of assets and liabilities;
Module X - Real application exercises;
Module XI - The concept and measurement of liquidity;
Module XII - Liquidity as available resources: static and dynamic perspective;
Module XIII - Cash conversion cycle and working capital management;
Module XIV - Float, credit and stock management;
Module XV - Credit granting policy;
Module XVI - Collection and payment of foreign trade operations;
Module XVII - Liquidity as debt repayment capacity;
Module XVIII - Liquidity management at group level;
Module XIX - Profitability of existing excess liquidity;
Module XX - Management of financial investments;
Module XXI - Elaboration and analysis of monetary dashboards.
Module XXII - Practical Cases
High Skills - Formação e Consultoria
Angola | Cabo- Verde | Moçambique | Portugal | S. Tomé e Princípe
