Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

STAR Limited is in the process of formulating plans for the first quarter of 2022. REQUIRED Use the information provided below to prepare the following

STAR Limited is in the process of formulating plans for the first quarter of 2022. REQUIRED Use the information provided below to prepare the following for STAR LIMITED for January, February and March 2022 (use separate amount columns for each month): 3.1 Debtors Collection Schedule (6 marks) 3.2 Cash Budget (14 marks) INFORMATION 1. The following sales figures are forecast: Year Month Sales (R) 2021 December 540 000 2022 January 380 000 2022 February 295 000 2022 March 320 000 2. Forty percent (40%) of the sales are expected to be for cash and the balance is on credit. 3. Twenty percent (20%) of the credit sales is expected to be collected in the month of the sale and eighty percent (80%) in the month after the sale. 4. Inventory equals 60% of the current months sales. All purchases are for cash in order to take advantage of a 10% discount. 5. Wages and salaries equal 20% of the current months sales. Labour costs are paid for in the month in which they are incurred. 6. Property taxes are estimated to be R48 000 for 2022 and will be paid in four equal instalments in the last month of each quarter. 7. General and administrative expenses are projected to be R222 000 for 2022 and are payable monthly. These expenses are incurred evenly throughout the year. 8. Selling and distribution expenses amount to R15 000 for January 2022 and are expected to increase by 10% per month thereafter. These expenses are paid for in the month in which they are incurred. 9. Income tax payments of the Company is paid in January 2022 for an amount of R75 000. 10. The expected cash balance on 31 December 2021 is R55 000.

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_2

Step: 3

blur-text-image_3

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

Making Sense Of School Finance

Authors: Clinton Born

1st Edition

1475856652, 978-1475856651

More Books

Students also viewed these Finance questions

Question

1. Write down two or three of your greatest strengths.

Answered: 1 week ago

Question

What roles have these individuals played in your life?

Answered: 1 week ago

Question

2. Write two or three of your greatest weaknesses.

Answered: 1 week ago