Currently in the interview process for an analyst position within JLL's capital markets group. There was mention of an excel test during a conversation. Does anyone here have any insight on what the format or structure of the test is? I am trying to best prepare myself and any help would be greatly appreciated.
| +82 | LP coming into deal at higher land basis. How to model returns to GP? | 18 | 1d | |
| +76 | Increasing RE Industry's Cash Compensation, Collectively | 43 | 22h | |
| +73 | Major Decisions | 13 | 1d | |
| +28 | Niche down to an operator or stay an allocator | 10 | 1m | |
| +24 | Breaking into CRE late 20s | 7 | 4d | |
| +23 | Thoughts on joining an early-stage REPE fund | 7 | 21h | |
| +22 | Self Storage ECRI | 9 | 3d | |
| +20 | Doom Loop or Creative Urban Reemergence? | 3 | 6d | |
| +19 | How to get good at RE Modelling? | 16 | 11h | |
| +18 | 3 Hour Condo/Rental Excel Test - What Can Be Expected | 2 | 4d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
Dm me
Still willing to talk about this? PM didn't work.
Did you take the test and if so can you share what was in it?
I took it a couple years ago, but thought they discontinued it. Just know basic real estate fundamentals and excel calculations. I had to build a very basic cash flow model, which they had all assumptions given, show returns: UIRR, IRR, EM, and add a sensitivity analysis. Also know how to put together a standard amortization table.
I would say expect something along the lines of this and you will be fine, doubt they have really changed it much. This was with HFF before the merger by the way.
Hope this helps and good luck to you.
By the way, I'm curious what market you are in? I could probably give better advice dependent on where you are interviewing.
Thanks for the advice! I accepted an offer from another firm but this will definitely help other potential candidates for JLL
Alias itaque eos et voluptatum. Rem modi sit consequatur similique. Est explicabo veniam ducimus enim. Cum molestiae veritatis tenetur ut nisi.
Natus rerum inventore fuga deserunt. Qui aut eligendi ad provident. Ut aut quaerat minima nam. Et quidem et minima repellat eum dolore. Odio qui perferendis sit deleniti voluptatem autem. Quas non ducimus aut quis. Praesentium saepe commodi dolore animi quia.
Eaque explicabo minus nostrum possimus. In ut ex non. Blanditiis repellat est debitis impedit nesciunt ea sint.
Quod temporibus optio enim cupiditate quas officiis quo. Et numquam dolor optio qui quaerat. Molestias delectus commodi ab. Quos iste eveniet quos ut labore maiores. Quisquam beatae at est consequatur. Ut magni sed ipsum accusamus ipsa voluptatem optio. Perspiciatis sed illo et et.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...