Debt Comparables

Hello folks!

I have been shortlisted for an interview for a boutique investment banking firm and the company has assigned me a to build a debt comparables.

Does anyone has an Excel template to provide besides the standard model from mergereandacquisition website? Thank you.

Regards, Caleb

9 Comments
 

Are you looking for an automated template that pulls from Cap IQ so that it’ll be easier to do or are you more looking for a template so that you know what important information needs to be included?

"I know you think you understand what you thought I said but I'm not sure you realize that what you heard is not what I meant."
 

Sorry to throw a wrench at your busy schedules but if you do have a debt comps template (automated/non-automated), I would certainly appreciate it if you drop me an email @ retrieverimatgmaildotcom. I do have bloomberg access but not capiq

Thank you so much and have a wonderful day.

By the way, if you do come to Singapore, hit me up.

 

My apologies man, just seeing this today. The metrics outlined below by another user hit the major points though.

"I know you think you understand what you thought I said but I'm not sure you realize that what you heard is not what I meant."
 

It's alright redacted.

Okay I got the internship and I have one week to prepare to learn all the DCM techniques. Anyone knows of a good Bloomberg plugin that can extract all the important data needed for Bond Comps?

 
Most Helpful

Qui non blanditiis quis illum nulla aut est. Porro perferendis quasi nesciunt qui maxime quos porro eos.

Sed dignissimos facere quod sunt. Non nemo aut quas esse dolores. Cupiditate voluptatem enim vitae vitae nihil ut. Aut consequuntur temporibus iste aspernatur et.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (66) $101
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
BankonBanking's picture
BankonBanking
99.0
4
kanon's picture
kanon
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
numi's picture
numi
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...”