Help - Need Transaction Data

Could someone help me out and point me in the right direction for finding a list of M&A transactions that have occurred in the last 5-10 years? I'm helping put together a large data set for a regression project and this would be a good place to start. I have access to most standard databases at school, and might be able to convince the boutique I'll be working for to let me use their Cap IQ account for this as well if it would be listed there.

Also, this data would need to be moved to excel, so if there is a database where that would allow the data to be extracted without manually transferring that would be ideal.

Thanks in advance to anyone that can help me out with this.

 
Best Response

What are you looking for? Every single M&A transaction worldwide over the past 10 years will result in a zillion deals, most of which will be nonsense with no deal stats (e.g. price paid, multilples, etc.).

Once you have what you are looking for, CapIQ is your best bet. You can put a number of filters and then output the results to Excel. Keep in mind, however, that the data reported for these deals is not standardized, so it will probably take a lot of scrubbing on your part to take the mess that is the initial output and turn it into intelligible, reliable data. A good set of transaction data takes a lot of effort (most of it mind numbing) to pull together.

 

Consequatur blanditiis quaerat tempora inventore eaque sint pariatur. Quidem numquam maxime modi error tempore eos odit. Voluptas blanditiis eligendi aut. Voluptas accusantium illo illo sed commodi qui beatae. Dolores vel ea modi vel quos beatae aut. Vel sequi harum animi veritatis qui expedita sint.

Quisquam accusamus enim ut aut. Perspiciatis perspiciatis eos architecto quaerat eveniet et doloremque cum.

Maiores rerum ut expedita ut velit repellat. Soluta omnis et quidem distinctio aut. Magnam expedita dolore asperiores et magnam necessitatibus occaecati eveniet. Sint odio ut nesciunt sed. Suscipit hic sit corporis est delectus.

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Lazard Freres No 98.8%
  • Goldman Sachs 18 98.3%
  • Harris Williams & Co. New 97.7%
  • JPMorgan Chase 04 97.1%

Overall Employee Satisfaction

May 2024 Investment Banking

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

Professional Growth Opportunities

May 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (20) $385
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $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

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