In This Section

Debt Modelling Masterclass

In This Section

Training

In This Section

Training

In This Section

Training

all posts

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'

Location Course Date
Sydney Debt Modelling Masterclass September 23 2010 - September 24 2010
Perth Debt Modelling Masterclass October 14 2010 - October 15 2010
Singapore Debt Modelling Masterclass October 28 2010 - October 29 2010
London Debt Modelling Masterclass November 4 2010 - November 5 2010
Sydney Debt Modelling Masterclass November 24 2010 - November 25 2010

View entire training schedule

Back to top

  • Project Finance
  • Corporate Finance
  • Mergers & Acquisitions
  • Leveraged Finance
  • Operational Models
  • Budgeting & Group Reporting
  • Private Equity
  • Investment Decision Models

Contact Us to discuss your next model audit

Recent Comments

  • 94 Hi ...
  • ExcelT8 The Sumwise blog is very great! It has the advantages of Index/Match in terms of flexibility of loca...
  • Ricaldo212 I am preparing a busines case in this project given to me by my supervisor and I am required to calc...
  • Gavin Townsend Good illustration to show that the programming techinique to iterate through a certain process is n...
  • Testimonials

    Jemena

    "Corality completed a model audit for Jemena on a strategic water project in December 2008. Throughout the audit work, the Corality staff were thorough and diligent. Despite being the holiday season, the job was completed efficiently and on time. We were impressed with the high level of “Corality professionalism” throughout the audit process."

    Vincent Leong, Financial Analyst Commercial Strategy