Would love to hear what the experience was like 2nd round. Tips on how to prepare for the excel test would be very beneficial as well. Thank you!
| +38 | Being a 100% Disabled Military Vet Pays as Much as RE Analyst Seat | 30 | 4h |
| +21 | Rate Hikes | 14 | 1d |
| +16 | Senior Living Modeling Help | 5 | 4d |
| +9 | What are the best undergrad schools for placing in real estate finance? | 16 | 1d |
| +9 | REPE Analyst Firm Advice | 3 | 1d |
| +9 | Launching a Development Platform in Greece | 1 | 9h |
| +8 | Hard Money Lenders? | 1 | 15h |
| +3 | BGO REPE LDN | 1 | 4d |
| +3 | LIHTC Syndicator Comp | 1 | 4d |
| +2 | Question on being paid a fee for bringing a developer a site | 3 | 13h |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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:
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.
Real Estate Fundamentals: Refresh your knowledge on key real estate concepts, such as:
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.
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.
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
When I interviewed for that group, the test was pencil and paper.
I’ve heard that too but recruiter said there would be an excel test. Was the pen and paper test hard?
^ I have heard this before as well.
Facere sit ut non soluta modi enim numquam sed. Corrupti hic praesentium reprehenderit ducimus. Unde quae fuga consectetur nulla. Aut perferendis aut nulla perspiciatis illum. Possimus et quae consequatur non. Et autem iusto qui corporis non omnis.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...