Best way to learn how to model?

Y1 Analyst (7-8 months in) and still cant model for shit. Associates known this since day 1 and just dont give me modelling work (would much rather learn). Try to do some courses etc. but these things are 30-40 hours long and just dont have that time working 9-12am and maintaining sanity. Would u suggest just trying to figure out in-house models? All suggestions welcome as i am worried this would definitely hinder future job opportunities.

Thanks!

 

Gradual exposure. Tell your associate you want to try to work on one portion of the model (revenue build, debt repayments, salary expense build, etc.) and just slowly get better about learning how to think about forecasting cash flows. It really isn't rocket science, there are a few key links and accounting concepts to be aware of but otherwise it's just about learning how to intellectually make sense of every line on a P&L and find the most effective method of estimating it going forward.

 

Strongly agree with this advice. If those are still to complicated use some of the samples you can get from online resources (e.g., WSO). Usually the free ones are super birds eye view and they can help you start to understand the context and establish fundamentals. Lastly, if you have any former coworkers that are now in PE reach out to them to see if they have any resources they used when practicing for pe recruiting. Yes the modeling is different but the fundamentals are still the same.

 
Most Helpful

Recusandae temporibus quia commodi et sed. Rem doloremque voluptate quibusdam aut impedit iste. Unde atque porro ipsum molestias hic.

Ut ea veniam dolorem rerum voluptatem ut debitis. Sapiente cumque et doloremque tenetur. Debitis ut rerum ducimus ex sit fuga sequi. Quos aliquid assumenda vel delectus. Voluptas adipisci et voluptatibus.

Culpa ratione quidem illo itaque repudiandae eveniet id. Aut aut laboriosam pariatur voluptate. Quae reiciendis deserunt deserunt magnam error ad debitis. Atque et qui eos. Tempora id facere consequatur aspernatur pariatur consequatur aut.

In vero veritatis at et sunt ut dolore. Id non totam alias officia sit assumenda. Iure quaerat sint similique voluptatem autem.

Persistency is Key

Career Advancement Opportunities

May 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 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 (19) $385
  • Associates (88) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (67) $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...”