|
Project Camel |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
13-Week Cash Forecast |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Prepared as of March 26, 2020 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
CH 11 |
|
|
|
|
|
|
|
|
|
|
|
Emergence |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
4/3/20 |
4/10/20 |
4/17/20 |
4/24/20 |
5/1/20 |
5/8/20 |
5/15/20 |
5/22/20 |
5/29/20 |
6/5/20 |
6/12/20 |
6/19/20 |
6/26/20 |
Forecast |
|
|
|
Wk 1 |
Wk 2 |
Wk 3 |
Wk 4 |
Wk 5 |
Wk 6 |
Wk 7 |
Wk 8 |
Wk 9 |
Wk 10 |
Wk 11 |
Wk 12 |
Wk 13 |
13-Wk |
|
($000s) |
|
POST |
POST |
POST |
POST |
POST |
POST |
POST |
POST |
POST |
POST |
POST |
POST |
POST |
Total |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Receipts |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Customer Collections |
|
$1,382 |
$1,273 |
$1,739 |
$1,674 |
$1,964 |
$2,288 |
$2,411 |
$1,793 |
$1,166 |
$1,083 |
$1,311 |
$1,260 |
$1,843 |
$21,189 |
|
Other Receipts / Asset Sale Proceeds |
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Cash Receipts |
|
$1,382 |
$1,273 |
$1,739 |
$1,674 |
$1,964 |
$2,288 |
$2,411 |
$1,793 |
$1,166 |
$1,083 |
$1,311 |
$1,260 |
$1,843 |
$21,189 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operating Disbursements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operating Expenses |
|
($1,107) |
($1,129) |
($996) |
($996) |
($1,006) |
($677) |
($1,128) |
($1,399) |
($759) |
($714) |
($720) |
($972) |
($718) |
($12,322) |
|
Wages & Benefits |
|
(500) |
(184) |
(1,375) |
(184) |
(1,352) |
(184) |
(1,400) |
(184) |
(1,372) |
(996) |
(1,352) |
(212) |
(858) |
(10,153) |
|
Insurance |
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
(899) |
- |
- |
- |
(899) |
|
Taxes |
|
- |
(20) |
- |
(2) |
- |
(5) |
- |
- |
(80) |
- |
- |
- |
(1,275) |
(1,381) |
|
G&A / Other |
|
(310) |
(223) |
(223) |
(223) |
(325) |
(233) |
(233) |
(233) |
(334) |
(233) |
(233) |
(233) |
(233) |
(3,270) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Operating Disbursements |
|
($1,917) |
($1,556) |
($2,595) |
($1,405) |
($2,683) |
($1,099) |
($2,761) |
($1,816) |
($2,545) |
($2,842) |
($2,306) |
($1,417) |
($3,084) |
($28,026) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Operating Cash Flow |
|
($535) |
($283) |
($856) |
$269 |
($719) |
$1,190 |
($350) |
($24) |
($1,379) |
($1,759) |
($995) |
($157) |
($1,241) |
($6,837) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Disbursements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Professional Fees |
|
$0 |
$0 |
$0 |
$0 |
($200) |
$0 |
($576) |
$0 |
$0 |
($1,798) |
$0 |
($507) |
$0 |
($3,081) |
|
Adequate Assurance / CV Payments |
|
(361) |
- |
(450) |
(450) |
(450) |
(450) |
- |
- |
- |
- |
- |
- |
- |
(2,161) |
|
Notes & Interest Payments |
|
(1,491) |
- |
- |
- |
(449) |
- |
- |
- |
- |
(497) |
- |
- |
- |
(2,436) |
|
DIP Interest & Fees |
|
(225) |
- |
- |
- |
(32) |
- |
- |
- |
- |
(44) |
- |
- |
- |
(301) |
|
Retention / Severance / Other |
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Other Disbursements |
|
($2,077) |
$0 |
($450) |
($450) |
($1,130) |
($450) |
($576) |
$0 |
$0 |
($2,339) |
$0 |
($507) |
$0 |
($7,979) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Disbursements |
|
($3,994) |
($1,556) |
($3,045) |
($1,855) |
($3,813) |
($1,549) |
($3,337) |
($1,816) |
($2,545) |
($5,181) |
($2,306) |
($1,924) |
($3,084) |
($36,005) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Net Cash Flow |
|
($2,611) |
($283) |
($1,306) |
($181) |
($1,849) |
$740 |
($925) |
($24) |
($1,379) |
($4,098) |
($995) |
($664) |
($1,241) |
($14,816) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Cash Balance |
|
$18,805 |
$21,194 |
$20,911 |
$19,605 |
$19,424 |
$17,575 |
$18,315 |
$17,390 |
$17,366 |
$25,986 |
$21,888 |
$20,894 |
$20,230 |
$18,805 |
|
(+/-) Weekly Cash Flow |
|
(2,611) |
(283) |
(1,306) |
(181) |
(1,849) |
740 |
(925) |
(24) |
(1,379) |
(4,098) |
(995) |
(664) |
(1,241) |
(14,816) |
|
(+/-) Change in Float |
|
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
- |
|
(+/-) DIP Draw / Paydown |
|
5,000 |
- |
- |
- |
- |
- |
- |
- |
10,000 |
- |
- |
- |
- |
15,000 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ending Cash Balance |
|
$21,194 |
$20,911 |
$19,605 |
$19,424 |
$17,575 |
$18,315 |
$17,390 |
$17,366 |
$25,986 |
$21,888 |
$20,894 |
$20,230 |
$18,988 |
$18,988 |
|
Less: Restricted Cash |
|
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
(9,732) |
|
Less: Foreign Cash |
|
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
(781) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ending Available Liquidity |
|
$10,681 |
$10,398 |
$9,092 |
$8,911 |
$7,062 |
$7,802 |
$6,877 |
$6,853 |
$15,473 |
$11,376 |
$10,381 |
$9,717 |
$8,475 |
$8,475 |