Cloud Peak Energy Inc., et al
13 Week Cash Forecast [DIP Budget No. 4]
Effective August 5, 2019
$’s 000s |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| FCST |
| Total |
|
Week Number |
| Week 1 |
| Week 2 |
| Week 3 |
| Week 4 |
| Week 5 |
| Week 6 |
| Week 7 |
| Week 8 |
| Week 9 |
| Week 10 |
| Week 11 |
| Week 12 |
| Week 13 |
| 5-Aug |
|
Week Ending |
| 9-Aug |
| 16-Aug |
| 23-Aug |
| 30-Aug |
| 6-Sep |
| 13-Sep |
| 20-Sep |
| 27-Sep |
| 4-Oct |
| 11-Oct |
| 18-Oct |
| 25-Oct |
| 1-Nov |
| 1-Nov |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Receipts |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Coal Sales |
| 4,528.0 |
| 20,784.0 |
| 190.1 |
| 19,771.2 |
| 3,471.7 |
| 10,152.6 |
| 12,852.3 |
| 8,504.8 |
| 13,566.3 |
| 10,137.1 |
| 13,566.3 |
| 5,550.5 |
| 15,825.2 |
| 138,900.1 |
|
Coal Sales (CPEL) |
| 7,815.0 |
| 7,665.9 |
| 17,533.7 |
| 3,900.6 |
| 62.6 |
| 7,337.6 |
| 62.6 |
| 3,724.0 |
| 4,102.6 |
| 62.6 |
| 7,225.1 |
| 62.6 |
| 6,986.3 |
| 66,541.2 |
|
Other Receipts |
| — |
| 100.0 |
| — |
| — |
| — |
| 100.0 |
| — |
| — |
| — |
| 100.0 |
| — |
| — |
| — |
| 300.0 |
|
Total Receipts |
| 12,343.0 |
| 28,549.9 |
| 17,723.8 |
| 23,671.8 |
| 3,534.2 |
| 17,590.1 |
| 12,914.9 |
| 12,228.8 |
| 17,668.9 |
| 10,299.6 |
| 20,791.4 |
| 5,613.1 |
| 22,811.5 |
| 205,741.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operating Disbursements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Operations (Core) |
| (6,142.7 | ) | (5,692.7 | ) | (7,161.0 | ) | (14,579.2 | ) | (4,731.6 | ) | (4,593.3 | ) | (5,391.8 | ) | (8,059.2 | ) | (12,950.7 | ) | (4,489.9 | ) | (5,187.1 | ) | (7,675.7 | ) | (4,867.1 | ) | (91,522.0 | ) |
Operations (CPEL) |
| (10,147.1 | ) | (10,879.0 | ) | (3,175.1 | ) | (9,639.4 | ) | (4,433.7 | ) | (1,238.1 | ) | (2,719.1 | ) | (2,547.7 | ) | (4,678.9 | ) | (3,680.3 | ) | (1,391.6 | ) | (4,423.8 | ) | (1,273.8 | ) | (60,227.8 | ) |
Employee Related |
| (4,642.1 | ) | (1,317.0 | ) | (4,704.6 | ) | (1,223.6 | ) | (4,817.6 | ) | (1,317.0 | ) | (4,964.2 | ) | (1,192.2 | ) | (4,875.9 | ) | (1,628.3 | ) | (4,906.3 | ) | (2,380.3 | ) | (4,746.0 | ) | (42,715.2 | ) |
Total Operating Disbursements |
| (20,931.9 | ) | (17,888.8 | ) | (15,040.7 | ) | (25,442.3 | ) | (13,982.9 | ) | (7,148.4 | ) | (13,075.2 | ) | (11,799.1 | ) | (22,505.6 | ) | (9,798.4 | ) | (11,485.1 | ) | (14,479.8 | ) | (10,887.0 | ) | (194,465.0 | ) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash Flow From Operations |
| (8,588.8 | ) | 10,661.2 |
| 2,683.1 |
| (1,770.5 | ) | (10,448.6 | ) | 10,441.8 |
| (160.3 | ) | 429.8 |
| (4,836.7 | ) | 501.2 |
| 9,306.4 |
| (8,866.7 | ) | 11,924.5 |
| 11,276.3 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other Disbursements |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Collateral Deposits |
| (3,400.0 | ) | 400.0 |
| 1,300.0 |
| (12,800.0 | ) | 12,900.0 |
| (7,400.0 | ) | 6,600.0 |
| (4,900.0 | ) | 6,100.0 |
| (6,100.0 | ) | 4,500.0 |
| (3,100.0 | ) | 2,800.0 |
| (3,100.0 | ) |
Cash Interest and Bank Fees |
| — |
| — |
| (83.9 | ) | (5.0 | ) | — |
| — |
| — |
| (86.2 | ) | — |
| — |
| — |
| (88.9 | ) | — |
| (264.1 | ) |
DIP Interest and Fees |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
|
Restructuring and Other |
| (763.9 | ) | (2,400.8 | ) | (1,716.7 | ) | (2,709.1 | ) | — |
| (100.0 | ) | (872.5 | ) | (2,810.0 | ) | — |
| — |
| (960.0 | ) | (4,815.0 | ) | — |
| (17,148.1 | ) |
Total Other Disbursements |
| (4,163.9 | ) | (2,000.8 | ) | (500.7 | ) | (15,514.1 | ) | 12,900.0 |
| (7,500.0 | ) | 5,727.5 |
| (7,796.2 | ) | 6,100.0 |
| (6,100.0 | ) | 3,540.0 |
| (8,003.9 | ) | 2,800.0 |
| (20,512.2 | ) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Total Net Cash Flow |
| (12,752.8 | ) | 8,660.4 |
| 2,182.4 |
| (17,284.6 | ) | 2,451.4 |
| 2,941.8 |
| 5,567.2 |
| (7,366.5 | ) | 1,263.3 |
| (5,598.8 | ) | 12,846.4 |
| (16,870.6 | ) | 14,724.5 |
| (9,235.9 | ) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Cash Balance |
| 81,674.9 |
| 68,922.2 |
| 77,582.5 |
| 79,765.0 |
| 62,480.4 |
| 64,931.7 |
| 67,873.5 |
| 73,440.7 |
| 66,074.2 |
| 67,337.5 |
| 61,738.8 |
| 74,585.1 |
| 57,714.5 |
| 81,674.9 |
|
Net Cash Flow |
| (12,752.8 | ) | 8,660.4 |
| 2,182.4 |
| (17,284.6 | ) | 2,451.4 |
| 2,941.8 |
| 5,567.2 |
| (7,366.5 | ) | 1,263.3 |
| (5,598.8 | ) | 12,846.4 |
| (16,870.6 | ) | 14,724.5 |
| (9,235.9 | ) |
Change in O/S Check Float |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
|
DIP Funding |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
|
Ending Cash Balance |
| 68,922.2 |
| 77,582.5 |
| 79,765.0 |
| 62,480.4 |
| 64,931.7 |
| 67,873.5 |
| 73,440.7 |
| 66,074.2 |
| 67,337.5 |
| 61,738.8 |
| 74,585.1 |
| 57,714.5 |
| 72,439.0 |
| 72,439.0 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Segregated Account Activity (Excluding PIK Int. & Fees) |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Beginning Balance |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
|
DIP Funding |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
|
DIP Escrow Account Interest Income |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
|
Transfers to DIP Loan Party Operating Accounts |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
| — |
|
Ending Cash Balance (Segregated Account) |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
| 31,005.6 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ending Cash Balance (Including Segregated Account) |
| 99,927.8 |
| 108,588.1 |
| 110,770.6 |
| 93,486.0 |
| 95,937.4 |
| 98,879.1 |
| 104,446.3 |
| 97,079.9 |
| 98,343.2 |
| 92,744.4 |
| 105,590.8 |
| 88,720.1 |
| 103,444.7 |
| 103,444.7 |
|