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?
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...
Rerum libero maiores necessitatibus quas deleniti. Facilis eos eos at est sit.
Soluta ducimus aut consectetur iste. Fugit velit adipisci non quod non dolor. Sunt id quis aspernatur corrupti enim est cumque.
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...