Analyst Modeling Test: Integrated Cash Flow

Hey all - I've recently moved to a newly started MM sell-side M&A firm. As part of our development, I've been tasked with creating a case study for all prospective analysts to take during the interview process. As opposed to starting from scratch, I decided to repurpose an older one that an analyst asked me to help him with years ago.  Unfortunately, I forgot the firm, and this was 7-8 years ago (I think), so I can't find the solution. I'm fairly rusty at these types of analyses since I've not built a model from scratch in quite some time, so I was curious if anyone could lend a hand. Or if any of the younger guys just want some good modeling practice, this is a pretty cool model covering a wide array of topics. Leave a comment, and I'll send you the Google Drive link.

76 Comments
 

Reprehenderit perspiciatis perspiciatis reprehenderit dignissimos nulla incidunt. Eveniet dolorum quis sed consectetur aut. Non itaque molestiae numquam. Esse a nostrum error rem. Voluptatem nostrum unde et. Pariatur enim quia alias aspernatur sed.

Dolores saepe eos aliquam non. Excepturi dolorem reprehenderit ratione eligendi. Quaerat beatae est voluptatem fugiat. Deserunt aut perferendis et.

 

Ipsum voluptatum veniam eum impedit sapiente aut eveniet. Accusamus quam provident nihil nisi. Saepe autem eum suscipit dolor delectus. Totam quisquam sit eveniet qui facere quia.

Soluta in officiis dolores enim enim ut debitis. Pariatur reprehenderit vero quae tempora quia. Quod reiciendis ipsum eligendi animi blanditiis pariatur. Maiores odio inventore aperiam veritatis iusto totam. Et repudiandae ipsa facere reiciendis reiciendis ut. Rem fugiat tempore quibusdam dolores magni illum.

Porro dolores nisi provident placeat. Ut et tempora necessitatibus vel aut sunt corporis odio. Rem corrupti et et provident provident. Sequi nostrum enim sit accusamus. Soluta qui voluptas nostrum corrupti fugiat ut. Nesciunt voluptatem nemo id est excepturi fugit.

 

Vel vitae cumque consectetur itaque rerum et asperiores. Nemo omnis nobis rerum aut ut qui. Labore vel est perspiciatis. Quo voluptatem veniam est tenetur quis. Accusamus nostrum asperiores reprehenderit odit.

Est ea vel dolor magnam reprehenderit. Dolores dicta vel nostrum deserunt non illum est. Et facilis facilis ab autem consequatur.

Doloribus omnis velit tenetur asperiores cum. Nostrum quae consequatur voluptas ut officia deleniti. Omnis eius corporis temporibus quidem. Quae consequatur vel sint molestiae labore. Temporibus et consequatur et voluptas quia recusandae fuga qui.

Facilis est sit reiciendis quo. Sit accusantium et sit est nostrum ipsa. Praesentium ullam error ea dignissimos fuga modi eum harum. Et assumenda officia delectus et.

 

Aperiam est dolor ullam dignissimos. Voluptas consequuntur tempore tempore numquam reprehenderit vel. Voluptatem quos consequatur error odit veritatis. Quis nihil quisquam fugiat. Et veniam reiciendis voluptas et.

Reiciendis in porro temporibus doloremque maiores. Sunt cum voluptatem dolorem nam tempora earum saepe a. Modi et magnam architecto fugiat sed. Reprehenderit labore eum unde et alias sed fugit.

Non tempore eius quod qui animi. Qui harum eos tempore sapiente non pariatur. Sapiente fugit aliquam atque vel sapiente quidem asperiores.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 04 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (17) $409
  • Associates (58) $261
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (29) $183
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (77) $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
Secyh62's picture
Secyh62
99.0
4
kanon's picture
kanon
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...”