Breaking into WallStreet- Excel & Modeling Fundamentals or Advanced Fin. Modeling?

Hey guys.
I am a finance major at BYU and trying to prepare for i-banking interviews. I am taking my finance major classes and I have taken 3 accounting classes. I am going to purchase one of the breaking into wall street guides but I am trying to decide between the two guides:

  1. Excel & Modeling Fundamentals
  2. Advanced Fin. Modeling

I don't think that I am super knowledgable to any extent, but I just want to make sure that if I got Excel and Modeling Fundamentals that it would be too basic. Anyone recommend me which one to get?

Thx

 

I'm going through summer associate recruiting and I would say hold off until you actually have a job. No one is going to ask you an Excel question. I get that it's a valuable skill etc but your time and money are best spent on things to prepare for actual interviews. When you have an offer in your hand you can start worrying about prep.

Others feel free to disagree .

 
Best Response
Cartwright:
I'm going through summer associate recruiting and I would say hold off until you actually have a job. No one is going to ask you an Excel question. I get that it's a valuable skill etc but your time and money are best spent on things to prepare for actual interviews. When you have an offer in your hand you can start worrying about prep.

Others feel free to disagree .

Cartwright, I can understand where you are coming from but the program doesn't just cover Excel functionality. It goes into Accounting Fundamentals, How to put together quick and dirty Operating Models, DCFs, Merger Models, and LBOs... I did the program (and the Advanced as well) and I can say that I felt very prepared for interviews. Each module even goes over interactive answers to the most common technical questions, and how to answer them thoroughly and succinctly...

I highly recommend the program

 

Get the fundamental modeling, the advanced course is overkill.

Respectfully disagree with Cartwright.

True, interviews usually do not ask you for any detailed modeling / excel questions, but when the questions come up, you can be sure to know the basics, drivers, and even short-cuts after building a couple simple models. There's also some positive spillover effects into answering other questions, in understanding what the question is probing for and how the answer will be used in the overall valuation / transaction process.

Personally, the program tested my interest with IB. If you can't stand learning the details on how to model, then chances are you won't like the job.

Lastly, the price is reasonable. Sure, for a college kid $400 (I don't know what price it is nowadays) might seem a lot, but think of this as an investment in yourself, because the knowledge you receive can be used anytime, anywhere. Besides, compared to the $$ you make even as an analyst, it's just a drop in the bucket. You'll really regret it if you get a question and later found out it's been covered in the program. I know I did.

This sounds awfully like an ad, but the program really helped me (especially the networking guide). A much better purchase than blowing through bottles.

 
[Comment removed by mod team]
 

My only issue with BIWS is that the program thinks it can teach you concepts from nothing. I really don't think you can learn from 100% scratch (i.e. no clue what accounting or finance even is). The "explanations" of some of the fundamental concepts, e.g. basic accounting, TVM, are very high level.

However, hopefully most people have taken acct and fin 101, or at least have read through a good textbook. If you have done that and feel good about your acct and corp fin, then you should be fine, and it is a good program. Pretty time consuming, I'd say. The advanced course is a BEAST.

 

With regards to prepping for an interview, I strongly recommend that you download Damodaran's webcasts for Corporate Finance and Valuation (http://pages.stern.nyu.edu/~adamodar/). Just listen to the them on your IPOD on your way to class, you'll find them immensely helpful.

--------------------------------------- When you assume, you make an ass out of you... and only you.
 

Voluptatum nam in nihil fugiat quia dolorum sequi. Veniam qui est qui error. Quaerat recusandae quaerat rem. Quod quasi ipsam fuga quo voluptate at sed. Quia doloremque labore recusandae ut unde quisquam rerum ut. Et atque placeat et corporis sint.

Veritatis eveniet quia et vitae. Aut quos optio quidem voluptate eligendi sit qui. Dolor quia ut error vero aliquam quam.

Amet soluta voluptas alias et facere. Esse saepe dolor natus accusantium. Cum voluptatum voluptatem commodi corporis illum possimus dicta. Consequuntur est ratione ut accusantium omnis laboriosam omnis. Porro corrupti voluptatibus dignissimos sapiente ut. Assumenda velit maxime dolorem praesentium.

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 (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $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

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