Real Estate Financial Modeling Interview Exam Questions - What You Need To Know

[@BreakIntoCRE]

Anything you've been asked in an interview that I missed? Let me know in the comments below. Thanks for watching!

[@FunSk8chick]

Usually it is making pro forma from scratch, they give you a few assumptions written on a word doc. Your videos are so helpful, thanks!

[@chrischristian5646]

I'm working towards a career change to CRE, and your videos are super helpful. This is now my favorite channel on KZbin. Keep up the great work!

[@BreakIntoCRE]

Great to hear, Chris! You're in the right place. Thanks for watching!

[@pokemanik]

How did the change go, did you manage to land the role you were looking for?

[@ColesCarCave]

I'll be a Junior in college next year and have shifted my focus towards getting a significant CRE summer internship in 2020 and these videos help so much! Thank you so much, I'll be recommending your channel to my fellow students.

[@BreakIntoCRE]

Thanks, Cole! Great to hear the videos have helped and I appreciate the support!

[@LGoromonzi]

I am an accountant with an interest in real estate, and this is brilliant!!

[@BreakIntoCRE]

Thanks, Goromonzi!

[@yuanli1159]

very general questions, eg, in current market, which type of property u will invest? where? why?

[@BreakIntoCRE]

Thanks for the input, Yuan!

[@jasonyang3157]

I already bought your course on Udemy, thanks

[@yuanli1159]

just one suggest for your future course: how to build a multi-let property cash flow and apply the concepts on a hypothetical case study. The ‘Rent Function’ and Multi-let cash flows The ‘date problem’ and assumptions in property asset cash flows Reducing the rent function, intermediate calculations and modelling theory Modelling lease expiries, break clauses, voids, and upward only covenants Incorporating time-varying rental growth rates Analysing multi-let cash flows to see if the leases are sufficiently diversified.

[@BreakIntoCRE]

Thank you, Yuan! Appreciate the feedback and I will keep this in mind for future course topics!

[@tagritel]

The awful reality is, I have an engineering degree, 3 yo experience as a product manager and 1+ year in SaaS sales and only recently I got into real estate. With that package, no one will want me to be an asset manager no matter if I take your course or not...

[@BreakIntoCRE]

Hey John, I definitely agree - asset manager jobs usually require 3-5 years of experience at the analyst/associate level, so it's not generally an entryway role for people coming from different industries. If you want to be an asset manager, the path is generally asset management analyst, portfolio management analyst, or acquisitions analyst to start, which is what these technical interview exam questions are focused on. My courses will teach you the technical skills you need to land an analyst or associate role. If you get some experience with the technical work in an analyst or associate job, then the asset manager role becomes much more attainable.

[@tagritel]

@@BreakIntoCRE Thanks for the reply! Your honesty is really appreciated, I prefer the truth rather than some myth that I can do it as it is! I've applied for an MBA in Construction and Real Estate and second year has Quantity surveying and Asset Management / Investment Analysis courses. I'll let you know how it goes and if I'm in. Catch up with me on LinkedIn for more :)

[@BreakIntoCRE]

@@tagritel Sounds good! I think the MBA will help with the process. Yes, keep me updated and good luck!

[@shweta7428]

Can you please link the answers too?

[@Gfield-rz3li]

Are you familiar with the CCIM designation? If so, do you think it is relevant for asset managers?

[@BreakIntoCRE]

CCIM can be worthwhile, but I definitely wouldn't say it's a pre-requisite for an asset management role. That said, it could help put you ahead of the competition if it's clear you have the finance knowledge the CCIM designation demonstrates.

[@mullehetz]

how would you model the interest payments and loan payoff when CF is quarterly and not annually?

[@BreakIntoCRE]

You can use the CUMIPMT function to calculate the cumulative interest payments for each quarter (months 1-3, months 4-6, and so on). Loan payoff would just involve calculating the total principal balance paid in all quarters up to that point.

[@karenbasulto2950]

I’m for sure not going to get the job. I don’t know any of this but I have an interview on Friday. Any tips?

[@dezhopkinsgaming2204]

did you end up getting the job?

[@JasonTsalkas]

Can you provide a sample, downloadable "interview exam Excel sheet"?

[@BreakIntoCRE]

Hi Jason, I have two courses which include sample Excel interview exams: The Real Estate Financial Modeling Bootcamp: www.udemy.com/course/the-real-estate-financial-modeling-bootcamp/?couponCode=BICRE4220 The Real Estate Financial Modeling Interview Exam Guide: www.udemy.com/course/the-real-estate-financial-modeling-interview-exam-guide/?couponCode=BICRE11220 Hopefully this helps!

[@alexcrocker4720]

Hi, I am really interested in a career in CRE and I am really interested in learning more about modelling. Do you know of any good modelling courses or resources where I can learn more?