Monitoring loan covenants - making it convenient?

I am responsible for loan covenants monitoring and compliance for a portfolio company.
There are several loans and yet another is coming.
Loans are complex and number of various covenants is huge. Covenants are of all types:
- To do something by X date
- To do something every X months or every Xth date of each quarter/year
- To notify about certain events within X days whenever they happen
- To get bank's approvals for certain events whenever they happen

I was wondering how can it be organizied conveniently (so that I could follow the upcoming events and have history of past covenants successfully dealt with)

I mean, I can definitely do an Excel table in random form, but I am wondering, maybe you have some good template at hand and willing to share? Or maybe you know some piece of software that can be used to make things easier?

Thanks for suggestions.

 
Best Response

We use a pretty sophisticated covenant calendar in excel, however I would probably be scolded for sharing it, even though I made it. Just make your own in excel. It's easy and shouldn't take you that long.

Create a blank calendar and a sources section at the top. Have conditions set for each type of loan or "event" that needs to be addressed. I would also add in dates so that they automatically flow to the right areas. There won't be any complex equations as long as you know what is due. Just a lot of setting cells equal to and calculating off other cells that run from the source. You could also just put in a today() cell for the date, and have other cells change a color when the date warrants a notification.

It might take you awhile to make the first template, but it'll be worth it in the long run. One thing I've learned over the past 2 years is that it's much better/easier to create these sorts of things yourself.

 

This makes no sense to me. "create"? a blank calendar? does this mean do NOT use a template calendar? what does "a sources section at the top" mean? "Add in dates"? isn't that what the calendar is for? automatically flow to the "right areas"? what right areas? what does that mean? there won't be any complex formulas SO LONG AS??? so long as what? you know what is due? put in a () today cell for the date? what date? in what cell? in a calendar day? which day? where/when does the calendar come in to play?

why not just post YOUR covenant calendar so everyone can see the set up?

 

Ea et dolor sed velit corrupti doloribus. Temporibus non harum dolorem quia accusamus. Et voluptate est aut magni suscipit quidem omnis. Voluptas est et quis commodi temporibus. Est excepturi nulla dignissimos quasi ad voluptates.

Neque necessitatibus et laudantium omnis. Corrupti occaecati assumenda minus consequatur similique. Consectetur voluptates vitae officiis in.

Career Advancement Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Warburg Pincus 99.0%
  • Blackstone Group 98.4%
  • KKR (Kohlberg Kravis Roberts) 97.9%
  • Bain Capital 97.4%

Overall Employee Satisfaction

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Blackstone Group 98.9%
  • KKR (Kohlberg Kravis Roberts) 98.4%
  • Ardian 97.9%
  • Bain Capital 97.4%

Professional Growth Opportunities

March 2024 Private Equity

  • The Riverside Company 99.5%
  • Bain Capital 99.0%
  • Blackstone Group 98.4%
  • Warburg Pincus 97.9%
  • Starwood Capital Group 97.4%

Total Avg Compensation

March 2024 Private Equity

  • Principal (9) $653
  • Director/MD (21) $586
  • Vice President (92) $362
  • 3rd+ Year Associate (89) $280
  • 2nd Year Associate (204) $268
  • 1st Year Associate (386) $229
  • 3rd+ Year Analyst (28) $157
  • 2nd Year Analyst (83) $134
  • 1st Year Analyst (246) $122
  • Intern/Summer Associate (32) $82
  • Intern/Summer Analyst (313) $59
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
DrApeman's picture
DrApeman
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”