Answered step by step
Verified Expert Solution
Question
1 Approved Answer
QUESTION 4 (20 Marks) REQUIRED Use the information providedby Empire Tradersto prepare the following for March and April 2024: Debtors Collection Schedule (4 marks) Cash
QUESTION 4 | (20 Marks) |
REQUIRED
Use the information providedby Empire Tradersto prepare the following for March and April 2024:
- Debtors Collection Schedule (4 marks)
- Cash Budget. (16 marks)
INFORMATION
The followinginformation was providedby Empire Traders:
- Empire Traders expectsto have a favourable bank balance of R60 000 on 28 February 2024.
- Budgeted sales figuresfor 2024 are as follows:
January | February | March | April | |
Cash sales | R320 000 | R370 000 | R310 000 | R250 000 |
Credit sales | R370 000 | R390 000 | R320 000 | R300 000 |
- Thirty percent (30%) of the cash sales is to informaltraders who are entitled to a discountof 10%. Collections from debtors are usually as follows:
- 80% is collected in the month after the sale.
- 20% is collected two months after the sale.
- Purchases of inventoryare expected to be as follows:
January | February | March | April | |
Total purchases | R410 000 | R460 000 | R400 000 | R380 000 |
- Sixty percent (60%) of the purchases is for cash to take advantage of a discount of 15%. The balance is purchased on credit. Creditors are paid two months after the month of purchase. (Separate entries for cash and credit payments are required.)
- The proprietors monthlydrawings comprise R12 000 inventory and R10 000 cash.
- The monthly salaries are expected to amount to R194 400 for April 2024 after an increase of 8% takes effect on 01 April 2024.
- A fixed deposit, R100 000, will mature (expire) on 31 March 2024. Interest at 12% per annum for three months will also be received.
- Equipment with a cost price R160 000 will be purchased on 31 March 2024. A deposit 25% will be paid on this date. The balance will be paid in four equal monthly instalments commencing 30 April 2024.
- Other cash operating expensesare expected to amount to R160 000 for February2024 and are expected to increase by 5% each month thereafter.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started