ER Modeling questions

I'm in my second year of IB, but I am looking to switch to equity research. I was hoping someone could give me some advice and ideas on how modeling is different between the two.

For some of our startup clients, I've had to really dig into revenue drivers and other precise detail, but I usually had the management team to work with on those. In equity research, data is limited. Do you estimate revenues on a year-over-year % growth or do you have other methods?

Also, I am guessing that equity valuations are much more focused on P/E and EBITDA multiples rather than DCF, but I could be wrong. For DCF, if you do it, how would you estimate some of those rarer line items (e.g., assets held for syndication [think railcars, for example])? Those don't exactly follow trends, so I guess you could straight line if management doesn't give a forecast, but just wanted to see if anyone has other thoughts?

 

Sorry to digress but you're one of the only IB analysts I've ever heard focusing on moving to ER. What are the primary reasons it interests you vs. other exit options?

"If you want to succeed in this life, you need to understand that duty comes before rights and that responsibility precedes opportunity."
 

I work in a boutique, serving middle market clients. Don't get me wrong, I love meeting the management teams, doing the pitches and CIMs and whatnot, but all of the data room management and that kind of stuff is gruesome.

I'd like to get into Asset Management or equity research so that there is less of the "deal" work and more "pitch" work, if that makes sense. In particular, less reading legal docs, less scanning business docs, less data room management. More analysis, more research, , more pitches.

 

rarer line items ... recurring or one time? recurring then what drives the need for those line items try linking to them ... if it is one time, leave it .. if it is very small then it is insignificant, leave it .. yes you can also straight line it .. or take the average but don't anchor any cell just drag the average formula across, the average usually fluctuates like its historical numbers .. you can also keep a drop down option to change the line item's projection whenever u want

 
Best Response

I don't know much about IB modeling, but I have been working on my stock pitches. You probably want to use multiple valuation methods (so DCF and comp at least) and then triangulate your results based on your insights to arrive at a target price. Also if you have done bull / bear cases, then you should do that too and probability-weigh the fair value under your different scenarios and justify your weights.

According to James Valentine, who wrote the "best practice in equity research" book, you are better off focusing on the few items that drive the company's value and refine your assumptions on them, rather than being mechanical and do all the small adjustments that you can make, as they probably don't even make a big difference to the final firm value.

Search for "equity research" on this website, there were few industry veterans who wrote superb articles on this topic.

 

Do you estimate revenues on a year-over-year % growth or do you have other methods?

Usually driven by a detailed drivers tab, depending on the industry you come up with various metrics to forecast, i.e. users, billing, ARPU, etc.

Also, I am guessing that equity valuations are much more focused on P/E and EBITDA multiples rather than DCF, but I could be wrong. For DCF, if you do it, how would you estimate some of those rarer line items (e.g., assets held for syndication [think railcars, for example])? Those don't exactly follow trends, so I guess you could straight line if management doesn't give a forecast, but just wanted to see if anyone has other thoughts?

More mature companies are valued on P/E and EBITDA. Cash burn companies on ev/rev or a DCF. Sometimes the sell side will triangulate a multiple along with a DCF. For the rarer items you either keep it flat or make an assumption on a directional move.

 

Et laborum et vel molestiae optio reiciendis. Aut numquam error voluptatem aut officiis at. Sit eos non harum.

Qui accusamus voluptatem sequi saepe architecto. Et voluptas quia similique animi. Doloremque magnam amet eveniet magni voluptatem.

Ullam nisi maiores perferendis quibusdam ut voluptas aut quo. Qui porro ut nemo dolorum eveniet sed omnis omnis. Soluta fugiat necessitatibus et autem aliquam illo. Temporibus quia voluptatum consequatur adipisci. Dicta laudantium ratione qui inventore vero ducimus.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
kanon's picture
kanon
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
Jamoldo's picture
Jamoldo
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”