I went back and checked the attachment to post 498. The excel document did in fact have errors. I accidentally uploaded the file I had been working with instead of the original raw file. It looks like column 'BY' did not sort properly.
I updated the file attached to post 498 with the original CMBS annex. Sorry for any confusion.
I don't think much emphasis should be put on column 'BY' titled "Cushman Stabilized Appraised Value." Using this to value the properties could lead to very misleading conclusions. For example, the Valley View Mall in Midtown Dallas was appraised at $9,267,333 back when this was a Class C mall. This property is under consideration for Amazon's HQ2 or a one million SQ FT Class A office development. Do a few Google searches. It's also been discussed previously in this thread (read the messages starting at post #461). This is one of Seritage's most valuable "Premier Properties" along with Aventura FL, La Jolla CA, Santa Monica CA, Hicksville NY, Redmond WA, etc. According to CEO Benjamin Schall's letter in the just released 2017 annual report, there are 36 "Premier Properties" in the portfolio.
Seritage has commenced redevelopment on 3 of their "Premier Properties" but these properties have yet to show up in the SNO lease figures.
Benjamin Schall's 2017 letter:
"As part of our announced redevelopment activity, we are now under construction on three of our premier redevelopments in Santa Monica and San Diego (La Jolla), CA and in Aventura, FL. The cumulative first phases of these three projects total over 500,000 square feet, with an expected incremental investment of approximately $300 million. These three projects generate minimal income today and are expected to generate north of $40 million of income upon stabilization – real needle movers for the Company. It is worth noting that we expect these projects, and others like them, to have future phases of development as we further activate these spectacular parcels of land."
That's $80 in rent PSF! Furthermore, Seritage is earning a higher return on their redevelopment investment on the "Premier Properties." These three properties are earning unlevered returns of over 13%, considerably higher than the 10-11% unlevered returns Seritage has achieved on their current redevelopment pipeline. The value of just the first phase of these 3 "Premier Properties" likely exceeds $400m after deducting the costs of redevelopment ($700m in gross value assuming $40m in annual stabalized rent at a 5.75% cap rate). That's $7 per share of value creation from just the first phase of 3 of 36 "Premier Properties."
2017 Annual Report with CEO Benjamin Schall's letter to shareholders:
http://www.envisionreports.com/srg/2018/2D112FE18E/234c5e1efc934721aedba9c2e654775f/Seritage_AR_3-13-18_secured.pdf