Looking at an preferred equity opportunity with current pay of 9% and all-in of 14.5%. I've put together a waterfall model for the investment. However, now I have to assess what the returns, specifically, the all-in if exit value (property) were to decrease by 10%. What's the best way to go about this?
| +52 | Leave brokerage to be GP | 12 | 1d | |
| +46 | New Comp Database - Google Form (Now with Data Validation) | 24 | 1d | |
| +24 | Seeking Career Guidance in Real Estate Development Post-Graduation | 3 | 2d | |
| +23 | Spreads over SOFR/UST | 5 | 6h | |
| +23 | Going out on your own | 4 | 1d | |
| +22 | REPE/Development GPA | 15 | 4d | |
| +21 | Real Estate = complicated + underpaid | 15 | 1d | |
| +18 | High achiever that doesn’t want to work weekends | 9 | 4s | |
| +17 | Fisher Brothers | 6 | 1d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 5d |
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.
Is this for a case study?
Regardless, you’d probably want to include a cell that has the amount you’d be haircutting the exit value by. Then, in the cell where you have the exit value formula, you’d want to modify the formula so that you’re multiplying by (1 - cell where you have the haircut%). Finally, you can create a sensitivity with that.
This is standpoint of a common equity holder. I'm trying to look at it from a lenders perspective.
By decreasing the exit value by 10%… questions like this make me realize how fucking dumb most people are. Gives me hope.
.
How would it not get you the all in return. Just have the cash flows calc’d out for the pref piece.
Does it make sense to determine the residual loan balance. Exit value - senior - pref. Assuming there is a residual. Adjust your pref piece (end value) by the residual and that should result in your all-in return?
Asperiores qui fugit ut iste rerum rem minima. Ad dolor sint in voluptatem et pariatur. Cumque ipsam et asperiores dolorum. Iusto eos et voluptas sint. Tempora adipisci sit magni repellendus ducimus reiciendis.
Architecto consectetur magni impedit incidunt. Impedit maiores et vel dolorem est molestiae culpa est. Laboriosam ducimus est dicta molestiae architecto cupiditate qui.
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...