Modeling Test - Quarterly

nofunleague's picture
Rank: Baboon | banana points 108

Hi Guys,

I have an upcoming modeling test in person at a well known sell side firm for research. I've done the WSP models and CFA 1 but have never done model with quarterly projections/data. Can someone advise how the modeling tests are generally set up and how to model quarterly?


Comments (11)

Dec 20, 2018

What sector?

Dec 20, 2018


Dec 20, 2018

Did they specifically say you'd have to do a quarterly model? Most of the research interviews I've had in the past with modeling test generally only wanted annual.

In any event, it's not all that different except certain things you'd be forecasting y/y whereas others are q/q. Hard to answer without knowing the sector.

Dec 20, 2018

They didn't state it would be quarterly. They just said it would be an inperson modeling test and writing test lasting around 2 hours. I have access to their research and I see that some companies they valued by P/E comparables and other multiples and other's DCF. Any advice how to prepare or what to expect?

Dec 20, 2018

In that case, I'd recommend prepping by getting the earnings release for some companies they cover and time yourself in basically quickly analyzing the release and being able to draft a one page, 3-5 bullet first take / flash note. You have to be able to do this within 1 hour - do it before you read the actual first reads they put out and then compare your work. After you go through about 3 earnings releases you'll either be ready or you'll realize there just wasn't enough time for you to prep.

For the models, if you've done any kind of prep package you should be good enough. Since you know what kind of valuation methodologies they use for their current coverage just memorize the key things you need (e.g. if valuing off 2020 earnings with P/E, be sure to note it's a YE19 PT and such). This assumes you can slap together a quickie 3-stmt model of course. I won't say it's impossible for them to require quarterlies, but as noted previously by myself and other posters, it just comes down to whether there's any obvious seasonality in the historicals.

    • 3
Learn More

Side-by-side comparison of top modeling training courses + exclusive discount through WSO here.

Dec 20, 2018

So the earnings release update what that be only a quick summary of what happened or would I have to update the model? For example update the EPS for the quarter and remaining quarters in the year, which would base a P/E valuation? Would I have the information on the consensus expectations? That's really my main concern as in the prep packages it was only annual DCF. A 2 hr test seems like it would be extensive, I'm concerned about having to build out a model from scratch.

Most Helpful
Dec 20, 2018

First off, you will have everything you need. Consensus figures, 'house estimates' of any, press release, etc. I've worked for some fairly psychotic people over the years and even they all provided this to prospective hires.

From what I can gather, it seems you don't have any work experience in this field, which is fine, but you're going to have to do a bit of extra leg work - e.g. not knowing what a first read note is.

I described above in multiple ways because every firm calls it something different, but it's basically as you say, a note that talks through the main things that happened in a quarter. Every analyst is pretty delusional in thinking their note adds any value if they're not literally first to publish. The first bullet is always something about adjusted EPS/EBITDA vs consensus. Here you will literally say, company XX delivered EPS of YY, vs cons. of ZZ. The main drivers were a beat/miss on XYZ. Second through fourth bullet (depending on size of note) talk about whatever nonsense management is peddling and other interesting stuff. Could be volumes, operating leverage, margins, Trump, anything. This is your opportunity as an analyst to add value by noticing interesting stuff or calling out oddities. 95% of the time, there isn't anything interesting. Your last bullet in the business will always be some rehashing of your thesis like "this reinforces our buy/sell rating for all the aforementioned reasons" (note: regardless of how good/bad a quarter is, you always claim victory because you're a sell side monkey). And you provide the dial information (time, phone number, conference code).

As for your modeling test, they may have you update one of their models for a quarter by giving you an incomplete model and a press release - the name of the game is accuracy. Your forecasts aren't worth squat to them because you seem fairly green. Make absolutely sure your EPS and/or Adj EPS ties out to what is reported. This is an auto ding if you fuck it up (as are any other important metrics like revenue or CFO). Be fast, methodical, and don't fuck up.

They can also make you build a model from scratch. This seems less likely based on my evaluation ofyou as someone with relatively little experience, but to prep, you should build from scratch a 3 stmt model and make sure your B/S and C/F tie out and that your I/S stuff is flowing properly into the C/F. Sky's the limit here in terms of variability - I've seen kids have to build two models and then a merger overlay after we reviewed the two models; dummy models with dummy information and you having to be able to do some quick and dirty analysis on what the trends mean; normal modeling with real companies; literally anything. Since you seem junior, just make sure your shit ties out and your numbers are accurate agains the source material provided - again, your forecasts don't really matter so long as they're not wildly stupid.

    • 4
Dec 20, 2018

Thanks for all your tips! With regards to the first read note, I noticed the press release mentions to consult the 10-Q for more info. Generally some press releases are more high level and don't have an abundance of info. In this case, from my understanding the 10-Q would have a lot more especially management commentary, sector/geography breakdown etc. Just wondering if that would be something that I would be given?


Dec 20, 2018

There's really no difference at all unless they state in the test that they want you to adjust the financials for seasonality... and that really depends on sector (ex. ski resorts are going to have stronger revenues and less CAPEX Q4 and Q1 results than Q2 and Q3).