REQURED Prepare the Cash Budget for Otober, November and December 2023 from the informaion provided below. Note: Where applicable, round of amounts to the nearest Rand. Use separate monetary columns for each morth. INFOPMATION The information given below has been made avalable by Pep Retailers to assist in the preparation of the cash budget for the fourth quarter of 2023. 1. Estimated cash sales after a 10% cash dscount are as follons: 2. Forty percent (40%) of the sales is for cash and 60% is on aredt. 3. Payments by dehtors for credt sales are received in the morth after the sale. 4. Expected invertory purchases (exduding discounts) are as follovs: Invertory purchases are paid for in the morth of the purchase to take advantage of a 10% discount. 5. Detais regarding reauning monthly expenses are as follows: 5.1 The salary bill for December 2023 is R316800,10% more than the salaries for each of the preceding two months. 52 Other monthly expenses are paid morthly and amourt to R384 000, induding deprecition of R80 000. 6. Pep Retalers is eqpeted to obtain a long-term loan of R560 000 on 01 November 2023 with an expansion project in mind for 2024 . Interest is dharged at 15% per annum Capital repayments of R20 000 and interest are to be paid morthly, commenaing 30 November 2023. 7. The annual property rates will be paid 01 November 2023 . The assessment for the year is calaulated at R4 per R100 of the propaty value. The property is valued at R1 800000 . 8. Pep Retailers expects to have an unfavourable bank balance of R100 000 on 30 September 2023