Example image
Advanced
Debt
TRAINING / COURSES / ADVANCED DEBT

Advanced Debt

Become the Debt Guru in your team.

The commercial intention of debt sizing is often quite straightforward but to implement in a model can go from a difficulty level 2/10 to 8/10 very quickly. This course gives you the skills to tackle literally any situation. We use VBA, of which you need no prior knowledge; you will come away confident and equipped with the techniques and straight-forward ‘readable’ VBA syntax that is needed for these situations. This is a VBA course in-disguise! You will learn skills that translate to scenario analysis and more but by focussing on debt.

You will start from a cashflow model with a debt account and will learn how to:

  • Pick-up and send back a value to the spreadsheet (the basis for all decision-based routines).
  • Create controlled Loops to search for solutions.
  • Incorporate constraints such as maximum gearing.
  • Build a Debt Dashboard to control inputs, monitor progress and sense check output.
  • Understand the DSCR, Tenor, Loan amount “Triangle”.
  • Be able to solve any circularity and incorporate it into a routine.
  • Master tolerances and user-friendly feedback – to avoid not knowing what the routine is doing.
  • Build a Re-Size Debt routine in as an option within a Scenario Manager / Sensitivity table.
  • Appreciate what to “make the model do” vs “what to make the solving routines do”.

This course is designed for people who already know the basics of debt but want to be able to analyse more realistic term sheet mechanics and have either no or unsatisfactory experiences working with VBA routines in the past. This is the course that sets you up to be the Debt Guru in your team!

Let’s start solving your challenges – Contact Us