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!
| +43 | What Is Your Backup Plan? | 20 | 10h |
| +39 | Where are free agents signing? | 21 | 16h |
| +35 | AvalonBay Equity Residential Merger discussion | 16 | 14h |
| +34 | Future of Real Estate | 9 | 19h |
| +31 | Laughable Job Posting | 12 | 12h |
| +16 | Extremely Slow Ramp Up | 1 | 1d |
| +14 | In RE, what is the ONE software tool you couldn’t survive without? | 5 | 1d |
| +10 | Dynex | 5 | 1d |
| +9 | Development Budget: use RENTABLE or GROSS BUILDABLE sf? | 3 | 3d |
| +9 | Portfolio Management strategy/transaction exposure on the analyst/associate level? | 1 | 1d |
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.
Eos ea eum quas explicabo rerum blanditiis. Harum veritatis voluptas quo illo. Ipsam pariatur enim rem voluptatem aut dolor. Minima voluptates molestiae odio quo est. Error debitis labore est et est dolores ad. Placeat voluptas occaecati commodi deserunt. In nihil sit soluta in nostrum placeat est.
Beatae sed distinctio similique. Aspernatur in quibusdam sint tempore aliquid. Incidunt facilis accusamus ratione tenetur. Quis eos ea omnis corporis.
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...