I’m currently interviewing at CBRE for a Debt Analyst role and I have modeling exam next week. I was told it will be 2 hours and done remotely. I’ll have access to the internet but that’s pretty much all I was told.
I’ve seen some YouTube videos about this but is anyone here familiar with it? How do I prepare? I have excel basics down but I want to know if there is a specific course or something that could help me prepare. Any tips or resources would be helpful. Thanks in advance!
For a CBRE Debt Analyst modeling exam, preparation is key, especially since it’s a 2-hour remote test. Based on the most helpful WSO content, here’s how you can prepare effectively:
1. Understand the Likely Focus Areas
2. Recommended Courses and Resources
3. Practice with Templates
4. Key Preparation Tips
5. Additional Practice
By leveraging these resources and focusing on real estate-specific modeling, you’ll be well-prepared for the CBRE exam. Good luck!
Sources: Interview at CBRE and have to take test, advice?, Excel Master Bootcamp (4-Hour) OPEN NOW - July 23 - Only 15 Seats, Analyst debt/lending at top CRE firm - 2018, REMOTE INTERN— will I actually do something this summer?, Real Estate Modelling Test Practice
Build a multifamily historical inputs and a proforma with a DSCR calculation at the bottom. Build a 5-year proforma with configurable income and expense growth rates. This will need a debt schedule with assumptions for base borrowing rate + a spread. Create a sensitivities analysis that sensitizes revenue growth and expense growth to result in a DSCR sensitivities table. Create a sensitivities analysis that sensitizes rate + spread to result in a DSCR sensitivities table.
That should cover it.
Sorry I assumed this was for Multifam. If not multifam or hotels, disregard. I dont know anything about other asset classes.
Thank you! I think this will help. I also got the following info that will be part of the exam:
IRR
Equity Multiple
10 year cash flow
DSCR Calculation
Is there a resource I could use to practice this?
this holds for most asset classes
Beatae dignissimos sed nostrum. Odio neque ut eveniet laudantium. Pariatur rerum accusantium repellendus. Nostrum corrupti aut fuga esse nemo voluptatem.
Accusantium sint suscipit quidem. Quos nemo molestiae optio consequatur. Iure suscipit saepe et sit.
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...