Analyst Modeling Test

Figured I would give back to the community. I have a modeling test I was recently given for a debt/equity shop that I am happy to share. PM me and I will send it over.

Comments (178)

5y 
MadmanM, what's your opinion? Comment below:

I PM'd

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy of the modeling test as well? thank you!

4mo 
yodizzle, what's your opinion? Comment below:

Do you have the test still?

5y 
third.comma, what's your opinion? Comment below:

Not trying to hijack this thread but I thought it would be a good chance for an exchange. I ended up trading excel tests with the OP. If any one has any excel tests I'd be happy to trade. I've got a test from a debt fund and a brokerage shop (HFF/JLL/Eastdil)

I had a flair for languages. But I soon discovered that what talks best is dollars, dinars, drachmas, rubles, rupees and pounds fucking sterling.
  • 2
4y 
want2bCRE, what's your opinion? Comment below:

Long shot, but the reward far outweighs the risk! Any chance you could send that that my way? Going into one of those shops and would greatly appreciate it.

3y 
dannydimes, what's your opinion? Comment below:

If you ended up being sent the test, could you send it my way? Thanks in advance

5y 
Bentley007, what's your opinion? Comment below:

Can you please send to me too?

5y 
Bentley007, what's your opinion? Comment below:

Can you please send to me too?

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy of the modeling test as well? thank you!

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy of the modeling test as well? thank you!

5y 
adrian-monk, what's your opinion? Comment below:

Anybody who received this, kind enough to send this me too, would be incredibly helpful, thank you!

3y 
dannydimes, what's your opinion? Comment below:

If you ended up being sent the test, could you send it my way? Thanks in advance

Best Response
5y 
ChangedMyName, what's your opinion? Comment below:

Im going to need a full time intern to tackle the amount of PMs I got.

  • 13
5y 
adrian-monk, what's your opinion? Comment below:

Hey man, you might have gotten a lot of pm's, sorry to bother you furthermore, but not able to pm you for some reason, would really appreciate this test though. Thank you!

5y 
MadmanM, what's your opinion? Comment below:

Well get to it! You're committed.

  • 1
5y 
OnlineMoniker, what's your opinion? Comment below:

lol can't believe you just said that

4y 
BBA18, what's your opinion? Comment below:

What are the exit ops and comp like? Asking for a friend.

I come from down in the valley, where mister when you're young, they bring you up to do like your daddy done

3y 
SamS15, what's your opinion? Comment below:

Hey I've reached my "allotted PM's" for the day, but as a rising undergrad senior who is looking to prepare for interviews I'd love if you could forward the modeling test to me! Thank you for your kindness!

3y 
CFN80, what's your opinion? Comment below:

If possible, I'd appreciate the test as well, I cannot PM you either

5y 
adrian-monk, what's your opinion? Comment below:

Hey man, cannot pm you for some reason, would really appreciate the test, thank you!

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy as well? thank you!

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy of the modeling test as well? thank you!

5y 
Sidney J. Weinberg, what's your opinion? Comment below:

To alleviate some of the burden on the OP, I can also send along the test if you PM me your email.

5y 
favorablegame, what's your opinion? Comment below:

Would you mind sharing with me as Well? Thanks!

5y 
Mowale-Ajose-Adeogun, what's your opinion? Comment below:

Please send to me as well. I'm unable to PM you right now

5y 
grahambo15, what's your opinion? Comment below:

Hello, would you be able to send me the model? Thank you!!

4y 
Jared-Maxey, what's your opinion? Comment below:

I just made an account so I can PM you. But I have to wait two days :(

4y 
LeveredLlama, what's your opinion? Comment below:

Hey would you mind sending it over to me as well?

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy as well? thank you!

1y 
FarmCat, what's your opinion? Comment below:

Hi - do you still have this test?

5y 
banker.chic95, what's your opinion? Comment below:

Would someone mind forwarding me this modeling test, as well? Thanks!

5y 
JoshuaRM, what's your opinion? Comment below:

I'm unable to PM the OP. Can anyone share the test with me?

5y 
DRBernieB, what's your opinion? Comment below:

Please share if possible

5y 
BasketballFinance, what's your opinion? Comment below:

Passed you a banana and about to PM you. Thank you x 10000.

5y 
Hnaeem, what's your opinion? Comment below:

PM - I have a similar interview coming up for an illiquid assets valuation role next week. Thanks!!

4y 
King Stannis, what's your opinion? Comment below:

If anyone is sharing excel tests, could I please have some? Thinking about applying as a debt brokerage analyst at a C&W/JLL type firm.

4y 
scshtx, what's your opinion? Comment below:

Since this is bumped up, can anyone share any excel tests with me? Or REFM/ULI? Have BIWS i can share

4y 
Matas Rascius, what's your opinion? Comment below:

Google Drive. Genius idea!

3y 
coakley_julianne, what's your opinion? Comment below:

Hi is it possible for you to share that with me

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy as well? thank you!

4y 
Pierogi Equities, what's your opinion? Comment below:

You sir are a gentleman and a scholar. Pm'd

Quant (ˈkwänt) n: An expert, someone who knows more and more about less and less until they know everything about nothing.

4y 
WSkiddo, what's your opinion? Comment below:

Pmed! Thanks for sharing!

4y 
alpgercek, what's your opinion? Comment below:

I am unable to PM to you. Would you mind sharing the tests with me as well? I would greatly appreciated! Thanks

4y 
Christopher-Tang1, what's your opinion? Comment below:

Pmed! thanks a lot for sharing!!!

4y 
t_mac86, what's your opinion? Comment below:

I have a modeling test to trade, if anyone is interested PM

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy as well? thank you!

4y 
chad21, what's your opinion? Comment below:

I have a test to trade as well - PM me

3y 
Zoon, what's your opinion? Comment below:

possible to get a copy of the modeling test as well? thank you!

4y 
WSO Monkey Bot, what's your opinion? Comment below:

Hey ChangedMyName, I'm the WSO Monkey Bot and I am sad to say, but this thread is lonely, so thought I'd post in here to try and help out. Some potential topics that might help:

More suggestions...

You're welcome.

4y 
zenoleen, what's your opinion? Comment below:

Please can someone forward it to me? Many thanks!

3y 
cowvun, what's your opinion? Comment below:

Can you forward me a copy of the modeling test as well?

Thank you in advance.

3y 
128, what's your opinion? Comment below:

Same for me! Would highly appreciate it!

3y 
mongjun, what's your opinion? Comment below:

Do you mind sending me one as well. Thanks!

3y 
TrojanFinanceGod, what's your opinion? Comment below:

Could you please send me the 5 exams too? Thanks so much!

3y 
Zoon, what's your opinion? Comment below:

Yes please! possible to get a copy of the tests as well? thank you!

3y 
Lorberto Larcos, what's your opinion? Comment below:

Hey , mind sending to me also ? Thanks!

3y 
William1974, what's your opinion? Comment below:

Would love it if you can send me one as well!

3y 
CRE-Monk, what's your opinion? Comment below:

Sent a PM! Would really appreciate it, thank you.

Array
  • Anonymous Monkey's picture
  • Anonymous Monkey
  • Rank: Chimp
3y 
Anonymous Monkey, what's your opinion? Comment below:

RIP HornsCRE Inbox

3y 
RE-PE, what's your opinion? Comment below:

PM'd you, thanks so much!

Real Estate Professional Network Discord Server: https://discord.gg/xxWQ2nC

3y 
alrisn87, what's your opinion? Comment below:

Pm'd Thanks!

Array
3y 
Real Grunt, what's your opinion? Comment below:

Looks like I'm one of the last few to the party. Can someone please send me the tests. Thanks!

3y 
stormedlloyd, what's your opinion? Comment below:

Could someone please send me the test too? Thank you so much!

Array
3y 
Wiggle369, what's your opinion? Comment below:

Could you please send over the exams to me as well? I have a modeling interview coming up and will be greatly appreciated.

3y 
Jab545, what's your opinion? Comment below:

Would appreciate if someone would send it to me as well. Thanks.

3y 
Wavvvy, what's your opinion? Comment below:

I would really appreciate it if someone could send me the test(s) as well. Thank you in advance!!

3y 
EBITWho, what's your opinion? Comment below:

Hey still sending it out?

3y 
dannydimes, what's your opinion? Comment below:

If you ended up being sent the test, could you send it my way? Thanks in advance

  • Investment Analyst in RE - Comm
3y 

Made a post about an "REPE Case Study Model Example". Let me know if this was helpful

https://www.wallstreetoasis.com/forums/repe-case-study-mf-model-example

3y 
Dils, what's your opinion? Comment below:

Can anyone send it to me too? Thanks!

2y 
cardinalbanker, what's your opinion? Comment below:

would also love to have this!

2y 
anniesun29, what's your opinion? Comment below:

Can you please share with me? Thanks!!

2y 
Steven-Ramzi, what's your opinion? Comment below:

is it possible to still get this modeling test please! and you very much

1y 
alvin17896, what's your opinion? Comment below:

Hi there, can I get a copy for it please.

Thank you 

1y 
Lutinppp, what's your opinion? Comment below:

PM'd thanks a lot!

1y 
drnorth22, what's your opinion? Comment below:

Earum perspiciatis pariatur magni doloribus est ut. Assumenda quis error doloribus illo aperiam. Sunt minus velit cumque ut corporis perferendis. Perspiciatis consequatur enim deserunt repudiandae. Vel asperiores deserunt amet aut odio repellat expedita. Aut voluptas tempore qui.

In quo velit ut et maxime itaque. Amet nostrum qui vero consectetur. Provident sit qui magni nobis necessitatibus ipsum. Nisi repellendus ratione aut.

Et exercitationem adipisci consectetur quo corrupti ab quos atque. Architecto qui nam veritatis doloribus sunt enim corrupti. Accusamus doloribus exercitationem dicta et.

Porro expedita rerum placeat dicta ullam illo. Quia quas dolorem voluptas. Pariatur at harum vero quia mollitia.

1y 
-nyc, what's your opinion? Comment below:

Molestias quasi rerum repellat magnam quidem quo. Qui molestiae maiores molestias est provident nobis. Quidem sint dolore quos voluptas quasi aliquam aut. Quia minima harum adipisci autem.

Sed eos exercitationem veniam. Et dolore officiis excepturi perspiciatis similique. Est vel aspernatur saepe excepturi provident.

Quia molestias aut quo temporibus deleniti. Fugiat aliquid dolor ab esse doloremque. Ullam est est blanditiis numquam. Maxime dolor deserunt autem facere et repellendus quae dicta. Rerum voluptate doloribus assumenda dicta tempora. Nihil mollitia hic qui sint sint cumque ut voluptatem.

Eum non cum animi ea vel eum. Quod nesciunt inventore laudantium hic iure.

  • NA in RE - Other
1y 

Assumenda fugit nostrum ipsam optio. Et voluptas quisquam laudantium. Omnis incidunt quos alias qui cum illum dolor. Dolorem velit esse id non qui. Laboriosam omnis sit quam dolore nulla animi velit. Vel eligendi est ex et.

Recusandae qui doloribus ipsam. In consectetur cumque modi veritatis accusantium veniam. Nostrum consequuntur aut optio reiciendis est similique. Nam aspernatur eum sunt accusantium magnam dolores inventore et. Ea minima quod placeat alias assumenda ea.

1y 
tracechoi, what's your opinion? Comment below:

Doloremque nihil minus assumenda porro fuga. Autem veniam qui maxime doloremque sint quo at. Sint rerum velit reiciendis. Harum ut qui iusto sunt et eos est. Asperiores et adipisci in ea. Aliquid voluptas in a omnis.

Rerum ea possimus expedita quos iusto fugiat non. Magni ab facilis nemo incidunt velit aliquid et. Ut fugit temporibus expedita ipsum veritatis alias. Itaque assumenda eos beatae eius doloremque est. Occaecati quia ut error id aperiam vel. Architecto ipsa mollitia laboriosam nam assumenda dolorem. Placeat autem iste ea officia alias.

[Comment removed by mod team]
1y 
mutleyfool, what's your opinion? Comment below:

Omnis assumenda enim rerum ipsa et. Consequuntur voluptatem voluptates dolor possimus. Ad ut sunt odit accusamus maiores quisquam. Officiis sit consequuntur ut quia laudantium id omnis. Id fuga laudantium dolor deleniti odit a necessitatibus minima. Ut aut facere numquam illum ullam animi doloribus unde.

Repellendus est veniam quaerat expedita. Aliquam necessitatibus voluptatem quod corrupti. Deserunt aperiam dolore magni necessitatibus. Aut impedit et dolores earum sit.

[Comment removed by mod team]
4mo 
skdj-isujd, what's your opinion? Comment below:

Repudiandae est sequi sed quod qui. Blanditiis vero iste dolorem repellat. Mollitia pariatur soluta quo assumenda eos. Numquam ipsum ullam aut facere blanditiis omnis quidem.

Aut quia eos debitis maiores. Voluptas et deserunt voluptates dolores vero neque aperiam. Voluptatem magnam consequatur sed hic. Sed natus id voluptatum praesentium corporis molestiae. Ipsa dolor officia ipsum.

Sint fugit est officiis et tenetur. Ad consequuntur mollitia ipsam itaque eius. Quia eos sequi corrupti quidem eos eveniet odit.

Accusamus molestiae corrupti qui sint debitis. Dolores repellendus blanditiis libero harum omnis. Numquam minima tempora eaque occaecati. Nemo tempore similique sed. Qui a in asperiores molestias consequatur.

[Comment removed by mod team]
  • Prospect in CorpFin
4mo 

Exercitationem omnis perferendis ut et. Beatae reiciendis porro aliquid ipsum expedita maiores ad corrupti. Voluptatem et inventore illum quasi aut ea rerum. Sit dignissimos consequatur numquam qui doloribus. Nulla minus sequi a mollitia maxime inventore molestiae aut. Dolor possimus dolores molestiae sapiente omnis quasi.

[Comment removed by mod team]
4mo 
yodizzle, what's your opinion? Comment below:

Culpa facilis totam esse sed facere. Mollitia non animi facilis sit voluptate esse consectetur non. Voluptatem sequi aut fuga doloribus commodi magni.

Natus cum tempore adipisci ipsum sed eaque necessitatibus saepe. Exercitationem eaque aut vitae eaque quas nisi. Ut autem quas sapiente accusamus laudantium iusto.

Ratione necessitatibus provident culpa repellendus sapiente veniam quo quasi. Quidem quasi neque non dolorum voluptas eveniet expedita dolores.

[Comment removed by mod team]
Start Discussion

Career Advancement Opportunities

March 2023 Investment Banking

  • Lazard Freres (+ +) 99.5%
  • Lincoln International (= =) 99.1%
  • Jefferies & Company (▽02) 98.6%
  • Financial Technology Partners (▽01) 98.2%
  • William Blair (▲10) 97.7%

Overall Employee Satisfaction

March 2023 Investment Banking

  • William Blair (▲04) 99.5%
  • Lincoln International (▲11) 99.1%
  • Canaccord Genuity (▲17) 98.6%
  • Stephens Inc (▲10) 98.1%
  • Financial Technology Partners (▲04) 97.7%

Professional Growth Opportunities

March 2023 Investment Banking

  • Financial Technology Partners (▲05) 99.5%
  • Lincoln International (▲01) 99.1%
  • Lazard Freres (▲14) 98.6%
  • Jefferies & Company (▽03) 98.1%
  • William Blair (▲02) 97.7%

Total Avg Compensation

March 2023 Investment Banking

  • Director/MD (6) $592
  • Vice President (27) $425
  • Associates (141) $260
  • 3rd+ Year Analyst (9) $194
  • 2nd Year Analyst (86) $170
  • 1st Year Analyst (264) $171
  • Intern/Summer Associate (45) $165
  • Intern/Summer Analyst (194) $92