Spreadsheet: 149554d1334011750-sumif-multiple-columns-using-reference-codes-equity-partnership-rollforward
Sheet: PS Income-Detail

 |  | BELZ | Enterprises
 |  | UNION REALTY & INVESTCO
 |  | PARTNERSHIP INCOME
 |  |  |  |  |  | 2010 UNAUDITED |  |  |  |  |  |  |  | 2009 AUDITED |  |  |  |  |  | DEPRECIATION & AMORTIZATION |  |  | TAI ABANDONMENT
 |  |  |  |  |  | K-1 Components |  |  |  | Total Before |  |  | Total Before | K-1 Components |  |  |  | Total Before |  | Unaudited | Audited |  | Unaudited | Audited
 |  | Entity |  | Owned By | Category | Operating | Gain (Loss) | 263A | Total | Depreciation & Amortization | Depreciation & Amortization | Non-Deductible / Taxable Items | Non-Deductible / Taxable Items | Operating | Gain (Loss) | 263A | Total | Depreciation & Amortization | Depreciation & Amortization | 2010 | 2009 | [NAME] | 2010 | 2009 | [NAME]
 |  | Belz Development Company |  | Investco | Hotels |  |  |  |  |  |  |  |  | -290109 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz Excelsior PS |  | Investco | Hotels |  |  |  |  |  |  |  |  | -282270 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz Partners LP |  | Investco | Hotels |  |  |  |  |  |  |  |  | -2472162 | 0 | 0 |  |  | 1068571 |  |  |  | 0 | 0
 |  | Belz Partners LP |  | Union | Hotels |  |  |  |  |  |  |  |  | -982984 | 0 | 0 |  |  | 166806 |  |  |  | 0 | 0
 |  | BG Excelsior LP |  | Investco | Hotels |  |  |  |  |  |  |  |  | -74017 | 0 | 0 |  |  | 721229 |  |  |  | 0 | 0
 |  | BOPH LLC |  | Investco | Hotels |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | BOPH LLC |  | Union | Hotels |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | BPO Inc |  | Investco | Hotels |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | BPO Inc |  | Union | Hotels |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Heritage [NAME] |  | Investco | Hotels |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Heritage Associates |  | Investco | Hotels |  |  |  |  |  |  |  |  | -796281 | 0 | 0 |  |  | 1515098 |  |  |  | 0 | 3408
 |  | Hotel Peabody GP PS |  | Investco | Hotels |  |  |  |  |  |  |  |  | 1505499 | 0 | -919536 |  |  | 1129441 |  |  |  | 0 | 0
 |  | Hotel Peabody GP PS |  | Union | Hotels |  |  |  |  |  |  |  |  | 534209 | 0 | -326288 |  |  | 400769 |  |  |  | 0 | 0
 |  | NEMA Limited PS |  | Union | Hotels |  |  |  |  |  |  |  |  | -119903 | 0 | 0 |  |  | 227393 |  |  |  | 0 | 143541
 |  | Park Avenue Associates |  | Investco | Hotels |  |  |  |  |  |  |  |  | -65711 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Peabody Place Hotel Company GP |  | Investco | Hotels |  |  |  |  |  |  |  |  | 551760 | 0 | 0 |  |  | 378212 |  |  |  | 0 | 1015
 |  | HOTELS TOTAL
 |  | BT Partnership |  | Investco | Start Up |  |  |  |  |  |  |  |  | -22421354 | -43061 | 0 |  |  | 4242698 |  |  |  | 0 | 79642
 |  | Gayoso Suite Hotel Company LP |  | Investco | Start Up |  |  |  |  |  |  |  |  | -133 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Peabody Place Center GP |  | Investco | Start Up |  |  |  |  |  |  |  |  | -7914964 | 0 | 0 |  |  | 1263307 |  |  |  | 0 | 2099114
 |  | STARTUP TOTAL
 |  | 100 Oaks Associates LP |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Able Empire Group |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Able Empire Group LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 880115 | 0 | 0 |  |  | 416306 |  |  |  | 0 | 0
 |  | Appling Associates |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -15646 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | [NAME] |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 6125 | 0 | 0 |  |  | 103 |  |  |  | 0 | 0
 |  | Belwin / HC LP |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz Arkansas LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 567 | 0 | 0 |  |  | 40850 |  |  |  | 0 | 0
 |  | Belz Associates |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 943605 | 0 | 0 |  |  | 27687 |  |  |  | 0 | 0
 |  | Belz Becker Shlenker Lewis |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -58845 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz Devco GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 47775 | -2 | -141997 |  |  | 841962 |  |  |  | 0 | 608323
 |  | Belz Lifestyle Partners |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -875515 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz Park Place Mall LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 183649 | 0 | 0 |  |  | 137045 |  |  |  | 0 | 0
 |  | Belz Properties |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 559978 | -2 | -1030 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz Realty Company LLC |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -30410 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz Ridge Park |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Belz West Pointe LP |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | BMCO LP |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Boat Rock GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 146373 | 0 | 0 |  |  | 453049 |  |  |  | 0 | 0
 |  | [NAME] |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 247027 | 0 | -264420 |  |  | 124671 |  |  |  | 0 | 0
 |  | [NAME] |  | Union | Real Estate |  |  |  |  |  |  |  |  | 197621 | 0 | -211536 |  |  | 99736 |  |  |  | 0 | 0
 |  | Brooks Road Associates |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 172187 | -3 | 0 |  |  | 7844 |  |  |  | 0 | 0
 |  | Champion Hills Associates |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -248267 | 0 | 0 |  |  | 651445 |  |  |  | 0 | 0
 |  | FOM Management Company LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 4695 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | [NAME] |  | Investco | Real Estate | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | FOM Vegas II LP |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | FOMPR Management Co LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -682 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | FOMSA Inc |  | Investco | Real Estate | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | FOW Management Co LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | [NAME] |  | Union | Real Estate |  |  |  |  |  |  |  |  | 172937 | 80736 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Hillrise Venture GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 175162 | 0 | 0 |  |  | 69687 |  |  |  | 0 | 0
 |  | Lauderdale - Greenlew |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -44115 | 0 | 0 |  |  | 1470 |  |  |  | 0 | 0
 |  | Mallory Development Co LLC |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 470 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Marina Drive Associates |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -539177 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Marina Drive Associates |  | Union | Real Estate |  |  |  |  |  |  |  |  | -215671 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Memphis Developmental Assoc |  | Investco | Real Estate | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Metro Industrial Parl LTD |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 87741 | 0 | 0 |  |  | 86960 |  |  |  | 0 | 0
 |  | Metro Investment Company |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -99710 | 0 | 0 |  |  | 92346 |  |  |  | 0 | 0
 |  | Metro Properties |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 67783 | 0 | 0 |  |  | 91429 |  |  |  | 0 | 0
 |  | Metro Properties |  | Union | Real Estate |  |  |  |  |  |  |  |  | 67782 | 0 | 0 |  |  | 83271 |  |  |  | 0 | 0
 |  | Midsouth Terminal Co GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -2112 | 0 | 0 |  |  | 271 |  |  |  | 0 | 0
 |  | Midsouth Terminal Co LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -1585 | 0 | 0 |  |  | 203 |  |  |  | 0 | 0
 |  | [NAME] |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -278205 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Parkway Realty Company |  | Union | Real Estate |  |  |  |  |  |  |  |  | -56334 | 0 | -191251 |  |  | 10993 |  |  |  | 0 | 0
 |  | Peabody Office Tower GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 198185 | 1 | 0 |  |  | 404200 |  |  |  | 0 | 0
 |  | Peabody Place Gold GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -1127307 | 0 | 0 |  |  | 342725 |  |  |  | 0 | 0
 |  | Peabody Place Hav GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 8848 | 0 | 0 |  |  | 66021 |  |  |  | 0 | 0
 |  | [NAME] |  | Union | Real Estate | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | PF Partners GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -510570 | 0 | 0 |  |  | 376456 |  |  |  | 0 | 0
 |  | PF Partners GP |  | Union | Real Estate |  |  |  |  |  |  |  |  | -204226 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Pigeon Forge Associates |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -1960 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Poplar Pointe LLC |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Reaves [NAME] |  | Investco | Real Estate |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Rivergate Terminal GP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -39625 | 503782 | 0 |  |  | 145 |  |  |  | 0 | 0
 |  | Rivergate Terminal LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -20771 | 319072 | 0 |  |  | 76 |  |  |  | 0 | 0
 |  | SC Associates |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -19407 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | South Ridge Industrial Park |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -248325 | 0 | 0 |  |  | 528670 |  |  |  | 0 | 0
 |  | Spring Creek LLC |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -702 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | Three Sisters |  | Investco | Real Estate |  |  |  |  |  |  |  |  | -1225 | 0 | 0 |  |  | 15664 |  |  |  | 0 | 0
 |  | Three Sisters |  | Union | Real Estate |  |  |  |  |  |  |  |  | -1531 | 0 | 0 |  |  | 19580 |  |  |  | 0 | 0
 |  | TM Investors Ltd LP |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 268318 | 0 | 0 |  |  | 27599 |  |  |  | 0 | 0
 |  | TM Investors Ltd LP |  | Union | Real Estate |  |  |  |  |  |  |  |  | 273793 | 0 | 0 |  |  | 28163 |  |  |  | 0 | 0
 |  | Union Apartments LP |  | Union | Real Estate | 0 | 0 | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 |  |  | 0 |  |  |  | 0 | 0
 |  | VRC Properties LLC |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 15049 | 0 | 0 |  |  | 43015 |  |  |  | 0 | 0
 |  | [NAME] |  | Investco | Real Estate |  |  |  |  |  |  |  |  | 43504 | 0 | 0 |  |  | 42264 |  |  |  | 0 | 0
 |  | REAL ESTATE TOTAL
 |  | TOTAL