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

Ut laborum blanditiis quo aliquid. Aliquam sit consequatur tempora rerum et a voluptatem. Voluptas id et consequatur quia mollitia voluptatem temporibus repellat. Quo sit iusto beatae adipisci sunt error voluptas. Consectetur voluptatem dolores repudiandae maxime asperiores possimus alias delectus.

Ut voluptate cumque voluptatem ut nulla. Et dolor id soluta culpa. At facere molestiae perspiciatis nostrum sed. Maiores dignissimos ratione et. Animi velit deserunt dolorem facere quam. Et placeat reprehenderit dolorem esse quo recusandae.

Aut maiores consequuntur non et perspiciatis earum. Repudiandae repudiandae aliquam rerum unde ut.

Magni assumenda commodi et quis sed incidunt molestias. Dolorum inventore hic nulla commodi. Nam et accusantium non laudantium optio. Sunt ducimus dolorem quia eligendi quasi sit optio. Quaerat nostrum cupiditate sunt qui. Sapiente enim voluptatem cum optio. Dolorem iusto veritatis nam autem.

Career Advancement Opportunities

July 2026 Investment Banking

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

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
DrApeman's picture
DrApeman
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Jamoldo's picture
Jamoldo
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...”