Excel Modeling Tests - Associate

I’m an associate (generalist) at a large institutional real estate firm. I work on everything - PM, AM, development, and some acquisitions. 4 years exp ($160ish all-in). During year-end review, I also ranked as one of the highest associates.

The models/ tests that you guys post on here, some of them I know I can’t do. Would I be expected to do some of these crazy models from scratch for most other positions?

I’ve made some quirky waterfall models w unique hurdles, and everything between. I still just can’t do that in 2 hours without looking at anything.

When it comes to understanding real estate deals (qualitative aspects), risks, how to compare yields, how to value it (even in todays market), I think I’m extremely good. I know there’s a bunch of tests I can practice on, but don’t really have time when I’m working 80 hr weeks.

Please tell me I’m not the only one that thinks some of this is BS.