
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
Question

Transcribed Image Text:Question-4
REQUIRED
Use the information provided by Empire Traders 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 Empire Traders:
1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 February 2024.
2. Budgeted sales figures for 2024 are as follows:
3.
4.
5.
6.
7.
Cash sales
Credit sales
9.
January
R320 000
R370 000
Total purchases
February
R370 000
R390 000
March
R310 000
R320 000
Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 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 inventory are expected to be as follows:
January
February
R410 000
R460 000
April
R250 000
R300 000
March
R400 000
April
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 proprietor's monthly drawings 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.
8.
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.
10. Other cash operating expenses are expected to amount to R160 000 for February 2024 and are expected
to increase by 5% each month thereafter.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 3 steps

Knowledge Booster
Similar questions
- Paul's Pool Service provides pool cleaning, chemical application, and pool repairs for residential customers. Clients are billed weekly for services provided and usually pay 40 percent of their fees in the month the service is provided, In the month following service, Paul collects 50 percent of service fees. The final 10 percent is collected in the second month following service. Paul purchases his supplies on credit, and pays 50 percent in the month of purchase and the remaining 50 percent in the month following purchase. Of the supplies Paul purchases, 85 percent is used in the month of purchase, and the remainder is used in the month following purchase. The following information is available for the months of June, July, and August, which are Paul's busiest months: • June 1 cash balance $14,800. • June 1 supplies on hand $4,000. • June 1 accounts receivable $8,300. • June 1 accounts payable $3,900. · Estimated sales for June, July, and August are $24,900, $37,400, and $39,900,…arrow_forwardQUESTION 4 REQUIRED Use the information provided by empire Traders 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 Empire Traders: 1. Empire Traders expects to have a favourable bank balance of R60 000 on 28 february 2024. 2. Budgeted sales figures for 2024 are as follows: January February March April Cash Sales R320 000 R370 000 R310 000 R 250 000 Credit Sales R370 000 R390 000 R320 000 R300 000 3. Thirty percent (30%) of the cash sales is to informal traders who are entitled to a discount of 10%. Collections from debtors are usually as follows: 80% is collected in the month after sale 20% is collected two months after the sale 4. Purchases of inventory are expected to be as follows: January February March April Total Purchases R410 000 R460 000 R400 000 R380 000 5. Sixty percent (60) of then purchases is for cash to take advantage of a discount of 15%. The balance is purchased on…arrow_forwardK Video Brian's Restaurant Supply is preparing its cash budgets for the first two months of the upcoming year. Here is the information about the company's upcoming cash receipts and cash disbursements: (Click the icon to view the information.) Requirements 1. Prepare schedules of (a) budgeted cash collections, (b) budgeted cash payments for purchases, and (c) budgeted cash payments for operating expenses. Show totals for each month and totals for January and February combined. 2. Prepare a combined cash budget. If no financing activity takes place, what is the budgeted cash balance on February 28? Requirement 1a. Prepare a schedule of budgeted cash collections for January and February. Show totals for each month and totals for January and February combined. Brian's Restaurant Supply Cash Collections Budget For the Months Ended January 31 and February 28 Cash sales Collection on credit sales Total cash collections January More info a. Sales are 60% cash and 40% credit. Credit sales are…arrow_forward
- 3.3 Tutorial Questions 3.3.1 Cash Budget 1. A firm reported actual sales of RM65,000 in the month of June and RM70,000 in July. The sales forecasts indicate that sales are expected to be RM85,000, RM92,000 and RM95,750 for the months of August, September and October, respectively. Sales are 60% cash and 40% credit and credit sales are collected evenly over the following 2 month. No other cash receipts were received. What are the firm's expected cash receipts for the month August, September and October? . compile a cash disbursementarrow_forwardQuestion 1 The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases August $85,000 $640,000 $420,000 September $70,000 $550,000 $550,000 October $88,550 $600,000 $500,000 November $77,160 $800,000 $600,000 December $174,870 $500,000 $450,000 - An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90: 50% in the month of sale 30% in the first month following the sale 20% in the second month following the sale -Expected purchases include monthly cash purchases of 5%. All other purchases are on Accounts payable are settled as follows,…arrow_forwardQuestion 8 View Policies Current Attempt in Progress Waterway Industries reported the following information for 2016: rt October November December Budgeted sales $1330000 $1230000 $1510000 . All sales are on credit. . Customer amounts on account are collected 50% in the month of sale and 50% in the following month. How much cash will Waterway receive in November? O $1370000 O $615000 O $1230000 O $1280000 hp Su prt sc delete hom & 7 backspace P H J Karrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education