b. Peter the sole owner of Cheshire Kitchen Tools Pty Ltd has supplied you with the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
b. Peter the sole owner of Cheshire Kitchen Tools Pty Ltd has supplied you with the following information to assist in preparing a Cash Budget for January 2025 for his business. He has recently secured a one-year contract to supply kitchen utensils for the 2026 season of Master Chef and provide utensils to major restaurants in Melbourne. The business has retained earnings of $107,000, and the cash balance as of December 1, 2024, stands at $55,000. All sales are credit-based and are collected as follows: 60% of sales are collected in the same month as the sale. 3 40% of sales are collected in the month following the sale. Purchases are also on credit and are settled as follows: 70% of purchases are paid in the same month as the purchase. 30% of purchases are paid in the month following the purchase. The Sales and Purchase figures are as follows: - Budgeted Budgeted Sales ($) Purchases ($) October $310,000 $106,500 November $225,000 $95,000 December $285,000 $75,000 January $295,000 $103,000 Here are additional financial details: i) The business plans to secure a $150,000 business loan from Northpac Bank at the end of January 2025, with repayment scheduled end June 2029. This loan carries a variable interest rate of 6.24% per annum for a 5-year term. ii) Monthly selling and administrative expenses amount to $80,000. These expenses include a monthly depreciation charge of $32,000. iii) Sales commissions equal 11% of the total monthly sales and are paid to the staff at the end of each month. iv) Equipment costing $60,000 is expected to be purchased in November 2024 and fully paid for in January 2025 with cash. v) Peter intends to upgrade the delivery vehicle in December from a Toyota Hi-Ace to a new Ford Transit Custom that costs $55,000. He will trade-in his Hi-Ace in December 2024 for $25,000 and use this sum as a downpayment for the purchase of the Ford Transit by taking out a vehicle loan for $30,000 when the vehicle is delivered in January 2025. vi) Peter withdraws $12,000 from the business every month. Required: C. Prepare a Cash Budget for the months of December 2024 & January 2025. Advise Peter on the cash balance at the end of both months. Show your workings clearly. Discuss the necessity of the business loan that Peter intends to take out based on the cash balances determined in your cash budget. The Cash budget must be supported with a Schedule of Cash Collection and Schedule of Cash Payment. (25 marks) The following question relates to the attached article by Jim Schell on business growth and financial statements, "Growing your small business: Is faster better?" [See Week 6 Reading in Moodle]. Reading between the lines in this article, the author is suggesting that small business entrepreneurs at some point need to make the subtle transition from working IN the business to working ON the business - Entrepreneur to Manager! In other words, devoting less of their energy in the pursuit of customers and focusing on Sales to training and empowering employees when growing the business. The author distinguishes between healthy growth and unhealthy growth with reference to the Profit & Loss and Balance Sheet and supports his ideas with clear explanations. You are provided with the following data taken from the financial statements of Delta Pty Ltd. 4 and Epsilon Pty Ltd: Sales Current Assets A/C Receivable Inventory Others Current Liabilities Non-Current Assets Equipment Non-Current Liabilities Gross profit Net profit Delta Pty Ltd 2023 2024 2024 $202,500 $243,000 $138,000 $158,700 $63,000 $72,450 $60,000 $75,480 $30,000 $35,000 $25,000 $32,000 $15,000 $18,000 $19,000 $23,480 $18,000 $19,450 $16,000 $20,000 $27,000 $29,700 $36,000 $43,400 $79,500 $91,425 $63,000 $86,950 $50,000 $55,000 $43,000 $55,000 $70,500 $77,550 $54,000 $79,000 $45,000 $57,000 $58,000 $10,500 $12,950 Epsilon Pty Ltd 2023 $63,800 $13,650 $14,606 Accounts Receivable 8.4 6.8 6.2 6.0 Turnover times times times times 7.3 Inventory Turnover 6 times times 6.5 times 5.9 times A/C Receivable, Inventory & Equipment $95,000 $108,000 $87,000 $110,480 Required: i. ii. Compute the percentage of growth of sales, then compute the percentage growth of profits for both companies. Compute the combined percentage growth of the key asset categories (accounts receivable, inventory and equipment). You are required to identify the company with healthy growth and the company with unhealthy growth based on the computations above. iii. Provide a real-life example of an Australian company that has recently been liquidated with early warning signs of unhealthy growth in businesses, and identify two main indicators that would have resulted in its downfall? References are required for this part. (20 marks) b. Peter the sole owner of Cheshire Kitchen Tools Pty Ltd has supplied you with the following information to assist in preparing a Cash Budget for January 2025 for his business. He has recently secured a one-year contract to supply kitchen utensils for the 2026 season of Master Chef and provide utensils to major restaurants in Melbourne. The business has retained earnings of $107,000, and the cash balance as of December 1, 2024, stands at $55,000. All sales are credit-based and are collected as follows: 60% of sales are collected in the same month as the sale. 3 40% of sales are collected in the month following the sale. Purchases are also on credit and are settled as follows: 70% of purchases are paid in the same month as the purchase. 30% of purchases are paid in the month following the purchase. The Sales and Purchase figures are as follows: - Budgeted Budgeted Sales ($) Purchases ($) October $310,000 $106,500 November $225,000 $95,000 December $285,000 $75,000 January $295,000 $103,000 Here are additional financial details: i) The business plans to secure a $150,000 business loan from Northpac Bank at the end of January 2025, with repayment scheduled end June 2029. This loan carries a variable interest rate of 6.24% per annum for a 5-year term. ii) Monthly selling and administrative expenses amount to $80,000. These expenses include a monthly depreciation charge of $32,000. iii) Sales commissions equal 11% of the total monthly sales and are paid to the staff at the end of each month. iv) Equipment costing $60,000 is expected to be purchased in November 2024 and fully paid for in January 2025 with cash. v) Peter intends to upgrade the delivery vehicle in December from a Toyota Hi-Ace to a new Ford Transit Custom that costs $55,000. He will trade-in his Hi-Ace in December 2024 for $25,000 and use this sum as a downpayment for the purchase of the Ford Transit by taking out a vehicle loan for $30,000 when the vehicle is delivered in January 2025. vi) Peter withdraws $12,000 from the business every month. Required: C. Prepare a Cash Budget for the months of December 2024 & January 2025. Advise Peter on the cash balance at the end of both months. Show your workings clearly. Discuss the necessity of the business loan that Peter intends to take out based on the cash balances determined in your cash budget. The Cash budget must be supported with a Schedule of Cash Collection and Schedule of Cash Payment. (25 marks) The following question relates to the attached article by Jim Schell on business growth and financial statements, "Growing your small business: Is faster better?" [See Week 6 Reading in Moodle]. Reading between the lines in this article, the author is suggesting that small business entrepreneurs at some point need to make the subtle transition from working IN the business to working ON the business - Entrepreneur to Manager! In other words, devoting less of their energy in the pursuit of customers and focusing on Sales to training and empowering employees when growing the business. The author distinguishes between healthy growth and unhealthy growth with reference to the Profit & Loss and Balance Sheet and supports his ideas with clear explanations. You are provided with the following data taken from the financial statements of Delta Pty Ltd. 4 and Epsilon Pty Ltd: Sales Current Assets A/C Receivable Inventory Others Current Liabilities Non-Current Assets Equipment Non-Current Liabilities Gross profit Net profit Delta Pty Ltd 2023 2024 2024 $202,500 $243,000 $138,000 $158,700 $63,000 $72,450 $60,000 $75,480 $30,000 $35,000 $25,000 $32,000 $15,000 $18,000 $19,000 $23,480 $18,000 $19,450 $16,000 $20,000 $27,000 $29,700 $36,000 $43,400 $79,500 $91,425 $63,000 $86,950 $50,000 $55,000 $43,000 $55,000 $70,500 $77,550 $54,000 $79,000 $45,000 $57,000 $58,000 $10,500 $12,950 Epsilon Pty Ltd 2023 $63,800 $13,650 $14,606 Accounts Receivable 8.4 6.8 6.2 6.0 Turnover times times times times 7.3 Inventory Turnover 6 times times 6.5 times 5.9 times A/C Receivable, Inventory & Equipment $95,000 $108,000 $87,000 $110,480 Required: i. ii. Compute the percentage of growth of sales, then compute the percentage growth of profits for both companies. Compute the combined percentage growth of the key asset categories (accounts receivable, inventory and equipment). You are required to identify the company with healthy growth and the company with unhealthy growth based on the computations above. iii. Provide a real-life example of an Australian company that has recently been liquidated with early warning signs of unhealthy growth in businesses, and identify two main indicators that would have resulted in its downfall? References are required for this part. (20 marks)
Expert Answer:
Related Book For
Managerial Accounting
ISBN: 9780073526706
12th Edition
Authors: Ray H. Garrison, Eric W. Noreen, Peter C. Brewer
Posted Date:
Students also viewed these finance questions
-
i need help with question 6.... A fair coin is tossed 25 times. What is the probability that at least 1tail occurs? a) 1 b) 0.00000075 c) 0.99999923 d) 0.00000003 e) 0.99999997
-
Hlathi Products Inc. is a manufacturing company whose stock is traded on the Johannesburg Stock Exchange. The company sells binders, paper and other school supplies and has a 31 July financial year...
-
The following information is taken from the records of West End Distributors Inc. for the month ended May 31. Units Unit cost May 1 6 12 19 29 Purchase #1 Purchase #2 Purchase #3 ...
-
You have been given the following algorithm. What does it return? Input: Array A [ 1 . . . [ 1 . . . n ] ] Output: ? ? ? ? out 1 1 for i 2 2 to n do if A [ [ i ] < ] < A [ [ out ] ] then out i return...
-
What is are the main industry(ies) in which the company competes ?
-
Tan Ltd. issued HK$600,000,000 of 7% bonds on November 1, 2019, for HK$644,636,000. The bonds were dated November 1, 2019, and mature in 10 years, with interest payable each May 1 and November 1. The...
-
Non-current assets are assets which are: a. Likely to last at least a year and are valuable b. Not going to be depreciated c. Unlikely to last a year d. The unsold goods of the business
-
Hardin Company paid $90,000 to purchase a machine on January 1, 2009. During 2011, a technological breakthrough resulted in the development of a new machine that costs $120,000. The old machine costs...
-
Suppose we wish to train a classification tree to predict whether a new smartphone will be profitable on Amazon.com. To build the classification tree, we have a dataset which consists of hundreds of...
-
A-Rod Manufacturing Company is trying to calculate its cost ofcapital for use in making a capital budgeting decision. Mr. Jeter,the vice-president of finance, has given you the followinginformation 2...
-
In contemporary times, the entrepreneur contributes his or her own initiative, skill and ingenuity in planning, organizing and administering the enterprise, assuming the chance of loss and gain. How...
-
We have operating and finance leases for datacenters, corporate offices, reasearch and development facilities, retail stores, and certain equipment. Our leases have remaining lease terms of 1 year to...
-
1. Given the following C program written for the MSP430 LaunchPad: #include int num [9]={1,1,0,1,0,1,0,1,0}; void main (void) { } WDTCTL-WDTPW | WDTHOLD; int i=0,zeros=0, ones=0; P1DIR=BITO+BIT6;...
-
For each of these three firms, answer the following questions: a.Is the overall enterprise profitable? b.Is the equity of the firm profitable? c.Would each firm improve its profit if it increased its...
-
The 5 stages of the processor have the following latencies: a. b. Fetch 300ns 200ns Decode 400ns 150ns Execute 350ns 100ns Memory Writeback 550ns 100ns 190ns 140ns Assume that when pipelining, each...
-
Precautionary demand for money arises from the desire of individuals and firms to hold cash Question 4 6 options: A ) to meet unforeseen emergency expenses. B ) for speculative equity purchases. C )...
-
Which one of the following anhydrous chloride is not obtained on direct heating of its hydrated chloride? (A) BaCl2 (B) CaClz (C) MgCl2 (D) SrCl2
-
Ernest Petroleum began operations January 1, 2015. Transactions for the first three years include the data below. Using that data: a. Prepare journal entries assuming full cost (ignore revenue...
-
Data as of 12/31/15 for Dry Hole Oil Companys U.S. properties are as follows: (This problem is similar to problem 14 in chapter 6.) Dry Holes activities during 2016 were as follows: a. Use T-accounts...
-
Cowboy Oil Corporation began operations in 2016. Give the entries, assuming the following transactions in the first three years of operations. Calculate DD&A twice, once assuming no exclusions and...
Study smarter with the SolutionInn App