Modeling debt

Friends,

Which sources do you use to learn spreadsheet modeling of debt (senior, sub, revolver, LoC, Mezz etc) ?

And then computation of ratios - Fixed charge coverage, Debt-to-Total Capital, Interest Coverage etc and if the borrower is going to trip a covenant or not ?

Vix

Comments (2)

 
Nov 17, 2008 - 10:30pm

vikram_eda:
Friends,

Which sources do you use to learn spreadsheet modeling of debt (senior, sub, revolver, LoC, Mezz etc) ?

And then computation of ratios - Fixed charge coverage, Debt-to-Total Capital, Interest Coverage etc and if the borrower is going to trip a covenant or not ?

Vix

Hey Vix,

I'm not sure if there are any specific sources to teach you how to model debt but do you have any specific questions? for most debt securities it is pretty straight forward. Beginning balance less principal = ending balance, then caluclate the interest expense off of the average of the BOP balance and EOP balance.

Where it gets more complex is when you have PIK (Paid-in Kind) interest -- ie interest that is non-cash added to the debt balance -- or convertible securities and preferreds. You might want to try and get your hands on a template lbo model that has some of these securities built in so you can see how they are modeled and then try to recreate them on your own. For the revolver you need the full model to know what your cash need or surplus is after each period (basically it's a nested IF statement).

good luck,
Patrick

Start Discussion

Popular Content See all

Girlfriend vs PE
+89PEby Investment Analyst in Private Equity - Growth Equity">Investment Analyst in PE - Growth
I’ll never take WSO for granted again
+51OFFby Principal in Venture Capital">Principal in VC
What's so good about Evercore?
+41IBby Prospective Monkey in Investment Banking - Mergers and Acquisitions">Prospect in IB-M&A
I'm tired man
+30IBby Intern in Corporate Finance">Intern in CorpFin
First year analyst, still feel incompetent and like I haven’t learned anything
+24IBby 1st Year Analyst in Investment Banking - Mergers and Acquisitions">Analyst 1 in IB-M&A
Friends in IB are chilling hard, how can I get this?
+20IBby 3rd+ Year Associate in Private Equity - LBOs">Associate 3 in PE - LBOs

Total Avg Compensation

January 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (31) $349
  • Associates (141) $232
  • 3rd+ Year Analyst (18) $155
  • 2nd Year Analyst (87) $152
  • Intern/Summer Associate (90) $144
  • 1st Year Analyst (346) $134
  • Intern/Summer Analyst (298) $83

Leaderboard See all

1
LonLonMilk's picture
LonLonMilk
98.5
2
Jamoldo's picture
Jamoldo
98.4
3
Secyh62's picture
Secyh62
98.3
4
CompBanker's picture
CompBanker
97.9
5
redever's picture
redever
97.8
6
frgna's picture
frgna
97.6
7
NuckFuts's picture
NuckFuts
97.5
8
bolo up's picture
bolo up
97.5
9
Addinator's picture
Addinator
97.5
10
Edifice's picture
Edifice
97.5