Financial Modeling for Corporate Finance?
Hey guys, looking into breaking into corporate finance and was wondering what the best self study financial modeling program out there? I have solid excel skills but am a novice when it comes to financial modeling. Also, am a novice when it comes to VBA/macros.
I want to learn how to do financial valuations (ie DCF valuations), variance analysis, forecasting, and any other essential technical skills needed to become an financial analyst. I've heard mixed reviews regarding WallStreetPrep, and simon benninga's financial modeling book. Any advice regarding making this career transition would be great. Thanks..
Use the search function. Macabus and Damodaran are your best free resources online.
^^^ www.macabacus.com
I know you want to get ahead and learn a bit of modeling but a little advice from my personal experience is wait until you know exactly what you will be doing before you invest a lot of your time and money. The methods and procedures vary significantly from company to company and a lot of the things you learn may turn out to be useless and a waste of time. I tried to practice a lot of modeling (DCF's, valuation, etc) with sample models and macabacus before I started work and transitioning into corp fin but it didn't provide me the ROI I had hoped for. My advice for you would be to just get a high level understanding of what certain models do and are used for whilst starting off. Once you know exactly what you will be doing, learning a program/macro to tune your skills and boost efficiency would be super helpful.
However, with that said, I will say that it is still good to know these things and have a general high level understanding. One awesome thing was that doing all of this helped me brush up on my excel skills and learn a bunch of new tricks that served to be useful down the road.
It sounds you don't want to do CF. You're describing the type of modelling that's done in banking. It's very very rare to get hired at entry level into the internal strategy/M&A group of a large company. Other than that group, no other groups in CF do DCF modelling or any type of advanced valuation modelling. The finance skills you'd learn from WallStreetPrep are not relevant for entry level CF.
Agreed
You shouldn't need modeling for corporate finance
If you can show them your vlookup and pivot table skills (or just name drop them), they will be impressed.
corporate fin modelling at its finest haha. but seriously thats not a joke. its all ad hoc type modelling. not much is the same from experience to experience.
I work in corporate finance and the areas you mentioned (DCF valuations, variance analysis, forecasting) are a major part of my job so those are all worhwhile areas to gain knowledge in based on my experience.
It isn't discussed much here, but I'd consider the CMA if I were you. You don't need the 150 credits the CPA requires and it is directly relevant to most corporate finance and accounting type jobs. I finished the exams right before I started this job and it was a big help since it covers DCF, forecasting, WACC, basic accounting, etc. If you're going to invest the time studying anyway, might as well get a few letters after your name as a result.
I would agree with this (as well as a number of the other posters)....really depends on your job.
My job involves DCF/IRR, understanding lease accounting for project budgets, running our five year forecast, and valuations of targets (my desk is also the first one our Chief Strategy Officer comes to when needing anything quantitative, but I'm housed in the corporate finance function)
I've been working a lot on our capital structure recently, but our bankers handle all of our issuance structure runs.
a number of my colleagues can only name drop vlookups and pivot tables without actually knowing how to use them...
The book Investment Banking by Rosenbaum and Pearl is a worthwhile place to start before you start tapping away at practice models.
He is going into CF, not IB. That book is not going to be helpful or beneficial for him at this stage.
If you're still looking for a course it depends on your budget and area of corporate finance you're interested in.
The wall street prep course is good at around $500 (I forget the exact price), its comprehensive and it has videos to help you understand the content.
If you're interested in project finance modelling there aren't as many around and you'll need to look around a bit to find one. But the more standard modelling courses will still provide you with the basic modelling skills you will need for the area.
This is corporate finance we're talking about....don't bother paying money for these courses. Just learn shortcuts, basic formulas, etc.
Just a heads up to anyone hitting this old discussion: I put together a side by side comparison of the top financial modeling training courses here: http://www.wallstreetoasis.com/financial-modeling-training
Tempora doloremque voluptatem ut doloribus aut assumenda. Est aliquam ducimus quibusdam dolor fugit. Id culpa vero quidem deserunt. Ut voluptas a et corporis aut.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...