Information: 1. Cash at bank on 1 January 2021 amounted to R155 000. 2. Projected sales per quarter for 2021: First quarter R450 000 Second quarter R750 000 Third quarter R870 000 Fourth quarter R880 000 Sixty percent (60%) of the sales are for cash and forty percent (40%) are on credit. Cash customers are entitled to a 5% cash discount. 3. Collection of credit sales: 55% of the credit sales are collected in the quarter of the sale. • 35% is collected in the following quarter and the balance is written off as a bad debt. 4. Purchases for each quarter are expected to be as follows: First quarter R120 000 Second quarter R125 000 Third quarter R130 000 Fourth quarter R170 000 All purchases are on credit. 70% of the purchases will be paid for in the quarter of purchase and the remaining 30% in the following quarter. 5. Fixed overheads total R180 000 per year and are paid for equally each quarter. 6. Administrative expenses are paid for in the quarter in which they are incurred and are estimated at a total of R15 000 per quarter. 7. An investment of R100 000 matures on 30 June 2021, and interest of R12 000 will also be received on this date.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question
100%

Prepare Cash Budget for four quarters of 2021

Information:
1. Cash at bank on 1 January 2021 amounted to R155 000.
2. Projected sales per quarter for 2021:
First quarter R450 000
Second quarter R750 000
Third quarter R870 000
Fourth quarter R880 000
Sixty percent (60%) of the sales are for cash and forty percent (40%) are on credit. Cash customers are
entitled to a 5% cash discount.
3. Collection of credit sales:
55% of the credit sales are collected in the quarter of the sale.
• 35% is collected in the following quarter and the balance is written off as a bad debt.
4. Purchases for each quarter are expected to be as follows:
First quarter R120 000
Second quarter R125 000
Third quarter R130 000
Fourth quarter R170 000
All purchases are on credit. 70% of the purchases will be paid for in the quarter of purchase and the
remaining 30% in the following quarter.
5. Fixed overheads total R180 000 per year and are paid for equally each quarter.
6. Administrative expenses are paid for in the quarter in which they are incurred and are estimated at a
total of R15 000 per quarter.
7. An investment of R100 000 matures on 30 June 2021, and interest of R12 000 will also be received
on this date.
Transcribed Image Text:Information: 1. Cash at bank on 1 January 2021 amounted to R155 000. 2. Projected sales per quarter for 2021: First quarter R450 000 Second quarter R750 000 Third quarter R870 000 Fourth quarter R880 000 Sixty percent (60%) of the sales are for cash and forty percent (40%) are on credit. Cash customers are entitled to a 5% cash discount. 3. Collection of credit sales: 55% of the credit sales are collected in the quarter of the sale. • 35% is collected in the following quarter and the balance is written off as a bad debt. 4. Purchases for each quarter are expected to be as follows: First quarter R120 000 Second quarter R125 000 Third quarter R130 000 Fourth quarter R170 000 All purchases are on credit. 70% of the purchases will be paid for in the quarter of purchase and the remaining 30% in the following quarter. 5. Fixed overheads total R180 000 per year and are paid for equally each quarter. 6. Administrative expenses are paid for in the quarter in which they are incurred and are estimated at a total of R15 000 per quarter. 7. An investment of R100 000 matures on 30 June 2021, and interest of R12 000 will also be received on this date.
Expert Solution
steps

Step by step

Solved in 3 steps

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