JLL Investment Banking Analyst Excel/Argus Test

I'm a college senior looking to land a real estate analyst role after graduation. I've been speaking to the real estate investment banking team at JLL in New York, who advise on capital markets/portfolio sales. They say a next step for the analyst hiring process is a written/Excel/Argus test before the final round interviews.

I have prior internship experience at a major NYC real estate firm (CBRE, JLL, C&W) on a brokerage team, and at a $50B+ real estate investment manager where I used Argus and edited models. My school's real estate program also has me working on a property valuation project that has me creating DCF reports and creating Argus files.

Does anyone have insight on what types of calculations or modeling I can expect in a test from JLL? They mentioned a combination of written, Excel, and Argus testing. If anyone with knowledge of the usual material that would be super helpful.

Real Estate Modeling Course

  • Real-life RE Modeling Tests from actual Interviews
  • Various asset classes including multi-family, commercial and more
  • Huge discount - until more tests and cases added

Comments (10)

Mar 29, 2019 - 2:57pm

Hey Realzstates96, I'm the WSO Monkey Bot and I'm here since nobody responded to your thread! Bummer...could just be time of day or unlucky (or the question/topci is too vague or too specific). Maybe one of these topics will help:

  • Advice: JLL Real Estate Investment Banking-Strategic Transactions Group Interview Finance Real estate Investment banking analyst interviews ... how to prepare for this would be greatly appreciated. Thanks legends. Real Estate jll Real Estate ... interview with HR for the above new group (apparently elite from what the Analysts are saying). Not saying ...
  • Bank of America Online Assessment Test and Application Process Investment Banking Interview Course Here test assessment Bank of America Merril Lynch ... know what that Bank of America online assessment test covers? Here's what I've gathered. BOA ... personality tests and personality types. hockey1316- Private Equity Analyst: Used to administer these tests as .
  • Real Estate "Investment Banking" I'd feel blessed if you shared what you do. Thanks people. analyst investment banking real estate ... Hello all, I'm curious about what Real Estate "Investment Banking" might be all ... postings have me interested, but can anyone shed some light on what a Real Estate "Investme
  • Licensed going into commercial real estate brokerage help or hurt? (CBRE, JLL,ect) in one of those sectors.Would having a real estate license help or hurt being hired as a analyst to ... As recently graduating college and looking to go into a commercial real estate brokerage like ... CBRE, I would like to be in the investment or leasing side of brokerage and eventually become a broker ...
  • Eastdil Secured- Analyst Interview followed by an excel/argus test. In terms of pay it I hear it is 65-70k base, with 100-120k all-in, but ... interview or the complexity of the exam? Also any other additional information would be welcomed. analyst ... real estate ...
  • CFA Level III Exam- No motivation all means put in the extra effort, you'll be real glad you're done with it, for whatever ... probability even if you're not feeling that sharp on the curriculum itself. from certified investment ... think about it? Everyone always says it is a harder test than L2 but easier content. I think because the ...
  • HSBC SHL Online Assessment Test complete it by sunday. thanks. SHL Online Assessment The SHL assessment is an apptitude test used by ... several banks across Wall Street as a pre-interview screen. There are several exams geared towards ... same set of questions regardless of the bank you are interviewing with. SHL Quantitative Exam Our users ...
  • More suggestions...

If those topics were completely useless, don't blame me, blame my programmers...

Learn More

300+ video lessons across 6 modeling courses taught by elite practitioners at the top investment banks and private equity funds -- Excel Modeling -- Financial Statement Modeling -- M&A Modeling -- LBO Modeling -- DCF and Valuation Modeling -- ALL INCLUDED + 2 Huge Bonuses.

Learn more
Start Discussion

Total Avg Compensation

April 2021 Investment Banking

  • Director/MD (9) $911
  • Vice President (32) $350
  • Associates (180) $232
  • 2nd Year Analyst (102) $151
  • 3rd+ Year Analyst (25) $146
  • Intern/Summer Associate (95) $145
  • 1st Year Analyst (387) $131
  • Intern/Summer Analyst (315) $82