REQUIRED Use the information provided below to prepare the following for July and August 2024 : 5.1 Debtors Collection Schedule 52 Cash Budget. INFORMATION The following information was provided by Miller Enterprises: 1. The balance in the bank on 30 June 2024 is expected to be R50 000 2. 3. Twenty percent (20%) of the cash sales is subject to a discount of 10%. Credit sales are normally callected as follows: 60% in the manth of the sale, and these customers are entitled to a 5% discount. 40% in the month after the sale. 4. R50 000 will be invested in a fixed deposit account on 31 July 2024 at an interest rate of 12% per annum. Interest will be received monthly commencing August 2024 5. Dirmhaces are avnented in he ae fillnuic: 6. Creditors are paid in the month after the month of purchase. 7. Wages and salaries are expected to amount to R143 000 for August 2024 after a 10% increase takes effect from 01 August 2024. Creditors are paid in the month after the month of purchase. Wages and salaries are expected to amount to R143 000 for August 2024 after a 10\% increase takes effect from 01 August 2024. Loan repayments of R10 000 are made at the end of each month. The balance in the loan account is expected to be R300 000 on 01 July 2024 . Interest at 12% per annum is alsc payable at the end of each month. Rent income amounts to R96000 per year. Rent is received monthly. Other cash expenses are budgeted at R30 000 for June 2024 . These expenses are expected to increase by 5% each month. END OFPAPER FORMULA SHEET