Various Scenarios in Your Model

Happy New Year everyone.


I'm putting together a model as supplementary content for BB bank that I'm the process with. I'm currently building out my sales projection (for a HC sector company, non biotech/pharma) and a dilemma popped up. Should I have Base, Outperform, Underperform sales scenarios in my model?


The reason I ask is that I have several models from my internship that top ER analysts put together, and there are no different scenarios for sales projections. Just one. I'm thinking that these 4 analysts were confident in there projection and only felt the need to have one case. These models are also highly complex. One is for XOM and is a beast.


Do the models that you put together, or models you grab from SS analysts have various scenarios that you can alter?


I'm thinking that I should just throw it in there. However I'm going pretty granular and breaking it down by each product (this is a multi bn company) and dont want things to look cluttered. I guess I can just build it so it shows only the selected case at a time.


Appreciate the help / advice.

 

It impresses people more if you have clear understanding of the drivers of the business. Base / Bull / Bear cases are great, but only do that if you have confidence the assumptions that go into those cases make sense, because anything you put in your model is fair game during an interview. 

 

Yep that's kinda what I figured. Appreciate the feedback. I'm going to go with 3 different cases and have a thesis tailored to each product. 

What do you do for your models?

Your instagram is great btw

Go all the way
 

Asperiores et a quidem odit. Delectus deserunt qui qui voluptatum. Est vero molestiae nesciunt provident sequi.

Nulla est consequuntur incidunt est consequuntur corrupti eligendi. Enim omnis aut voluptatem et tempora voluptatem praesentium. Non in assumenda itaque dicta porro.

Ut numquam autem voluptate qui animi dolorum. Ut ut ad ullam consectetur. Amet eligendi quae quibusdam in impedit voluptas.

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
GameTheory's picture
GameTheory
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
kanon's picture
kanon
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
numi's picture
numi
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...”