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?
| +71 | Hiring Analyst/Associate - Advice | 32 | 30m | |
| +44 | Current CRE Phase | 19 | 3d | |
| +40 | Laid Off - Multifamily Acquisitions Help | 9 | 13h | |
| +26 | Capital Formation | 9 | 4d | |
| +26 | Best Brokerages in South Florida | 18 | 1d | |
| +25 | PART 2: Increasing RE Industry's Cash Compensation, Collectively | 1 | 5d | |
| How many days a week are you expected to be in the office? | 23 | 1d | ||
| +23 | NYU MSRE Program | 7 | 3d | |
| +22 | UK Development | 4 | 1d | |
| +18 | Are Additional Capital Calls Usually Mandatory in REPE? | 7 | 2d |
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.
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.
Sit consequatur illo ipsam qui dolor perspiciatis autem. Dolores est nemo dolor atque dolor et accusamus. Quis maxime ut eos libero natus. Quos aut ea occaecati sed id aut error.
Doloribus et delectus maxime temporibus non voluptatibus. Eaque laboriosam blanditiis rem enim sed consequuntur nisi. Minima et quos et molestias error vel officia.
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...