CBRE Financial Consulting Group Analyst excel modeling test?
Anyone know what the excel test is like for this group and what I should be studying to prepare? I’m not sure if the test is an acquisition model from scratch or just a general skills test online.
Based on the most helpful WSO content, Excel modeling tests for roles like the CBRE Financial Consulting Group Analyst position often focus on real estate financial modeling. While the exact format of the test isn't explicitly detailed, here are some key areas you should prepare for:
Acquisition Modeling: Be ready to build or analyze an acquisition model. This could involve creating cash flow projections, calculating IRR (Internal Rate of Return), and NPV (Net Present Value), and understanding key metrics like cap rates and debt service coverage ratios.
General Real Estate Financial Modeling: Familiarize yourself with constructing models for commercial real estate (CRE) investments. This might include:
Excel Proficiency: Expect to demonstrate advanced Excel skills, such as:
DCF and Cash Flow Analysis: Be comfortable with Discounted Cash Flow (DCF) modeling and projecting cash flows over a holding period.
Scenario Analysis: You might be asked to run different scenarios or stress-test assumptions in your model.
To prepare, consider practicing with resources like the WSO Elite Modeling Package, which includes courses on financial statement modeling, DCF, M&A, and LBO modeling. Additionally, reviewing templates and practicing real estate-specific models can be highly beneficial.
For more specific insights, you can explore threads like https://www.wallstreetoasis.com/forum/real-estate/real-estate-modelling…</a">Real Estate Modelling Test Practice or https://www.wallstreetoasis.com/forum/real-estate/analyst-modeling-test…</a">Analyst Modeling Test on WSO.
Sources: Interview at CBRE and have to take test, advice?, Acquisitions modeling test, Real Estate Modelling Test Practice, Q&A: Real Estate Acquisitions Analyst. Uni -> BO -> Mtg Financing -> Acquisitions, JLL Analyst Excel Test
Bumping this. Curious about FCG and not related to Occupier Services.
OP, did you ever end up taking the test? Anyone else have tips?
Yes, I took the test. It wasn’t an excel test or anything related to financial modeling. It was a finance/accounting test using pen, paper, and a financial calculator.
What concepts did you need to know?
Aliquid aliquam ipsa minus possimus voluptas ut. Quae in totam sed in. Est aut sint ut eius earum qui quaerat. Rerum eaque sit quo rem eligendi optio.
Ipsum ut earum explicabo quam eius suscipit. Ipsa quia quam voluptate accusantium corrupti accusantium odio nihil. Neque dolor iusto amet ipsum et. Sequi quam nisi quos eum magni est.
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...