5 Comments
 

Based on the most helpful WSO content, for a financial analyst role at CBRE, the second-round interview often includes a "real estate and finance" test. While the exact details of the test can vary, here are some key preparation tips:

  1. Excel Proficiency: Be prepared to demonstrate strong Excel skills. This could involve building or analyzing financial models, such as cash flow projections or valuation models. Familiarize yourself with advanced Excel functions and shortcuts.

  2. Real Estate Fundamentals: Refresh your knowledge on key real estate concepts, such as:

    • Cap rates (going-in vs. terminal cap rates)
    • Loan-to-Value (LTV) ratios
    • Debt Service Coverage Ratios (DSCR)
    • Discounted Cash Flow (DCF) analysis
    • Types of valuation methods (e.g., income, sales comparison, cost approach)
  3. Market Insights: Be ready to discuss your perspective on the current commercial real estate (CRE) market, including sectors you are bullish or bearish on and why.

  4. Practice Modeling: If possible, practice constructing a basic real estate financial model. This could include creating a pro forma, calculating net operating income (NOI), and determining property valuation.

  5. Behavioral Questions: While technical skills are crucial, don’t neglect behavioral preparation. Be ready to discuss your experiences, problem-solving skills, and how you handle challenges.

For additional resources, consider exploring WSO's financial modeling templates and training programs, which include lessons on DCF, M&A, and LBO modeling. These can help sharpen your technical skills and boost your confidence for the test.

Sources: Interview at CBRE and have to take test, advice?, Advice from an ex-IB MD: Eight tricks to ace your 1st round interview, https://www.wallstreetoasis.com/forum/real-estate/my-8-month-real-estate-finance-internship-journey-some-general-thoughts-on-nyus?customgpt=1, 20 Most Frequently Asked Questions - London Edition, JLL Analyst Excel Test

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

Rerum dolores iusto unde temporibus nemo perspiciatis ea ab. Reprehenderit repellendus voluptatem et exercitationem soluta ex. Doloremque aut repudiandae id et distinctio rerum.

Neque dolore voluptatibus cumque mollitia nisi. Quia corrupti sunt molestiae porro. Inventore quae eius tenetur molestias error. Quos et a fugiat omnis qui distinctio.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.8%
  • JPMorgan 01 98.2%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 01 98.8%
  • Evercore 01 98.2%
  • BMO Capital Markets 12 97.6%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Evercore No 98.8%
  • Morgan Stanley 05 98.2%
  • JPMorgan No 97.7%
  • BMO Capital Markets 12 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (14) $434
  • Associates (43) $259
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (75) $151
  • Intern/Summer Analyst (67) $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
BankonBanking's picture
BankonBanking
99.0
3
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
DrApeman's picture
DrApeman
98.9
7
dosk17's picture
dosk17
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
GameTheory's picture
GameTheory
98.9
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...”