From the following information you are to prepare a Cash Budget for the period from July to December 2008.

From the following information you are to prepare a Cash Budget for the period from July to December 2008.

i) The estimated sales and expenses are as follows:

ii) Sales are 20% in cash and balance on credit. 50% of the debtors are collected in the month of sales and the remaining in the next month.

iii) The time lag in payment of purchases and expenses is 1 month. However, wages and salaries are paid fortnightly with a time lag of 15 days.

iv) The company maintains a minima cash balance of Rs. 5,000. The cash balance in excess of Rs. 7,000 is invested in government securities in multiples of Rs. 1,000. Short falls in cash balance are made good by borrowing from banks. The interest received as well as paid is to be ignored.

					Cash Budget
Particular				July	Aug		Sep			Oct		Nov		Dec
Recipts:-
1) cash sales				8,000	8,000		10,000			10,000		12,000		13,000
2) Collection				16,000	16,000		20,000			20,000		24,000		26,000
50% in the same month
3) collection Debtor				0	16,000		16,000			20,000		20,000		24,000
in the following month
4) Intt Recd				0	0		2,000			0		0		0
5) Sales of fixed
Accents				0	20,000		0			0		0		0
Payment:-
1) Purchases			14,000			16,000		17,000	20,000		20,000		25,000
2) Expenses			5,000			6,000		6,000	6,000		7,000		7,000
3) wages and
Salaries			7,000			7,000		9,000	9,000		10,000		11,000
			6,000			7,000		7,000	9,000		9,000		10,000
			32,000			36,000		39,000	44,000		46,000		53,000
Balance
Cash			5,000			5,000		5,000	5,000		5,000		5,000
Deficit/surplus			13,000			19,000		4,000	1,000		5,000		5,000
			(borrowed)			(invested)
Closing Cash			18,000			24,000		9,000	9,000		10,000		10,000