help

Bauer Ltd has provided the following information regarding its expected activities from July to December 2023. The following additional information are also provided: - The expected cash balance as of 1 October 2023 is 15,000. - Sales are 60% on cash and 40% on credit. Payment for credit sales is expected to receive after one month from the month of sales. - Purchases are all on credit. Credit terms of purchases allow payment within two months from the month of purchase. The owner of the company, David to take full advantage of these credit terms. - Rent is paid quarterly, and wages, advertising and overheads are to be paid in the month in which they are expected to occur. - David to receive dividend of 17,000 in November 2023 . - In October, the business to sell an old vehicle for 7,500 cash and expected to pay cash for a new vehicle in November 2023, which is estimated to cost 16,500. - David plans to contribute 14,500 cash and 3,500 worth office equipment in December 2023. - New fittings to the value of 2,725 are to be purchased in October 2023. Using the information provided, you are required to: i. Prepare a Budgeted Cash Flow Statement for Bauer Ltd for the period October to December 2023. (20 marks) ii. Comment on the results (2) and suggest three actions (3) the owner may consider improving the cash flow situation. (Total 5 marks) Bauer Ltd has provided the following information regarding its expected activities from July to December 2023. The following additional information are also provided: - The expected cash balance as of 1 October 2023 is 15,000. - Sales are 60% on cash and 40% on credit. Payment for credit sales is expected to receive after one month from the month of sales. - Purchases are all on credit. Credit terms of purchases allow payment within two months from the month of purchase. The owner of the company, David to take full advantage of these credit terms. - Rent is paid quarterly, and wages, advertising and overheads are to be paid in the month in which they are expected to occur. - David to receive dividend of 17,000 in November 2023 . - In October, the business to sell an old vehicle for 7,500 cash and expected to pay cash for a new vehicle in November 2023, which is estimated to cost 16,500. - David plans to contribute 14,500 cash and 3,500 worth office equipment in December 2023. - New fittings to the value of 2,725 are to be purchased in October 2023. Using the information provided, you are required to: i. Prepare a Budgeted Cash Flow Statement for Bauer Ltd for the period October to December 2023. (20 marks) ii. Comment on the results (2) and suggest three actions (3) the owner may consider improving the cash flow situation. (Total 5 marks)