Research analyst interview questions

Hi everyone,

I have a second interview for a junior research analyst position at CBRE and I wil be tested on Excel, data interpretation and writing skills. Any advice or experience about it? Will it be doing pivots tables, graphs,.. based on a huge excel database and write something about my observations ?

Anyone has already did these kind of test for a Real estate research analyst position ?

Any help will be really appreciated !

Thanks

11 Comments
 

Hey kyokura, sorry about the delay, but are any of these useful:

  • Equity Research- Interview Questions Equity Research Interview Questions Positions in equity research are available for seasoned ... a research analyst after gaining experience. Before any of this though, you must get the interview and show ... writing the reports. Equity Research Questions- Technical Unlike ib interviews, equity research techni
  • Equity Research Interview questions equity research interviews Equity Research Types of Interview Questions As with any other interview for ... comment below! Equity Research Equity Research Forum Resources Investment Banking Interview Questions ... Hi, On short notice I have an interview with an analyst and an associate on thu
  • M&A Interview Questions- Beginner to Advanced Questions Interview Questions for Mergers and Acquisitions I have a set of M&A interview questions ... below are inclusive of premium and synergies. Beginner Interview Questions- Basic Accretion / Dilution ... I like to ask. In my career, I've only had two analyst / associate candidates answer all four levels ...
  • Why Morgan Stanley Interview Question Questions in IB Interviews Investment Banking Resume Example IB CL Sample How to Answer: Why IB? IB Analyst ... here. I needed your perspective in one of the interview questions that I am struggling with and will ... will help me and not just feed my ego. How to Answer the Question Why MS? In any interview or ...
  • Investment Banking Interview Questions- A Comprehensive Guide questions are a major part of the investment banking analyst interview. A great chunk of the interview will ... Take my word for whatever you will. I drill my analyst interview candidates hard on technicals. Not ... moment. Investment Banking Fit Questions (And Answers) You've reached the interview. This means that ...
  • Interview Questions- Questions asked in Banking or Hedge Funds I have done a search and there a several answers to the interview questions. Yet, I propose that ... Here it goes: What are the interview questions that were/are asked in the interview process for the ... some of the more knowledgeable members answer these questions or those that have been through the ...
  • J.P. Morgan- Video Interview Invitation Corporate & Investment Banking Summer Analyst Help! JP Morgan Investment Banking Video Interview Questions? I just got offered a J.P. Morgan- ... know if they ask specific video interview questions? Do you have any general video interview tips? ... Something like a top 10 interview questions and answers list to the JP Morgan hirevue interview? Thank you ...
  • 1st Year Equity Research Analyst BB London- AMA;https://www.wallstreetoasis.com/forums/investment-banking-interview-questions-a-comprehensive-guide&quot ... ;>Investment Banking Interview Questions
  • interview-questions-a-complete-guide">Private Equity Interview ...
  • More suggestions...

Or maybe the following WSO members have something to say: Biffa @Kisame111Hoshigaki" REMS_

You're welcome.

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

I don't know anything about the test, but a big part of a research analysts job is to create the quarterly reports for different asset classes. In that role, you have to use excel to track hundreds-thousands of buildings, so pivot tables are useful. From there, you will graph the data and then write about your findings. Basically what you're expecting.

I'd recommend getting a hold of a few reports from CB, Cush and JLL (you can download from their websites) and familiarizing yourself with the lingo.

Let me know if you have any questions, I work a lot with the research team at my company.

 

Good work buddy. If you've dealt with real estate models before you'll be fine. If not, go get some practice.

I work as an analyst in cre asset management and acquisitions. From my experience with broker analysts at cbre, cw, jll, and hff:

  • Pivot tables - doubt it

  • Graphs - maybe but doubt it

  • Huge excel dataset - doubt it

  • Build a small 10yr cash flow analysis - maybe

  • Edit/manipulate an existing model - likely

Good luck. If you can't figure out the answer then explain the steps you would theoretically do to arrive at it.

 

Thank you all for your responses. Finally the test was just a big database containing rental transactions with data such as location, surface area, tenant, annual renting,... The goal was to analyse the database and test my narrative skills.

I hope that it has gone well, the job seems very interesting :)

 

My friend worked their last summer and he told me the interview process was very centered around your knowledge about the markets and current events as well as certain trading strategies

 

Was this for the South Brunswick office? Apparently a lotta shit's been going on ever since DJI was bought out by Chicago Mercantile Exchange. How did the phone interview go? I'm friends with a lot of the interns there for this summer and a bunch of the full-timers. PM me if you've got questions the phone interview didn't answer.

 

Voluptas voluptatibus sapiente molestiae sapiente rerum. Ut exercitationem nesciunt consequatur unde asperiores dolorem perspiciatis. Qui et ipsam aut qui repellat.

Eius rem quaerat praesentium omnis vel rerum et. Fugiat blanditiis laudantium consectetur tempore libero at iusto inventore. Aut aliquam quos doloribus dolores voluptatem deleniti aut. Optio vel in mollitia aut voluptates.

Et dolorem ut rerum sunt ut similique quam tempore. Assumenda ex adipisci quis numquam. Voluptas sint impedit perferendis sapiente nesciunt quasi est. Quae eius reprehenderit natus. Earum voluptas neque debitis esse. Ut quo aut non quod omnis porro. Nihil molestiae laudantium eligendi omnis doloribus quas.

Career Advancement Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Morgan Stanley 08 97.8%
  • Goldman Sachs 02 97.2%

Overall Employee Satisfaction

August 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.9%
  • Morgan Stanley 01 98.3%
  • Banco Santander 02 97.8%
  • BMO Capital Markets 12 97.2%

Professional Growth Opportunities

August 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.8%
  • JPMorgan 01 97.2%

Total Avg Compensation

August 2026 Investment Banking

  • Vice President (16) $429
  • Associates (47) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (25) $178
  • Intern/Summer Associate (14) $159
  • 1st Year Analyst (83) $151
  • Intern/Summer Analyst (74) $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
kanon's picture
kanon
99.0
3
BankonBanking's picture
BankonBanking
99.0
4
Secyh62's picture
Secyh62
99.0
5
dosk17's picture
dosk17
98.9
6
CompBanker's picture
CompBanker
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
Betsy Massar's picture
Betsy Massar
98.9
10
Jamoldo's picture
Jamoldo
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...”