Description
Asset Management: Registers, Valuation & Disposal with Advanced Excel
Module 1: Introduction to Asset Management
- Overview of Asset Management in the Public and Private Sectors
- Importance of Effective Asset Management
- Key Challenges in Asset Management
- Relevant Accounting Standards:
- IPSAS 17 (Property, Plant, and Equipment)
- IAS 16 (Property, Plant, and Equipment)
- IAS 36 (Impairment of Assets)
- IFRS 5 (Non-Current Assets Held for Sale and Discontinued Operations)
- Excel Functions Covered:
- SUMIF, COUNTIF, FILTER (Managing and analyzing asset data)
- DATA VALIDATION (Ensuring data accuracy in asset registers)
Module 2: Asset Registers and Classification
- Definition and Purpose of an Asset Register
- Key Components of an Asset Register
- Classification of Assets: Fixed, Current, and Intangible Assets
- Asset Coding and Tagging Systems
- Establishing and Maintaining an Accurate Asset Register
- Excel Functions Covered:
- VLOOKUP, HLOOKUP, XLOOKUP (Retrieving asset information efficiently)
- CONCATENATE & TEXTJOIN (Creating unique asset codes)
- Conditional Formatting (Highlighting missing or duplicate assets)
Module 3: Asset Valuation and Depreciation
- Understanding Asset Valuation Principles
- Initial Recognition and Measurement of Assets
- Depreciation Methods:
- Straight-Line Method
- Reducing Balance Method
- Units of Production Method
- Impairment of Assets and Revaluation Process
- Relevant Accounting Standards:
- IAS 16 (Depreciation and Valuation)
- IAS 36 (Impairment Testing)
- IPSAS 17 (Valuation of Public Sector Assets)
- Excel Functions Covered:
- SLN, DB, DDB (Depreciation calculations)
- NPV, IRR (Asset investment and valuation analysis)
- IFERROR, ISBLANK (Error handling in asset valuation models)
Module 4: Asset Disposal and De-recognition
- Identifying Assets for Disposal
- Methods of Asset Disposal:
- Sale
- Scrapping
- Donation
- Trade-in
- Accounting for Asset Disposal:
- Gain/Loss on Disposal Calculation
- Adjusting Financial Statements
- Compliance with Accounting Standards:
- IFRS 5 (Non-Current Assets Held for Sale)
- IAS 16 (Derecognition of Assets)
- Excel Functions Covered:
- IF, NESTED IF (Determining disposal decisions)
- GOAL SEEK (Analyzing disposal impact on financials)
- SCENARIO MANAGER (Evaluating different disposal scenarios)
Module 5: Asset Management Reporting and Compliance
- Preparing Asset Reports for Stakeholders
- Compliance with Internal Controls and Audits
- Generating Reports using Advanced Excel
- Dashboard Creation for Asset Tracking and Valuation
- Forecasting Future Asset Needs and Budgeting
- Relevant Accounting Standards:
- IPSAS 17 & IAS 16 (Asset Reporting)
- IAS 36 (Asset Impairment Disclosures)
- Excel Functions Covered:
- PIVOT TABLES & PIVOT CHARTS (Summarizing asset data)
- POWER QUERY (Data transformation and integration)
- DASHBOARD DESIGN (Visualizing asset trends and financial impacts)
Module 6: Practical Case Study & Hands-on Exercises
- Creating a Dynamic Asset Register in Excel
- Automating Depreciation Calculations
- Developing a Disposal Decision Model
- Building an Asset Management Dashboard
- Real-world Scenarios and Problem-Solving Sessions
Description
Course Overview:
This comprehensive workshop is designed to equip banking professionals with the essential skills and knowledge to effectively manage the assets and liabilities of financial institutions. Participants will gain a deep understanding of the unique aspects of banking, the structure and components of a bank's balance sheet, income generation, and the myriad of risks and regulatory requirements that banks face. The workshop will also cover advanced topics such as market risk management, interest rate risk in the banking book (IRRBB), and the ALM process.
Course Objectives:
To understand the unique nature and functions of banks.
To analyze the structure of a bank's balance sheet and how banks generate income.
To identify and manage the various risks banks are exposed to.
To comprehend the regulatory framework imposed on banks, including capital requirements and liquidity regulations.
To master the techniques for measuring bank performance.
To learn effective strategies for funding the bank and managing liquidity.
To manage market risk and interest rate risk in the banking book.
To implement an effective Asset and Liability Management (ALM) process.
Target Audience:
Banking professionals involved in risk management, treasury, finance, and compliance.
Financial analysts and consultants specializing in the banking sector.
Bank regulators and supervisors.
Academics and students specializing in finance and banking.
Professionals preparing for roles in ALM and treasury management.
General Notes
GENERAL NOTES
i. The clients have many options on where they would wish to have the training
ii. The client should communicate their preferred training venue at least seven days before the training date failure to which the training shall take place in Nairobi.
iii. This course is delivered by our seasoned trainers who have vast experience as expert professionals in the respective fields of practice. The course is taught through a mix of practical activities, theory, group works and case studies.
iii. Training manuals and additional reference materials are provided to the participants.
iv. Upon successful completion of this course, participants will be issued with a Chania finance consultancy certificate.
v. The onsite training fee covers tuition fees, training materials, tea at 10am, lunch, tea at 4pm, training venue and a certificate on completion. Accommodation and travel may be arranged for our participants upon request.
vi. The online training fee covers tuition fees, training materials, and a certificate on completion.
Available at the following Venues
- Nairobi
- Mombasa
- Kisumu
- Nakuru
- At Work Place
- Zoom
- Google Meet
- Google Teams
- Webex
Choose the date you would like to take the course
Related Courses
10,000+ unique online course list designs
