fbpx
Free preview

Overview

Commercial Banking – Debt Modeling course overview

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.

 

Operating line of credit and term loan

 

Commercial Banking – Debt Modeling learning objectives

  • Upon completing this course, you will be able to:
  • Differentiate between operating finance (operating line of credit) and term lending (term loans)
  • Understand the benefits of using different types of credit facilities
  • Build a yearly debt schedules laying out the different types of debt drawn, the interest expense, and the principal repayments
  • Perform covenant analysis to identify early warning signs and possibilities of breach
  • Construct a monthly operating line analysis to determine the operating line drawn and amount available based on margining
  • Understand how the amount of leverage could impact a company’s risk rating

 

Covenant analysis

 

Commercial Banking – Debt Modeling is an elective course of CFI’s CBCA® program

CFI’s Certified Banking & Credit Analyst (CBCA)® Program offers skills including credit evaluation, documentation, and review procedures. For beginners to advanced users, the CBCA® program is designed to help you become a world-class credit analyst.

 

Risk rating model

 

Who should take this CBCA® course?

This Commercial Banking – Debt Modeling course is perfect for any aspiring credit analysts working in insurance, underwriting, rating agencies, commercial lending, corporate credit analysis, and other areas of credit evaluation. It is also a great elective course for anyone who would like to learn more about how commercial banks forecast debt capacity and cash flows of the borrowers.

 

Debt model components

Commercial Banking - Debt Modeling

Get Started

Level 4

Approx 4.5h to complete

100% online and self-paced

Subscribe to get access to CBCA and other programs

From $497/year

Learn More

What you'll learn

Lesson
Multimedia
Exams
Files

Become a certified Commercial Banking & Credit Analyst (CBCA)™ Certification

Commercial Banking – Debt Modeling is part of the Commercial Banking & Credit Analyst (CBCA)™ certification, which includes 40 courses.

Commercial Banking & Credit Analyst (CBCA)™ Certification
  • Skills Learned Financial Analysis, Credit Structuring, Risk Management
  • Career Prep Commercial Banking, Credit Analyst, Private Lending

Path to certification

Prep courses

7 courses from beginner to intermediate level.

01 Optional

Core courses

16 courses from beginner to intermediate level.

02 Required

Elective courses

17 courses in advanced and intermediate levels.

03 Required

Get certified

Submit your CBCA™ checklist and order your certificate.

04 Required

Join our community

Get access to the Global Corporate Finance Society.

05 Optional

How the certification works

Commercial Banking & Credit Analyst (CBCA)™ courses are offered 100% online, allowing you the flexibility to start the Commercial Banking & Credit Analyst (CBCA)™ program anytime and learn when it’s most convenient for you.

The program is a part of the All Access Subscription, which includes all programs and courses.

CFI courses are designed by instructors with over 21 years of financial analyst training experience.

Students must complete all core and elective courses (18 in total) and demonstrate mastery of the topics through successful completion of course materials, quizzes, and assessments.
Within 48 hours of program completion, your Blockchain Verified (CBCA)™ Certification will be emailed to you.

What our students say

A Very Tough Course - Need to Have Good Excel Chops
By far, the toughest course in the whole CBCA Program - But glad I Did it

Davin Mac Ananey

Assessment sheet is not correct
Please check calculations.

Arvind Kumar

Chileshe
Amazing course. I highly recommend it

CHILESHE KELVIN

Debt Modelling
Excellent content and case study and excellent presentation. CFI needs to add Working capital assessment methods and apportioning the Assessed Bank Finance into fund based and non-fund based credit facilities, show how the Letter of credit and bank guarantee operates internationally to the CBCA programme to make it complete.

venugopal rajamanuri

See more

Frequently asked questions

Can I download the Excel files and financial modeling templates for the course?
Absolutely! All the files and templates needed in a course are available for download. Just look for a module that shows Downloadable Files within the course dashboard. See here for a visual guide on how to do this.
How long do I have to complete the courses?
Depending on your enrollment type, you will either have two years, yearly, or monthly access to your courses. All the courses are self-paced as well so you can take your time in learning without worrying about any deadlines. Click here to compare our available enrollment options.
Are CFI courses officially accredited?
CFI is accredited by the Better Business Bureau® (BBB) to maintain training standards, and by the CPA Institutions in Canada, and the National Association of State Boards of Accountancy (NASBA) in the USA. Most of our courses qualify for verified CPE credits for CPA charter holders. Please refer to this page to view all available CPE credits.
Are there any additional fees or costs?
No! The bundle price includes everything and there are no additional fees or charges to earn your digital certification. You can see our enrollment fees listed here.
What currency are your courses priced in?
All our online courses are priced in USD. We accept debit/credit cards (Visa, Mastercard, Amex), PayPal, and wire transfers for one-time course payments. If you wish to proceed with a wire transfer from your bank, please see instructions here.
How do I earn my certificates?
Students must complete all the video lessons, quizzes, and final assessments in each course. You can retake the assessments as many times as necessary until you reach an 80% passing grade. For more information on how to earn a course certificate, click HERE.
Will these courses help me advance my career?
Based on hundreds of reviews from thousands of students we know how CFI courses have helped so many people advance their finance careers. Our courses are designed to be extremely practical and simulate the experience of being trained as a professional financial analyst…the ultimate way to advance your career. For real-world examples and help delve even deeper into the course concepts, please look into our free career resources library.
Can I email the instructor if I have questions?
While the courses are designed mainly for self-study, we are happy to provide email assistance for general or technical support inquiries. The Full Immersion bundles include a premium email support function which allows you to communicate directly with in-house experts regarding course content. This is one of the key features that sets the Full Immersion bundle apart and makes it a worthwhile upgrade over the more affordable self-study bundle. You can compare more features in our bundles here.
What is the price of the subscription?
All Access Subscription is priced for $497 per year as Self-Study plan or $897 per year as Full Immersion plan.
What is included in the subscription?
All Access Subscription includes all courses from Financial Modeling & Valuation Analyst (FMVA)® Certification, Commercial Banking & Credit Analyst (CBCA)™ Certification, Capital Markets & Securities Analyst (CMSA)® Certification, Business Intelligence & Data Analyst (BIDA)™ Certification, Commercial Real Estate Finance Specialization and Environmental, Social & Governance (ESG) Specialization.
More Questions?
Please Email us and we'll be happy to answer any of your questions!
0 search results for ‘