solve without using excel and show all calculations

Q.6 Set. (B) ABC Company Ltd. has given the following particulars. You are required to prepare a cash budget for the three months ending 31st December, 2021. [10 Marks] i) Credit terms are: Sales terms: 20% sales are on cash basis; 40% of credit sales are collected next month and the balance in the following month. Creditors terms: -Materials 1 months -Wages 1/2 month -Overheads 1/4 month ii) Cash balance on October 1 is expected to be 50,000. iii) A machinery will be installed in August, at a cost of 2,00,000. The monthly installment of 10,000 is payable form October onwards. iv) Dividend at 5% on preference share capital of 3,00,000 will be paid on October 1 . v) Advance to be received from sale of vehicle 10,000 in November. vi) Income-tax (advance) to be paid in December 10,000. For simplicity, ignore any interest on cash balances