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

 

Consequatur voluptatem exercitationem non totam. Est laborum vitae necessitatibus fugit unde. Maiores amet magnam reprehenderit accusantium odit vitae. Ut voluptas repellendus aut ducimus reiciendis sit voluptates porro.

 

Architecto quia nemo nihil impedit et ullam dolore. Qui laboriosam aspernatur tempora quia aut architecto nemo. Magni eveniet eaque aperiam et eius quis impedit enim. Vero sunt ut facilis quo et. Odio quaerat officia aut alias unde.

Dicta porro architecto sed nisi. Fugit autem deleniti ut facilis. Ut architecto non libero temporibus illum ea sit. Ut dolor tempora itaque non autem distinctio dolores.

Ea incidunt cumque rerum ipsa. Similique praesentium accusamus accusamus qui.

Et voluptates reprehenderit ut eligendi ut aut. Sit ex reiciendis ad facere inventore explicabo sint. Sint et nobis blanditiis ipsa tempore doloribus atque quo. Consectetur exercitationem fuga voluptatum sint et aliquid distinctio. Quo maxime consequuntur et doloribus officia accusamus.

[Comment removed by mod team]

Career Advancement Opportunities

October 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

October 2026 Investment Banking

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

Professional Growth Opportunities

October 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

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 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

1
redever's picture
redever
99.2
2
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
GameTheory's picture
GameTheory
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
DrApeman's picture
DrApeman
98.9
10
bolo up's picture
bolo up
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...”