I am a relatively competent coder soon to be working at an agri-focused PE firm.
Already have TTS, but what are some good books teaching more complex financial modelling tools in Excel such as Monte Carlo, Black Scholes, etc...
Also, this is my first finance-type job. Do people just not use Excel for things like this?
| +83 | Cognitive decline | 27 | 2h |
| +54 | Vibe-Working in Finance with AI ? What about you | 34 | 4h |
| +49 | Del | 26 | 2d |
| +44 | PE VP: Thoughts on Quitting with Nothing Lined Up? | 12 | 2h |
| +18 | How do PE funds choose their advisors? | 8 | 7h |
| +18 | Acquisition Deal Structure: More Cash at Close vs. Smaller Equity Rollover in a Holdco | 3 | 3d |
| +17 | Is buyside worth it if most associate programs are 2 and out? | 4 | 3d |
| +13 | Management consulting or munis? | 6 | 3d |
| +13 | How Cooked is Software PE? | 1 | 1d |
| +12 | Indian PE Landscape | 2 | 10h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Depends what type of role you are entering.
If you're going in as an analyst, rule of thumb is to only use code if you absolutely must, otherwise don't. It just over-complicates models and there is a 99.99% chance that as soon as someone senior to you opens up the spreadsheet they will move some cells and fuck it all up anyway.
I am going in as an analyst and wholeheartedly agree with you regarding avoiding VBA.
This is more for my own personal development, than the role.
Financial Modeling Fourth Edition by Simon Benniga. Light on corp valuation but heavy on portfolio modeling, SML, black-scholes, monte carlo, derivatives, bonds etc. Includes a lot of VBA code and ready made models that you can tweak for personal use.
https://www.amazon.com/Financial-Modeling-Press-Simon-Benninga/dp/02620…
http://san.edu.mn/wp-content/uploads/2016/10/18.Financial-Modeling.pdf
PDF of the book posted above if you're not allowed to spread this stuff then can an admin delete
If you're a competent coder, run it through R or Python (how I run a lot of this type stuff, anyway)
then communicate it via Powerpoint...
Eum est distinctio dolore dolore. Occaecati repellendus dolorum ad sit. Quos ut modi atque est saepe.
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...