11/11/15

Hi Guys,

I am in third round equity research interviews and have to put together a 3 statement, dynamic, financial model that is capable of doing not only historicals obviously but projections.

Problem is, my group never uses these type of models. Does anyone have a template they could pm me (or ideally a complete model with formulas built in so I can see how it works/mechanics)? Interview is in the next couple days so I need some ASAP help.

Thanks

Comments (18)

11/11/15

You should check out the Macabacus tutorial on doing this --
https://www.macabacus.com/operating-model/introduc...

Hey, how's your art career going?

Financial Modeling

11/13/15

I have a model of Under Armour I could PM you, it is a rough model I did pretty quickly but should flow through with everything linked properly. let me know

Recent College Graduate

11/16/15

That would be awesome. Thank you. The one on macabacus is a monster. I am looking for a simplified one so your description sounds spot on.

1/7/16

Could you PM me as well? Thanks!

1/7/16

Would be also interested! Thank you so much!!

1/31/16

Would also be interested if you could PM too please.

1/31/16

Would also be interested if you don't mind please.

5/8/16

Would you mind sharing this model with me too? Thanks!

5/20/16

Hi Mate , Could you kindly PM the Model as well.

Appreciate your help :)

6/19/16

I would like a copy of that too sir, thanks!!!

1/11/17

Hello - I have an upcoming interview as well and will be tested on a 3 statement operating model. I am looking for something to get me up to speed before the interview. Can you PM as well?

2/18/17

Can you PM the model too boss ? appreciate you

2/28/17

Could you PM me as well? Thanks!

3/1/17

Could you PM me too, thanks!!

1/31/16

@NYRBlueshirts would you be able to PM as well? thank you so very much!!

2/28/17

As a general comment if you can't build a three statement model on your own in a timely manner you have no business getting anywhere near an ER job. Hope I never have to work with anyone looking to reformat someone elses model for a job interview, this is basic stuff.

3/1/17

An insane amount of sell-side ER teams will just fudge bits and pieces on the full model. Often times people won't even have a proper balance sheet. Still very much the case that people blindly look at short-term earnings and that's the end of it.

3/1/17
Add a Comment