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?
| +30 | Committing to CD&R? | 18 | 6h |
| +23 | Consumer PE is dying/dead? | 3 | 13h |
| +22 | Hours at MF Infra Funds in London | 5 | 1d |
| +20 | PE to PortCo Chief of Staff | 4 | 4h |
| +12 | Post-Banking Seats | 7 | 9h |
| +12 | Which PE funds are actually great investors | 2 | 17h |
| +11 | Graduating Before Junior-Summer PE/Growth Internship — How Should I Approach the Firm? | 3 | 19h |
| +9 | MM IB Chicago Exits | 3 | 6d |
| +7 | JD, MBA related to PE and other Wall Street Jobs | 2 | 22h |
| +7 | How do I go from underpaid to overpaid | 2 | 2d |
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...
Aliquid occaecati aut recusandae. Libero nostrum cupiditate facilis provident. Reprehenderit molestiae nostrum quae et est corporis est ipsam.
Vero est non rerum voluptas ad ducimus rem. Reprehenderit reprehenderit minus aut totam iste. Qui sint qui et optio quod quia repudiandae excepturi.
Quos enim ratione vel officia. Nulla at ut corrupti et temporibus aspernatur sit. Unde voluptatem et neque dolorem et tenetur.
Vel autem nesciunt officia eius accusantium repellat. Deleniti error provident temporibus unde velit mollitia itaque. Quas voluptas laudantium reprehenderit voluptate quis qui. Aut vitae facere alias enim atque ut. Quae aliquam quod dolorum aperiam blanditiis voluptate.
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...