Cash Flow Modelling For Securitisation - Miscellaneous
Introduction to Securitisation (1 hour – Theory) – the module will cover the fundamentals of securitisation from a bank’s viewpoint. It will review the history of securitisation, the way that it has been used in different countries as well as the different types of assets that have been securitise.
Click here to view PDF of PowerPoint slide from module
Introduction to Excel (No Theory/Practical 2 hours) - This module has been designed to introduce all of the important functions and techniques that will be used over the full course. Whilst these will be all be included in the pre-course material, you will find that any time spent on this section will greatly enhance the speed and efficiency of the remainder of the course.
Click here to view PDF of Excel workbook from module
Introduction to Non-Performing Loans (Theory and Practical 3 Hours) – the theory part of the module looks at the different types of non-performing loans structures and how they impact upon the types of notes. In addition, the importance of the servicer and how its previous performance impacts upon credit enhancement levels. The practical session identifies how the recovery rates and durations can be derived for both secured and unsecured asset types. The programme will require the use to participate in programming and testing the final workbook.
Click here to view PDF of Excel workbook from module
Trade Receivable Securitisation (Theory and Practical 3 Hours) – the theory part of the module takes the delegates through the basics of trade receivables securitisation. It then moves on to cover dynamic reserve mechanism and how these are calculated with respect to loss and dilution reserves. The latter two concepts are covered in great detail. The practical session sues Fitch’s trade receivables criteria piece to build a cash flow programme that allows credit enhancement levels to be set based on a dynamic portfolio of assets. This module requires an intermediate level of Excel programming.