REQUIRED Use the information provided below to prepare the following for March and April 2024: 4.1 Debtors Collection Schedule 4.2 Cash Budget INFORMATION The following information was provided by BN Traders: 1. The bank balance on 28 February 2024 is expected to be R100 000 (unfavourable). The sales figures for the first four months of 2024 are expected to be as follows: 2 March R1 000 000 3. 4. 4.1 4.2 5. 6. 7. 8 Cash sales usually make up 30% of the total sales. The balance of the sales is on credit. (Separate entries are required for cash sales and collections from credit sales.) Credit sales are normally collected as follows: 30% in the month of the sale, and these debtors are entitled to a 3% discount 65% in the month after the sale January R1 500 000 9. The rest is usually written off as bad debts. Purchases from February to April 2024 are expected to be as follows March February R1 100 000 Cash purchases Credit purchases 10 February R320 000 R350 000 April R1 200 000 R360 000 R400 000 April R480 000 R440 000 Sixty percent (60%) of the cash purchases is subject to a 10% cash discount. Creditors are paid in the month after the month of purchase. (Separate entries for cash purchases and payments to creditors are required.) The monthly salaries amount to R200 000. This includes the salary of the manager, R50 000. On 01 April 2024 the salary of the manager is expected to increase by 8% and the rest of the employees by 10% The loan balance is expected to be R360 000 on 01 March 2024. Repayments of R15 000 per month are made at the end of each month as per the loan agreement. Interest at 12% per annum on the loan balance is also payable at the end of each month Part of the building is sublet to a tenant. The lease agreement for the year ended 31 March 2024 reflected the rental at R144 000 per year payable monthly. The rental will increase by 10% with effect from 01 April 2024 Other cash operating expenses are expected to total R150 000 for February 2024 These expenses are expected to increase by 5% each month thereafter

Cornerstones of Financial Accounting
4th Edition
ISBN:9781337690881
Author:Jay Rich, Jeff Jones
Publisher:Jay Rich, Jeff Jones
Chapter4: Internal Control And Cash
Section: Chapter Questions
Problem 66.1C
icon
Related questions
icon
Concept explainers
Question

Don't give answer in image format 

REQUIRED
Use the information provided below to prepare the following for March and April 2024:
4.1 Debtors Collection Schedule
4.2
Cash Budget
INFORMATION
The following information was provided by BN Traders:
1.
2
3.
4.
4.1
42
5
The bank balance on 28 February 2024 is expected to be R100 000 (unfavourable)
The sales figures for the first four months of 2024 are expected to be as follows:
March
R1 000 000
6.
7.
8
Cash sales usually make up 30% of the total sales. The balance of the sales is on credit. (Separate
entries are required for cash sales and collections from credit sales.)
Credit sales are normally collected as follows:
January
R1 500 000
30% in the month of the sale, and these debtors are entitled to a 3% discount
65% in the month after the sale
9.
February
R1 100 000
The rest is usually written off as bad debts.
Purchases from February to April 2024 are expected to be as follows:
March
R360 000
R400 000
Cash purchases
Credit purchases
10
April
R1 200 000
February
R320 000
R350 000
April
R480 000
R440 000
Sixty percent (60%) of the cash purchases is subject to a 10% cash discount Creditors are paid in
the month after the month of purchase (Separate entries for cash purchases and payments to
creditors are required.)
The monthly salaries amount to R200 000. This includes the salary of the manager, R50 000. On 01
April 2024 the salary of the manager is expected to increase by 8% and the rest of the employees by
10%
The loan balance is expected to be R360 000 on 01 March 2024. Repayments of R15 000 per month
are made at the end of each month as per the loan agreement. Interest at 12% per annum on the
loan balance is also payable at the end of each month
Part of the building is sublet to a tenant. The lease agreement for the year ended 31 March 2024
reflected the rental at R144 000 per year payable monthly. The rental will increase by 10% with effect
from 01 April 2024
Other cash operating expenses are expected to total R150 000 for February 2024 These expenses
are expected to increase by 5% each month thereafter
Transcribed Image Text:REQUIRED Use the information provided below to prepare the following for March and April 2024: 4.1 Debtors Collection Schedule 4.2 Cash Budget INFORMATION The following information was provided by BN Traders: 1. 2 3. 4. 4.1 42 5 The bank balance on 28 February 2024 is expected to be R100 000 (unfavourable) The sales figures for the first four months of 2024 are expected to be as follows: March R1 000 000 6. 7. 8 Cash sales usually make up 30% of the total sales. The balance of the sales is on credit. (Separate entries are required for cash sales and collections from credit sales.) Credit sales are normally collected as follows: January R1 500 000 30% in the month of the sale, and these debtors are entitled to a 3% discount 65% in the month after the sale 9. February R1 100 000 The rest is usually written off as bad debts. Purchases from February to April 2024 are expected to be as follows: March R360 000 R400 000 Cash purchases Credit purchases 10 April R1 200 000 February R320 000 R350 000 April R480 000 R440 000 Sixty percent (60%) of the cash purchases is subject to a 10% cash discount Creditors are paid in the month after the month of purchase (Separate entries for cash purchases and payments to creditors are required.) The monthly salaries amount to R200 000. This includes the salary of the manager, R50 000. On 01 April 2024 the salary of the manager is expected to increase by 8% and the rest of the employees by 10% The loan balance is expected to be R360 000 on 01 March 2024. Repayments of R15 000 per month are made at the end of each month as per the loan agreement. Interest at 12% per annum on the loan balance is also payable at the end of each month Part of the building is sublet to a tenant. The lease agreement for the year ended 31 March 2024 reflected the rental at R144 000 per year payable monthly. The rental will increase by 10% with effect from 01 April 2024 Other cash operating expenses are expected to total R150 000 for February 2024 These expenses are expected to increase by 5% each month thereafter
Expert Solution
steps

Step by step

Solved in 5 steps

Blurred answer
Knowledge Booster
Budgeting
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Cornerstones of Financial Accounting
Cornerstones of Financial Accounting
Accounting
ISBN:
9781337690881
Author:
Jay Rich, Jeff Jones
Publisher:
Cengage Learning
Entrepreneurial Finance
Entrepreneurial Finance
Finance
ISBN:
9781337635653
Author:
Leach
Publisher:
Cengage
Intermediate Financial Management (MindTap Course…
Intermediate Financial Management (MindTap Course…
Finance
ISBN:
9781337395083
Author:
Eugene F. Brigham, Phillip R. Daves
Publisher:
Cengage Learning
Quickbooks Online Accounting
Quickbooks Online Accounting
Accounting
ISBN:
9780357391693
Author:
Owen
Publisher:
Cengage
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781285866307
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning
Financial & Managerial Accounting
Financial & Managerial Accounting
Accounting
ISBN:
9781337119207
Author:
Carl Warren, James M. Reeve, Jonathan Duchac
Publisher:
Cengage Learning