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)
 
 
1

 
 
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)
     
 
 
2

 
 
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
                       
 
 
3

 
 
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
-
                                       
 
 
4

 
 
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
                               
 
 
5

 
 
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
       
 
 
6