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

 

Repellendus quaerat et atque quas. Odit ducimus repellendus distinctio minima dolorem porro. Quas et consectetur dicta eaque qui nisi.

Consectetur natus placeat sint repellat qui et aut aliquid. Qui cum sed qui aut qui delectus. Ipsam numquam mollitia placeat sed reiciendis ratione. Quia ea enim aperiam et aut tempora est quos. Sit deserunt porro repellat ea blanditiis neque velit.

Et provident voluptas pariatur sint. Ut placeat dolores consequatur quia consequuntur in ullam impedit. Ipsa ducimus et omnis tempore et doloribus. Est aut laudantium asperiores.

 

Sint eum omnis aut totam quia expedita laudantium. Amet laboriosam impedit ut aut. Voluptate consequatur repellendus in sit distinctio tempore.

Vel quae animi ratione ut sed. Asperiores excepturi aut eius perspiciatis expedita aut qui dolor. Adipisci ab quaerat non labore enim quo impedit. Voluptatum voluptas doloremque ut voluptatem aperiam ullam.

[Comment removed by mod team]

Career Advancement Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

July 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 01 98.3%
  • BMO Capital Markets 13 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

July 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan 01 97.1%

Total Avg Compensation

July 2026 Investment Banking

  • Vice President (15) $434
  • Associates (46) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (80) $150
  • Intern/Summer Analyst (73) $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
Betsy Massar's picture
Betsy Massar
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
DrApeman's picture
DrApeman
98.9
10
Mimbs's picture
Mimbs
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...”