Files & Resources: breakingintowallstreet.com/kb/project-finance/debt-sculpting-vs-debt-sizing/ Table of Contents: 0:00 Introduction 1:09 Part 1: The TL;DW of Debt Sculpting and Sizing 3:07 Part 2: Simple Debt Sculpting Example 4:49 Part 3: DSCR-Based Debt Sizing 7:10 Part 4: LLCR-Based Debt Sizing 9:25 Part 5: VBA to Automate Debt Sizing and Avoid Circ Ref’s 17:24 Recap and Summary
Great video ! From my understanding, the only issue with VBA is that you can’t build sensitivity tables since they don’t run VBA code. Is that correct ? Do you know what is the alternative ?
That is a downside to VBA in models, but you can get around this issue by building the sensitivity table manually using VBA. It's not that complicated, but it does take more code than you might think because of the way VBA works (there are a few examples in our Project Finance course).
Files & Resources:
breakingintowallstreet.com/kb/project-finance/debt-sculpting-vs-debt-sizing/
Table of Contents:
0:00 Introduction
1:09 Part 1: The TL;DW of Debt Sculpting and Sizing
3:07 Part 2: Simple Debt Sculpting Example
4:49 Part 3: DSCR-Based Debt Sizing
7:10 Part 4: LLCR-Based Debt Sizing
9:25 Part 5: VBA to Automate Debt Sizing and Avoid Circ Ref’s
17:24 Recap and Summary
Best debt sizing video I have watched so far...
Thanks for watching!
Thank you, sir!
Thanks for watching!
Great video ! From my understanding, the only issue with VBA is that you can’t build sensitivity tables since they don’t run VBA code. Is that correct ? Do you know what is the alternative ?
That is a downside to VBA in models, but you can get around this issue by building the sensitivity table manually using VBA. It's not that complicated, but it does take more code than you might think because of the way VBA works (there are a few examples in our Project Finance course).
Awesome ❤
Thanks for watching!
V useful
Thanks for watching!