Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Clean Enterprise Limited Cash sales Credit sales Credit purchases Salaries Utilities Depreciation Property taxes Insurance Advertising Statutory deductions Other expenses 2021 December $'000 12,000
Clean Enterprise Limited Cash sales Credit sales Credit purchases Salaries Utilities Depreciation Property taxes Insurance Advertising Statutory deductions Other expenses 2021 December $'000 12,000 30,000 40,000 5,000 500 1,000 Additional information: 0 0 500 1,500 300 2022 January $'000 5,000 12,000 18,000 5,000 300 1,000 0 3,000 0 1,800 100 2022 February $'000 6,000 10,000 40,000 5,000 300 1,000 0 0 100 1,500 100 2022 March $'000 10,000 26,000 10,000 7,000 400 1,000 100 0 300 2,100 200 1. Collection from credit customers are normally 60% in the month of sale, 30% in the month following sale and the balance of 10% in the second month following sale. 2. The credit sale for November 2021 was $14,000,000. 3. Including in the November 2021 credit sales is a credit sale to Hard Luck Limited. The company (Hard Luck Limited) purchased $100,000 goods on November 1, 2021. A notice in the newspaper on November 6, 2021 indicated that a loan creditor of the company had placed the company into receivership. 4. Credit purchases are paid for in the month following purchase. 5. The company is expected to invest $12,000,000 on fixed deposit for six months on December 1, 2021. The company will receive a 5% rate of return per annum. The interest income will be received on a monthly basis. 6. A bonus of 2% of total sales for December 2021 will be paid to staff members in January 2022. 7. Salaries, utilities, property taxes, insurance, advertising and other expenses are paid in the month incurred. 8. Financial institutions charge no penalty for paying a loan before the due date. Financial institutions will charge a penalty of $5,000 if a company liquidates its investment early. (2) 9. Statutory deductions are paid for in the month following the payroll deductions. Corporation tax for 2022 is estimated at $1,200,000 and is normally paid on a quarterly basis. The first payment is normally made on March 31. 10. The expected closing cash and bank balance on December 31, 2021 is expected to be $8,000,000. 11. The company wants to purchase computer equipment costing $8,000,000 in March 2022 and wants to obtain an overdraft to purchase the computer equipment. The computer equipment is expected to last for 4 years. The company will also need to purchase software in March 2022 at a cost of $1,000,000. No funds have been identified to purchase the software. 12. The company's Statement of Financial Position reveals a loan amounting to $4,000,000 at an interest rate of 10% per annum. The loan is to be repaid on February 28, 2022. The company pays the interest on a monthly basis. Required: (1) Assume that you are employed by the company. What recommendations would you make to the management team of the company? (2 marks) Prepare the cash budget for the quarter ending March 31, 2022 incorporating any relevant recommendation(s) you made in (1) above. Round all calculations to the nearest $'000. (6 marks)
Step by Step Solution
★★★★★
3.52 Rating (152 Votes )
There are 3 Steps involved in it
Step: 1
ANSWER Cash budget calculations Particulars 2021000 cash sales 10000 credit sales NOV mo...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started