How Do You Learn Financial Modeling W/O an I-Banking Internship?
(Senior Orangutan, 401
Points)
on 3/15/07 at 1:54am
How do you get financial modeling training if you are not going to be doing an i-banking summer internship but you still want to do i-banking fulltime. I am going to be on Wall Street this summer but just not in i-banking, how can I learn about this?





Divine intervention on the shitter
Divine intervention on the shitter
Take a class...
Take a class...
open excel.
open excel.
and then beat off?
no shit sherlock, but then what
Model This, Model That
I'd hit up yahoo or google and search out financial model examples and the like. There has to be some sample excel files floating around in cyber space. If that fails, check out a bookstore. Ideally, firms want to know you have some knowledge of modeling (you already have the job), but realistically, they will mold you into what kind of modeler (word?) they want.
DealMaven, WallStreetPrep,
DealMaven, WallStreetPrep, Damodaran's site (google it).
The first two cost money, but are worth it IMO.
Interview Guides
GMAT Tutors
WSO Resume Review
Benninga
There's a text book "Financial Modeling" by Simon Benninga which supposedly does a pretty good job.
I haven't found a single
I haven't found a single good book on Excel and financial modeling (may be time for me to write it). Along with the other book I want to write ("Too Blue for Banking: A Men's Fashion Guide to the Financial Services Industry"
book on excel and business modeling
Microsoft Excel Data Analysis and Business Modeling
by Wayne L. Winston ISBN:0735619018
Microsoft Press © 2004 (616 pages)
I have it as a e-book ( 35 MB.) If i able to upload it somewhere, I will provide a link...
You can always do DealMaven.
You can always do DealMaven.
Best Bet
While I'm not sure how necessary it is, if you really have your heart set on becoming conversant in modeling, have a patient friend who's already been working full time for a while (read: not a first year, if it can be helped) explain the basics of an integrated cash flow model to you and walk you through a template. If you've got a decent grasp of accounting, it's really not hard to understand the principles. If they were trained by a good training firm, then you could "borrow" their step-by-step modeling manual and template so you can play around with it, which would be ideal. Then buy said patient friend a beer. Or a shot, if they're an embittered third year analyst.
But anyway, all that will only get you familiar with modeling--you really won't understand it well until you've built one from scratch and gone barking mad trying to get your BS to balance for the first time. But hey, it's a start. Good luck.
<><><><><><><><><><><><><><>
Once more into the breach, dear friends.
Training the Street
Training the Street(I don't work there or get compensated for the plug).
Took their valuation and modeling courses. They have open enrollment in some cities. You'll learn a lot more in 2-4 days then you'll ever learn in school as far as real application to investment banking. The valuation course is essentially a template for technical interviews. Money!
Re: Training the Street
Training the Street(I don't work there or get compensated for the plug).
Took their valuation and modeling courses. They have open enrollment in some cities. You'll learn a lot more in 2-4 days then you'll ever learn in school as far as real application to investment banking. The valuation course is essentially a template for technical interviews. Money!
While I agree that TTS is the best, isn't it REALLY expensive to sit in on their courses and buy their materials?
Check out my WSO Blog
TTS
I was lucky enough to take it through my university, where they essentially subsidized the courses. It's $199 to buy an online subscription. I can't find the link for open enrollment or I would post it. Yeah it's not cheap. As far as technicals goes, my TTS valuation packet was invaluable to interviews. The class however, adds a lot of insight to the packet and interview Q's.
Is this just to train for
Is this just to train for interviews or what? I took a grand total of 2 accounting/finance related courses and talked to a 2nd year associate for about 2 hours on the phone. Aside from my very first technical interview, I feel that I did just as well as anyone could possibly do technical-wise. A lot of interviews I had they didn't even bother mentioning the technical stuff.
Are you bringing up your excel modelling/valuation skills in the interview and using that as a sell point if you are getting this in-depth knowledge before you even start? How are you using it to your advantage?
anon3333
Interviewers will steer the
But Do I-Banking Interviewers Expect You to Know How to Model?
"Like if you are doing a BB
Indeed.
<><><><><><><><><><><><><><>
Once more into the breach, dear friends.
I completely agree, having a
Re: How Do You Learn Financial Modeling W/O an I-Banking Interns
people
financial modeling
+SEO Career Program, Investment Banking
http://www.seo-usa.org/career/default.asp?page_id=99
+Excel 2007, Webcasts
http://www.microsoft.com/events/series/officesyste...
If you live in Chicago, Wall
Analyst Exchange?
kamilbas
Just on a side note, you
then other than the title of
Most good interns at my bank
Use the search function for
Re: Most good interns at my bank
Link?
WALL STREET PREP IS GOOD
There are programs out there
____________________________________________
Chase Us, Break In!
The Recruiting Ace: An Inside Look at Banking, Finance, and Management Consulting
RESUME AND COVER LETTER RE-WRITES
http://chasingconsultantsbreakingbankers.blogspot....
here are a few options
TTS 2 for 1 Deal (5 days - $2,500 each)
It means
How about the 'Breaking into
hello everyone, I would like