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...
-
Tishimingo Sand and Gravel paid $800,000 to acquire 1,200,000 cubic yards of sand reserves. The following statements model reflects Tishimingos financial condition just prior to purchasing the sand...
-
A copper wire and an aluminum wire of the same length have the same resistance. What is the ratio of the diameter of the copper wire to that of the aluminum wire?
-
Find a California case where social media was used.
-
Rehab Health Co. offers personal weight reduction consulting services to individuals. On June 30, 2010, the balances of selected accounts of Rehab Health Co. are as follows: Prepare a classified...
-
Download the Early Childhood Professional Resource Guide Template document. Visit the websites for the first three organizations (Center on the Developing Child, NAEYC, and Zero to Three) and...
-
Pie Corporation acquired 75 percent of Slice Companys ownership on January 1, 20X8, for $96,000. At that date, the fair value of the noncontrolling interest was $32,000. The book value of Slices net...
-
briefly explain: a. calibration b. accuracy c. precision d. qualitative d. quality control and quality assurance e. what is reliability?
-
What is virtual coefficient of friction in a V-belt drive?
-
Answer true or false, and if the statement is false, change it to make it true. Illustrate your answers on a demand and supply graph. a. An increase in demand is represented by a movement up the...
-
When chain drive is preferred?
-
Optimize the following Boolean functions \(F\) together with the don't-care conditions \(d\) : (a) \(F(A, B, C, D)=\Sigma m(0,1,7,13,15), d(A, B, C, D)=\Sigma m(2,6,8,9,10)\) (b) \(F(W, X, Y,...
-
Explain the motivational effect that an audit has on preparers of financial statements.
-
Q2. A dielectric sphere is carrying surface charge density as shown. a. Determine the electric field intensity in all space (Hint: use Gauss's Law). b. Determine the electric potential in all space....
-
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...
-
How reliable is the model in Task 6? Task 6 An HIV researcher explored the factors that influenced condom use with a new partner (relationship less than 1 month old). The outcome measure was whether...
-
An HIV researcher explored the factors that influenced condom use with a new partner (relationship less than 1 month old). The outcome measure was whether a condom was used (use: condom used = 1, not...
-
A female who used a condom in her previous encounter scores 2 on all variables except perceived risk (for which she scores 6). Use the model in Task 6 to estimate the probability that she will use a...
Study smarter with the SolutionInn App