Tenant Reconciliation Worksheet - Excel by ltedprosser

VIEWS: 371 PAGES: 2

More Info
									   XZY Properties, LLP
2008 Expense Reconciliations
      (South Building)                                                       Newco         Omin Equipment     WorkForce       Star International     Non-Tenant
                                                                             Corp.            Finance          Options               Inc.             Income        Total
Square footage                                                                  8,899              18,838          18,453                   13,785                   61,521

 Base rents:
January-08                                                                     9,640.58           17,660.62       18,453.00             14,359.38           -       60,113.58
February-08                                                                    9,640.58           17,660.62       18,453.00             14,359.38           -       60,113.58
March-08                                                                      10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
April-08                                                                      10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
May-08                                                                        10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
June-08                                                                       10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
July-08                                                                       10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
August-08                                                                     10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
September-08                                                                  10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
October-08                                                                    10,382.16           19,230.46       18,453.00             14,933.75           -       62,999.37
November-08                                                                    9,022.08           19,230.46       18,453.00             14,933.75           -       61,639.29
December-08                                                                         -             19,230.46       18,453.00             14,933.75           -       52,617.21
 Base rents                                                                  111,360.52          227,625.84      221,436.00            178,056.26           -      738,478.62

Other charges                                                                        -                  -               -                      -            -             -

CAM charges:
January-08                                                                     7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
February-08                                                                    7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
March-08                                                                       7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
April-08                                                                       7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
May-08                                                                         7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
June-08                                                                        7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
July-08                                                                        7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
August-08                                                                      7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
September-08                                                                   7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
October-08                                                                     7,193.35           15,227.38       14,916.17             11,142.87           -       48,479.77
November-08                                                                    5,088.92           15,227.38       14,916.17             11,142.87           -       46,375.34
December-08                                                                         -             15,227.38       14,916.17             11,142.87           -       41,286.42
 CAM revenue charged                                                          77,022.42          182,728.56      178,994.04            133,714.44           -      572,459.46
 CAM charge adjustment                                                            (0.00)           9,500.59        6,036.99              7,082.81           -       22,620.39
 Adjusted CAM revenue                                                         77,022.42          192,229.15      185,031.03            140,797.25           -      595,079.85

Expenses to pass through
Common expenses:               2007 actual     Per foot      2008 actual
  Utilities                      116,281.00           1.89     134,146.83
  Maintenance                    156,566.69           2.54     146,394.65
  Insurance                        8,919.63           0.14       8,247.96
  Property tax                   232,702.96           3.78     237,509.52
  Patrol service                   7,761.60           0.13       8,160.00
  Total common expenses          522,231.88           8.49     534,458.96
Common expenses per foot                8.49                          8.69
  Days of responsibility                                                            310                 365             365                   365
  Tenant percentage                                                              14.46%              30.71%          29.90%                22.41%
  Tenants expense                                                             65,637.42          164,132.35      159,803.23            119,772.25                  509,345.25
  Days of responsibility
  Tenant percentage
  Tenant expense
  Total tenant expense

Tenant specific:
  Janitorial, tenant spaces       22,692.00                                    3,850.00           11,302.80        8,968.80              8,271.00                   32,392.60
  Management fee                  48,840.00                                    7,535.00           16,794.00       16,259.00             12,754.00           -       53,342.00
                                 593,763.88                                   77,022.42          192,229.15      185,031.03            140,797.25           -      595,079.85
Annual expense per foot                                                           10.19               10.20           10.03                 10.21
Amount due to (from) tenant                                                       0.00           (9,500.59)      (6,036.99)            (7,082.81)                 (22,620.39)
    XYZ Properties, LLP
2008 Expense Reconciliations
      (North Building)
                                                                                Proco                                                                              Bell South    Wavetec      Z-Mobile        Total
                                                                           North Bldg Total     Proco        Proco        Proco       Skytec          Total        Roof Rent     Roof Rent    Roof Rent     Roof Rent      Total
Square footage                                                                     75,824.00       63,970         9,254      2,600       10,148                                                       -                        85,946

 Base rents:
January-08                                                                         71,079.38     59,971.88     8,670.00    2,437.50    12,262.17       83,341.55      2,339.72       300.00      2,249.73      4,889.45      88,231.00
February-08                                                                        71,079.38     59,971.88     8,670.00    2,437.50    12,262.17       83,341.55      2,339.72       300.00      2,249.73      4,889.45      88,231.00
Ma
								
To top