ABGHIJKLMNOPQRSTUVWXYZ
1
Sample 13-Week Cash Flow Projection
2
ABL Line of Credit with 85% Against A/R
3
4
13-Week Cash Flow Projections7/13/20237/20/20237/27/20238/3/20238/10/20238/17/20238/24/20238/31/20239/7/20239/14/20239/21/20239/28/202310/5/2023TOTAL
5
Company IFridayFridayFridayFridayFridayFridayFridayFridayFridayFridayFridayFridayFriday
6
AP Payments from Aging$95,691.57 $64,799 $75,373 $8,295 $44,592 $2,478 $3,577 $8,500 $4,698 $4,480 $1,270 $33,500 $0 $ 347,254
7
AP Payments Inventory$12,305.85 $60,284 $13,126 $78,619 $41,300 $107,747 $105,963 $36,826 $26,592 $15,000 $0 $19,739 $20,000 $ 537,501
8
Payroll$110,941.12 $87,178 $87,178 $87,178 $87,178 $87,178 $87,178 $87,178 $87,178 $20,607 $20,607 $20,607 $20,607 $ 890,791
9
Payroll - O/T $17,677.44 $16,342 $16,342 $16,342 $16,342 $0 $0 $0 $0 $0 $0 $0 $0 $ 83,044
10
Payroll - Stay On Bonus$0.00 $0 $0 $0 $82,500 $0 $44,000 $0 $0 $27,500 $0 $0 $0 $ 154,000
11
Rents$0.00 $0 $0 $52,612 $29,000 $0 $0 $12,862 $39,750 $0 $0 $12,862 $39,750 $ 186,836
12
Autopays$20,062.64 $17,632 $11,013 $2,906 $16,619 $10,314 $20,941 $7,703 $18,072 $10,314 $20,941 $7,703 $18,072 $ 182,294
13
Loans - Total $5,420.01 $23,980 $50,393 $21,550 $6,870 $5,420 $63,109 $12,548 $27,136 $5,420 $63,109 $12,548 $20,266 $ 317,769
14
Materials$25,000.00 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $ 325,000
15
Substrate/Chem/ Prepays$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
16
Outside Whse, Net$41,847.34 $0 $0 $0 $0 $0 $0 $0 ($16,000)$0 $0 $0 $0 $ 25,847
17
Interest$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
18
Commissions$0.00 $0 $58,000 $0 $0 $0 $0 $52,000 $0 $0 $0 $21,000 $0 $ 131,000
19
Consultants$10,000.00 $25,000 $10,000 $25,000 $10,000 $25,000 $10,000 $25,000 $10,000 $25,000 $10,000 $25,000 $10,000 $ 220,000
20
Legal - Total$0.00 $0 $0 $0 $5,000 $0 $0 $53,463 $5,000 $0 $0 $0 $0 $ 63,463
21
Freight$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
22
Insurance (Non-health, total)$0.00 $0 $0 $0 $0 $0 $46,900 $0 $0 $0 $46,900 $0 $0 $ 93,800
23
Health Insurance (incl dental & vis)$0.00 $0 $0 $16,927 $0 $0 $0 $0 $14,528 $0 $0 $0 $14,580 $ 46,035
24
Credit Cards$25,000.00 $0 $30,000 $0 $0 $25,000 $0 $25,000 $0 $25,000 $0 $25,000 $0 $ 155,000
25
Guaranteed Payments$8,193.49 $4,894 $0 $0 $8,193 $4,894 $0 $0 $0 $13,088 $0 $0 $0 $ 39,263
26
Additional AP / OIV$14,500.00 $14,500 $14,500 $14,500 $11,250 $11,250 $11,250 $11,250 $0 $0 $0 $0 $0 $ 103,000
27
Total Company II$386,639.46 $339,608.59 $390,922.93 $348,927.99 $383,844.85 $304,280.29 $417,917.69 $357,330.37 $241,954.22 $171,409.08 $187,827.74 $202,959.15 $168,274.93 $3,901,897.29
28
29
30
Company II
31
AP Payments from Aging$23,884.75 $4,155 $14,522 $450 $43,487 $7,897 $576 $0 $12,994 $0 $1,368 $0 $0 $ 109,334
32
AP Payments Inventory$203,750.42 $209,776 $63,428 $222,485 $192,627 $183,699 $150,773 $196,272 $1,272 $86,439 $22,121 $86,078 $82,676 $ 1,701,397
33
Payroll$156,447.03 $0 $143,130 $0 $143,130 $0 $143,130 $0 $143,130 $0 $143,130 $0 $143,130 $ 1,015,230
34
Payroll - O/T$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
35
Rents$0.00 $0 $0 $95,822 $0 $0 $0 $95,822 $0 $0 $0 $95,822 $0 $ 287,465
36
Autopays$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
37
Florida Power & Light$0.00 $0 $0 $7,000 $0 $0 $0 $0 $7,000 $0 $0 $0 $7,000 $ 21,000
38
Loans - Total$0.00 $35,248 $0 $0 $0 $665 $34,583 $0 $0 $665 $34,583 $0 $0 $ 105,743
39
Materials$25,000.00 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $ 325,000
40
Substrate/ Prepays$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
41
Outside Whse, Net$0.00 $12,000 $0 $0 $0 $12,000 $0 $0 $0 $0 $12,000 $0 $0 $ 36,000
42
Commissions$0.00 $0 $40,000 $0 $0 $0 $0 $40,000 $0 $0 $0 $40,000 $0 $ 120,000
43
Expansion$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
44
Freight$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
45
Insurance (Non-health)$0.00 $0 $0 $0 $18,000 $0 $0 $0 $18,000 $0 $0 $0 $18,000 $ 54,000
46
Health insurance$15,976.16 $0 $15,461 $0 $15,461 $0 $15,461 $0 $15,461 $0 $15,461 $0 $15,461 $ 108,741
47
Credit Cards$0.00 $0 $25,000 $0 $0 $0 $0 $20,000 $0 $0 $0 $20,000 $0 $ 65,000
48
Guaranteed Payments$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
49
Equipment$0.00 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $ -
50
Additional AP / OIV$0.00 $0 $0 $0 $0 $0 $24,000 $0 $0 $0 $0 $0 $0 $ 24,000
51
Total Company II$425,058.36 $286,178.29 $326,542.17 $350,756.19 $437,705.22 $229,261.17 $393,523.39 $377,093.34 $222,856.98 $112,104.03 $253,663.12 $266,899.68 $291,267.62 $3,972,910
52
53
Total Consolidated$811,697.82 $625,787 $717,465 $699,684 $821,550 $533,541 $811,441 $734,424 $464,811 $283,513 $441,491 $469,859 $459,543 $7,874,807
54
55
Company I Sales$514,600.00 $475,865 $586,008 $439,347 $221,718 $119,299 $554,817 $581,266 $608,990 $200,983 $200,983 $200,983 $200,983 $ 4,905,840
56
Company II SalesLess PPY$161,030.40 $108,498 $283,635 $217,262 $93,749 $93,749 $93,749 $93,749 $114,496 $145,617 $145,617 $145,617 $145,617 $ 1,842,385
57
85%85%85%85%85%85%85%85%85%85%85%85%85%85%85%
58
Addition to Availability$574,286 $496,709 $739,196 $558,118 $268,147 $181,091 $551,281 $573,762 $614,963 $294,610 $294,610 $294,610 $294,610 $5,735,992
59
Adjustments
($14,524)($14,524)($14,524)($14,524)($13,261)($13,261)($13,261)($13,261)($13,502)($13,864)($13,864)($13,864)($13,864) $ (180,095)
60
Projected Change in Availability($251,936)($143,602)$7,207 ($156,090)($566,664)($365,712)($273,421)($173,922)$136,650 ($2,767)($160,745)($189,113)($178,796)($2,318,910)
61
15% of Projected Cash ReceiptsSales if Req$100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $ 1,300,000
62
Projected Availability$1,150,465 $1,106,863 $1,214,070 $1,157,980 $691,316 $425,604 $252,183 $178,261 $414,911 $512,144 $451,399 $362,287 $283,490 $283,490
63
Cash Contribution$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
64
Other$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
65
Adjusted Availability$1,150,465 $1,106,863 $1,214,070 $1,157,980 $691,316 $425,604 $252,183 $178,261 $414,911 $512,144 $451,399 $362,287 $283,490 $283,490
66
67
Loan Balance$5,970,190 $5,929,310 $5,980,108 $6,013,126 $6,168,009 $6,034,884 $6,179,659 $6,247,416 $6,045,560 $5,662,407 $5,437,231 $5,240,423 $5,033,299 $5,033,299
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100