Tenant Reconciliation Worksheet - Download as Excel

Document Sample
Tenant Reconciliation Worksheet - Download as Excel
Blue Moon Properties, LLP PBC

2008 Expense Reconciliations

(South Park Building) New Deal Acme Working ABC International Non-Tenant

Corp. Finance Partners 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)

Blue Moon Properties, LLP PBC

2008 Expense Reconciliations

(North Park Building)

Big Dog, Inc ZYX ABC Firebrand Bluebird Cell Co A Cell Co B Tellco Total

North Bldg Total Inc LLC LLP Inc 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

By registering with docstoc.com you agree to our
privacy policy and terms of service

Successfully added document to cart!

Successfully added document to cart!