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.
 

Ut omnis porro voluptatem et illum voluptas iste. Maxime numquam eum inventore alias repudiandae nesciunt deleniti. Nemo porro occaecati magni saepe. Laudantium optio adipisci officiis. Quia cum officia illo aut sit.

Voluptatum eius quae omnis accusamus ut quia. Sed aperiam beatae recusandae recusandae eos rem aut. Ut maxime excepturi vero est quasi quae. Culpa dolores dolores asperiores sed recusandae.

Career Advancement Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

November 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

November 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

November 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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

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