Anyone using AI for their modeling?
Curious if anyone is using AI for their financial modeling and in what capacity?
Thanks!
Trending Content - Private Equity Forum
Career Resources
As a former programmer in IB, no. financial modeling is meant to be auditable and reproducible by peers, superiors, 3rd parties, etc. and AI is generally a black box - the exact opposite of that.
I have heard that programming (not even AI, just like number crunching in python or something) is becoming more slowly more common at l/s hedge funds, but even then it doesn't replace core financial modeling in excel (is at most a way to supplement and confirm an existing thesis). And you'd probably need a really forward thinking and technical PM to not tell you to fck off when you propose to pull out python for anything
Helpful - couldn't you use it to help your modeling though? e.g., debug or do the more mundane things (e.g., copy paste)?
I use it all the time for answering questions about how to structure things out. It's great for questions, but never for building out the entire model. If I'm trying to get my balance sheet to balance, for example, and it's just not, then I will go through each assumption and ask where it go wrong, and it helps me debug, like having another Associate next door that I chat with for some help. I'd love to see something where I put in my assumptions and it kicks out an actual excel, though, that would be sick.
What platform are you using for this?
Vanilla ChatGPT.
I disagree with above. LLM can generate VBA codes, and Excel is essentially a human-friendly UI on top of bunch of unreadable, hard-to-comprehend VBA code. So this is how it will work: LLM generate VBA code based on natural language prompts, than Excel converts VBA code into human-readable format ( traditional financial models - tabular UI with math formulas ), then human do adjustments such as fixing inappropriate stuff generated by AI blackbox, then the LLM in the background utilized reinforcement learning to reflect on real-time human feedback ( which is the adjustment that human made to the model ) such that LLM won't fall for the same mistake twice, and it will only get better the next time. This entire thing hasn't been built yet but it's theoretically possible, and there's a start-up doing this stuff.
That is fair - but the pain of fixing one imperfect model is greater than building three models from scratch.
Adjustments can be done in natural language as well, so you may never need to get your hands dirty on excel stuff. Imagine you are the VP who leads a deal. Which one are you a going to choose: 1. Build all models from scratch by yourself because you're so good at it. 2. Throw model work to empty-headed analysts and assos and provide one thousand comments when they do a lousy job. 1 is more efficient, but all VPs choose 2 lol. Because it just feel so fucking good to not do anything from scratch and be the one who sits back and judges other people's work lol. It's human nature.
What's the startup? Curious to check them out
Magnam qui voluptatem nam at repellendus. Libero necessitatibus et neque consectetur animi est. Fugit repellendus est aperiam illo maxime. Dignissimos omnis ex voluptas quasi.
Architecto nostrum ipsa voluptatem laboriosam. Nisi doloribus dolore reiciendis et. Nesciunt repudiandae ipsum voluptates voluptas consequuntur. Voluptatem aut corporis commodi qui.
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...