Course curriculum

    1. 0.1 Welcome to the Course!

    2. 0.2 Course Instructions

    3. 0.3 Best Practices Review

    4. 0.4 Excel Shortcuts Review

    5. Course Downloads

    1. 1.1 Refresh on Impact of Leverage

    2. 1.2 Effects of Leverage (Extended)

    3. 1.3 Scenarios and Sensitivities

    4. 1.4 Data Tables

    5. 1.5 Linear, Mortgage Style, and DSCR Sculpted Repayment Styles

    6. 1.6 Mini-Perms

    7. 1.7 Intro to Demo Models

    8. 1.8 DSCR Sculpting - Demo

    9. Chapter 1 Downloads

    1. 2.1 Optimizing Your Model

    2. 2.2 Optimization Part 1: Goal Seek - Demo

    3. 2.3 Optimization Part 2: Construction Funding - Demo

    4. Chapter 2 Downloads

    1. 3.1 Types of Credit Facilities

    2. 3.2 Recitals and Definitions

    3. 3.3 Reps and Warranties

    4. 3.4 Conditions Precedent

    5. 3.5 Covenants

    6. 3.6 The Waterfall

    7. 3.7 Events of Default and Remedies

    8. 3.8 Amendments, Waivers, and Consents

    9. Glossary of Terms

    1. 4.1 The Governing Case

    1. 5.1 Intro to Multiple Cashflows and DSCR

    2. 5.2 Cashflow Risk (Contracted vs Non-Contracted)

    3. 5.3 Multiple DSCRs

    4. 5.4 Intro to DSCRs Demo Model

    5. 5.5 Multiple DSCR Cashflows (Instructions) - Demo

    6. 5.6 Multiple DSCR Cashflows (Solution) - Demo

    7. 5.7 Min DSCR Requirement (Instructions) - Demo

    8. 5.8 Min DSCR Requirement (Solution) - Demo

    9. Chapter 5 Quiz 1

    10. 5.9 Blended DSCRs

    11. 5.10 Blended DSCR (Instructions) - Demo

    12. 5.11 Blended DSCR (Solution) - Demo

    13. Chapter 5 Quiz 2

    14. Chapter 5 Downloads

About this course

  • $450.00 first payment, $100.00 / year onwards
  • 90 lessons
  • 8.5 hours of video content