Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

REQUIRED Use the following information provided by Ashton Enterprises to prepare the: 5.1 Debtors Collection Schedule for January and February 2021. 5.2 Cash Budget for

image text in transcribed REQUIRED Use the following information provided by Ashton Enterprises to prepare the: 5.1 Debtors Collection Schedule for January and February 2021. 5.2 Cash Budget for January and February 2021. Note: Where applicable, round off amounts to the nearest Rand. INFORMATION 1. The bank balance on 31 December 2020 is expected to be R40 000 (favourable). Expected credit sales are as follows: 2. 3. 4. * December 2020 R360 000 January 2021 R390 000 February 2021 R420 000 Credit sales usually make up 60% of the total sales. Cash sales make up the balance. Credit sales are normally collected as follows: 20% in the month in which the transaction took place. These debtors are entitled to a 5% discount. * 75% in the following month. The rest is usually written off as bad debts. 11 5. The mark-up is 25% on cost. The goods that are sold each month are replaced in the same month. The ratio of cash purchases to credit purchases is 3:1 respectively. Creditors are paid in the month after the purchase. Cash purchases of inventory are subject to a 10% discount. 6. 7. 8. 9. The salaries for February 2021 are expected to amount to R114 480, after an 8% increase takes effect on 01 February 2021. Interest at 15% per annum on the loan balance is paid at the end of each month. The loan balance on 01 January 2021 is expected to be R200 000 and capital repayments of R20 000 are made at the end of each month. Part of the building is sublet to a tenant. The rent expense for the year ended 31 December 2020 is R131 000. The rental increases by 10% on 01 February each year. Rent is received monthly. Other operating expenses are estimated at R28 000 per month. This amount excludes R2 000 for depreciation. Sixty percent (60%) of the operating expenses are paid for in the month in which they are incurred. The rest is paid in the following month

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Managerial Accounting Tools for Business Decision Making

Authors: Jerry J. Weygandt, Paul D. Kimmel, Donald E. Kieso, Ibrahim M. Aly

4th Canadian edition

1118856996, 978-1118856994

More Books

Students also viewed these Accounting questions