Question: (4 marks) Use the information provided below to prepare the following for March and April 2022: 4.1 Debtors Collection Schedule 42 Cash Budget INFORMATION (16

 (4 marks) Use the information provided below to prepare the following

(4 marks) Use the information provided below to prepare the following for March and April 2022: 4.1 Debtors Collection Schedule 42 Cash Budget INFORMATION (16 marks) The following forecasts have been made by the management team of FG Wholesalers: 1. The bank balance on 28 February 2022 is estimated to be R30 000 (unfavourable). 2. Budgeted sales (excluding discounts) for the first four months of 2022 are as follows: January February March April Cash sales R102 000 R114 000 R100 000 R80 000 Credit sales R115000 R128 000 R105 000 R82000 3. Customers who purchase for cash are entitled to a 10% cash discount Collections from credit sales are expected to be as follows: * 70% in the month after the sale; * 25% two months after the sale. 5% is usually written off as irrecoverable 4. Expected purchases for the first four months of 2022 are as follows: January February March April Cash purchases R55 000 R56 000 R50 000 R40 000 Credit purchases R60 000 R65000 R60 000 R45 000 5. Creditors are paid in the month after the purchase. A discount of 5% is expected on 60% of these purchases. 6. The proprietor's fixed monthly drawings comprise 75% cash and 25% trading stock. The cost of the trading stock that the proprietor takes is R1 250. 7. The monthly salaries amount to R50 000. Salaries will increase by 8% with effect from 01 April 2022 8. The last installment on the loan, R4 000, as well as interest on loan for April 2022 will be paid at the end of April 2022. The interest rate is 15% 9. Equipment will be purchased on credit during March 2022 for R100 000. A deposit of 20% will be paid during March 2022. The balance plus finance charges of R10 000 will be paid in ten equal instalments commencing April 2022 10. Cash operating expenses are expected to amount to R30 000 for February 2022 and are expected to increase by 5% per month thereafter

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!