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!)

https://rapidgator.net/file/1ad70025acf2298649d087018476d7bc/Project_Finance_Debt_Ratios_Sculpting_DSCR_LLCR_PLCR.part1.rar.html
https://rapidgator.net/file/74c2be9b2c27a9e22e23e474429667a1/Project_Finance_Debt_Ratios_Sculpting_DSCR_LLCR_PLCR.part2.rar.html