Spreadsheet: 31568d1227480454-complex-if-statement-2003xlforum-payable
Sheet: Payables

Weekly Cash Flow Projection for Client Name
Sort Data By:
BILL DATA |  |  |  |  |  |  |  |  |  |  | Payment Plan |  |  |  |  |  |  |  |  |  | 1st Wk Ending | 2nd Wk Ending | 3rd Wk Ending | 4th Wk Ending | 5th Wk Ending | 6th Wk Ending | 7th Wk Ending | 8th Wk Ending | 9th Wk Ending | 10th Wk Ending | 11th Wk Ending | 12th Wk Ending | 13th Wk Ending | 14th Wk Ending | 15th Wk Ending | 16th Wk Ending | 17th Wk Ending | 18th Wk Ending | 19th Wk Ending | 20th Wk Ending | 21st Wk Ending | 22nd Wk Ending | 23rd Wk Ending | 24th Wk Ending | 25th Wk Ending | 26th Wk Ending
Accounts Payable | Paid | [NAME] | [NAME] | Amt (Bal) | Terms | [NAME] | Due | Planned to | [NAME] | Plann'd | Payment | Amount | Payment | Amount | Payment | Amount | Payment | Amount | Balance |  | 2008-10-05 00:00:00 | 2008-10-12 00:00:00 | 2008-10-19 00:00:00 | 2008-10-26 00:00:00 | 2008-11-02 00:00:00 | 2008-11-09 00:00:00 | 2008-11-16 00:00:00 | 2008-11-23 00:00:00 | 2008-11-30 00:00:00 | 2008-12-07 00:00:00 | 2008-12-14 00:00:00 | 2008-12-21 00:00:00 | 2008-12-28 00:00:00 | 2009-01-04 00:00:00 | 2009-01-11 00:00:00 | 2009-01-18 00:00:00 | 2009-01-25 00:00:00 | 2009-02-01 00:00:00 | 2009-02-08 00:00:00 | 2009-02-15 00:00:00 | 2009-02-22 00:00:00 | 2009-03-01 00:00:00 | 2009-03-08 00:00:00 | 2009-03-15 00:00:00 | 2009-03-22 00:00:00 | 2009-03-29 00:00:00
Vendor Names | ("X") | Date | No. | Due |  | Status | Date | Pay Date | Aging | Aging | Date |  | Date |  | Date |  | Date |  |  |  | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated | Estimated
Accounts Payable
ICC Warrenty |  | 2008-09-01 00:00:00 | 6 | 15000 | 30 |  | 2008-10-01 00:00:00 | 2008-10-05 00:00:00 | 83.74006979166734 | 49.74006979166734 | 2008-10-10 00:00:00 | 2000 | 2008-10-17 00:00:00 | 3000 | 2008-10-25 00:00:00 | 4000 | 2008-10-31 00:00:00 | 6000 | 0 |  |  | 2000 | 3000 | 4000 | 6000
Jonesville equip. backcharges |  | 2008-10-30 00:00:00 | 7 | 2000 | 45 |  | 2008-12-14 00:00:00 | 2008-12-01 00:00:00 | 24.74006979166734 | -7.259930208332662 |  |  |  |  |  |  |  |  | 2000 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
ICC Warrenty |  | 2008-10-25 00:00:00 | 5 | 4250 | 15 |  | 2008-11-09 00:00:00 | 2008-11-15 00:00:00 | 29.74006979166734 | 8.740069791667338 |  |  |  |  |  |  |  |  | 4250 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
East Noble Schools |  | 2008-08-15 00:00:00 | 4 | 5000 | 30 |  | 2008-09-14 00:00:00 | 2008-10-20 00:00:00 | 100.7400697916673 | 34.74006979166734 |  |  |  |  |  |  |  |  | 5000 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
Deam Lake |  | 2008-08-01 00:00:00 | 2 | 15000 | 60 |  | 2008-09-30 00:00:00 | 2008-10-10 00:00:00 | 114.7400697916673 | 44.74006979166734 |  |  |  |  |  |  |  |  | 15000 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  | 0
 |  |  |  | 41250 |  |  |  |  | 70.74006979166734 | 26.14006979166734 |  | 2000 |  | 3000 |  | 4000 |  | 6000 | 26250 |  | 0 | 2000 | 3000 | 4000 | 6000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0