Clean Enterprise Limited Cash sales Credit sales Credit purchases Salaries Utilities Depreciation Property taxes Insurance Advertising...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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) 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)
Expert Answer:
Answer rating: 100% (QA)
ANSWER Cash budget calculations Particulars 2021000 cash sales 10000 credit sales NOV mo... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these accounting questions
-
1) Assume that you are employed by the company. What recommendations would you make to the management team of the company? 2) Prepare the revised cash budget for the quarter ending March 31, 2021...
-
Jen and Berry's sells ice-creams from its factory-shop in Petone. There is a managing director (Maynard Dibble), a marketing manager (Mary Salman) and a production manager (Peter Pritchard). Maynard...
-
Clean Enterprise Limited Prepare the cash budget for the quarter ending March 31, 2022, incorporating any relevant assumption(s) you made with the information provided below. Round all calculations...
-
1. If France can make 25 pounds of butter or 5 lamps while Spain can make 6 pounds of butter or 1 lamp, who has the comparative advantage in which good? A. France has the comparative advantage in...
-
Bread & Butter, Inc., is authorized to issue 120,000 shares of common stock and 7,000 shares of preferred stock. During its first year, the business completed the following stock issuance...
-
The following are auditor judgments and attributes sampling results for six populations. Assume large population sizes. .:. Required a. For each population, did the auditor select a smaller sample...
-
Yale Corporation issued to Zap Corporation \(\$ 60,000,8 \%\) (cash interest payable semiannually on July 1 and January 1) 10 -year bonds dated and sold on January 1,2020 . If the bonds were sold at...
-
PCB Corporation manufactures a single product. Monthly production costs incurred in the manufacturing process are shown below for the production of 3,000 units. The utilities and maintenance costs...
-
Please Help. 9. Using a binomial interest rate tree, fill out the table below. (30 points) The first four columns are inputs. P0.5 is the price of a six-month zero-coupon bond. P1 and CR1 are,...
-
Forecasting with the Parsimonious Method and Estimating Share Value Using the ROPI Model Following are income statements and balance sheets for Cisco Systems. Cisco Systems Consolidated Statements of...
-
1. How would stabilizing the human population affect biological diversity? 2. What are the goals of restoration ecology? Are there any disadvantages associated with restoring disturbed areas? 3. How...
-
Define resilience. How can the concept of resilience be applied to the environment, community, and the economy? How are environmental, community, and economic resilience intertwined? Explain at least...
-
What influences a child's resilience to adversity? 2 What influences a child's resilience to genes ? 3 What influences a child's resilience to parenting? 4 How can resilience be fostered in children?
-
How do emerging fintech disruptors leverage cutting-edge technologies such as blockchain, artificial intelligence, and big data analytics to revolutionize traditional financial services, reshaping...
-
Castle Island Company produces a single product speedboat. The company produced 800 units and sold 600 units during the year 2019. Its total fixed manufacturing overhead cost is $400,000. Its...
-
Write a mini-essay in which you define the terms resilience and s ocio-ecological resilience . Support your argument with at least five (5) source references. Think about the following questions...
-
Answer the following questions: What changes occur in middle and/or early adulthood and what is their impact on a psychological level? In what way do you believe that death is a biological fact,...
-
Using the theoretical sampling strategy, how many samples of size 4 (n = 4) can be drawn from a population of size: (a) N = 5? (b) N = 8? (c) N = 16? (d) N = 50?
-
Jason and Mary Wells, friends of yours, were married on December 30, 2012. They know you are studying taxes and have come to you with a question concerning their filing status. Jason and Mary would...
-
Joan is a self-employed attorney in New York City. Joan took a trip to San Diego, CA, primarily for business, to consult with a client and take a short vacation. On the trip, Joan incurred the...
-
Yolanda is a cash basis taxpayer with the following transactions during the year: Cash received from sales of products........................................................................$65,000...
-
Convert 3.8874 to fraction form and reduce to lowest terms. Do the indicated conversion. If it is a repeating decimal, use the correct notation.
-
Convert \(\frac{27}{625}\) to decimal form. Do the indicated conversion. If it is a repeating decimal, use the correct notation.
-
\(\frac{3}{5}+\frac{3}{10}\) Perform the indicated operations. Reduce to lowest terms.
Study smarter with the SolutionInn App