In: Accounting
QUESTION 3 REQUIRED Use the information provided below to prepare the following for Electroman Limited for August and September 2020 (using separate monetary columns for each month):
3.1 Debtors Collection Schedule
3.2 Cash Budget. Note: Where applicable, round off amounts to the nearest Rand. INFORMATION Electroman Limited sells appliances.
The following forecasts were made:
1. The bank balance on 31 July 2020 is expected to be R50 000 (favourable).
2. Sixty percent (60%) of all sales are for cash; the balance is on credit. Credit sales for June and July 2020 are expected to be R320 000 and R360 000 respectively. Sales are expected to increase by 10% each month. Twenty percent (20%) of the credit sales are expected to be settled during the month of the sale for a discount of 5%. The remaining customers usually pay in the month after the sale.
3. All appliances are purchased on credit and the creditors are paid in the month after the purchase. Purchases are expected to be as follows: July R420 000 August R460 000 September R510 000
4. Salaries and wages are expected to cost R85 800 for September 2020, after a 10% increase takes effect on 01 September 2020.
5. Advertising expenses are expected to be 6% of the total monthly sales, and are paid one month later. 6. Equipment that cost R300 000 is expected to be purchased during August 2020.
6. A deposit of 10% will be paid in August and the balance plus finance charges of R20 000 is payable in 5 equal instalments commencing September 2020.
7. A long-term loan of R250 000 at 12% per annum interest is to be raised on 01 August 2020. Interest on loan and a loan repayment of R5 000 is payable monthly on the last day of each month, commencing 31 August 2020.
8. Other cash expenses are expected to amount to R80 000 for July 2020. These expenses are expected to increase by 5% each month.
9. An interim dividend of 8 cents per share is expected to be paid to shareholders on 31 August 2020. The issued share capital of Electroman Li
mited consists of 500 000 ordinary shares