Spreadsheet: chris_germany__2015__6-25-02 Gas Cash
Sheet: Daily CFs

 |  |  |  |  | Days 1 - 5 | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9 | Day 10 | Day 11 | Day 12 | Day 13 | Day 14 | Day 15 | Day 16 | Day 17 | Day 18 | Day 19 | Day 20 | Day 21 | Day 22 | Day 23 | Day 24 | Day 25 | Day 26 | Day 27 | Day 28 | Day 29 | Day 30
5 Day Rolling Cash Forecast |  |  |  |  |  | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon | Tue | Wed | Thu | Fri | Mon
 |  |  |  |  | Total | 2002-06-25 00:00:00 | 2002-06-26 00:00:00 | 2002-06-27 00:00:00 | 2002-06-28 00:00:00 | 2002-07-01 00:00:00 | 2002-07-02 00:00:00 | 2002-07-03 00:00:00 | 2002-07-04 00:00:00 | 2002-07-05 00:00:00 | 2002-07-08 00:00:00 | 2002-07-09 00:00:00 | 2002-07-10 00:00:00 | 2002-07-11 00:00:00 | 2002-07-12 00:00:00 | 2002-07-15 00:00:00 | 2002-07-16 00:00:00 | 2002-07-17 00:00:00 | 2002-07-18 00:00:00 | 2002-07-19 00:00:00 | 2002-07-22 00:00:00 | 2002-07-23 00:00:00 | 2002-07-24 00:00:00 | 2002-07-25 00:00:00 | 2002-07-26 00:00:00 | 2002-07-29 00:00:00 | 2002-07-30 00:00:00 | 2002-07-31 00:00:00 | 2002-08-01 00:00:00 | 2002-08-02 00:00:00 | 2002-08-05 00:00:00
All Wholesale Gas Deals
 | Total Wholesale Gas
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 1278727.08 | 1280619.23 | -1892.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | -2371234.02 | 0 | 0 | 0 | 0 | -2371234.02 | 0 | 0 | 0 | 0 | -3936347.315978491 | -3936347.315978491 | -3936347.315978491 | -3936347.315978491 | -3936347.315978491 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19045748.64838681 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | -1090614.79 | 1280619.23 | 0 | 0 | 0 | -2371234.02 | 0 | 0 | 0 | 0 | -3936347.315978491 | -3936347.315978491 | -3936347.315978491 | -3936347.315978491 | -3936347.315978491 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 19045748.64838681 | 0 | 0 | 0 | 0 | 0 | 0
Supply/Demand Deals
 | Total Supply/Demand Deals
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 1280619.23 | 1280619.23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | -2371234.02 | 0 | 0 | 0 | 0 | -2371234.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | -1090614.79 | 1280619.23 | 0 | 0 | 0 | -2371234.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | City of Tallahassee
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 1280619.23 | 1280619.23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 1280619.23 | 1280619.23 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other: Citrus
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | -2371234.02 | 0 | 0 | 0 | 0 | -2371234.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | -2371234.02 | 0 | 0 | 0 | 0 | -2371234.02 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other 2:
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Storage Deals
 | Total Storage
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | TCO
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Sonat
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Bridgeline
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Transport Deals
 | Total Transport
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable |  |  | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -823516.7287804801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801 | -943886.0633596801
 |  | Cash Revenues |  |  | -1892.15 | 0 | -1892.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME]
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable |  |  | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5 | -91837.5
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Northern Border
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable |  |  | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -153352.69998048 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968 | -178630.61755968
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Florida Gas Transmission
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable |  |  | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -578326.5288000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001 | -673417.9458000001
 |  | Cash Revenues |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Other Transport
 |  | Est. Accounts Receivable
 |  | Est. Accounts Payable
 |  | Cash Revenues |  |  | -1892.15 | 0 | -1892.15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Cash Expenses |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Net Cash |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0