WPCS International Inc.
|
Bond Holders - CR
|
||||||||||||||||||
Cash Forecast
|
|||||||||||||||||||
Weekly Forecast As of 11/01/13
|
|||||||||||||||||||
Actual Beginning
|
|||||||||||||||||||
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
|||||||||||
CONTROLLED ACCOUNTS
|
08/31/13
|
09/06/13
|
09/13/13
|
09/20/13
|
09/27/13
|
10/04/13
|
10/11/13
|
10/18/13
|
10/25/13
|
11/01/13
|
11/08/13
|
11/15/13
|
11/22/13
|
11/29/13
|
12/06/13
|
12/13/13
|
12/20/13
|
12/27/13
|
01/03/14
|
Beginning cash in Collateral
|
696,364
|
979,588
|
560,301
|
450,441
|
274,667
|
699,111
|
593,111
|
865,907
|
995,651
|
841,480
|
1,065,297
|
449,993
|
446,861
|
406,345
|
386,735
|
247,803
|
127,671
|
40,324
|
|
Transfers (to)/from Operating
|
(431,000)
|
(585,000)
|
(745,000)
|
(536,000)
|
(565,000)
|
(642,000)
|
(456,000)
|
(769,000)
|
(727,000)
|
(453,441)
|
(931,457)
|
(435,715)
|
(390,420)
|
(476,412)
|
(622,842)
|
(552,421)
|
(423,714)
|
(446,970)
|
|
Cash Receipts
|
714,224
|
165,713
|
635,140
|
360,226
|
989,445
|
536,000
|
728,796
|
898,744
|
572,829
|
677,258
|
316,154
|
432,583
|
349,904
|
456,803
|
483,910
|
432,288
|
336,366
|
527,019
|
|
Blue Chip Over 150 Days
|
0
|
0
|
1,463
|
0
|
878
|
5,888
|
0
|
3,367
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Blue Chip Over 90 Days - Under 150
|
33,325
|
948
|
26,075
|
0
|
0
|
78,711
|
0
|
0
|
34,867
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Blue Chip Under 90 Days
|
106,440
|
20,142
|
19,702
|
12,830
|
309,596
|
101,259
|
143,823
|
130,994
|
130,002
|
68,342
|
0
|
0
|
54,295
|
0
|
87,291
|
0
|
22,729
|
0
|
|
Collections Over 90 Days
|
46,360
|
3,500
|
35,416
|
48,212
|
2,664
|
143,742
|
115,458
|
7,174
|
21,436
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Collections Over 60 Days - Under 90
|
223,471
|
11,419
|
85,985
|
99,390
|
43,096
|
15,108
|
22,678
|
73,319
|
2,342
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Collections Under 60 Days
|
288,587
|
108,100
|
283,087
|
107,486
|
264,801
|
183,442
|
446,737
|
740,013
|
74,409
|
608,916
|
316,154
|
259,171
|
295,609
|
456,803
|
396,619
|
301,961
|
313,637
|
527,019
|
|
Collections Bonded Jobs
|
0
|
1,015
|
0
|
73,170
|
0
|
0
|
0
|
0
|
301,009
|
0
|
0
|
173,412
|
0
|
0
|
0
|
130,327
|
0
|
0
|
|
Miscellaneous - Non AR cash receipts
|
16,040
|
20,588
|
183,411
|
19,139
|
368,411
|
7,851
|
100
|
(56,123)
|
8,762
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
|
Unknown
|
|||||||||||||||||||
LOC Interest/Fees
|
0
|
0
|
0
|
0
|
0
|
||||||||||||||
Master Account Total
|
1,173,421.30
|
979,588
|
560,301
|
450,441
|
274,667
|
699,111
|
593,111
|
865,907
|
995,651
|
841,480
|
1,065,297
|
449,993
|
446,861
|
406,345
|
386,735
|
247,803
|
127,671
|
40,324
|
120,372
|
Qualified AR-BB Calc
|
4,054,151
|
4,054,151
|
4,054,151
|
4,054,151
|
4,054,151
|
4,054,151
|
4,272,379
|
4,272,379
|
4,272,379
|
4,272,379
|
3,901,171
|
3,901,171
|
3,901,171
|
3,901,171
|
3,901,171
|
3,734,265
|
3,734,265
|
3,734,265
|
|
Qualified AR x 95%
|
3,851,444
|
3,851,444
|
3,851,444
|
3,851,444
|
3,851,444
|
3,851,444
|
4,058,760
|
4,058,760
|
4,058,760
|
4,058,760
|
3,706,112
|
3,706,112
|
3,706,112
|
3,706,112
|
3,706,112
|
3,547,552
|
3,547,552
|
3,547,552
|
|
Reserves and/or holdbacks:
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
|
Principal Balance
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
(3,406,077)
|
|
Interest on Principal
|
(13,632)
|
(16,290)
|
(18,947)
|
(21,606)
|
(24,269)
|
(26,936)
|
(29,603)
|
(32,270)
|
(378)
|
(3,028)
|
(5,677)
|
(8,326)
|
(10,975)
|
(13,632)
|
(16,290)
|
(18,947)
|
(21,606)
|
(24,269)
|
|
Net Available to Borrow
|
1,161,324
|
739,378
|
626,861
|
448,428
|
870,209
|
761,543
|
1,238,988
|
1,366,065
|
1,243,785
|
1,464,952
|
494,352
|
488,570
|
445,405
|
423,139
|
281,549
|
199
|
(89,807)
|
(12,421)
|
|
DISBURSEMENTS
|
|||||||||||||||||||
Recurring Monthly Payments:
|
|||||||||||||||||||
Facility Rent
|
11,651
|
0
|
0
|
0
|
23,665
|
0
|
0
|
0
|
23,755
|
0
|
0
|
0
|
0
|
23,965
|
0
|
0
|
0
|
23,965
|
|
Utilities, Auto leases, Comcast
|
4,549
|
0
|
3,500
|
882
|
1,000
|
3,552
|
0
|
4,382
|
547
|
7,260
|
0
|
4,382
|
0
|
2,000
|
5,260
|
882
|
3,500
|
2,000
|
|
Bank Fees / Veh. Equip Lease
|
1,648
|
14,279
|
1,515
|
0
|
656
|
4,865
|
8,226
|
0
|
3,600
|
2,562
|
8,800
|
0
|
0
|
6,162
|
8,000
|
0
|
0
|
3,600
|
|
Credit Cards (AMEX, BOA, Gas)
|
0
|
57,515
|
40,227
|
0
|
0
|
20,054
|
16,689
|
51,993
|
0
|
28,606
|
174,000
|
55,200
|
0
|
8,500
|
44,000
|
9,000
|
42,000
|
0
|
|
Interest, Consent Fees, Sales Tax, Franchise Tax
|
0
|
0
|
3,741
|
7,297
|
102,182
|
0
|
0
|
5,000
|
74,988
|
0
|
0
|
5,000
|
6,000
|
0
|
0
|
5,000
|
5,600
|
33,497
|
|
SUBTOTAL RECURRING PAYMENTS
|
17,848
|
71,795
|
48,983
|
8,179
|
127,503
|
28,471
|
24,915
|
61,375
|
102,890
|
38,428
|
182,800
|
64,582
|
6,000
|
40,627
|
57,260
|
14,882
|
51,100
|
63,062
|
|
|
|||||||||||||||||||
Payroll & Benefits:
|
|||||||||||||||||||
Payroll
|
125,315
|
194,108
|
126,828
|
194,658
|
108,650
|
162,711
|
150,735
|
153,195
|
147,139
|
169,540
|
163,800
|
160,300
|
160,300
|
160,300
|
157,071
|
154,471
|
117,071
|
192,571
|
|
PR Taxes & Fees
|
75,268
|
44,454
|
61,446
|
51,243
|
61,162
|
41,034
|
61,875
|
42,200
|
149,348
|
49,016
|
72,407
|
52,341
|
70,348
|
48,841
|
70,348
|
50,832
|
72,332
|
50,839
|
|
Union Dues & Fringes
|
15,000
|
16,217
|
295,155
|
94,973
|
1,984
|
0
|
189,783
|
79,251
|
0
|
0
|
257,367
|
25,158
|
0
|
0
|
151,418
|
136,000
|
30,000
|
0
|
|
Admin Health Insurance
|
0
|
25,647
|
0
|
7,395
|
0
|
1,932
|
23,872
|
0
|
9,212
|
0
|
22,058
|
5,235
|
0
|
0
|
18,558
|
10,735
|
0
|
0
|
|
Admin Simple Plan & 401K
|
0
|
2,020
|
2,826
|
5,839
|
577
|
2,402
|
14,529
|
2,356
|
4,019
|
2,387
|
4,591
|
2,384
|
544
|
6,428
|
4,588
|
2,384
|
544
|
6,675
|
|
Garnishments
|
497
|
703
|
1,571
|
1,196
|
1,506
|
1,977
|
1,521
|
1,977
|
1,506
|
1,971
|
1,462
|
1,978
|
1,528
|
1,978
|
1,528
|
1,978
|
1,528
|
1,978
|
|
Delinquent PR Taxes
|
21,562
|
21,562
|
21,562
|
21,562
|
21,562
|
21,554
|
15,493
|
15,493
|
15,493
|
28,004
|
15,493
|
15,493
|
15,493
|
15,493
|
15,493
|
11,962
|
11,962
|
11,962
|
|
SUBTOTAL PAYROLL & BENEFITS
|
237,642
|
304,712
|
509,388
|
376,865
|
195,441
|
231,610
|
457,808
|
294,472
|
326,716
|
250,919
|
537,178
|
262,889
|
248,213
|
233,040
|
419,005
|
368,362
|
233,437
|
264,025
|
|
Vendors to be Paid
|
100,083
|
75,133
|
34,753
|
50,052
|
68,079
|
56,304
|
40,530
|
47,806
|
101,992
|
68,114
|
52,380
|
51,144
|
59,369
|
75,645
|
34,477
|
57,077
|
27,077
|
32,783
|
|
7,232
|
0
|
0
|
0
|
0
|
14,666
|
300
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
||
34,500
|
0
|
0
|
3,181
|
0
|
0
|
0
|
0
|
759
|
9,978
|
0
|
0
|
1,738
|
0
|
0
|
0
|
0
|
0
|
||
2,916
|
0
|
0
|
0
|
5,002
|
11,207
|
13,045
|
16,070
|
4,858
|
1,741
|
0
|
5,000
|
5,000
|
0
|
0
|
0
|
0
|
0
|
||
964
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
||
1,561
|
8,600
|
0
|
0
|
269
|
1,739
|
0
|
0
|
50
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
||
99,475
|
90,145
|
165,800
|
170,034
|
233,163
|
145,454
|
151,583
|
80,542
|
186,140
|
77,162
|
152,000
|
45,000
|
63,000
|
120,000
|
105,000
|
105,000
|
105,000
|
80,000
|
||
All other vendors/suppliers
|
4,144
|
7,167
|
8,500
|
0
|
2,194
|
3,734
|
0
|
38,048
|
6,054
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
|
SUBTOTAL VENDOR PAYMENTS
|
250,875
|
181,045
|
209,053
|
223,268
|
308,707
|
233,104
|
205,458
|
182,467
|
299,853
|
164,094
|
211,480
|
108,244
|
136,207
|
202,745
|
146,577
|
169,177
|
139,177
|
119,883
|
|
Subtotal Disbursements
|
506,365
|
557,551
|
767,423
|
608,312
|
631,650
|
493,185
|
688,181
|
538,313
|
729,459
|
453,441
|
931,457
|
435,715
|
390,420
|
476,412
|
622,842
|
552,421
|
423,714
|
446,970
|
|
Total Forecast Disbursements
|
506,365
|
557,551
|
767,423
|
608,312
|
631,650
|
493,185
|
688,181
|
538,313
|
729,459
|
453,441
|
931,457
|
435,715
|
390,420
|
476,412
|
622,842
|
552,421
|
423,714
|
446,970
|
|
SUMMARY
|
|||||||||||||||||||
Current Projection 11/1/13
|
|||||||||||||||||||
Beginning of Week Cash in Collateral Account
|
696,364
|
979,588
|
560,301
|
450,441
|
274,667
|
699,111
|
593,111
|
865,907
|
995,651
|
841,480
|
1,065,297
|
449,993
|
446,861
|
406,345
|
386,735
|
247,803
|
127,671
|
40,324
|
|
Receipts
|
714,224
|
165,713
|
635,140
|
360,226
|
989,445
|
536,000
|
728,796
|
898,744
|
572,829
|
677,258
|
316,154
|
432,583
|
349,904
|
456,803
|
483,910
|
432,288
|
336,366
|
527,019
|
|
Borrow (Disbursements for the Week)
|
(431,000)
|
(585,000)
|
(745,000)
|
(536,000)
|
(565,000)
|
(642,000)
|
(456,000)
|
(769,000)
|
(727,000)
|
(453,441)
|
(931,457)
|
(435,715)
|
(390,420)
|
(476,412)
|
(622,842)
|
(552,421)
|
(423,714)
|
(446,970)
|
|
Ending Cash Balance
|
979,588
|
560,301
|
450,441
|
274,667
|
699,111
|
593,111
|
865,907
|
995,651
|
841,480
|
1,065,297
|
449,993
|
446,861
|
406,345
|
386,735
|
247,803
|
127,671
|
40,324
|
120,372
|
|
Cumulative
|
|||||||||||||||||||
Cumulative Reciepts
|
714,224
|
879,937
|
1,515,077
|
1,875,302
|
2,864,747
|
3,400,747
|
4,129,543
|
5,028,287
|
5,601,116
|
6,278,373
|
6,594,527
|
7,027,110
|
7,377,014
|
7,833,817
|
8,317,727
|
8,750,015
|
9,086,382
|
9,613,400
|
|
Cumulative Disbursements/Draws
|
(431,000)
|
(1,016,000)
|
(1,761,000)
|
(2,297,000)
|
(2,862,000)
|
(3,504,000)
|
(3,960,000)
|
(4,729,000)
|
(5,456,000)
|
(5,909,441)
|
(6,840,898)
|
(7,276,614)
|
(7,667,034)
|
(8,143,446)
|
(8,766,287)
|
(9,318,708)
|
(9,742,422)
|
(10,189,392)
|
|
Net Cash Flow
|
283,224
|
(136,063)
|
(245,923)
|
(421,698)
|
2,747
|
(103,253)
|
169,543
|
299,287
|
145,116
|
368,933
|
(246,371)
|
(249,504)
|
(290,019)
|
(309,629)
|
(448,561)
|
(568,693)
|
(656,040)
|
(575,992)
|
|
Prior Projection 10/18/13
|
|||||||||||||||||||
Beginning of Week Cash in Collateral Account
|
696,364
|
979,588
|
560,301
|
450,441
|
274,667
|
699,111
|
593,111
|
865,907
|
756,911
|
708,210
|
813,869
|
477,459
|
487,922
|
476,581
|
595,687
|
291,153
|
239,306
|
248,794
|
|
Receipts
|
714,224
|
165,713
|
635,140
|
360,226
|
989,445
|
536,000
|
728,796
|
674,380
|
557,636
|
493,062
|
368,463
|
472,583
|
369,966
|
538,260
|
277,072
|
423,508
|
410,536
|
621,825
|
|
Borrow (Disbursements for the Week)
|
(431,000)
|
(585,000)
|
(745,000)
|
(536,000)
|
(565,000)
|
(642,000)
|
(456,000)
|
(783,376)
|
(606,338)
|
(387,402)
|
(704,874)
|
(462,119)
|
(381,308)
|
(419,154)
|
(581,606)
|
(475,355)
|
(401,048)
|
(583,074)
|
|
Ending Cash Balance
|
979,588
|
560,301
|
450,441
|
274,667
|
699,111
|
593,111
|
865,907
|
756,911
|
708,210
|
813,869
|
477,459
|
487,922
|
476,581
|
595,687
|
291,153
|
239,306
|
248,794
|
287,545
|
|
Cumulative
|
|||||||||||||||||||
Cumulative Reciepts
|
714,224
|
879,937
|
1,515,077
|
1,875,302
|
2,864,747
|
3,400,747
|
4,129,543
|
4,803,923
|
5,361,559
|
5,854,621
|
6,223,085
|
6,695,668
|
7,065,634
|
7,603,893
|
7,880,965
|
8,304,473
|
8,715,009
|
9,336,834
|
|
Cumulative Disbursements/Draws
|
(431,000)
|
(1,016,000)
|
(1,761,000)
|
(2,297,000)
|
(2,862,000)
|
(3,504,000)
|
(3,960,000)
|
(4,743,376)
|
(5,349,714)
|
(5,737,116)
|
(6,441,990)
|
(6,904,109)
|
(7,285,417)
|
(7,704,571)
|
(8,286,176)
|
(8,761,532)
|
(9,162,580)
|
(9,745,654)
|
|
Net Cash Flow
|
283,224
|
(136,063)
|
(245,923)
|
(421,698)
|
2,747
|
(103,253)
|
169,543
|
60,547
|
11,845
|
117,505
|
(218,906)
|
(208,442)
|
(219,783)
|
(100,677)
|
(405,211)
|
(457,058)
|
(447,570)
|
(408,820)
|
|
Current Projection vs 10/18/13
|
|||||||||||||||||||
Receipts
|
|||||||||||||||||||
Current Projection
|
714,224
|
165,713
|
635,140
|
360,226
|
989,445
|
536,000
|
728,796
|
898,744
|
572,829
|
677,258
|
316,154
|
432,583
|
349,904
|
456,803
|
483,910
|
432,288
|
336,366
|
527,019
|
|
10/18/13 Forecast
|
714,224
|
165,713
|
635,140
|
360,226
|
989,445
|
536,000
|
728,796
|
674,380
|
557,636
|
493,062
|
368,463
|
472,583
|
369,966
|
538,260
|
277,072
|
423,508
|
410,536
|
621,825
|
|
Over/(Under)
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
224,364
|
15,192
|
184,196
|
(52,309)
|
(40,001)
|
(20,062)
|
(81,457)
|
206,838
|
8,780
|
(74,170)
|
(94,806)
|
|
Cumulative
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
224,364
|
239,556
|
423,752
|
371,443
|
331,442
|
311,380
|
229,923
|
436,762
|
445,542
|
371,372
|
276,566
|
|
Disbursements
|
|||||||||||||||||||
Current Projection
|
(431,000)
|
(585,000)
|
(745,000)
|
(536,000)
|
(565,000)
|
(642,000)
|
(456,000)
|
(769,000)
|
(727,000)
|
(453,441)
|
(931,457)
|
(435,715)
|
(390,420)
|
(476,412)
|
(622,842)
|
(552,421)
|
(423,714)
|
(446,970)
|
|
10/18/13 Forecast
|
(431,000)
|
(585,000)
|
(745,000)
|
(536,000)
|
(565,000)
|
(642,000)
|
(456,000)
|
(783,376)
|
(606,338)
|
(387,402)
|
(704,874)
|
(462,119)
|
(381,308)
|
(419,154)
|
(581,606)
|
(475,355)
|
(401,048)
|
(583,074)
|
|
Over/(Under)
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
14,376
|
(120,662)
|
(66,039)
|
(226,583)
|
26,404
|
(9,112)
|
(57,259)
|
(41,236)
|
(77,066)
|
(22,666)
|
136,104
|
|
Cumulative
|
0
|
0
|
0
|
0
|
0
|
0
|
0
|
14,376
|
(106,286)
|
(172,325)
|
(398,908)
|
(372,504)
|
(381,616)
|
(438,875)
|
(480,111)
|
(557,177)
|
(579,843)
|
(443,738)
|
WPCS Consolidated Sovereign Accounts
|
||||||||||||||||||||||
Cash Forecast
|
||||||||||||||||||||||
Weekly Forecast As of 11/01/13
|
||||||||||||||||||||||
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
||||
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
||||
8/31/2013
|
9/6/2013
|
9/13/2013
|
9/20/2013
|
9/27/2013
|
10/4/2013
|
10/11/2013
|
10/18/2013
|
10/25/2013
|
11/1/2013
|
11/8/2013
|
11/15/2013
|
11/22/2013
|
11/29/2013
|
12/6/2013
|
12/13/2013
|
12/20/2013
|
12/27/2013
|
1/3/2014
|
Totals
|
|||
Receipts
|
||||||||||||||||||||||
Bank Statement Balance
|
743,005
|
|||||||||||||||||||||
Less: Outstanding Checks ( )
|
(268,851)
|
|||||||||||||||||||||
Add: Deposits In Transit
|
-
|
|||||||||||||||||||||
Adjusted Opening Cash Balance
|
474,154
|
|||||||||||||||||||||
Cash Receipts
|
||||||||||||||||||||||
Blue Chip Over 150 Days
|
-
|
-
|
-
|
1,463
|
-
|
878
|
5,888
|
-
|
3,367
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
11,595
|
||
Blue Chip Over 90 Days-Under 150 Days
|
-
|
33,325
|
-
|
26,075
|
-
|
-
|
78,711
|
-
|
-
|
34,867
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
172,978
|
||
Blue Chip Under 90 Days
|
-
|
106,440
|
20,142
|
19,702
|
12,830
|
309,596
|
101,259
|
143,823
|
130,994
|
130,002
|
68,342
|
-
|
-
|
54,295
|
-
|
87,291
|
-
|
22,729
|
-
|
1,207,445
|
||
Remaining AR Over 90 Days
|
-
|
45,082
|
3,500
|
35,416
|
48,212
|
2,664
|
143,742
|
115,458
|
7,174
|
21,436
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
422,684
|
||
Remaining AR Over 60 and Under 90 Days
|
-
|
223,471
|
11,419
|
85,985
|
99,390
|
43,096
|
15,108
|
22,678
|
73,319
|
2,342
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
576,808
|
||
Remaining AR Under 60 Days
|
-
|
289,865
|
109,048
|
283,087
|
107,486
|
264,801
|
183,442
|
446,737
|
740,013
|
74,409
|
608,916
|
316,154
|
259,171
|
295,609
|
456,803
|
396,619
|
301,961
|
313,637
|
527,019
|
5,974,777
|
||
Collections Bonded Jobs
|
-
|
15,000
|
-
|
-
|
73,170
|
-
|
-
|
-
|
-
|
301,009
|
-
|
-
|
173,412
|
-
|
-
|
-
|
130,327
|
-
|
-
|
692,918
|
||
Miscellaneous - Non AR cash receipts
|
-
|
1,040
|
21,268
|
183,411
|
19,139
|
368,411
|
7,851
|
100
|
(56,123)
|
8,762
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
553,859
|
||
Subtotal Receipts
|
-
|
714,224
|
165,378
|
635,140
|
360,226
|
989,445
|
536,000
|
728,796
|
898,744
|
572,829
|
677,258
|
316,154
|
432,583
|
349,904
|
456,803
|
483,910
|
432,288
|
336,366
|
527,019
|
9,613,065
|
9,613,065
|
|
Trans from Hudson Bay
|
714,224
|
165,378
|
635,140
|
360,226
|
989,444
|
536,000
|
728,796
|
674,380
|
557,636
|
493,062
|
368,463
|
472,583
|
369,966
|
538,260
|
277,072
|
423,508
|
410,536
|
621,825
|
9,336,499
|
9,336,499
|
||
Cash Disbursements
|
Less trans from Hudson Bay
|
-
|
276,566
|
|||||||||||||||||||
Recurring Monthly Payments:
|
-
|
-
|
||||||||||||||||||||
Facility Rent
|
-
|
11,651
|
-
|
-
|
-
|
23,665
|
-
|
-
|
-
|
23,755
|
-
|
-
|
-
|
-
|
23,965
|
-
|
-
|
-
|
23,965
|
107,001
|
||
Utilities, Auto leases, Comcast
|
-
|
4,549
|
-
|
3,500
|
882
|
1,000
|
3,552
|
-
|
4,382
|
547
|
7,260
|
-
|
4,382
|
-
|
2,000
|
5,260
|
882
|
3,500
|
2,000
|
43,696
|
||
Bank Fees / Veh. Equip Lease
|
-
|
1,648
|
14,279
|
1,515
|
-
|
656
|
4,865
|
8,226
|
-
|
3,600
|
2,562
|
8,800
|
-
|
-
|
6,162
|
8,000
|
-
|
-
|
3,600
|
63,913
|
||
LOC Principal / Credit Cards (AMEX, BOA, Gas)
|
-
|
-
|
57,515
|
40,227
|
-
|
-
|
20,054
|
16,689
|
51,993
|
-
|
28,606
|
174,000
|
55,200
|
-
|
8,500
|
44,000
|
9,000
|
42,000
|
-
|
547,784
|
||
Interest, Consent Fees, Sales Tax, Franchise Tax
|
-
|
-
|
-
|
3,741
|
7,297
|
102,182
|
-
|
-
|
5,000
|
74,988
|
-
|
-
|
5,000
|
6,000
|
-
|
-
|
5,000
|
5,600
|
33,497
|
248,305
|
||
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
|||
Payroll & Benefits:
|
-
|
-
|
||||||||||||||||||||
Payroll
|
-
|
125,315
|
194,108
|
126,828
|
194,658
|
108,650
|
162,711
|
150,735
|
153,195
|
147,139
|
169,540
|
163,800
|
160,300
|
160,300
|
160,300
|
157,071
|
154,471
|
117,071
|
192,571
|
2,798,762
|
||
PR Taxes & Fees
|
-
|
75,268
|
44,454
|
61,446
|
51,243
|
61,162
|
41,034
|
61,875
|
42,200
|
149,348
|
49,016
|
72,407
|
52,341
|
70,348
|
48,841
|
70,348
|
50,832
|
72,332
|
50,839
|
1,125,333
|
||
Union Dues & Fringes
|
-
|
15,000
|
16,217
|
295,155
|
94,973
|
1,984
|
-
|
189,783
|
79,251
|
-
|
-
|
257,367
|
25,158
|
-
|
-
|
151,418
|
136,000
|
30,000
|
-
|
1,292,307
|
||
Admin Health Insurance
|
-
|
-
|
25,647
|
-
|
7,395
|
-
|
1,932
|
23,872
|
-
|
9,212
|
-
|
22,058
|
5,235
|
-
|
-
|
18,558
|
10,735
|
-
|
-
|
124,645
|
||
Admin Simple Plan & 401K
|
-
|
-
|
2,020
|
2,826
|
5,839
|
577
|
2,402
|
14,529
|
2,356
|
4,019
|
2,387
|
4,591
|
2,384
|
544
|
6,428
|
4,588
|
2,384
|
544
|
6,675
|
65,095
|
||
Garnishments
|
-
|
497
|
703
|
1,571
|
1,196
|
1,506
|
1,977
|
1,521
|
1,977
|
1,506
|
1,971
|
1,462
|
1,978
|
1,528
|
1,978
|
1,528
|
1,978
|
1,528
|
1,978
|
28,382
|
||
-
|
21,562
|
21,562
|
21,562
|
21,562
|
21,562
|
21,554
|
15,493
|
15,493
|
15,493
|
28,004
|
15,493
|
15,493
|
15,493
|
15,493
|
15,493
|
11,962
|
11,962
|
11,962
|
317,198
|
|||
Vendors to be Paid
|
-
|
-
|
||||||||||||||||||||
WPCS CORPORATE
|
-
|
100,083
|
75,133
|
34,753
|
50,052
|
68,079
|
56,304
|
40,530
|
47,806
|
101,992
|
68,114
|
52,380
|
51,144
|
59,369
|
75,645
|
34,477
|
57,077
|
27,077
|
32,783
|
1,032,799
|
||
-
|
7,232
|
-
|
-
|
-
|
-
|
14,666
|
300
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
22,198
|
|||
-
|
34,500
|
-
|
-
|
3,181
|
-
|
-
|
-
|
-
|
759
|
9,978
|
-
|
-
|
1,738
|
-
|
-
|
-
|
-
|
-
|
50,156
|
|||
-
|
2,916
|
-
|
-
|
-
|
5,002
|
11,207
|
13,045
|
16,070
|
4,858
|
1,741
|
-
|
5,000
|
5,000
|
-
|
-
|
-
|
-
|
-
|
64,838
|
|||
-
|
964
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
964
|
|||
-
|
1,561
|
8,600
|
-
|
-
|
269
|
1,739
|
-
|
-
|
50
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
12,219
|
|||
-
|
99,475
|
90,145
|
165,800
|
170,034
|
233,163
|
145,454
|
151,583
|
80,542
|
186,140
|
77,162
|
152,000
|
45,000
|
63,000
|
120,000
|
105,000
|
105,000
|
105,000
|
80,000
|
2,174,498
|
|||
All other vendors/suppliers
|
-
|
4,144
|
7,167
|
8,500
|
-
|
2,194
|
3,734
|
-
|
38,048
|
6,054
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
7,100
|
133,741
|
||
-
|
||||||||||||||||||||||
Subtotal Disbursements
|
-
|
506,365
|
557,551
|
767,423
|
608,312
|
631,650
|
493,185
|
688,181
|
538,313
|
729,459
|
453,441
|
931,457
|
435,715
|
390,420
|
476,412
|
622,842
|
552,421
|
423,714
|
446,970
|
10,253,832
|
10,253,832
|
|
10/18/2013
|
506,365
|
557,551
|
767,423
|
608,312
|
631,650
|
493,185
|
688,181
|
554,376
|
606,338
|
387,402
|
704,874
|
462,119
|
381,308
|
419,154
|
581,606
|
475,355
|
401,048
|
583,074
|
9,809,322
|
|||
(444,510)
|
||||||||||||||||||||||
Ending Cash
|
474,154
|
207,859
|
91,150
|
114,929
|
(110,435)
|
122,536
|
(11,893)
|
14,358
|
100,924
|
59,005
|
253,788
|
(115,424)
|
(138,675)
|
(136,967)
|
(240,562)
|
(401,009)
|
(421,417)
|
(526,940)
|
(474,377)
|
(640,767)
|
||
Net Weekly Cash Flow
|
207,859
|
(392,173)
|
(132,284)
|
(248,087)
|
357,794
|
42,815
|
40,615
|
360,431
|
(156,631)
|
223,817
|
(615,303)
|
(3,133)
|
(40,516)
|
(19,610)
|
(138,931)
|
(120,132)
|
(87,347)
|
80,049
|
(582,264)
|
|||
Cumulative Cash Flow
|
207,859
|
(184,314)
|
(316,598)
|
(564,684)
|
(206,890)
|
(164,075)
|
(123,460)
|
236,971
|
80,341
|
304,158
|
(311,146)
|
(314,278)
|
(354,794)
|
(374,404)
|
(513,336)
|
(633,468)
|
(720,815)
|
(640,767)
|
-
|
|||
(254,142)
|
(388,571)
|
(362,320)
|
(275,754)
|
(317,673)
|
(122,890)
|
(642,103)
|
(665,353)
|
(663,645)
|
(767,240)
|
(927,687)
|
(948,095)
|
(1,053,619)
|
(1,001,055)
|
|||||||||
47,252
|
224,497
|
238,861
|
512,725
|
398,014
|
427,048
|
330,957
|
351,075
|
308,851
|
392,836
|
414,351
|
314,627
|
332,803
|
360,288
|
|||||||||
CONTROLLED ACCOUNTS
|
||||||||||||||||||||||
Cash Balance in Controlled Accounts
|
2,026,354
|
2,026,354
|
2,026,354
|
2,026,354
|
2,562,355
|
3,291,151
|
4,189,894
|
4,762,723
|
5,439,981
|
5,756,135
|
6,188,718
|
6,538,622
|
6,995,424
|
7,479,334
|
7,911,623
|
8,247,989
|
8,775,008
|
|||||
Collections
|
-
|
-
|
-
|
-
|
0
|
0
|
0
|
224,364
|
15,192
|
199,388
|
147,079
|
107,078
|
(20,062)
|
(101,519)
|
105,319
|
114,100
|
39,930
|
(94,806)
|
||||
Qualified AR x 95%
|
3,285,816
|
3,285,816
|
3,285,816
|
3,285,816
|
3,285,816
|
3,285,816
|
3,285,816
|
2,996,436
|
2,996,436
|
2,996,436
|
2,996,436
|
3,121,375
|
3,121,375
|
3,121,375
|
3,121,375
|
3,121,375
|
3,365,015
|
|||||
Reserves and/or holdbacks:
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
(250,000)
|
|||
Principal Balance
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
4,000,000
|
|||
Available to Borrow
|
(250,000)
|
(250,000)
|
1,062,171
|
1,062,171
|
1,062,171
|
1,062,171
|
1,598,172
|
2,326,967
|
3,450,075
|
3,524,351
|
4,385,805
|
4,649,650
|
5,042,232
|
5,389,935
|
5,765,280
|
6,456,029
|
6,897,098
|
7,159,294
|
7,795,217
|
|||
OPERATING ACCOUNTS
|
||||||||||||||||||||||
Beginning Operating Cash Balance
|
474,154
|
|||||||||||||||||||||
Less Outstanding Checks
|
||||||||||||||||||||||
Available to Borrow
|
(250,000)
|
(250,000)
|
1,062,171
|
1,062,171
|
1,062,171
|
1,062,171
|
1,598,172
|
2,326,967
|
3,450,075
|
3,524,351
|
4,385,805
|
4,649,650
|
5,042,232
|
5,389,935
|
5,765,280
|
6,456,029
|
6,897,098
|
7,159,294
|
7,795,217
|
|||
Total Cash for Disbursements
|
224,154
|
(250,000)
|
1,062,171
|
1,062,171
|
1,062,171
|
1,062,171
|
1,598,172
|
2,326,967
|
3,450,075
|
3,524,351
|
4,385,805
|
4,649,650
|
5,042,232
|
5,389,935
|
5,765,280
|
6,456,029
|
6,897,098
|
7,159,294
|
7,795,217
|
|||
Amount Drawn
|
714,224
|
165,378
|
635,140
|
360,226
|
989,444
|
536,000
|
728,796
|
674,380
|
557,636
|
493,062
|
368,463
|
472,583
|
369,966
|
538,260
|
277,072
|
423,508
|
410,536
|
621,825
|
||||
Disbursements
|
(506,365)
|
(1,063,916)
|
(1,831,339)
|
(2,439,651)
|
(3,071,301)
|
(3,564,487)
|
(4,252,667)
|
(4,790,980)
|
(5,520,440)
|
(5,973,880)
|
(6,905,338)
|
(7,341,053)
|
(7,731,473)
|
(8,207,886)
|
(8,830,727)
|
(9,383,148)
|
(9,806,862)
|
(10,253,832)
|
Subsidiary: WPCS
|
||||||||||||||||||||||
Cash Forecast
|
||||||||||||||||||||||
Weekly Forecast As of 11/01/13
|
||||||||||||||||||||||
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
||||
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
18 Week
|
|||
8/31/2013
|
9/6/2013
|
9/13/2013
|
9/20/2013
|
9/27/2013
|
10/4/2013
|
10/11/2013
|
10/18/2013
|
10/25/2013
|
11/1/2013
|
11/8/2013
|
11/15/2013
|
11/22/2013
|
11/29/2013
|
12/6/2013
|
12/13/2013
|
12/20/2013
|
12/27/2013
|
1/3/2014
|
Totals
|
|||
Receipts
|
||||||||||||||||||||||
Bank Statement Balance
|
495,758
|
|||||||||||||||||||||
Less: Outstanding Checks ( )
|
-
|
|||||||||||||||||||||
Add: Deposits In Transit
|
||||||||||||||||||||||
Adjusted Opening Cash Balance
|
495,758
|
|||||||||||||||||||||
Cash Receipts
|
||||||||||||||||||||||
Blue Chip Over 150 Days
|
-
|
|||||||||||||||||||||
Blue Chip Over 90 Days-Under 150 Days
|
-
|
|||||||||||||||||||||
Blue Chip Under 90 Days
|
-
|
|||||||||||||||||||||
Remaining AR Over 90 Days
|
-
|
|||||||||||||||||||||
Remaining AR Over 60 and Under 90 Days
|
-
|
|||||||||||||||||||||
Remaining AR Under 60 Days
|
-
|
|||||||||||||||||||||
Collections Bonded Jobs
|
-
|
|||||||||||||||||||||
Miscellaneous - Non AR cash receipts
|
367,981
|
367,981
|
||||||||||||||||||||
Subtotal Receipts
|
-
|
-
|
-
|
-
|
-
|
367,981
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
367,981
|
367,981
|
|
367,981
|
367,981
|
367,981
|
||||||||||||||||||||
Cash Disbursements
|
-
|
0
|
||||||||||||||||||||
Recurring Monthly Payments:
|
-
|
|||||||||||||||||||||
Facility Rent
|
5,325
|
5,250
|
5,274
|
5,274
|
21,124
|
|||||||||||||||||
Auto leases
|
882
|
882
|
882
|
882
|
3,527
|
|||||||||||||||||
Account Analysis Fees
|
8,772
|
8,226
|
8,800
|
8,000
|
33,798
|
|||||||||||||||||
LOC Principal/legal, etc
|
150,000
|
150,000
|
||||||||||||||||||||
Quarterly Interest and Consent Fees
|
102,182
|
64,834
|
167,017
|
|||||||||||||||||||
-
|
||||||||||||||||||||||
Payroll & Benefits:
|
-
|
|||||||||||||||||||||
Payroll
|
41,917
|
41,101
|
38,902
|
40,607
|
3,381
|
41,900
|
1,900
|
41,900
|
1,900
|
41,900
|
1,900
|
1,900
|
40,000
|
339,208
|
||||||||
PR Taxes & Fees
|
79
|
14
|
79
|
90
|
52
|
79
|
72
|
79
|
72
|
79
|
72
|
79
|
72
|
72
|
79
|
1,068
|
||||||
Union Dues & Fringes
|
-
|
|||||||||||||||||||||
Admin Health Insurance
|
7,395
|
9,212
|
5,235
|
7,235
|
29,078
|
|||||||||||||||||
Admin Simple Plan & 401K
|
2,633
|
3,455
|
3,550
|
3,550
|
4,047
|
4,044
|
4,044
|
4,291
|
29,614
|
|||||||||||||
Garnishments
|
-
|
|||||||||||||||||||||
-
|
||||||||||||||||||||||
Vendors to be Paid
|
-
|
|||||||||||||||||||||
Insurance premiums FY13/14 - due 12th
|
38,000
|
38,000
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
17,500
|
356,000
|
|||
Other
|
3,875
|
3,875
|
||||||||||||||||||||
Tchek 8th and 22nd
|
3,723
|
4,389
|
5,683
|
5,279
|
10,326
|
10,000
|
7,000
|
7,000
|
53,400
|
|||||||||||||
AMEX due by the 6th & Settlement 7/15 & 8/15
|
1,150
|
1,150
|
||||||||||||||||||||
Sichenzia - monthly retainer $4k
|
1,300
|
1,300
|
2,600
|
1,300
|
1,800
|
1,800
|
1,800
|
7,500
|
2,500
|
2,500
|
2,500
|
2,500
|
2,500
|
2,500
|
2,500
|
2,500
|
2,500
|
2,500
|
44,400
|
|||
Directors Fees 9/30/13
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
5,077
|
66,000
|
||||||||
Zurich must be there by 5th
|
25,000
|
25,000
|
25,000
|
25,000
|
100,000
|
|||||||||||||||||
Cohn Reznick 50k 8/15, 50k 8/31, doulble 50k 9/15
|
28,333
|
28,333
|
12,333
|
12,333
|
12,333
|
12,333
|
12,333
|
12,333
|
17,333
|
17,333
|
12,333
|
12,333
|
12,333
|
12,333
|
214,666
|
|||||||
Minken $4k & $2k 8/30, half $18k 9/30, half 10/31
|
-
|
2,319
|
2,319
|
2,319
|
2,319
|
2,319
|
2,319
|
2,319
|
2,319
|
2,319
|
2,319
|
1,725
|
3,085
|
28,003
|
||||||||
AC Lordi
|
5,000
|
4,400
|
4,400
|
4,400
|
4,400
|
4,400
|
5,000
|
32,000
|
||||||||||||||
Sebastian Giordano
|
10,833
|
10,833
|
10,833
|
10,833
|
43,332
|
|||||||||||||||||
Other
|
830
|
395
|
3,000
|
3,000
|
3,000
|
3,000
|
3,000
|
25,000
|
41,225
|
|||||||||||||
DE Franchise Tax-was due 6/1/13, pay 1Q & 2Q 9/1/13
|
33,497
|
33,497
|
||||||||||||||||||||
Other
|
5,000
|
7,500
|
5,000
|
2,050
|
15,000
|
2,500
|
20,000
|
920
|
3,250
|
2,015
|
2,750
|
1,950
|
67,935
|
|||||||||
All other vendors/suppliers
|
1,300
|
-
|
767
|
2,000
|
2,275
|
1,500
|
577
|
600
|
13,195
|
2,000
|
2,000
|
2,000
|
2,000
|
2,000
|
2,000
|
34,213
|
||||||
-
|
||||||||||||||||||||||
Subtotal Disbursements
|
-
|
100,083
|
129,624
|
41,789
|
102,964
|
175,586
|
61,988
|
91,298
|
54,019
|
225,525
|
81,893
|
257,206
|
69,233
|
101,348
|
86,935
|
95,500
|
67,166
|
36,049
|
115,924
|
1,894,130
|
1,894,130
|
|
10/18/2013
|
100,083
|
129,624
|
41,789
|
102,964
|
175,586
|
61,988
|
91,298
|
54,320
|
237,605
|
59,450
|
94,159
|
57,012
|
92,968
|
77,070
|
84,706
|
35,194
|
33,077
|
107,892
|
1,636,785
|
|||
(257,345)
|
||||||||||||||||||||||
Ending Cash
|
495,758
|
395,675
|
266,051
|
224,261
|
121,297
|
313,692
|
251,705
|
160,407
|
106,388
|
(119,137)
|
(201,030)
|
(458,236)
|
(527,469)
|
(628,817)
|
(715,752)
|
(811,252)
|
(878,418)
|
(914,466)
|
(1,030,391)
|
(1,744,130)
|
||
Net Cash Flow
|
-
|
(100,083)
|
(129,624)
|
(41,789)
|
(102,964)
|
192,395
|
(61,988)
|
(91,298)
|
(54,019)
|
(225,525)
|
(81,893)
|
(257,206)
|
(69,233)
|
(101,348)
|
(86,935)
|
(95,500)
|
(67,166)
|
(36,049)
|
(115,924)
|
|||
Cumulative Cash Flow
|
(100,083)
|
(229,707)
|
(271,496)
|
(374,461)
|
(182,065)
|
(244,053)
|
(335,351)
|
(389,370)
|
(614,895)
|
(696,788)
|
(953,993)
|
(1,023,227)
|
(1,124,574)
|
(1,211,510)
|
(1,307,010)
|
(1,374,176)
|
(1,410,224)
|
(1,526,148)
|
||||
Liggett
|
Vivien Chan
|
Tallmon
|
Cooper Elec Settle
|
|||||||||||||||||||
Donah-5075
|
Mullins
|
Marilyn Travel Award $4919.08
|
||||||||||||||||||||
Retention
|
Cohen 830
|
Alliance
|
K&L Gates
|
Minken-Q1
|
||||||||||||||||||
Greenberg
|
Steve Chaussy
|
Klaris, Thomson
|
Subsidiary: Seattle Operations
|
|||||||||||||||||||||||
Cash Forecast
|
|||||||||||||||||||||||
Weekly Forecast As of 11/01/13
|
|||||||||||||||||||||||
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
|||||
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Forecasted
|
||||
8/31/2013
|
9/6/2013
|
9/13/2013
|
9/20/2013
|
9/27/2013
|
10/4/2013
|
10/11/2013
|
10/18/2013
|
10/25/2013
|
11/1/2013
|
11/8/2013
|
11/15/2013
|
11/22/2013
|
11/29/2013
|
12/6/2013
|
12/13/2013
|
12/20/2013
|
12/27/2013
|
1/3/2014
|
Totals
|
||||
Receipts
|
|||||||||||||||||||||||
Bank Statement Balance 8/31/13
|
189,339
|
||||||||||||||||||||||
Less: Outstanding Checks ( )
|
(191,946)
|
||||||||||||||||||||||
Add: Deposits In Transit
|
|||||||||||||||||||||||
Adjusted Opening Cash Balance
|
(2,607)
|
||||||||||||||||||||||
Cash Receipts
|
|||||||||||||||||||||||
Blue Chip Over 150 Days
|
-
|
-
|
1,463
|
-
|
878
|
5,888
|
-
|
-
|
-
|
8,228
|
|||||||||||||
Blue Chip Over 90 Days-Under 150 Days
|
33,325
|
-
|
26,075
|
-
|
-
|
78,711
|
-
|
-
|
-
|
138,111
|
|||||||||||||
Blue Chip Under 90 Days
|
43,296
|
11,882
|
7,383
|
12,380
|
235,188
|
60,517
|
97,117
|
130,994
|
93,707
|
692,464
|
|||||||||||||
Remaining AR Over 90 Days
|
35,707
|
3,500
|
4,759
|
45,468
|
-
|
143,742
|
29,390
|
7,174
|
-
|
269,740
|
|||||||||||||
Remaining AR Over 60 and Under 90 Days
|
216,703
|
1,435
|
11,740
|
80,133
|
-
|
-
|
17,394
|
18,054
|
-
|
345,459
|
|||||||||||||
Remaining AR Under 60 Days
|
181,645
|
54,527
|
125,071
|
101,075
|
40,249
|
67,876
|
125,478
|
374,306
|
24,860
|
216,000
|
175,000
|
195,000
|
100,000
|
240,000
|
185,000
|
185,000
|
190,000
|
175,000
|
2,756,087
|
||||
Collections Bonded Jobs
|
15,000
|
-
|
-
|
-
|
-
|
-
|
-
|
-
|
15,000
|
||||||||||||||
Miscellaneous - Non AR cash receipts
|
-
|
8,639
|
1,033
|
12,511
|
429
|
231
|
-
|
82
|
3,861
|
26,788
|
|||||||||||||
Subtotal Receipts
|
-
|
525,676
|
79,983
|
177,524
|
251,567
|
276,743
|
356,965
|
269,379
|
530,611
|
122,429
|
216,000
|
175,000
|
195,000
|
100,000
|
240,000
|
185,000
|
185,000
|
190,000
|
175,000
|
4,251,876
|
4,251,876
|
||
10/18/2013
|
525,676
|
79,983
|
177,524
|
251,567
|
276,743
|
356,965
|
269,379
|
200,000
|
200,000
|
195,000
|
125,000
|
220,000
|
100,000
|
240,000
|
185,000
|
185,000
|
190,000
|
175,000
|
3,952,836
|
||||
Cash Disbursements
|
299,040
|
Fav
|
|||||||||||||||||||||
Recurring Monthly Payments:
|
-
|
||||||||||||||||||||||
Facility Rent
|
7,521
|
7,521
|
7,691
|
7,691
|
7,691
|
38,115
|
|||||||||||||||||
Utilities (Elec, tele., etc)
|
3,750
|
-
|
-
|
-
|
3,552
|
5,260
|
5,260
|
17,822
|
|||||||||||||||
Vehicle & equipment leases
|
1,648
|
3,600
|
1,515
|
2,303
|
3,600
|
3,600
|
3,600
|
19,866
|
|||||||||||||||
Credit Cards ( AMEX, VISA, Gas)
|
-
|
29,863
|
11,665
|
4,070
|
16,689
|
5,821
|
10,372
|
24,000
|
10,000
|
8,500
|
22,000
|
9,000
|
151,980
|
||||||||||
Sales Tax
|
-
|
7,297
|
-
|
5,776
|
6,000
|
5,600
|
24,673
|
||||||||||||||||
-
|
|||||||||||||||||||||||
Payroll & Benefits:
|
Nov 5 week
|
-
|
|||||||||||||||||||||
Payroll
|
75,025
|
64,305
|
68,086
|
63,166
|
58,828
|
72,355
|
58,333
|
65,000
|
65,000
|
68,233
|
68,500
|
65,000
|
65,000
|
65,000
|
65,000
|
65,000
|
65,000
|
65,000
|
1,181,830
|
||||
PR Taxes
|
32,227
|
27,694
|
23,351
|
26,010
|
23,582
|
21,920
|
24,611
|
21,836
|
108,028
|
28,708
|
26,591
|
29,000
|
25,500
|
25,500
|
25,500
|
25,500
|
25,500
|
25,500
|
546,559
|
||||
Union Dues & Fringes
|
161,672
|
94,973
|
70
|
63,735
|
78,224
|
102,842
|
25,158
|
136,000
|
30,000
|
692,675
|
|||||||||||||
Admin Health Insurance
|
4,000
|
3,500
|
3,500
|
3,500
|
14,500
|
||||||||||||||||||
Admin Simple Plan & 401K
|
26
|
384
|
384
|
384
|
10,819
|
384
|
384
|
387
|
384
|
384
|
384
|
384
|
384
|
384
|
384
|
384
|
16,226
|
||||||
Garnishments
|
497
|
497
|
1,343
|
497
|
1,278
|
1,278
|
1,271
|
1,278
|
1,278
|
1,271
|
1,212
|
1,278
|
1,278
|
1,278
|
1,278
|
1,278
|
1,278
|
1,278
|
20,646
|
||||
DELINQUENT PR TAXES
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
24,473
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
11,962
|
227,827
|
||||
Vendors to be Paid
|
-
|
||||||||||||||||||||||
List any single vendor payments over $50K
|
-
|
||||||||||||||||||||||
-- Connect Air
|
7,232
|
7,232
|
|||||||||||||||||||||
-- GexPro
|
34,500
|
34,500
|
|||||||||||||||||||||
-- Platt invoices over 53
|
2,916
|
2,916
|
|||||||||||||||||||||
-- Stoneway invoices over 53
|
964
|
964
|
|||||||||||||||||||||
-- Northcoast invoices over 53
|
1,385
|
1,385
|
|||||||||||||||||||||
All other vendors/suppliers
|
34,950
|
38,602
|
53,994
|
70,000
|
46,100
|
58,163
|
64,095
|
57,017
|
31,321
|
46,162
|
30,000
|
30,000
|
30,000
|
30,000
|
30,000
|
30,000
|
30,000
|
30,000
|
740,404
|
||||
Office Vendors
|
2,626
|
6,609
|
2,194
|
3,734
|
15,223
|
2,100
|
2,100
|
2,100
|
2,100
|
2,100
|
2,100
|
2,100
|
2,100
|
2,100
|
2,100
|
51,386
|
|||||||
-
|
|||||||||||||||||||||||
Subtotal Disbursements
|
-
|
217,203
|
187,158
|
333,587
|
274,289
|
151,920
|
179,721
|
255,015
|
256,746
|
237,140
|
186,966
|
271,091
|
174,882
|
142,224
|
156,015
|
163,484
|
284,724
|
171,824
|
147,515
|
3,791,505
|
3,791,505
|
||
10/18/2013
|
217,203
|
187,158
|
333,587
|
274,289
|
151,920
|
179,721
|
255,015
|
225,081
|
220,020
|
153,659
|
280,899
|
174,899
|
144,899
|
158,520
|
166,159
|
294,399
|
176,999
|
146,420
|
3,740,848
|
||||
(50,657)
|
fav
|
||||||||||||||||||||||
Ending Cash
|
(2,607)
|
305,865
|
198,690
|
42,627
|
19,905
|
144,728
|
321,973
|
336,336
|
610,201
|
495,490
|
524,524
|
428,433
|
448,550
|
406,326
|
490,311
|
511,827
|
412,103
|
430,279
|
457,764
|
460,371
|
|||
Net Cash Flow
|
308,472
|
(107,175)
|
(156,063)
|
(22,722)
|
124,823
|
177,245
|
14,364
|
273,865
|
(114,711)
|
29,034
|
(96,091)
|
20,118
|
(42,224)
|
83,985
|
21,516
|
(99,724)
|
18,176
|
27,485
|
|||||
Cumulative Cash Flow
|
-
|
308,472
|
201,297
|
45,234
|
22,512
|
147,335
|
324,580
|
338,944
|
612,808
|
498,097
|
527,131
|
431,040
|
451,158
|
408,934
|
492,919
|
514,434
|
414,710
|
432,886
|
460,371
|
||||
109,230
|
|||||||||||||||||||||||
As of 8/16/13
|
UPDATE
|
||||||||||||||||||||||
Total Due
|
Over 120
|
Retention
|
|||||||||||||||||||||
Accounts Receivable
|
3,168,373
|
369,020
|
560,891
|
179,721
|
|||||||||||||||||||
Accounts Payable
|
497,384
|
377,410
|
-
|
Subsidiary: Suisun City Operations
|
|||||||||||||||||||||||
Cash Forecast
|
|||||||||||||||||||||||
As of: 11/1/13
|
|||||||||||||||||||||||
1
|
2
|
3
|
4
|
5
|
6
|
7
|
8
|
9
|
10
|
11
|
12
|
13
|
14
|
15
|
16
|
||||||||
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Cumulative
|
||||
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
22 Week
|
||||
8/31/2013
|
9/6/2013
|
9/13/2013
|
9/20/2013
|
9/27/2013
|
10/4/2013
|
10/11/2013
|
10/18/2013
|
10/25/2013
|
11/1/2013
|
11/8/2013
|
11/15/2013
|
11/22/2013
|
11/29/2013
|
12/6/2013
|
12/13/2013
|
12/20/2013
|
12/27/2013
|
1/3/2014
|
Totals
|
||||
Receipts
|
|||||||||||||||||||||||
Bank Statement Balance 8/31/13 - ALL ACCOUNTS
|
57,908
|
||||||||||||||||||||||
Less: Outstanding Checks (SOV )
|
(42,130)
|
||||||||||||||||||||||
Add: Deposits In Transit (unlocated diff)
|
|||||||||||||||||||||||
GL Opening Cash Balance
|
15,778
|
||||||||||||||||||||||
ACTUAL
|
ACTUAL
|
ACTUAL
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
Forecasted
|
||||||
Cash Receipts
|
15,778
|
168,131
|
69,967
|
378,847
|
330,239
|
374,523
|
268,225
|
303,253
|
435,079
|
135,584
|
125,321
|
219,398
|
249,045
|
269,966
|
259,979
|
108,030
|
231,108
|
232,385
|
458,674
|
||||
Blue Chip Over 150 Days
|
-
|
-
|
-
|
-
|
3,367
|
3,367
|
|||||||||||||||||
Blue Chip Over 90 Days-Under 150 Days
|
-
|
-
|
-
|
-
|
-
|
34,867
|
34,867
|
||||||||||||||||
Blue Chip Under 90 Days
|
63,144
|
8,260
|
12,319
|
450
|
74,408
|
40,742
|
46,707
|
36,295
|
68,342
|
-
|
-
|
54,295
|
87,291
|
22,729
|
-
|
514,981
|
|||||||
Remaining AR Over 90 Days
|
9,376
|
-
|
30,657
|
2,744
|
2,664
|
86,068
|
21,436
|
152,944
|
|||||||||||||||
Remaining AR Over 60 and Under 90 Days
|
6,769
|
9,984
|
74,245
|
19,257
|
43,096
|
15,108
|
5,284
|
55,264
|
2,342
|
231,349
|
|||||||||||||
Remaining AR Under 60 Days
|
87,802
|
39,094
|
153,580
|
6,410
|
127,686
|
92,920
|
285,409
|
327,906
|
33,511
|
338,283
|
115,850
|
60,633
|
190,671
|
108,888
|
210,119
|
95,713
|
123,207
|
352,019
|
2,749,702
|
||||
Collections Bonded Jobs
|
-
|
-
|
-
|
73,170
|
301,009
|
173,412
|
130,327
|
677,918
|
|||||||||||||||
Miscellaneous - Non AR cash receipts
|
1,040
|
12,629
|
182,378
|
6,627
|
7,620
|
(56,205)
|
154,090
|
||||||||||||||||
Subtotal Receipts
|
168,131
|
69,967
|
453,179
|
108,659
|
247,854
|
156,389
|
423,467
|
330,332
|
429,461
|
406,625
|
115,850
|
234,045
|
244,966
|
108,888
|
297,410
|
226,040
|
145,936
|
352,019
|
4,519,218
|
4,519,218
|
|||
10/18/2013
|
168,131
|
69,967
|
453,179
|
108,659
|
247,854
|
156,389
|
423,467
|
435,079
|
342,559
|
188,546
|
223,628
|
249,045
|
269,966
|
254,369
|
89,572
|
219,260
|
220,536
|
446,825
|
4,567,031
|
||||
Cash Disbursements
|
(47,813)
|
fav
|
|||||||||||||||||||||
Recurring Monthly Payments:
|
|||||||||||||||||||||||
Facility Rent
|
4,130
|
10,819
|
10,814
|
11,000
|
11,000
|
47,763
|
|||||||||||||||||
Utilities (Elec, tele., etc)
|
799
|
3,500
|
1,000
|
3,500
|
-
|
2,000
|
3,500
|
2,000
|
3,500
|
2,000
|
21,799
|
||||||||||||
Vehicle & equipment leases
|
1,907
|
656
|
2,562
|
-
|
2,562
|
2,562
|
10,249
|
||||||||||||||||
Credit Cards (AMEX, VISA, Gas)
|
16,103
|
24,172
|
9,923
|
35,306
|
-
|
7,219
|
35,000
|
15,000
|
35,000
|
177,724
|
|||||||||||||
Sales Tax
|
3,741
|
5,000
|
4,377
|
5,000
|
5,000
|
23,118
|
|||||||||||||||||
Payroll & Benefits:
|
|||||||||||||||||||||||
Payroll
|
40,013
|
77,713
|
48,359
|
82,991
|
41,972
|
81,658
|
46,000
|
84,000
|
37,205
|
93,600
|
48,900
|
88,900
|
48,900
|
88,900
|
48,900
|
86,300
|
48,900
|
86,300
|
1,179,511
|
||||
PR Taxes
|
38,161
|
12,301
|
33,124
|
20,810
|
33,951
|
15,602
|
33,913
|
16,952
|
39,473
|
18,469
|
43,969
|
21,469
|
42,969
|
21,469
|
42,969
|
25,000
|
46,500
|
25,000
|
532,102
|
||||
Union Dues & Fringes
|
133,483
|
111,000
|
141,000
|
141,000
|
526,483
|
||||||||||||||||||
Admin Health Insurance
|
19,125
|
17,850
|
17,850
|
17,850
|
72,675
|
||||||||||||||||||
Admin Simple Plan & 401K
|
-
|
1,994
|
193
|
2,000
|
193
|
2,018
|
160
|
1,972
|
85
|
2,000
|
160
|
2,000
|
160
|
2,000
|
160
|
2,000
|
160
|
2,000
|
19,255
|
||||
Garnishments
|
-
|
206
|
228
|
699
|
228
|
699
|
250
|
699
|
228
|
700
|
250
|
700
|
250
|
700
|
250
|
700
|
250
|
700
|
7,736
|
||||
Delinquent taxes
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
3,531
|
||||||||
Vendors to be Paid
|
|||||||||||||||||||||||
List any single vendor payments over $50K
|
|||||||||||||||||||||||
Consultants
|
14,666
|
14,666
|
|||||||||||||||||||||
Transfers to Corporate
|
-
|
||||||||||||||||||||||
New Job - material purchases
|
-
|
||||||||||||||||||||||
Material Bills-paid when paid (non-specific jobs)
|
-
|
||||||||||||||||||||||
Special Payments
|
8,600
|
50
|
8,650
|
||||||||||||||||||||
Material Bills-pay when paid (specific job)
|
64,525
|
51,543
|
111,806
|
100,034
|
187,063
|
87,291
|
87,488
|
23,525
|
154,819
|
31,000
|
122,000
|
15,000
|
33,000
|
90,000
|
75,000
|
75,000
|
75,000
|
50,000
|
1,434,095
|
||||
Office Bills
|
1,518
|
558
|
8,500
|
22,825
|
3,954
|
5,000
|
5,000
|
5,000
|
5,000
|
5,000
|
5,000
|
5,000
|
5,000
|
5,000
|
82,355
|
||||||||
Subtotal Disbursements
|
-
|
152,677
|
193,581
|
370,638
|
210,065
|
279,413
|
217,950
|
300,192
|
197,310
|
254,536
|
166,081
|
382,660
|
180,100
|
133,810
|
227,162
|
349,660
|
199,000
|
214,310
|
182,000
|
4,211,145
|
4,211,145
|
||
10/18/2013
|
152,677
|
193,581
|
370,638
|
210,065
|
279,413
|
217,950
|
300,192
|
245,755
|
131,186
|
161,793
|
303,791
|
212,731
|
135,941
|
179,793
|
318,791
|
144,231
|
189,441
|
327,231
|
FALSE
|
4,075,200
|
|||
(135,945)
|
unfav
|
||||||||||||||||||||||
Ending Cash
|
15,778
|
31,232
|
(92,382)
|
(9,841)
|
(111,247)
|
(142,806)
|
(204,366)
|
(81,091)
|
51,931
|
226,856
|
467,400
|
200,590
|
254,534
|
365,690
|
247,416
|
195,166
|
222,206
|
153,833
|
323,851
|
308,073
|
|||
Net Cash Flow
|
15,454
|
(123,614)
|
82,541
|
(101,406)
|
(31,559)
|
(61,560)
|
123,275
|
133,023
|
174,925
|
240,544
|
(266,810)
|
53,945
|
111,156
|
(118,274)
|
(52,250)
|
27,040
|
(68,374)
|
170,019
|
|||||
Cumulative Cash Flow
|
15,454
|
(108,160)
|
(25,619)
|
(127,025)
|
(158,584)
|
(220,144)
|
(96,869)
|
36,153
|
211,078
|
451,622
|
184,812
|
238,756
|
349,912
|
231,638
|
179,388
|
206,428
|
138,055
|
30 8,073
|
|||||
As of 9/13/13
|
Total Due
|
Current
|
30 Days
|
60 Days
|
Over 90
|
Over 120
|
Retention
|
||||||||||||||||
Accounts Receivable
|
3,006,933
|
1,562,264
|
467,359
|
595,155
|
249,058
|
133,096
|
362,066
|
||||||||||||||||
Accounts Payable
|
1,047,878
|
325,386
|
235,202
|
410,385
|
76,905
|
36,128
|
Subsidiary: Trenton Operations
|
|||||||||||||||||||||||
Cash Forecast
|
|||||||||||||||||||||||
Weekly Forecast As of 11/01/13
|
|||||||||||||||||||||||
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Actual
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
Projected
|
|||||
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
Cash Bal
|
18 Week
|
||||
8/31/2013
|
9/6/2013
|
9/13/2013
|
9/20/2013
|
9/27/2013
|
10/4/2013
|
10/11/2013
|
10/18/2013
|
10/25/2013
|
11/1/2013
|
11/8/2013
|
11/15/2013
|
11/22/2013
|
11/29/2013
|
12/6/2013
|
12/13/2013
|
12/20/2013
|
12/27/2013
|
1/3/2014
|
|||||
Receipts
|
|||||||||||||||||||||||
Bank Statement Balance
|
-
|
||||||||||||||||||||||
Less: Outstanding Checks ( )
|
(34,775)
|
||||||||||||||||||||||
Add: Deposits In Transit
|
-
|
||||||||||||||||||||||
Adjusted Opening Cash Balance
|
(34,775)
|
||||||||||||||||||||||
Cash Receipts
|
|||||||||||||||||||||||
Blue Chip Over 150 Days
|
-
|
||||||||||||||||||||||
Blue Chip Over 90 Days-Under 150 Days
|
-
|
||||||||||||||||||||||
Blue Chip Under 90 Days
|
-
|
||||||||||||||||||||||
Remaining AR Over 90 Days
|
-
|
||||||||||||||||||||||
Remaining AR Over 60 and Under 90 Days
|
-
|
||||||||||||||||||||||
Remaining AR Under 60 Days
|
20,418
|
15,428
|
4,437
|
-
|
96,866
|
22,646
|
35,850
|
37,801
|
16,038
|
54,633
|
25,304
|
3,538
|
4,938
|
107,915
|
1,500
|
21,249
|
430
|
-
|
468,989
|
||||
Collections Bonded Jobs
|
-
|
||||||||||||||||||||||
Miscellaneous - Non AR cash receipts
|
100
|
4,901
|
5,001
|
||||||||||||||||||||
Subtotal Receipts
|
-
|
20,418
|
15,428
|
4,437
|
-
|
96,866
|
22,646
|
35,950
|
37,801
|
20,939
|
54,633
|
25,304
|
3,538
|
4,938
|
107,915
|
1,500
|
21,249
|
430
|
-
|
473,989
|
473,989
|
||
3
|
10/18/2013
|
20,418
|
15,428
|
4,437
|
-
|
96,866
|
22,646
|
35,950
|
39,301
|
15,077
|
109,516
|
19,835
|
3,538
|
-
|
43,891
|
2,500
|
19,249
|
-
|
-
|
448,650
|
448,650
|
||
Cash Disbursements
|
-
|
25,339
|
fav
|
||||||||||||||||||||
Recurring Monthly Payments:
|
-
|
||||||||||||||||||||||
Facility Rent
|
-
|
||||||||||||||||||||||
Utilities (Elec, tele., etc)
|
547
|
547
|
|||||||||||||||||||||
Vehicle & equipment leases
|
-
|
||||||||||||||||||||||
Credit Cards (AMEX, VISA, Gas)
|
7,826
|
378
|
5,587
|
689
|
200
|
14,680
|
|||||||||||||||||
Sales Tax
|
-
|
||||||||||||||||||||||
|
-
|
||||||||||||||||||||||
Payroll & Benefits:
|
-
|
||||||||||||||||||||||
Payroll
|
10,277
|
10,173
|
10,383
|
7,400
|
7,849
|
8,699
|
7,500
|
4,195
|
4,326
|
4,326
|
4,500
|
4,500
|
4,500
|
4,500
|
1,271
|
1,271
|
1,271
|
1,271
|
98,212
|
||||
PR Taxes
|
4,880
|
4,380
|
4,957
|
4,344
|
3,628
|
3,512
|
3,261
|
3,359
|
1,767
|
1,767
|
1,767
|
1,800
|
1,800
|
1,800
|
1,800
|
260
|
260
|
260
|
45,604
|
||||
Union Dues & Fringes
|
15,000
|
16,217
|
1,914
|
15,049
|
1,027
|
13,525
|
10,418
|
73,150
|
|||||||||||||||
Admin Health Insurance
|
2,522
|
1,932
|
2,522
|
708
|
708
|
8,392
|
|||||||||||||||||
Admin Simple Plan & 401K
|
-
|
||||||||||||||||||||||
Garnishments
|
-
|
||||||||||||||||||||||
Delinquent PR Taxes
|
6,069
|
6,069
|
6,069
|
6,069
|
6,069
|
6,061
|
36,406
|
||||||||||||||||
Vendors to be Paid
|
-
|
||||||||||||||||||||||
List any single vendor payments over $50K
|
-
|
||||||||||||||||||||||
Cooper Electric litigation
|
300
|
300
|
|||||||||||||||||||||
Cohen
|
3,181
|
759
|
9,978
|
1,738
|
15,656
|
||||||||||||||||||
Billows
|
5,002
|
11,207
|
13,045
|
16,070
|
4,858
|
1,741
|
5,000
|
5,000
|
61,922
|
||||||||||||||
Burlington Electric - balance $15600 Credit Card
|
-
|
||||||||||||||||||||||
Vendors
|
176
|
269
|
1,739
|
2,184
|
|||||||||||||||||||
-
|
|||||||||||||||||||||||
All other vendors/suppliers
|
-
|
||||||||||||||||||||||
-
|
|||||||||||||||||||||||
Subtotal Disbursements
|
-
|
36,402
|
47,188
|
21,409
|
20,994
|
24,731
|
33,527
|
41,676
|
30,238
|
12,258
|
18,501
|
20,501
|
11,500
|
13,038
|
6,300
|
14,197
|
1,531
|
1,531
|
1,531
|
357,052
|
357,052
|
||
10/18/2013
|
36,402
|
47,188
|
21,409
|
20,994
|
24,731
|
33,527
|
41,676
|
29,220
|
17,526
|
12,500
|
26,025
|
17,478
|
7,500
|
3,771
|
11,949
|
1,531
|
1,531
|
1,531
|
356,489
|
||||
(563)
|
unfav
|
||||||||||||||||||||||
Ending Cash
|
(34,775)
|
(50,758)
|
(82,518)
|
(99,491)
|
(120,485)
|
(48,351)
|
(59,232)
|
(64,958)
|
(57,395)
|
(48,714)
|
(12,582)
|
(7,779)
|
(15,740)
|
(23,840)
|
77,774
|
65,077
|
84,794
|
83,693
|
82,162
|
116,937
|
|||
Net Cash Flow
|
(15,984)
|
(31,760)
|
(16,973)
|
(20,994)
|
72,135
|
(10,882)
|
(5,726)
|
7,563
|
8,681
|
36,132
|
4,803
|
(7,962)
|
(8,100)
|
101,615
|
(12,697)
|
19,718
|
(1,101)
|
(1,531)
|
|||||
Cumulative Cash Flow
|
(15,984)
|
(47,744)
|
(64,716)
|
(85,711)
|
(13,576)
|
(24,458)
|
(30,183)
|
(22,620)
|
(13,939)
|
22,193
|
26,996
|
19,034
|
10,934
|
112,549
|
99,852
|
119,569
|
118,468
|
116,937
|