Loan Covenants - On-demand

Loan Covenants - On-demand
CFI is a global provider of online financial training courses with a focus on practical applications. Most courses involve hands on Excel tutorials, which take participants beyond the theory to develop job-based skills. All participants are automatically issued certificates of completion after successfully finishing each course. The price of the course varies and are based on a function of a few criteria including, (1) their duration (CPD hours), (2) level of difficulty, and (3) demand for the topic.


In this Loan Covenants course, we will demonstrate how the loan covenants are used in the lending process. We will start this course by defining covenants and discussing how they benefit both the lender and the borrower. We will then compare different types of covenants and discuss what a credit analyst should do in the event of a covenant breach.

After that, we will discuss key financial covenant ratios such as total liabilities to equity ratio (debt to equity), debt service coverage ratio (DSCR), working capital ratio, and debt to EBITDA ratio. We will explain what these ratios are, how to calculate them, and how they are used in evaluating a company's creditworthiness. Finally, we will complete a case study where you need to build a covenant model in Excel. We will calculate a company's key credit metrics based on the historical and forecast financial statements. We will compare these metrics to the covenants that are set for this business and are suitable for the loan.

    Upon completing this course, you will be able to: 

    • Understand the key concepts of covenants in a loan agreement
    • Explain different types of loan covenants
    • Calculate key financial covenant metrics
    • Use a financial model in Excel to model financial covenants

      ½ Passport Day - 3 PD Hours

      4/1/2021 - 3/31/2022