please assist

QUESTION 4 (20 Marks) REQUIRED Use the inlormation given below to prepare the following for July. August and Seplamber 2023. 4.1 Debtors Collection Schedule 4.2 Cash Budgot (6 maks) (14 mats) INFORMATION Brentiord Limiled suppied the folowing budgeled information for 2023 : 1. The expected sales figures for the second and fird quarters of 2023 are as follows: 2. Experienoe has shown that salas \60 of the sales is for cash and the balince is on credt. Seventy percent (70\\%) of the credit sales is collocted in the month ater the sale. The balance is crilected two months aher the sale. 3. Purchases of inventory arte ostmated to equal \50 of the sales. Farty peroint (40\\%) of the purchases will be on credit and creditors are paid wo mocths aher the purchase. The rest will be lor cash, subject to a \10 cash discourt 4. Salaries and wagas are budgutod at R80 000 per month from tune to August 2023. On 01 Septenter: 2023 employees will reoeive an increase of \95 in freir romuneration. 5. Markating experues are esfimated at \10 of the totai sales and payment is dilaynd by one month. 6. Admiristration expenses ase expocied to be Re0 000 per month, payable monthly. 7. An investment of R 100000 wil be made in a foed deposit acoount on 31 Jly 2023 . Interest at \9 per year will be received monthly trom August 2002 . 8. Brentford limiled oxpects to pay an intarm dividend of 6 cents per share on 31 Auguth 2023 . The iseued share capital of the company oonsists of 300000 ondinary shares. 9. The bank balance on 30 June 2023 is expected to be R40 000 (tavourable)