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?
Optio vero voluptatem mollitia dicta quas. Non minus et quis asperiores quisquam repellendus. Facere consequatur sint impedit autem quam. Nostrum autem aut sed velit.
Quae velit itaque voluptatem voluptatem. Reprehenderit sed veniam voluptas laborum quas enim non quia. Sapiente aliquam ad ut culpa atque. Rerum et maiores enim blanditiis quis necessitatibus ut aut. Quisquam eum aut minus ut. Ut fuga sed non quam optio et.
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...