Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 4 (20 MARKS) REQUIRED Use the information provided below to prepare the following for August and September 2023: 4.1 Debtors Collection Schedule (4 marks)

QUESTION 4 (20 MARKS) REQUIRED Use the information provided below to prepare the following for August and September 2023:

4.1 Debtors Collection Schedule (4 marks)

4.2 Cash Budget (16 marks)

INFORMATION

The following information was provided by Orlando Enterprises:

1. The bank balance on 31 July 2023 is expected to be R80 000 (favourable).

2. The expected sales are as follows:

JuneJulyAugustSeptemberCash salesR408 000R480 000R412 000R300 000Credit salesR500 000R540 000R224 000R340 000

3. Customers who purchase for cash are entitled to a 5% discount. Collections from credit sales are expected to be as follows: 3.1 20% in the month of sale, and these debtors receive a 2% discount 3.2 80% in the month after the sale 4. The expected purchases (excluding discounts) are as follows:

The expected purchases (excluding discounts) are as follows:

JuneJulyAugustSeptemberCash purchasesR240 000R288 000R246 000R200 000Credit purchasesR260 000R280 000R220 000R180 000

5. A discount of 10% is receivable on all cash purchases. Creditors are paid two months after the month of purchase. 6. The proprietors cash drawings will amount to R20 000 for September 2023. 7. The monthly salaries amount to R120 000. Salaries will increase by 7.5% with effect from 01 September 2023. 8. The final instalment on the loan, R12 000, together with interest at 18% p.a. for one month will be paid at the end of August 2023. 9. A vehicle will be purchased during August 2023 for R480 000. A deposit of 20% will be paid during August 2023. The balance of the loan plus interest of R71 400 will be paid in 36 equal monthly instalments from September 2023. 10. Cash operating expenses are expected to amount to R80 000 for July 2023 and are expected to increase by 2% per month thereafter.

image text in transcribed REQUIRED Use the information provided below to prepare the following for August and September 2023: 4.1 Debtors Collection Schedule (4 marks) 4.2 Cash Budget (16 marks) INFORMATION The following information was provided by Orlando Enterprises: 1. The bank balance on 31 July 2023 is expected to be R80000 (favourable). 2. The expected sales are as follows: 3. Customers who purchase for cash are entitled to a 5% discount. Collections from credit sales are expected to be as follows: 3.120% in the month of sale, and these debtors receive a 2% discount 3.280% in the month after the sale 4. The expected purchases (excluding discounts) are as follows: 5. A discount of 10% is receivable on all cash purchases. Creditors are paid two months after the month of purchase. 6. The proprietor's cash drawings will amount to R20 000 for September 2023. 7. The monthly salaries amount to R120000. Salaries will increase by 7.5% with effect from 01 September 2023. 8. The final instalment on the loan, R12 000 , together with interest at 18% p.a. for one month will be paid at the end of August 2023. 9. A vehicle will be purchased during August 2023 for R480000. A deposit of 20% will be paid during August 2023. The balance of the loan plus interest of R71 400 will be paid in 36 equal monthly instalments from September 2023. 10. Cash operating expenses are expected to amount to R80 000 for July 2023 and are expected to increase by 2% per month thereafter

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

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

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions