Prepare each of the following for June and July 2020 from the information provided above. (Provide separate monetary columns for each month.)  4.1 Debtors collection schedule (6) 4.2 Cash budget (19) END

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

The information provided below was taken from the records of Chotoo Projects for the financial year ended 31 May 2020. Extract of statement of comprehensive income for the year ended 31 May 2020 R Revenue 480 000 Direct costs 240 000 Rent income 150 000 Advertising 4 800 Salaries and wages 90 000 Rates and taxes 1 200 Other operating expenses 80 000 21 Additional information 1. Revenue is calculated as direct cost plus 25%. 2. Revenue is divided equally each month. Revenue is expected to increase by 18% for the financial year ending 31 May 2021. 3. Fifty percent (50%) of the revenue is for cash and the balance is on credit. Debtors normally pay their accounts as follows:  40% in the month of the invoice, and these debtors are entitled to a 5% discount;  55% one month after the invoice; The balance is usually written off as bad debts. 4. Purchases for June and July are expected to be 30 000 per month. All purchases are for cash. 5. In terms of the lease agreement rent is received monthly. The rent for the year ending 31 May 2021 is expected to be 12% more than the previous twelve months. 6. Advertising is paid for monthly and is estimated to be 8% of each month’s sales. 7. Salaries and wages will increase by 12% with effect from 01 July 2020. 8. Rates and taxes are paid in one instalment for the year during July 2020. Rates are calculated at 5% of the value of the premises. The premises are valued at R500 000. 9. Other operating expenses are expected to increase by 7% and are spread evenly throughout the year. Operating expenses are paid for in the month in which they are incurred. 10. On 31 May 2020 a Debit bank balance of R6 000 appeared in the ledger of Chotoo Projects. Required: Prepare each of the following for June and July 2020 from the information provided above. (Provide separate monetary columns for each month.)  4.1 Debtors collection schedule (6) 4.2 Cash budget (19) END

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Cost volume profit (CVP) analysis
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