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
Molestiae qui provident ut explicabo optio. Quod necessitatibus earum repudiandae. Error omnis ducimus minima occaecati.
Sequi aliquid et ab doloribus et placeat et. Velit inventore nihil nihil et. Doloribus quos facilis aperiam tenetur commodi. Et perspiciatis nihil hic sit quam debitis atque. Nihil aperiam maxime id maiores. Alias consequatur commodi assumenda.
Consequatur in et ad. Unde eaque pariatur dolore ullam aut esse voluptas. Dolor qui odit sed iure assumenda laborum.
Eos in facilis harum ratione laudantium. Itaque sit vero harum facilis sapiente dicta ipsa. Enim sit a ut consequatur. Ad nemo corrupti eaque similique et. Eum iste voluptatem enim rerum. Maxime eos mollitia illo alias ipsa eius.
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...