Does anyone have an example of what an excel test for a multi-family investment shop (ex. Equity, GID, Avalon) would be like? Or an example would be helpful
| +111 | Is anybody just going to leave the industry? | 35 | 11h |
| +36 | CRE Recruiting for a Career - crazy? | 9 | 8h |
| +26 | Multifamily firms collpasing in Dallas whose next? | 8 | 2d |
| +22 | Exits from REPE | 11 | 1d |
| +19 | Arbor Realty Trust in 2026 | 10 | 14h |
| +18 | LOI Underwriting / Due Diligence | 1 | 15h |
| +15 | NYC Real Estate Job Market | 5 | 2d |
| +14 | Q3/Q4 CRE Job Market Optimism (or lack thereof) | 5 | 2d |
| +10 | Red Flag? Commissions-only acquisitions roles | 2 | 9h |
| +10 | Do REPE SA/VP/Dir expect base/bonus bump annually or is 'bump' inherent in carry? | 1 | 18h |
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.
Took a test recently. The gave me the rent roll and all the various trending assumptions. For the debt they gave the rate, amortization, and DSCR limit on the debt and asked me to size the loan. Make sure you set up your inputs nicely and make the pro forma dynamic. When we test candidates I hate it when they burry the assumptions as hard coded values.
You also need to be comfortable with calculating the remaining principal on the loan for exit analysis. Every test I have taken only ask for one holding period scenario, but bonus points if you know how to make it dynamic.
They then gave a discount rate and asked me to come up with the value of the property. (Debt plus sum of PV of CFADS)
They then gave me another bid price and asked what the IRR would be on that. A good way to check these two answers is your IRR should equal the discount rate if you use the value you came up with as the purchase price in that calculation.
Good luck.