QUESTION $420$ MARKS REQUIRED Use the information provided below to prepare the following for February and March $2025$: $4\mathrm{.}1$ Debtors Collection Schedule $(4$ marks$)4\mathrm{.}2$ Cash Budget. $(16$ marks$)$ INFORMATION The following budgeted information is available for $2025$ and was provided by Questor Limited: $1.$ An unfavourable bank balance of R$75000$ is expected on $31$ January. $2.$ Seventy percent $(70\%)$ of the sales is for cash; the balance is on credit. Sales for January and February are expected to be R$400000$ and R$600000$ respectively. Sales are expected to increase by $10\%$ during March $2025.$ Thirty percent $(30\%)$ of the credit sales are expected to be collected in the month of the sale for a cash discount of $5\%.$ The remaining customers pay one month later. $3.$ Questor Limited sells its products at cost plus $100\%.$ All goods that are sold each month are replaced in the same month. All purchases are on credit and creditors are paid in month after the purchase. $4.$ Salaries and wages cost R$162000$ for March, after an increase of $8\%$ takes effect from $01$ March. $5.$ Rent expense costs R$130000$ for $2025$ and is payable monthly. The rental increases by $10\%$ on $01$ March each year. $6.$ Insurance costs R$3000$ per month but will be paid in full for $2025$ on $28$ February to take advantage of a reduction of $10\%$ in the premiums for the year. $7.$ Municipal rates are paid half$-$yearly in February and August. The annual rates are calculated at $6$ cents per rand on the market value of the property. The market value of the property of Questor Limited is R$4000000.8.$ Monthly administration costs of R$50000($excluding R$20000$ for depreciation$)$ are payable in the month in which they are incurred. $9.$ Advertising expenses are estimated to be $6\%$ of the monthly sales and are paid one month in arrears. $10.$ Equipment with a cost price of R$600000$ will be purchased during February. A deposit of R$60000$ will be paid during February and the balance is payable in five equal monthly instalments commencing March. $11.$ A long$-$term loan of R$300000$ at $15\%$ per annum interest is to be raised on $01$ March. A capital repayment of R$12000$ and interest are payable monthly commencing $31$ March