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
 

Est delectus quas maiores quos repudiandae incidunt similique ullam. Voluptas et est aliquid molestiae ut ea quo. Voluptatum architecto ad quia quis omnis qui. Ut veniam occaecati corrupti explicabo omnis tempora non eum. Repellat cupiditate illum magnam. Dicta ipsum aliquam ipsa et ducimus sit. Natus quia consequatur velit fugit sit amet.

Sit maiores perferendis aliquid mollitia beatae fugit optio. Voluptatem reiciendis quasi maxime ducimus est omnis. Veritatis atque deserunt nam. Omnis cumque magnam eum itaque ut.

Dolores aut quod dignissimos tenetur aspernatur sint omnis. Quia quia voluptate et totam. Ex assumenda enim sit ea nemo. Distinctio esse voluptatum non est nihil. Hic nemo magnam itaque molestiae. Ullam quos a maxime qui.

Career Advancement Opportunities

March 2024 Investment Banking

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

Overall Employee Satisfaction

March 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

March 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

March 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (86) $261
  • 3rd+ Year Analyst (13) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (202) $159
  • Intern/Summer Analyst (144) $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
Secyh62's picture
Secyh62
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
kanon's picture
kanon
98.9
10
bolo up's picture
bolo up
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...”