Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the information provided below to prepare the following for February, March and April 2023: 4.1 Debtors Collection Schedule (6 marks) 4.2 Cash Budget (14

Use the information provided below to prepare the following for February, March and April 2023: 4.1 Debtors Collection Schedule (6 marks) 4.2 Cash Budget (14 marks) INFORMATION The information given below has been made available by Regent Retailers to assist in the preparation of its cash budget for February to April 2023. 1. The sales forecasts for the first four months of 2023 are as follows: January R480 000 February R540 000 March R580 000 April R720 000 2. Forty percent (40%) of the sales is expected to be for cash and the balance on credit. 3. Payment for 20% of the credit sales is usually received in the month of the sale. The balance is collected in the month after the sale. 4. Expected purchases of inventory are as follows: January R260 000 February R280 000 March R300 000 April R360 000 Fifty percent (50%) of the inventory purchases are paid for in the month of purchase to take advantage of a 10% discount. The balance is on credit and is paid in the month after the purchase. 5. Recurring monthly expenses are as follows: Depreciation R40 000 Cash expenses R200 000 6. Regent Retailers expects to obtain a long-term loan of R300 000 on 31 March 2023. Interest is charged at 15% per annum and interest is paid monthly, commencing April 2023. 7. Annual property rates will be paid on 01 April 2023 and rates are calculated at R20 per R1 000 of the value of the property. The property is valued at R1 000 000. 8. Regent Retailers expects to have a bank overdraft of R50 000 on 31 January 2023.

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

Health Care Finance Economics And Policy For Nurses

Authors: Betty Rambur

2nd Edition

0826152538, 978-0826152534

More Books

Students also viewed these Finance questions

Question

Draw a picture consisting parts of monocot leaf

Answered: 1 week ago