IB Model + Deck test with CapIQ?

Hello there,

I am interviewing with a boutique IB in Asia (think India, Singapore, China) for the Analyst role. I have ~2 years of experience in financial services. Next round of interview involves a model + deck test which will last ~12 hours and they will be providing CapIQ access for it (I get to do this from my home). What should I expect? Other companies here usually provide a set of high-level assumptions and that involves creating a model from scratch. Some companies also ask to create a model on public companies and they provide 2-3 days for that (yes, we have to hand spread/copy paste the historicals for that). What's the freaking point of CapIQ here? What are they planning to test me on?

Thanks for all the help!

Most Helpful

Model could be a combination of DCF and/or LBO (likely not LBO if India but be prepared in any case). It could be for a stock pitch or public to private transaction.

Capiq could be for any number of reasons - make WACC calc easier (and hence trading comps), help on transaction comps, cross check your numbers etc. (although beware! It’s not always 100%)

If they are giving you this much time and access, safe to say it’s a test of competence not efficiency. They are looking for a finished product that they can onboard quickly. Have your templates ready, allocate enough time for triple checking your work and be ready to talk about company, industry etc. Professional output matters…

Most western online materials available should be helpful here, (although debt schedules might work differently in Asia) but can try reaching out to former workers of that company and ask..


Ipsam excepturi doloribus tempora quae quia odio. Repellendus ullam cupiditate ad soluta repudiandae minus. Ut sint quo doloribus exercitationem sunt dicta blanditiis nihil.

Career Advancement Opportunities

March 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. (++) 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

March 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 11 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

March 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 06 97.7%
  • Lincoln International 04 97.1%

Total Avg Compensation

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (82) $263
  • 3rd+ Year Analyst (12) $184
  • Intern/Summer Associate (32) $172
  • 2nd Year Analyst (62) $169
  • 1st Year Analyst (194) $159
  • Intern/Summer Analyst (142) $101
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...”


From 10 rejections to 1 dream investment banking internship

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