Saw a post like this about pitches, thought I'd ask it about modeling + building an initial fundamentals based understanding. Am a student so any color would really be appreciated.
| +47 | Do Quantamental roles really exist? | 23 | 9h |
| +18 | Worth Joining a Small Hedge Fund? | 13 | 2d |
| +17 | L/S Equity Career London | 11 | 1d |
| +12 | Hedge Fund (Fundamental Long Short Equity) Compensation in Singapore Hong Kong | 3 | 2d |
| +9 | Nvm | 6 | 1d |
| +8 | Yes, this question again… | 3 | 3d |
| +5 | Wfh / work remotely at MMs or SMs? | 2 | 7h |
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.
how to model if i had to do it over again?
dont
Ask ChatGPT.
Seriously. Create a project with a specific prompt sharing what your goal is and what you want to learn. I.e. you’re a PM at a L/S hedge fund and I’m a junior analyst looking to learn how to build detailed models of public companies. Help me iterate on my process to build highly detailed, logical models for different companies and gut check my assumptions.
Create a chat for each company you want to model and feed it SEC filings as a starting point. Then start asking questions to help build a model. Like “based on the Filings what metrics should I use to consistently model revenue”.
Once you create a draft, upload it into the chat and ask for feedback on drivers, logic, etc.
That makes sense and I've tried something similar, however I don't really even know where to start with building the model itself. By this I mean I don't even know what the model looks like, what physically goes where on the spreadsheet and things like that. Do you have any recs if I'm that much of a beginner?
Go learn how to build a basic 3 statement model on youtube. That is what most financial models are for L/S - now the tutorials on youtube will be very basic, but that’s a good starting point - it’s up to the analyst (you) to add granularity and detail e.g. revenue building from volume x pricing etc
The modeling itself is just corp finance, and that can be learned anywhere. There is no shortcut to learning other than repetition imo. That said, anyone can put together a 3 statement model (in fact this gets outsourced to asia or canalyst often).
The real "value" of the model comes from the layout + underlying assumptions.
1) Simplicity + cleanliness should always be prioritized. Streamline everything that can, and only focus on what matters. There should be as few inputs as possible that actually drive the model. That way, you know what KPI change = to Rev/EPS/FCF/etc.
2) This isn't super modeling specific, but being thoughtful about drivers and the build is the whole goal. Early on, don't borrow other people's numbers for coming up with things / the baseline. Its a muscle in your brain - having an independent, original opinion or perspective on the business, what drives it, etc. I liked learning from seeing other people's stuff, but its a bad habit to borrow other people's work when doing this work, especially if you haven't developed your own thinking yet. Training your brain to analyze things (not just process, repackage, condense, and sensitize), is the most important. If I tell you a business, you should immediately think about how the revenue and cost build should flow, not check out sell side models to see how they did it.
I'd probably buy one of these "Break into IB" courses that come with Excel templates that they ask you to complete.
Curious for a link to the original post on pitches that inspired this thread
Consequatur facilis ab sint quidem veritatis non. In non nulla repellendus rerum.
Repellat et sit incidunt expedita error eligendi. Veritatis culpa deserunt dolorem a omnis et unde. Deserunt quis dicta ad explicabo voluptas officiis. Nesciunt quisquam amet enim.
Eius voluptas non vel laboriosam. Beatae quo dolore adipisci et sit.
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...