Organization Name / Organize By
Devimpact institute
Organizing/Related Departments
Training
Organization Type
Institution
Training or Development ClassCategory
Both (Technical & Non Technical)
Training or Development ClassLevel
International
Related Industries
Education/Teaching/Training/Development
Course Objectives
By the end of the course, participants will be able to:
- Understand alternative approaches to NPLs management and recovery structures
- Understand different NPLs recovery strategies/techniques
- Understand accounting treatment of non-performing loans and loan loss provisioning
- Understand IFRS 9 accounting standard for NPL management
- Prepare effective financial models utilizing powerful Excel functions
- Use core financial modeling techniques
- Forecast investments, and calculate valuations of projects and companies in an effective manner
- Develop comprehensive financial models to support investments decisions
Target Audience
Credit controllers, risk management professionals, corporate finance professionals, investment professionals, CFOs, financial controllers, finance managers, financial analysts, corporate bankers, and business development analysts.
Course Outline
Non-Performing Loans Management
Introduction to Non-Performing Loans
- Definition of NPL
- NPL Types
- Systematic impact of NPL
NPL Strategy
- Assessing the operating environment
- Developing the NPL strategy
- Implementing the operational plan
- Embedding the NPL strategy
NPL governance and decision making
- Steering and decision making
- NPL operating model
- Control framework
- Monitoring of NPLs and NPL workout activities
- Early warning mechanisms/watch-lists
Forbearance
- Forbearance options and their viability
- Sound forbearance processes
- Affordability assessments
NPL Recognition
- Implementation of the NPE definition
- Link between NPEs and forbearance
- Further aspects of the non-performing definition
- Links between regulatory and accounting definitions
NPL impairment in line with IFRS 9
- Overview of IFRS 9
- Overview of impairment
- Probabilities of Default considerations
- Loss Given Default considerationss
- Individual estimation of provisions
- Collective estimation of provisions
- Other aspects related to NPL impairment measurement
NPL write-offs
- Overview of NPL write-offs
- Timeliness of provisioning and write-off
- Provisioning and write-off procedures
Advanced Financial Modeling and Dashboards using Excel
Introduction to Financial Modeling in Excel
- Key Excel functions used in Financial modeling
- Advanced range names, including formulas and naming conventions
- Pivot Tables
- Scenarios, sensitivity, data tables
- Best practice guidelines and spreadsheet modeling standards
Financial Modeling Overview
- Modeling fundamentals
- Steps in model building
- Key concepts
Model Components
- Capital budgeting & depreciation modeling
- Debt modeling
- Capital Structure
- Ratio analysis
- Tax considerations
- Inflation
- Reporting considerations: changing timescales, changing currencies, units
Specific Purpose Modeling
- Company valuation & financial statement simulation
- Project finance modeling
- Mergers & Acquisitions Analysis
- Divestiture
Advanced Modeling Applications
- Multi-variable Monte Carlo Simulations
- Advanced MapReduce
- Introduction to VBA Macros: useful functions and macros, and how to apply these to models
- Advanced Charting techniques
- Advance Excel Dashboards
Training Methodology
This course is delivered by our expert trainers who have extensive M&E field experience. The course is taught through a mix of practical activities, theory, group works and case studies.
Training manuals and additional reference materials are provided to the participants.
Training Approach
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.
Training manuals and additional reference materials are provided to the participants.
Certification
Upon successful completion of this course, participants will be issued with a certificate.
Tailor-Made Course
We can also do this as tailor-made course to meet organization-wide needs. Contact us to find out more: [email protected]
Training venue
The training will be conducted at Devimpact Institute Training Centre, Nairobi Kenya.
Payment
The training fee covers tuition fees, learning materials, and training venue. Accommodation and airport transfer are arranged for our participants upon request.
Payment should be sent to our bank account before start of training and proof of payment sent to [email protected]
Registration Fees
Available
Registration Fees Details
950$
Registration Ways
Website
Address/Venue
Muthithi Road
Pin/Zip Code : 38164-00100