Spreadsheet: 83891d1283932254-billing-forecast-cash-flow-test
Sheet: Data Source

2010-08-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00
 |  |  |  |  |  | New
Job Summary No | Project Type | ODD Yr | Open Date Date (ODD - Proj/Act) | Closeout Package Submitted-Actual | Total Forecasted Cost (CW) | Adjustments | Total Projected (CW - Adj.) | Funded to date (CW-Capital) | Total Paid $ (CW-Capital) | 2010 YTD Implied Cash Flow- CW Capital | Payables Cash Flow - CW Capital | Adjustments - CW Capital | Management Fees - CW Capital | Amount Paid Prior to 2010- CW Capital | Amount Left to [NAME] | % Left to [NAME] | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2010 Capital Utilization
ATMNJ1099 | ATM | 2010 | 2010-09-15 00:00:00 |  | 39478 |  |  | 42900 |  | 8442.5 | 7675 | 0 | 767.5
NS08037 | New Store | 2010 | 2010-09-22 00:00:00 |  | 1984763.86 |  |  | 1953978 |  | 1062604.68 | 997750.87 | 0 | 64853.81 | 218048.69
NS07084 | New Store | 2010 | 2010-09-27 00:00:00 |  | 2129205.18 |  |  | 2138148.81 |  | 1383480.98 | 1300050.22 | 0 | 83430.76 | 182404.81
ATMCA1001 | ATM | 2010 | 2010-09-30 00:00:00 |  | 69786 |  |  | 17040 |  | 9655.17 | 9015.86 | 0 | 639.31
ATMCA1013 | ATM | 2010 | 2010-09-30 00:00:00 |  | 126507 |  |  | 132222 |  | 6755.65 | 6141.5 | 0 | 614.15
ATMNJ1062 | ATM | 2010 | 2010-10-14 00:00:00 |  | 211885 |  |  | 47300 |  | 15352.65 | 13956.95 | 0 | 1395.7
ATMCA8191 | ATM | 2010 | 2010-10-21 00:00:00 |  | 226312.36 |  |  | 239438 |  | 85842.33 | 80603.12 | 0 | 5239.21 | 32677.52
ATMNJ1100 | ATM | 2010 | 2010-10-25 00:00:00 |  | 19415 |  |  | 19800 |  | 9543.34 | 8675.76 | 0 | 867.58
ATMCA8171 | ATM | 2010 | 2010-10-28 00:00:00 |  | 142930 |  |  | 37489 |  | 12966.93 | 12175.52 | 0 | 791.41 | 10036.97
ATMMO1101 | ATM | 2010 | 2010-10-29 00:00:00 |  | 11365 |  |  | 114303.2 |  | 3151.5 | 2865 | 0 | 286.5
ATMNJ8049 | ATM | 2010 | 2010-11-01 00:00:00 |  | 201644.75 |  |  | 193208 |  | 7878.12 | 7397.3 | 0 | 480.82 | 67127.1
ATMNJ8075 | ATM | 2010 | 2010-11-01 00:00:00 |  | 185654.85 |  |  | 194176 |  | 8104.65 | 7610 | 0 | 494.65 | 59915.78
ATMNJ8106 | ATM | 2010 | 2010-11-09 00:00:00 |  | 237279.16 |  |  | 218013 |  | 24593.51 | 23092.5 | 0 | 1501.01 | 58126.59
ATMCA8181 | ATM | 2010 | 2010-11-10 00:00:00 |  | 30678.55 |  |  | 34268 |  | 0 |  |  |  | 17169.17
ATMCA1107 | ATM | 2010 | 2010-11-11 00:00:00 |  | 72928 |  |  | 17600 |  | 2596 | 2360 | 0 | 236
ATMCA8201 | ATM | 2010 | 2010-11-11 00:00:00 |  | 101720 |  |  | 22000 |  | 0
ATMCA1083 | ATM | 2010 | 2010-11-14 00:00:00 |  | 31150 |  |  | 22550 |  | 881.03 | 800.94 | 0 | 80.09
ATMNJ1152 | ATM | 2010 | 2010-11-15 00:00:00 |  | 94511 |  |  | 98670 |  | 11371.65 | 10337.86 | 0 | 1033.79
ATMCA1084 | ATM | 2010 | 2010-11-18 00:00:00 |  | 78068 |  |  | 17600 |  | 2871 | 2610 | 0 | 261
ATMCA8200 | ATM | 2010 | 2010-11-18 00:00:00 |  | 95502 |  |  | 22000 |  | 0
ATMNJ1176 | ATM | 2010 | 2010-11-22 00:00:00 |  | 17215 |  |  | 18700 |  | 9539.18 | 8671.98 | 0 | 867.2
ATMNJ1154 | ATM | 2010 | 2010-11-23 00:00:00 |  | 83755 |  |  | 25041.5 |  | 8795.23 | 7995.66 | 0 | 799.57
ATMCA9096 | ATM | 2010 | 2010-11-30 00:00:00 |  | 125199 |  |  | 17040 |  | 13788.58 | 12947.03 | 0 | 841.55
ATMAR1175 | ATM | 2010 | 2010-12-01 00:00:00 |  | 14164.5 |  |  | 31350 |  | 0
ATMCA8203 | ATM | 2010 | 2010-12-02 00:00:00 |  | 137130 |  |  | 17600 |  | 0
ATMCA1116 | ATM | 2010 | 2010-12-09 00:00:00 |  | 94187 |  |  | 17600 |  | 0
ATMNJ1153 | ATM | 2010 | 2010-12-11 00:00:00 |  | 110435 |  |  | 25371.5 |  | 8731.88 | 7938.07 | 0 | 793.81
ATMNJ1149 | ATM | 2010 | 2010-12-13 00:00:00 |  | 85737 |  |  | 14300 |  | 10847.02 | 9860.93 | 0 | 986.09
ATMCA1088 | ATM | 2010 | 2010-12-14 00:00:00 |  | 127600 |  |  | 17600 |  | 9924.6 | 9022.36 | 0 | 902.24
ATMCA1089 | ATM | 2010 | 2010-12-15 00:00:00 |  | 28920 |  |  | 29557 |  | 9018.12 | 8198.29 | 0 | 819.83
ATMCA1148 | ATM | 2010 | 2010-12-21 00:00:00 |  | 116708 |  |  | 116708.27 |  | 14333.16 | 13030.14 | 0 | 1303.02
ATMAZ8203 | ATM | 2010 | 2010-12-31 00:00:00 |  | 73700 |  |  | 25300 |  | 0
ATMCA1155 | ATM | 2010 | 2010-12-31 00:00:00 |  | 199048 |  |  | -47999.46 |  | -247047.76 | 0 | -247047.76 | 0
ATMKS8218 | ATM | 2010 | 2010-12-31 00:00:00 |  | 0 |  |  |  |  | 0
ATMIL9030 | ATM | 2010 | 2010-12-31 00:00:00 |  | 92578.2 |  |  | 107362 |  | 0 | 0 | 0 | 0 | 4988.75
TBD | ATM | 2010 | 2010-12-31 00:00:00 |  | 0
TBD | ATM | 2010 | 2010-12-31 00:00:00 |  | 0
TBD | ATM | 2010 | 2010-12-31 00:00:00 |  | 0
TBD | ATM | 2010 | 2010-12-31 00:00:00 |  | 60914
TBD | ATM | 2010 | 2010-12-31 00:00:00 |  | 110000
TBD | ATM | 2010 | 2010-12-31 00:00:00 |  | 0
TBD | ATM | 2010 | 2010-12-31 00:00:00 |  | 60111
TBD | ATM | 2010 | 2010-12-31 00:00:00
TBD | ATM | 2010 | 2010-12-31 00:00:00
TBD | ATM | 2010 | 2010-12-31 00:00:00
ATMNJ8219 | ATM | 2011 | 2011-01-18 00:00:00 |  | 110687 |  |  | 24937 |  | 0
ATMCA8072 | ATM | 2011 | 2011-01-20 00:00:00 |  | 134418.32 |  |  | 16122.29 |  | 873.3 | 820 | 0 | 53.3 | 7620.57
ATMCA8202 | ATM | 2011 | 2011-01-21 00:00:00 |  | 84600 |  |  | 17600 |  | 0
NS07106 | New Store | 2011 | 2011-01-25 00:00:00 |  | 2360924.48 |  |  | 266250 |  | 44498.43 | 41782.56 | 0 | 2715.87 | 149114.96
TBD | ATM | 2011 | 2011-02-07 00:00:00 |  | 125500
ATMCA8197 | ATM | 2011 | 2011-02-16 00:00:00 |  | 80540 |  |  | 34540 |  | 0 | 0 | 0 | 0
NS09002 | New Store | 2011 | 2011-02-22 00:00:00 |  | 2447202.8175 |  |  | 2459766.5 |  | 419423.52 | 393824.91 | 0 | 25598.61 | 97298.7
ATMCA7124 | ATM | 2011 | 2011-02-23 00:00:00 |  | 101255 |  |  | 39405 |  | 0 |  |  |  | 17040
ATMCA9024 | ATM | 2011 | 2011-02-24 00:00:00 |  | 145675 |  |  | 30353 |  | 21300 | 20000 | 0 | 1300 | 0
ATMNJ8122 | ATM | 2011 | 2011-03-05 00:00:00 |  | 207499.54 |  |  | 97981 |  | 6755.19 | 6342.9 | 0 | 412.29 | 57808.62
[NAME] | ATM | 2011 | 2011-03-14 00:00:00 |  | 21465 |  |  | 36730 |  | 0 |  |  |  | 339.35
NS08076 | New Store | 2011 | 2011-03-14 00:00:00 |  | 2658322.69 |  |  | 194363 |  | 111137.59 | 104354.55 | 0 | 6783.04 | 72497.42
NS08065 | New Store | 2011 | 2011-03-14 00:00:00 |  | 2820318.39 |  |  | 265718 |  | 65462.23 | 61466.88 | 0 | 3995.35 | 58329.77
ATMCA8213 | ATM | 2011 | 2011-03-31 00:00:00 |  | 94000 |  |  | 15400 |  | 0