Hi all,
Is anyone aware of any commercial real estate modelling tests (free or at a cost) (preferably non development) on the internet? I've found the PGIM case study on WSO and the free one on REFM but both are multifamily which is not the industry I am trying to get into - moreover, I am already in multifamily so I am more than comfortable with modelling these case studies
The reason I ask is because my modelling skills are pretty good, and without any pressure, I can model as good as most people looking for junior roles. However, I don't get enough interviews (not many people give me a chance after seeing my multifamily background) and as a result, I am not familiar with the pressure (not necessarily time pressure as I can model quickly when comfortable, but its the pressure of this opportunity being last-chance-saloon in my own head) and I tend to panic so my models turn to shit. Ultimately this is not reflective of my ability but I get rejected because of this.
It would be ideal if I could practice with some real world examples, under exam conditions so that I can get rid of this mental block.
Any help would be much appreciated.
Any tests with a promote would be a bonus!
Thanks
***** It would also be amazing if anyone would be willing to tear apart one of my models but I fully appreciate if nobody has the time :)
And just so that I'm not leaching completely (!) here is a collection of what I've already found.
https://www.wallstreetoasis.com/forums/re-model-c…
Most of the Excel case studies are based on a value-add multi-family or hotel asset. They will likely give you some base assumptions (current occupancy, rents, how long to stabilize the property, etc.) and ask you to build a model from the ground up. The case will ask you to solve for something like, "At what purchase price will make the hold-period levered IRR 18%?" Some will also ask you to incorporate a basic 2-tier equity waterfall.
So, you should know how to create: 1) Property-level cash flow statement 2) Debt amortization table 3) Sources and uses table 4) Equity waterfall 5) How to value a property using cap rate 6) How to calculate basic return metrics (IRR, cash-on-cash return, and equity multiple)
If you can do this, you will be in great shape. PM me and I can send you an example.