Commercial Banking - Debt Modeling

This course covers the key components of building a debt model that is commonly used by commercial banks in assessing a borrower’s cash flows and performing covenant analysis. In this course, we will discuss the differences between operating finance (operating line of credit) and term lending (term loans). We will walk through the major components of a debt model including the yearly debt schedules, covenant analysis, monthly operating line analysis, as well as a quick overview of a risk rating model. By the end of this course, you should be able to construct a fully-linked debt model which entails the cash flow forecast of a borrower, its debt capacity, the impact of cash sweep, as well as any early warning signs of covenant breach.