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.

 

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...

I'm an AI bot trained on the most helpful WSO content across 17+ years.
 

Quis voluptatem sapiente libero. Pariatur a distinctio qui rerum cum facilis ipsa. Consequuntur sunt ut nobis reprehenderit recusandae commodi voluptas.

Facilis officia architecto et blanditiis dolorem. Neque cum distinctio atque error. Qui nulla et dignissimos quis beatae. Sit qui voluptatibus sint deserunt vitae qui. Occaecati aliquam omnis iusto deserunt doloribus itaque assumenda. Pariatur quo dolor minus non itaque ratione. Vitae sunt ipsum aspernatur impedit rerum quae.

Career Advancement Opportunities

April 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Goldman Sachs 19 98.8%
  • Harris Williams & Co. New 98.3%
  • Lazard Freres 02 97.7%
  • JPMorgan Chase 03 97.1%

Overall Employee Satisfaction

April 2024 Investment Banking

  • Harris Williams & Co. 18 99.4%
  • JPMorgan Chase 10 98.8%
  • Lazard Freres 05 98.3%
  • Morgan Stanley 07 97.7%
  • William Blair 03 97.1%

Professional Growth Opportunities

April 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.8%
  • Goldman Sachs 17 98.3%
  • Moelis & Company 07 97.7%
  • JPMorgan Chase 05 97.1%

Total Avg Compensation

April 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (19) $385
  • Associates (87) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (66) $168
  • 1st Year Analyst (205) $159
  • Intern/Summer Analyst (146) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
Secyh62's picture
Secyh62
99.0
3
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
kanon's picture
kanon
98.9
6
CompBanker's picture
CompBanker
98.9
7
dosk17's picture
dosk17
98.9
8
GameTheory's picture
GameTheory
98.9
9
Jamoldo's picture
Jamoldo
98.8
10
bolo up's picture
bolo up
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”