Answered step by step
Verified Expert Solution
Question
...
1 Approved Answer
Goodmorning , please could you assist in the following questions posed to prepare the following: 1) Debtors collection schedule 2) Cash budget Thank you. Use
Goodmorning , please could you assist in the following questions posed to prepare the following:
1) Debtors collection schedule
2) Cash budget
Thank you.
Use the information provided below to prepare the following for March and April 2022: 4.1 Debtors Collection Schedule (4 marks) 4.2 Cash Budget (16 marks) INFORMATION 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 R115 000 R128 000 R105 000 R82 000 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; C *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 R55 000 Cash purchases R56 000 R40 000 R50 000 Credit purchases R60 000 R65 000 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 instalment on the loan, R4 000, as well as interest on loan for April 2022 will be paid at the end of April 8. The last instalment 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 thereafterStep by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started