Project Finance Debt Ratios & Sculpting (Dscr Llcr Plcr)

Say “Goodbye!” to spreadsheet errors and confusion with the help of this special laser-focused course!

What you’ll learn
You will understand high-level objectives of using project finance debt ratios
Understand difference between ‘descriptive’ and ‘prescriptive’ ratio use
Understand the different risk information communicated by ratios
You will master the hardest ratio of them all – the LLCR!

Requirements
Some familiarity with project finance / non-recourse debt

Description
Project Finance models are among the most complicated spreadsheet models in the whole of finance.You have to deal with complexity on several fronts, and your prior experience outside of the field may have done little to prepare you for it.Most project finance courses will serve you the entire skillset and theory you need as a modeler, all at once. But for many analysts I have spoken to, that is simply too much information at once. And in a well-intentioned effort not to overload students, course-makers end up leaving out many significant details.This course takes a different approach.It gives you a narrow, laser-focused examination of issues that are central to any project finance deal:How much debt is going loaned to the company?How is it going to be paid back?Project finance models answer critical questions with mathematical procedures centred on project finance debt ratios.This course will look at all the project finance ratios, along with mathematical explanations about how, and why they work… (instead of asking you to just copy them and trust that they do.)You will finally gain clear-minded understanding, and be able to spot and avoid errors that trip other analysts up… and which may even be lurking in the model you have inherited.All this will help you work, faster, more confidently, with lower risk of error – a great reward for your investment.

Overview
Section 1: Introduction

Lecture 1 Introduction

Lecture 2 The ‘Golden Rule’ of Project Finance!

Lecture 3 The big picture: what is it all about?

Section 2: Descriptive use of debt ratios

Lecture 4 CFADS

Lecture 5 DSCR

Lecture 6 The first LLCR

Lecture 7 The first LLCR – in Excel

Lecture 8 The rolling LLCR

Lecture 9 The rolling LLCR – by backwards induction

Lecture 10 Timing pitfalls to avoid using the LLCR

Lecture 11 LLCR for break-even, and restructuring analysis

Lecture 12 PLCR

Lecture 13 Ratio math DEEP DIVE!

Section 3: Prescriptive use of debt ratios for debt sizing and sculpting

Lecture 14 Introduction to debt sizing

Lecture 15 Sizing and sculpting with DSCR, under fixed payments

Lecture 16 Introduction to sculpting

Lecture 17 Sizing and sculpting with variable cashflows – NPV method

Lecture 18 Sizing & sculpting with variable cashflows – by backwards induction

Lecture 19 Key variable relationships for sizing and sculpting

Lecture 20 Working with maximum leverage constraints

Lecture 21 Rescaling of debt-service as stakeholder-neutral solution

Lecture 22 BONUS LECTURE

Junior analysts, associates, (and any seniors getting back into modelling work!)