Debt Modelling Masterclass

Timetable for 'Debt Modelling Masterclass' courses

If you can build a basic model but still find yourself wanting to learn more in order to deliver peak performance within a banking environment, you should participate in the Debt Modelling Masterclass. This course builds on the key concepts obtained in Corality’s course Project Finance Modelling (A) but can also be attended as a stand-alone course.

This course is essential to improve your ability to build, review or analyse financial models where debt sizing, repayment, refinancing and seniority are issues to consider.

Apply sophisticated analytical skills of debt transactions

Flexible and robust modelling is at the heart of the analysis of a debt transaction. This course provides you with a range of proven techniques to efficiently manage the transactional complexities of a structured debt transaction or a complex project financing.

Take full control of debt modelling

• Master the modelling of comprehensive debt mechanics
• Gain full understanding of debt sizing and debt sculpting
• Model and test a Debt Service Reserve Account (DSRA)
• Model seniority of payments and mezzanine debt mechanics
• Add cash sweep metrics to your credit analysis toolbox

Extract of course outline

• Coding of flexible debt sculpting methods
• Advanced techniques for annuities to enable sculpting
• Sculpting repayments to a target DSCR
• Cash sharing proportions for different scenarios
• Explanation of the DSRA and why it is used
• Mezzanine debt for funding during construction
• Incorporating a stand-alone cash sweep with a flexible start date
• Debt sizing with gearing and LLCR constraints
• Prepare DSCR for senior and mezzanine debt for all scenarios
• Breaking a circular reference with VBA
• Solving the circular reference of average interest with algebraic techniques
• Calculating interest on an average balance without a circular reference and without VBA
• Using a one-dimensional (1D) data table to value the IRR and NPV benefits of the tax shield on interest
• Multiple IRRs problem - discussion of possible and practical solutions
• Dynamic highlights of minimum / maximum in a graph

Duration: 2 days

Timetable for 'Debt Modelling Masterclass'

View entire training schedule

Back to top