Answered step by step
Verified Expert Solution
Question
1 Approved Answer
REQUIRED Use the following information provided by Ashton Enterprises to prepare the: 5.1 Debtors Collection Schedule for January and February 2021. 5.2 Cash Budget for
REQUIRED Use the following information provided by Ashton Enterprises to prepare the: 5.1 Debtors Collection Schedule for January and February 2021. 5.2 Cash Budget for January and February 2021. Note: Where applicable, round off amounts to the nearest Rand. INFORMATION 1. The bank balance on 31 December 2020 is expected to be R40 000 (favourable). Expected credit sales are as follows: 2. 3. 4. * December 2020 R360 000 January 2021 R390 000 February 2021 R420 000 Credit sales usually make up 60% of the total sales. Cash sales make up the balance. Credit sales are normally collected as follows: 20% in the month in which the transaction took place. These debtors are entitled to a 5% discount. * 75% in the following month. The rest is usually written off as bad debts. 11 5. The mark-up is 25% on cost. The goods that are sold each month are replaced in the same month. The ratio of cash purchases to credit purchases is 3:1 respectively. Creditors are paid in the month after the purchase. Cash purchases of inventory are subject to a 10% discount. 6. 7. 8. 9. The salaries for February 2021 are expected to amount to R114 480, after an 8% increase takes effect on 01 February 2021. Interest at 15% per annum on the loan balance is paid at the end of each month. The loan balance on 01 January 2021 is expected to be R200 000 and capital repayments of R20 000 are made at the end of each month. Part of the building is sublet to a tenant. The rent expense for the year ended 31 December 2020 is R131 000. The rental increases by 10% on 01 February each year. Rent is received monthly. Other operating expenses are estimated at R28 000 per month. This amount excludes R2 000 for depreciation. Sixty percent (60%) of the operating expenses are paid for in the month in which they are incurred. The rest is paid in the following month
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