Teaching myself to model

I’m currently a student at a small liberal arts school recruiting for IB and I want to teach myself how to model both to develop the skills and make a reasonable argument to people in the industry that, no I didn’t go to Wharton, but I’ve tried to remedy my educations shortcomings.

I have reasonable experience in excel and built a three statement model in my last internship, so I’m thinking I’ll try building a DCF from scratch. Any thoughts on resources/something to compare it to/a way to get feedback on the final output?

 
 

I liked watching RareLiquid DCFs, he has a ton of them on mega caps. You can try to follow along with one, and then maybe make your own from the template, inputting historicals changing all the assumptions etc, and then maybe try one from scratch on a company he did as well and compare at the end.

 
Most Helpful

If you're at a non-target your absolute best use of time is networking. You really do not need to learn to model. It's never going to come up in interviews, and if you proactively bring it up you are inviting much harder technical questions. No one cares that you don't go to Wharton, plenty of non-targets make it in but using your time wisely is a huge part of this.

I get you want to show your work ethic and be a self-starter, but this is just not a good use of time when you could send out a hundred or more intro emails in the time it'll take you.

 

Omnis sit omnis molestiae id enim nulla expedita. Labore similique omnis ut perspiciatis. Est voluptas molestiae illum eveniet et.

Rerum nostrum voluptatibus maxime ullam cupiditate aut. Quo est nobis dicta ab qui.

Iste ut voluptas doloremque ut dolor. Ipsum unde enim modi autem.

Career Advancement Opportunities

April 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 03 97.1%

Overall Employee Satisfaction

April 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

April 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

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (145) $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
Betsy Massar's picture
Betsy Massar
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
CompBanker's picture
CompBanker
98.9
6
GameTheory's picture
GameTheory
98.9
7
dosk17's picture
dosk17
98.9
8
kanon's picture
kanon
98.9
9
Jamoldo's picture
Jamoldo
98.8
10
DrApeman's picture
DrApeman
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...”