Finish the following Cash Budget

CASH BUDGET
		JAN	FEB	MAR	APRIL	MAY	JUNE	JULY	AUG	SEPT	OCT	NOV	DEC
SALES		200,000	230,000	150000	210,000.00	220,000.00	170,000.00	160,000.00	150,000.00	180,000.00	210,000.00	220,000.00	210,000.00
COLLECTIONS:
No cash Sales
30 days	50%
60 days	50%
TOTAL CASH RECEIPTS
CASH DISBURSEMENTS
SUPPLIES	70%
PAYABLES/SUPPLIES	paid next month(in 30 days)
SALARIES/OVER	monthly	40000
INTEREST	monthly	1000
DIVIDENDS	monthly	1000
TAXES	quarterly			1200
TOTAL DISBURSEMENT		42000	0	1200	0	0	0	0	0	0	0	0	0
NET CHANGE IN CASH
BEGINNING CASH		10000	0	0	0	0	0	0	0	0	0	0	0
FINANCING NEEDED		0	0	0	0	0	0	0	0	0	0	0	0
ENDING CASH
	starting loan balance
CUMMULATIVE BORROWING	100,000