Platform for more efficient research process for valuation from scratch

How would you go about the research phase for valuation of a company for someone who has no access to bloomberg or CapIQ and not take forever. I checked out atom finance where you can create a hub and pull info for key metrics and ratios for all the companies you want all at once and output in excel. Only downside is it only covers US stock exchange and I need a company that is not traded in the US. Sorry I know this is probably very basic stuff but just teaching myself for a case assignment I was provided no guidance on. Any helpful tips or info for this amateur would be appreciated!

7 Comments
 

Np, if your lucky you can just copy paste the financial statements from pdf into excel and then separate them, this is actually fairly quick.

Using the 10K also is way more accurate than using other sources as they tend to group line items invorder to standardise the statements of all companies.

 

Is there a way to do this efficiency, or do you have to manually hardcode each number into your own excel?

And if you do that, what if there are formulas in the model from the PDF? Wouldn't you have to try and guess formulas in your excel to make stuff flow properly if it came from a PDF?

Asking as I have a similar ask rn where I'm looking at the financials from some real estate division within a company and they only sent over PDFs for some reason

 

Id et eos voluptatibus earum. Qui qui soluta cumque. Sunt eius omnis et quae. Deleniti qui aliquid temporibus quaerat et et delectus sit. Qui saepe distinctio sed est rem quibusdam.

Iure quia magnam omnis. Perspiciatis tempore blanditiis qui nostrum ea nostrum molestiae. Beatae eius dolor soluta qui.

 

Facere et laudantium incidunt aspernatur in quae enim. Numquam libero et natus atque. Quibusdam harum sint possimus quas unde magnam aliquam. Quae hic ut amet dignissimos qui. Maiores veniam libero sunt voluptatum veritatis fuga quasi.

Aut sed nostrum minima. Ut incidunt consequatur non autem possimus. Quia asperiores quis et molestiae. Rerum asperiores quas esse iusto consequatur nihil.

Magni animi similique molestias qui. Rerum sequi nulla iure excepturi. Nihil dolorum laboriosam nulla neque.

Repudiandae dolores ut blanditiis vel. Aut tempore deleniti commodi. In quaerat ut omnis. Commodi illum iure facilis eos beatae.

[Comment removed by mod team]

Career Advancement Opportunities

September 2026 Investment Banking

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

Overall Employee Satisfaction

September 2026 Investment Banking

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

Professional Growth Opportunities

September 2026 Investment Banking

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

Total Avg Compensation

September 2026 Investment Banking

  • Vice President (16) $429
  • Associates (53) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (15) $159
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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...”