1
Welcome to the Course
1:27
3
Introduction to the Model
5:46
4
Sculpting & Sizing - Intro
4:57
5
Mini-model I - Setup, Sculpting & Tenor vs Sizing
3:39
6
Mini-model II - Debt Sizing
3:42
7
Mini-model III - Circularities
2:44
8
Mini-model III - Manual Sizing, Bisection Method, Recap
4:06
9
Capital Structure - Macro Sheet & Max Permissible Debt Size
5:26
10
Capital Structure - The Calculated-Applied Structure & Linking
5:16
11
Introduction to Macros
3:23
12
Macro - Recording & Triggering a Macro to Get Started
6:25
13
Getting into VBA & Refining Code
5:31
14
Using the For Loop to Iterate the Macro
5:49
15
Improving Robustness & Using Named Ranges
2:40
16
Using the Do While Loop to Iterate the Macro
2:48
17
Basic Improvements to Speed up the Macro
3:56
18
Recap to Understand the Role of Loops, Using Shortcuts and Speed Improvements
6:28
19
Introduction to the DSRA
4:36
20
Overview of the DSRA - The Logic Behind Additions & Releases of Cash
5:00
21
Setting up the DSRA & Establishing the Target Balance
7:37
22
Funding the DSRA from Sources of Cash
5:38
23
How to Break the Circularity & Creating a DSRA Macro
5:36
24
Funding from Cashflows to Top-Up the DSRA
11:57
25
Release from DSRA in the Event of CFADS Shortfall
4:01
26
Release from DSRA for DSRA in Excess of Target Balance
3:12
27
Review of DSRA, Linking to Financial Statements and Distribution Lock-Up Flag
7:47
28
Introduction - Motivations for Refinancing Debt & Types of Refinancing
2:23
29
Inputs for Refinancing Debt
3:38
30
Timing of Refinancing Debt & Modifying the Senior Debt Structure
2:33
31
Calculating the Refinancing Fee
4:43
32
Calculating the Refinancing Margin & Incorporating it into the Debt Structure
5:02
33
Introduction to Shareholder Loan - Purpose and Order of Repayment
3:25
34
Creating Inputs for the Shareholder Loan and Building an Account
4:48
35
SHL Drawdowns - Integrating the SHL into Funding Sources & Updating the Capital Structure
7:28
36
Calculating SHL Interest CapitaliZed and Interest Paid
4:21
37
Calculating SHL Principal Repayment and Updating Distributions
6:07
38
Updating the CFW - Testing and Recap
3:50
39
Introduction to Automating Debt Sizing & Equity Calculations with Macros
5:25
40
Introducing the Debt Sizing Switch & Scheduling Repayment
5:21
41
Creating a Master Macro to Run All Macro's Once
9:36
42
Testing & Updating Scenario Manager
5:34
43
Setting up the Data Table for a Macro
4:05
44
Writing the Data Table Macro to Run All Cases AND Run Debt Sizing Macros
8:32
45
Performing Debt and Equity Analysis
4:20
46
Re-profiling Debt to Improve Equity Returns
5:37