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.
| +63 | What's an Undergrad to Do? | 21 | 2d |
| +59 | Development Fees > Sponsor Equity Contribution | 18 | 1d |
| +49 | Advice to Job Seekers: Don't Sleep on Asset Management | 13 | 1d |
| +26 | Mid Sized REPE firm for first job in RE | 10 | 5h |
| +6 | LDG Development wins $36.3M Lawsuit | 1 | 22h |
| +3 | Tishman Speyer Debt Fund | 0 | 5d |
| +3 | Debt fund jobs | 1 | 4d |
| +3 | Thoughts on CIM Group today? | 11 | 1d |
| +1 | Equity Waterfall - Market Standard | 2 | 3d |
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, 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?
Hic fugiat excepturi eum quia. A quam incidunt consequatur ut quia est. Ea vero qui impedit nihil optio. Modi quis quo laboriosam pariatur. Placeat alias vitae et laudantium.
In enim beatae minima consequatur rerum porro cum. Beatae itaque labore sit. Reprehenderit laudantium non quisquam dicta.
Aliquam fuga a placeat nam repellat. Possimus in sunt aliquid adipisci quia distinctio quis. Debitis est incidunt repellendus iste delectus. Incidunt omnis dolore debitis delectus hic ut. Quos assumenda distinctio quasi quaerat. Quisquam fugit officiis distinctio. Ipsa nobis est officia enim.
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...