Debt:
Loans &
Covenants
Course Length — 4 weeks
CPD Hours — 9
Course Level — Beginner - Intermediate
Mentoring — 3 months access to monthly group hot-seat call
Price — £597
Our Debt: Loans & Covenants course is your deep dive into the world of debt finance, equipping you with the skillset to model diverse loan terms effectively.
With expert guidance, we help you build various loan terms, create a leveraged cash flow, and craft models for Loan Covenants and Cure Accounts.
By the end of this course, you'll possess the skills to model, interpret, and negotiate complex debt terms, and sit our Debt Modelling Test.
Learning Objectives
By the time you’ve finished this course, you will be able to do the following with confidence.
- Learn how to use Excel, including key features such as functions, shortcuts, and error checking.
- Understand key debt fundamentals in property – term sheets, loan definitions, covenants and hedging.
- Understand and model different types of loans.
- Learn about financial covenants and how to model them.
- Be able to build a leveraged cash flow.
- Analyse leveraged returns
Other Extras
Along with the learning objectives listed above, you’ll also receive the following.
- Develop Excel Skills
- Understand and model different types of loans
- Develop Negotiation Skills
- 50 Excel Shortcuts
- Lifetime Access
Course Modules
Excel: Level Up 2.0
01
Summary
Study Time
Video Length
Course Level
1.5 Hours
36 Minutes
Beginner > Intermediate
What to Expect
Before we dive into debt and what it’s all about, we want to help advance your Excel skills. We will teach you functions, how to layer functions, use goal seek and more!
Chapters
- Formatting & Conditional Formatting
- Shortcuts
- Functions & Nested Functions
- Extra Features to Know about
- Reviewing & Troubleshooting
Debt: The Fundamentals
02
Summary
Study Time
Video Length
Course Level
0.5 Hours
11 Minutes
Beginner > Intermediate
What to Expect
This module will teach you the debt fundamentals. From understanding debt terms to different types of hedging, we’ll help turn you into property debt masters.
Chapters
- Understanding a Term Sheet
- Different Types of Loans
- Covenant Definitions
- Hedging
Debt: Set Up
03
Summary
Study Time
Video Length
Course Level
30 Minutes
4 Minutes
Beginner
What to Expect
Now that you understand the debt fundamentals, it’s time to lay out all the debt assumptions and set up the different loans so that they can be easily modelled. As Excel experts, we know that layout and formatting are a number one priority.
Chapters
- Debt Assumptions
- Loan Years
- Beginning and End of Period Balances
- Different types of Investors
- Understanding a Sales Brochure
- Understanding a Lease
- Understanding a Tenancy Schedule
Debt: Understanding and
Modelling Different Property Loans
04
Summary
Study Time
Video Length
Course Level
1 Hour
17 Minutes
Intermediate
What to Expect
The real fun starts now! It’s time to model the different types of loans. Step by step we will guide you through the process of modelling the different elements of a loan to create a leveraged cash flow.
Chapters
- Drawdowns
- Fees
- Interest
- Pre-payment, Repayment & Exit Fees
Financial Covenants
05
Summary
Study Time
Video Length
Course Level
1 Hour
17 Minutes
Intermediate
What to Expect
In this module, we will focus on understanding and modelling financial covenants. We’ll teach you how to quickly identify where you have breached a covenant and how to cure it.
Chapters
- Loan to Value (LTV)
- Interest Cover Ratio (ICR)
- Debt Service Cover Ratio(DSCR)
- Conditional Formatting
- Cure Account
Debt: Negotiations & Decision Making
06
Summary
Study Time
Video Length
Course Level
0.5 Hours
9 Minutes
Intermediate
What to Expect
In our final module, we will show you how to model the returns. We will compare different loan terms and how these terms impact returns. We’ll show you how each element impacts the returns and how you can use that during your negotiations.
Chapters
- Returns
- Negotiating and Analysing Returns
Assessment
07
Summary
Study Time
Video Length
Course Level
2 Hours
N/A
Intermediate
What to Expect
You’ve reached the end of the course and it’s time to see how well you have got on! In this assessment module, you’ll sit a multiple choice test and then model an investment loan.
Chapters
- Multiple Choice Assessment
- Debt Modelling Test
“I am always ready to learn although I do not always like being taught.”
