CASH MANAGEMENT
FORECAST FOR CASH RECEIPTS SALES CREDIT SALES COLLECTION OF A/C RECEIVABLES CASH SALES RECEIPT FROM SALE OF EQUIPMENT INTEREST TOTAL CASH RECEIPT (4:9)
FORECAST FOR CASH PAYMENTS MATERIAL PURCHASES CREDIT MATERIAL PURCHASES PAYMENT OF A/C PAYABLE MISCELLENEOUS CASH PURCHASE WAGES MANUFACTURING EXPENSES GEN ADMIN & SELLING EXPENSES DIVIDEND TAX CAPITAL EXPENDITURE TOTAL PAYMENT (A16:A25)
SUMMARY OF CASH FORECAST OPENING CASH BALANCE RECEIPTS PAYMENTS NET CASH FLOW (A31-A32) CUMULATIVE NET CASH FLOW OPENING CASH BALANCE + CUML. NET CASH FLOW (A30+A34) MINIMUM CASH BALANCE REQUIRED (GIVEN) SURPLUS OR DEFICIT (A36 -A37)
doc_396963128.xls
FORECAST FOR CASH RECEIPTS SALES CREDIT SALES COLLECTION OF A/C RECEIVABLES CASH SALES RECEIPT FROM SALE OF EQUIPMENT INTEREST TOTAL CASH RECEIPT (4:9)
FORECAST FOR CASH PAYMENTS MATERIAL PURCHASES CREDIT MATERIAL PURCHASES PAYMENT OF A/C PAYABLE MISCELLENEOUS CASH PURCHASE WAGES MANUFACTURING EXPENSES GEN ADMIN & SELLING EXPENSES DIVIDEND TAX CAPITAL EXPENDITURE TOTAL PAYMENT (A16:A25)
SUMMARY OF CASH FORECAST OPENING CASH BALANCE RECEIPTS PAYMENTS NET CASH FLOW (A31-A32) CUMULATIVE NET CASH FLOW OPENING CASH BALANCE + CUML. NET CASH FLOW (A30+A34) MINIMUM CASH BALANCE REQUIRED (GIVEN) SURPLUS OR DEFICIT (A36 -A37)
doc_396963128.xls