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."
 

An automated template would be good. But I am currently using bloomberg. And yes, I do wish to know what is important. Thank you! :)

My interview is tommorow so I am kinda desperate.

 

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

Officiis deserunt enim ad tempora nesciunt et. Maiores perspiciatis a in et veniam. Sunt repudiandae culpa ratione natus fugiat cum quibusdam dolor.

Officia ipsum occaecati neque a velit. Et cumque sint est dolorem. Aut velit dolor est doloremque. Voluptas sunt eos qui blanditiis. Et velit tempore qui natus. Optio illo ipsum exercitationem explicabo culpa possimus quod.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.4%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.3%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.4%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.3%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.4%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.3%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (48) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (83) $151
  • Intern/Summer Analyst (75) $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
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Linda Abraham's picture
Linda Abraham
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...”