Condensing Historic Company Data

Hey all - Im working on some of my own models and ran into a quick question. Do you look at the 10k/q and include every line in your model(s) or do you condense lines together to make the forecasting work a little easier? 

I've been working with inputting every line into my models, but those models can get quite tedious and nuanced when things arent condensed much 

4 Comments
 

They to condense lines together to make the forecasting work a little easier. Once you can figure it out and everything is formatted right, you can save a lot of time.

 

Thanks. Yeah, I've realized that the balance sheet in particular has a lot of misc items under assets & liabilities, so I'll condense those. When condensing the items though, do I need to adjust the cash flow statement lines to project everything out accurately ? 

 

Sapiente aut temporibus magnam quidem nihil ea saepe. Maxime ut in sit tenetur aliquam omnis. Dolores molestiae omnis voluptas ut praesentium aspernatur nihil non.

Career Advancement Opportunities

August 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.0%
  • Citadel Investment Group 97.0%
  • AQR Capital Management 96.0%
  • Magnetar Capital 95.0%

Overall Employee Satisfaction

August 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.0%
  • Citadel Investment Group 96.0%
  • Two Sigma Investments 94.9%

Professional Growth Opportunities

August 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.0%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.1%
  • Magnetar Capital 95.1%

Total Avg Compensation

August 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (11) $372
  • NA (9) $320
  • Engineer/Quant (83) $287
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (76) $193
  • Analysts (233) $178
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (276) $95
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
DrApeman's picture
DrApeman
98.9
7
GameTheory's picture
GameTheory
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
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...”