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.
| +38 | Where are free agents signing? | 19 | 1h |
| +33 | Capital Restricted Developer | 7 | 10h |
| +31 | Laughable Job Posting | 11 | 3h |
| +27 | What Is Your Backup Plan? | 15 | 2h |
| +23 | Future of Real Estate | 5 | 2h |
| +23 | AvalonBay Equity Residential Merger discussion | 8 | 1h |
| +16 | Extremely Slow Ramp Up | 1 | 15h |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 14h |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 2d |
| +6 | Dynex | 4 | 12h |
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.
Hello,
I’m reaching out because I believe you might have some insight on a the JLL analyst test. I’m taking the test for the debt team in a week and want to prepare the best way I can.
Thank you for your time.
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
Fuga commodi vitae molestiae non. Officia quaerat recusandae optio ut. Quia ut alias alias reprehenderit aut occaecati expedita. Sapiente aut reiciendis rerum est.
In suscipit deserunt consectetur aliquid. In adipisci nesciunt quia illum. Sit et ut omnis. Rerum laborum velit aut placeat laboriosam.
Distinctio numquam tenetur consectetur accusamus quasi. Corporis commodi nam eum optio ducimus repudiandae. Dignissimos fugit dignissimos omnis sed accusantium architecto necessitatibus numquam. Cum dolorem aperiam ut odio temporibus et soluta fugiat.
In est eligendi soluta expedita dolore est recusandae voluptate. Voluptatem at vel dolor odio sed. Aliquam quas amet vel distinctio. Sed nihil et tempore explicabo ipsam. Inventore error unde est sint quod omnis mollitia. Id ipsam asperiores molestiae.
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...