The following quarterly results are expected by XYZ Ltd next year (Rs. in thousands)

	Quarter
	1	2	3	4
Sales	7,500	10,500	18,000	10,500
Cash Payments:
Production Costs	7,000	10,000	8,000	8,500
Selling, administrative and other costs	1,000	2,000	2,900	1,600
Purchases of plant and other fixed costs	100	1,100	2,100	2,100

Debtors at the end of a quarter are one-third of sales for the quarter. The opening balance of debtors is Rs. 30,00,00. Cash in hand at the beginning of the year is Rs. 6,50,000 and the desired minimum balance is Rs. 5,00,000. Borrowings are made in multiples of Rs. 10,000 at the beginning of the quarter in which need will occur and are repaid at the end of the quarter. Interest charges may be ignored.

Question:

prepare:

(i) Cash Budget by quarters for the year, and

(ii) State the amount of loan outstanding at the end of the year.