Models and Memos

Hi everyone,
Does your average analyst use templates while modeling or does the format come from your head. Also, how long are memos required to be (on average).You can name the length for any specific memo.

Finally, are they all written in a format which comes from the banks library? How much creativity will acutually go into writing a memo?

 
Best Response

Most models are already pre-built. Where people will expect you to grow your learning curve will be in the methodology of such and the complexity of the deals you'll be modeling. Each analysis, whether it be comps, LBO's or projections will have its own mechanisms.

Typically, an associate or more senior analyst will usually give you more insight into them, but most BB's expect you to know the types of models, their fundamental development, concepts etc., and a moderate degree of excel proficiency.

If you want to learn how to write a memo, google it. Remember brevity takes precedence regardless of the subject matter. Each bank may have its own style so try to get your hands on two or three to fall in line...

"Cut the burger into thirds, place it on the fries, roll one up homey..." - Epic Meal Time
 

I've been through dealmaven already, but it didn't seem all that great. Is there any other place I could get solid modeling practice?

 

Learning how to model really comes from on-the-job experience. If you don't have that, I recommend understanding the fundamentals of accounting / finance because at that point, modeling is just punching in numbers in Excel.

 

Most of the templates I was handed as a 1st year absolutely sucked in retrospect. They "worked" but were either sloppily thrown together or had gone through so many iterations that they were confusing as hell.

Once I learned the basic mechanics of everything, I took the time to build models from scratch. Now I've got a repertoire of just about anything I'd be asked to model, with clean formatting, good Excel hygiene, intuitive organization, etc.

And once you know your own model inside and out, making changes or additions should be fairly straightforward.

But that comes with time. I'm 2 1/2 years into the job....

 
  1. Majority of models are pre-built, but most analysts will go ahead and change the model to do what they need/like to do quicker, and make their own version of it.

  2. Internal approval memos can be anywhere from 3 to 30 pages long. It really depends on the deal.

  3. Short memos don't really require creativity too much creativity, just decent formatting and good comps. Long memos on the other hand require you to be creative about how you analyze data and materials.

 

I wouldn't say the majority of models are pre built. I think that any time something needs to be done extremely quickly (i.e., get me merger plans for company buying 2-3 different targets in an hour or two), then things are pre-built. Also, for the first 1/2 or so of yr 1, 75% of things will be prebuilt.

After that situations/assignments get so complicated that pre-built stuff rarely works, but it is ok b/c your skills have improved such that you can easily build your own sick models if you're good.

 

Exercitationem debitis molestias veritatis fuga nemo voluptas. Doloribus eum aut debitis repellendus. Molestiae est dolore dignissimos aut.

Iusto voluptatem cupiditate temporibus repudiandae inventore eius. Voluptatem quo sequi assumenda exercitationem sapiente et est. Dolorum enim non laboriosam illo enim sunt. Animi atque nostrum est ut et. Consequuntur sed amet necessitatibus ut et minus ut ea. Et rerum et neque nihil earum.

Deserunt impedit ut et aut laboriosam repellendus. Est laborum repudiandae cumque et qui assumenda error. Cumque quod impedit iure.

Esse qui sit deserunt doloremque sint velit. Eos placeat error asperiores quia explicabo. Sapiente consectetur aliquid aut qui.

Career Advancement Opportunities

May 2024 Investment Banking

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

Overall Employee Satisfaction

May 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

May 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

May 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (21) $373
  • Associates (91) $259
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (68) $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
Betsy Massar's picture
Betsy Massar
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
kanon's picture
kanon
98.9
7
CompBanker's picture
CompBanker
98.9
8
GameTheory's picture
GameTheory
98.9
9
numi's picture
numi
98.8
10
DrApeman's picture
DrApeman
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...”