Back to Courses

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
  1. Formatting & Conditional Formatting
  2. Shortcuts
  3. Functions & Nested Functions
  4. Extra Features to Know about
  5. 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
  1. Understanding a Term Sheet
  2. Different Types of Loans
  3. Covenant Definitions
  4. 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
  1. Debt Assumptions
  2. Loan Years
  3. Beginning and End of Period Balances
  4. Different types of Investors
  5. Understanding a Sales Brochure
  6. Understanding a Lease
  7. 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
  1. Drawdowns
  2. Fees
  3. Interest
  4. 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
  1. Loan to Value (LTV)
  2. Interest Cover Ratio (ICR)
  3. Debt Service Cover Ratio(DSCR)
  4. Conditional Formatting
  5. 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
  1. Returns
  2. 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
  1. Multiple Choice Assessment
  2. Debt Modelling Test

“I am always ready to learn although I do not always like being taught.”

WINSTON CHURCHILL

Join The Waitlist

By clicking Sign Up you're confirming that you agree with our Terms and Conditions.
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.