Spreadsheet: 129331d1321548112-excel-2007-vlookup-with-critera-in-multple-columns-copy-of-example-4
Sheet: Sheet1

 |  |  |  |  | Jan 31, 11 |  | Feb 28, 11 |  | Mar 31, 11 |  | Apr 30, 11 |  | May 31, 11 |  | Jun 30, 11 |  | Jul 31, 11 |  | Aug 31, 11 |  | Sep 30, 11 |  | Oct 31, 11
ASSETS
 | Current Assets
 |  | Checking/Savings
 |  |  | 1120 |  | 5223.21 |  | 6967.55 |  | 3893.21 |  | 3918.36 |  | 2259.93 |  | 26026.82 |  | 3259.39 |  | 2694.49 |  | 1066.98 |  | 393.26
 |  |  | 1191 · Security Deposit Bank |  | 18208.53 |  | 18210.63 |  | 18212.95 |  | 18215.12 |  | 15717.3 |  | 15719.23 |  | 15721.11 |  | 15723.24 |  | 16725.19 |  | 14727.08
 |  | Total Checking/Savings
 |  | Accounts Receivable
 |  |  | 1130.1 · Tenant Rent Receivable (MPW) |  | 8268.33 |  | 2551.33 |  | 3466.83 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
 |  | Total Accounts Receivable
 |  | Other Current Assets
 |  |  | 1121.1 · Cash - Invested Operating Cash |  | 1188.12 |  | 1188.12 |  | 1188.12 |  | 1188.12 |  | 1188.12 |  | 1188.12 |  | 1188.12 |  | 1188.12 |  | 1188.12 |  | 1188.12
 |  |  | 1128 · [NAME] |  | -2000 |  | -1655 |  | -1400 |  | 0 |  | 0 |  | -861 |  | -292 |  | 0 |  | 0 |  | 0
 |  |  | 1130 · Tenant Rent Receivable |  | 0 |  | 0 |  | 0 |  | 4700.33 |  | 8499.21 |  | 4403.63 |  | 4184.63 |  | 5311.13 |  | 3168.71 |  | 4579.71
 |  |  | 1141 · A/R DHC |  | 3097.38 |  | 0 |  | 0 |  | 0 |  | 0 |  | 3097.38 |  | 0 |  | 0 |  | 0 |  | 0
 |  |  | 1152 · [NAME] |  | 17706.27 |  | 17706.27 |  | 17706.27 |  | 17706.27 |  | 17706.27 |  | 17581.66 |  | 17581.66 |  | 16583.27 |  | 16804.52 |  | 16804.52
 |  |  | 1154 · [NAME] |  | 1395 |  | 1395 |  | 1395 |  | 1395 |  | 1395 |  | 1395 |  | 1395 |  | 1395 |  | 1395 |  | 1395
 |  |  | 1155 · [NAME] |  | 52371.44 |  | 50371.44 |  | 50371.44 |  | 50371.44 |  | 50371.44 |  | 50371.44 |  | 50371.44 |  | 50371.44 |  | 50932.44 |  | 50932.44
 |  |  | 1160 · [NAME] |  | 3596.49 |  | 3596.49 |  | 3596.49 |  | 3596.49 |  | 3596.49 |  | 3596.49 |  | 3596.49 |  | 3596.49 |  | 3596.49 |  | 3596.49
 |  |  | 1161 · [NAME] |  | 0 |  | 0 |  | 0 |  | 0 |  | 1189.5 |  | 1189.5 |  | 1189.5 |  | 1189.5 |  | 1189.5 |  | 1189.5
 |  |  | 1220 · Prepaid Insurance |  | 12538.33 |  | 11871.66 |  | 11204.99 |  | 10538.32 |  | 9871.65 |  | 9204.98 |  | 8538.31 |  | 7871.64 |  | 7204.97 |  | 6538.3
 |  |  | 1310 · Tax & Insurance Escrow |  | 20617.34 |  | 22448.51 |  | 24279.68 |  | 26838.23 |  | 29396.78 |  | 31955.33 |  | 33445.44 |  | 34935.55 |  | 36425.66 |  | 37915.77
 |  |  | 1315 · [NAME] |  | 5750.14 |  | 6305.43 |  | 6860.72 |  | 7419.29 |  | 7977.86 |  | 8536.43 |  | 9086.76 |  | 9637.09 |  | 10187.42 |  | 10737.75
 |  |  | 1320 · Replacement Reserve |  | 43699.41 |  | 44574.41 |  | 45449.41 |  | 46324.41 |  | 47199.41 |  | 48074.41 |  | 48949.41 |  | 40444.26 |  | 41319.26 |  | 32798.83
 |  |  | 1321 · Restricted Reserve |  | 35.15 |  | 35.15 |  | 35.15 |  | 35.15 |  | 35.15 |  | 35.15 |  | 35.15 |  | 35.15 |  | 35.15 |  | 35.15
 |  | Total Other Current Assets
 | Total Current Assets
 | Fixed Assets
 |  | 1420 · Buildings |  |  | 6104266.04 |  | 6104266.04 |  | 6104266.04 |  | 6104266.04 |  | 6104266.04 |  | 6104266.04 |  | 6104266.04 |  | 6104266.04 |  | 6104266.04 |  | 6104266.04
 |  | 1495 · Accumulated Depreciation |  |  | -587160.46 |  | -587160.46 |  | -587160.46 |  | -587160.46 |  | -587160.46 |  | -587160.46 |  | -587160.46 |  | -587160.46 |  | -587160.46 |  | -587160.46
 | Total Fixed Assets
 | Other Assets
 |  | 1800 · Org costs |  |  | 59774.48 |  | 59774.48 |  | 59774.48 |  | 59774.48 |  | 59774.48 |  | 59774.48 |  | 59774.48 |  | 59774.48 |  | 59774.48 |  | 59774.48
 | Total Other Assets
TOTAL ASSETS
LIABILITIES & EQUITY
 | Liabilities
 |  | Current Liabilities
 |  |  | Accounts Payable
 |  |  |  | 2110 · Accounts Payable | 23363.9 |  | 19879.94 |  | 24202.8 |  | 16107.78 |  | 14481.46 |  | 16355.08 |  | 26688.6 |  | 13064.8 |  | 15549.17 |  | 5330.1
 |  |  | Total Accounts Payable
 |  |  | Other Current Liabilities
 |  |  |  | 1140 · [NAME] | -2693 |  | -3737 |  | -1627 |  | -2510 |  | -2471 |  | -3703 |  | -2954 |  | -2772 |  | 0 |  | 57
 |  |  |  | 1151 · [NAME] sdffff | 21889.97 |  | 21889.97 |  | 21889.97 |  | 21889.97 |  | 21889.97 |  | 21889.97 |  | 21889.97 |  | 21889.97 |  | 21344.97 |  | 21344.97
 |  |  |  | 2120 · Accured PILOT | 17890.87 |  | 18890.87 |  | 19890.87 |  | 20890.87 |  | 21890.87 |  | 22890.87 |  | 23890.87 |  | 24890.87 |  | 25890.87 |  | 26890.87
 |  |  |  | 2130.1 · Accrued Interest - | 7573.62 |  | 7573.62 |  | 7573.62 |  | 7573.62 |  | 7573.62 |  | 7573.62 |  | 7573.62 |  | 7573.62 |  | 7573.62 |  | 7573.62
 |  |  |  | 2130.2 · Accured Interest   242 | 319298.18 |  | 319298.18 |  | 319298.18 |  | 319298.18 |  | 319298.18 |  | 319298.18 |  | 319298.18 |  | 319298.18 |  | 319298.18 |  | 319298.18
 |  |  |  | 2130.3 · Accrued Interest  2233 | 44938.36 |  | 44938.36 |  | 44938.36 |  | 51438.4 |  | 51438.4 |  | 51438.4 |  | 51438.4 |  | 51438.4 |  | 51438.4 |  | 51438.4
 |  |  |  | 2150 · Accrued Expenses | 13779 |  | 13779 |  | 13779 |  | 13779 |  | 13779 |  | 13779 |  | 13779 |  | 17442.99 |  | 13779 |  | 13779
 |  |  |  | 2190 · Tenant Refunds Payable | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 96 |  | 96 |  | 96 |  | 96
 |  |  |  | 2191 · Security Deposits | 16492 |  | 15465 |  | 15465 |  | 15452 |  | 15452 |  | 15187 |  | 15078 |  | 14988 |  | 14143 |  | 13943
 |  |  |  | 2210 · PrePaid Rent | 1317.69 |  | 1513.29 |  | 2556.79 |  | 3156.87 |  | 5239.75 |  | 2631.67 |  | 2397.67 |  | 3898.67 |  | 5104.67 |  | 3766.67
 |  |  | Total Other Current Liabilities
 |  | Total Current Liabilities
 |  | Long Term Liabilities
 |  |  | 20-0500 · L/P Home loan |  | 500000 |  | 500000 |  | 500000 |  | 500000 |  | 500000 |  | 500000 |  | 500000 |  | 500000 |  | 500000 |  | 500000
 |  |  | 2320 · Mortgage |  | 1503732.55 |  | 1502766.82 |  | 1501796.23 |  | 1500820.75 |  | 1499840.36 |  | 1498855.04 |  | 1497864.76 |  | 1496869.49 |  | 1495869.21 |  | 1494863.9
 |  |  | 2320.1 · Second Mortgage |  | 1559212.53 |  | 1559212.53 |  | 1559212.53 |  | 1559212.53 |  | 1559212.53 |  | 1559212.53 |  | 1559212.53 |  | 1559212.53 |  | 1559212.53 |  | 1559212.53
 |  | Total Long Term Liabilities
 | Total Liabilities
 | Equity
 |  | 3135.2 · Partner 1 W Apts |  |  | 2741124.58 |  | 2741124.58 |  | 2741124.58 |  | 2741124.58 |  | 2741124.58 |  | 2766032.58 |  | 2741754.58 |  | 2741754.58 |  | 2741754.58 |  | 2741754.58
 |  | 3250 · [NAME] |  |  | -1001780.01 |  | -1001780.01 |  | -1001780.01 |  | -1001780.01 |  | -1001780.01 |  | -1001780.01 |  | -1001780.01 |  | -1001780.01 |  | -1001780.01 |  | -1001780.01
 |  | Net Income |  |  | 2434.96 |  | 1631.9 |  | -5180.6 |  | 2672.05 |  | 6314.46 |  | 8733.7 |  | -1097.7 |  | -9.66 |  | -1154.72 |  | 2143.17
 | Total Equity
TOTAL LIABILITIES & EQUITY