FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
Bartleby Related Questions Icon

Related questions

bartleby

Concept explainers

Question

BTB (Pty) Limited is a distributor of PPE to rural health clinics in KZN. Turnover has been good and running expenses are under control, however the owner of the business, Mr Sam Jonas, is concerned that upcoming legal expenses and necessary vehicle repairs may negatively affect the business’ cash flow. He has hired you to prepare a cash budget for the next four months, from July to October 2022.

All sales are made on credit and collected as follows:

• 40% in the month of the sale;

• 35% in the month after the sale;

• 15% in the second month after the sale;

• 10% will be written off as bad debts.

All purchases are made on credit and paid for as follows:

• 60% in the month of the purchase and 

• 40% in the month after the purchase.

 

Total administration expenses (rent, rates stationary etc) will be R14 000 per month. The legal costs will be R34 000 in each of July and August 2022. Major repairs and maintenance to vehicles will cost R45 000 and this amount will be paid in three equal instalments from August to October 2022. Cash on hand on 1st July 2022 is expected to be zero, however the company has agreed to maintain a minimum cash balance of R28 000 at all times with immediate effect.

Actual sales were R180 000 for May and R130 000 for June 2022. The estimated sales are R140 000 for July, R120 000 for August, R100 000 for September and R110 000 for October. Purchases for June 2022 were R75 000. The estimated purchases are R80 000 for July, R65 000 for August, R40 000 for September and R50 000 for October.  

Required:

(e) Determine the cumulative cash balance at the end of October

 

Expert Solution
Check Mark
Knowledge Booster
Background pattern image
Accounting
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
Text book image
FINANCIAL ACCOUNTING
Accounting
ISBN:9781259964947
Author:Libby
Publisher:MCG
Text book image
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
Text book image
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Text book image
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
Text book image
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
Text book image
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education