REPE debt fund - what kind of excel modelling is typical?
I'm preparing for an interview with a REPE Debt Fund (hence my prior posting regarding this topic). I was curious to know what types of financial models are typically used. The folks I'm interviewing with typically purchase portfolios of distressed assets, rarely individual properties.
Does anyone have knowledge or experience regarding what specific types of excel models will be typically used in this niche field of REPE?
maybe know how to price a loan to a yield, spread and % of par. also how to run through a foreclosure scenario
great thanks - anyone else with knowledge on typical excel models used?
You should know how to run a take-out financing scenario. Also, once you have the pro forma you should be able to size it by DSCR and Debt Yield.
pm if you have any other questions.
also know how to do an IRR and cash flow waterfall
Are you in the industry/have experience? The modeling at debt funds can be pretty complex, it may be hard to learn it on your own. If this entry-level I wouldn't worry.
Are yiu acquiring or originating real estate debt? Sr, Mezz, pref or all three? The "modeling" shouldn't be that difficult, all you're doing is a building a p&l, stating you're assumptions behind your numbers (rent, vacancy, concessions, expense, TI/LC) finding dscr, debt yield, value, etc. If you have to calculate irr (I don't think you'll have to) it's pretty simple. Just google "excel irr"
REPE Distressed Debt Model Exam (Originally Posted: 06/28/2014)
I am interviewing with a real estate PE firm that invests in distressed debt. I have to take a loan acquisition modeling exam. Does anyone have an example or know what to expect for this?
Bump.
Qui possimus numquam iusto sint quis corrupti. Alias culpa consequuntur voluptatem quia aut atque modi error. Blanditiis sed expedita nostrum est quia pariatur error sint. Sint in iure molestias ipsam. Consequatur qui ipsa sunt qui. Aut labore ut saepe in error sed.
Maiores qui aut blanditiis minus qui mollitia eaque. Placeat et aut tenetur accusamus maxime incidunt sed. Dolore ea enim mollitia omnis sed dolorem enim. Cum placeat molestias nobis sed.
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...