Ace Industrial Supply sells its products at an average price of $10/unit. The products cost $5.50...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Ace Industrial Supply sells its products at an average price of $10/unit. The products cost $5.50 /unit. Ace Industrial pays its suppliers for inventory deliveries at the time of delivery. Ace's customers are given 30 days to pay (e.g. payments for sales from March are received in April, etc.). Ace expects to grow rapidly in the next four months. Sales in March and April were 5,000 units but with new contracts they anticipate 8,000 units to be sold in May, and 10,000 units to be sold in each of June and July. The following table presents select information for the months of March through July, 4 Ace Industrial Supply Revenue Cost of Goods Sold Operating Expenses Depreciation Inventory Purchases Taxes Ending Cash Balance Answer: Ace Industrial Supply Profit and Loss Statement Sales Activity Revenue Cost of Sales Gross Profit Operating Expenses Depreciation March $50,000 Taxes $10,400 Profit Before Taxes-Operating Profit Net Profit April $50,000 $80,000 $100,000 $44,000 $55,000 $19,000 $1,627 $27,500 $15,500 $1,627 $27,500 $1,128 1. Prepare a projected profit and loss statement for ACE Industrial Supply for each month April through July to analyze the results of the anticipated growth on profits. This profit and loss will be used for all three growth scenarios. I May Units Sold 5000 April $44,000 $3,228 June 5000 May $24,000 $1,627 $55,000 $4,068 July 10,000 lune $100,000 $55,000 $24,000 $1,627 $55,000 $4,068 10,000 July 2. Growth Scenario 1: Answer questions 2-3 Prepare a projected growth cash flow statement for Ace Industrial Supply for each month April through July. Answer: Ace Industrial Supply Cash Flow Statement Beginning Cash Balance Cash Generated from Operating Activities Collections from Accts Reci Total Cash in from Operating Activities Cash used in Operating Activities Inventory Purchases Operating expenses Taxes Total Cash Used in Operating Activities Net Operating Cash Flow Ending Cash Balance Answer: Ace Industrial Supply Cash Flow Statement Beginning Cash Balance Cash Generated from Operating Activities 3. How much additional cash does Ace Industrial Supply need to fund its growth over this period? Collections from Accts Rec Total Cash in from Operating Activities Units Sold 5000 Cash used in Operating Activities Inventory Purchases Operating expenses Taxes Total Cash Used in Operating Activities English (United States) April 4. Growth Scenario 2: Answer Questions 4-7 Prepare a projected cash flow for Ace Industrial Supply using the original information in question 2 above but assume you decided to leverage available supplier credit and take advantage of terms that would give you 30 days to pay for the inventory. OCT 28 5000 May Units Sold 5000 April 5000 10,000 June May Focus 10,000 10,000 July June P 10,000 July Net Operating Cash Flow Ending Cash Balance 5. By leveraging supplier credit, how would it change the amount needed to fund your growth? Answer: 2 6. Does it hurt or benefit your operational capacity to grow and why? Answer: 7. In your opinion, would you choose this financing option for this type of growth and give a brief explanation for your decision. Answer: 8. Growth Scenario 3: Answer questions 8-13 Prepare a projected cash flow for Ace Industrial Supply using the original information in question 2 above but this time assume your competition is offering 60 day terms to customers. To achieve your desired growth Ace Industrial Supply must match the competition and extend receivable terms to also allow customers 60 days to pay. Note: February sales were 5000 units. Ace Industrial Supply Cash Flow Statement Beginning Cash Balance Cash Generated from Operating Activities Collections from Accts Rec Total Cash in from Operating Activities Cash used in Operating Activities Inventory Purchases Operating expenses Taxes Units Sold 5000 April English (United States) 5000 May 10,000 June Focus H 10,000 Total Cash Used in Operating Activities Net Operating Cash Flow Ending Cash Balance 9. By extending customer terms from 30 to 60 days to remain competitive, how would this change the amount needed to fund this growth? Answer: 10. In your opinion, what type of funding would you use to cover the amount? Give your reasoning? Answer: July THE 11. Assuming this growth projection is completed in March and you have chosen to go with a bank loan of some type, what month should you meet with the loan officer and submit your request for the funding? Give your reasoning. Answer: 12. Use the Profit and Loss Statement you created in Question 1, calculate a margin analysis on the Gross Profit Margin, Operating Profit Margin, and Net Profit Margin for April and July to evaluate the effect on margins as a result of the anticipated growth. Answer: Ace Industrial Supply Profit and Loss Statement Sales Activity Revenue Cost of Sales Gross Profit B Operating Expenses Depreciation Profit Before Taxes-Operating Profit Taxes Net Profit Units Sold 5000 English (United States) April 10,000 3 April Margin % Focus July Margin % 13. Based on the profit margin analysis above, what might you say to convince the loan officer the growth is beneficial to the business and there will be enough money pay back the loan? generated to Answer: July th Ace Industrial Supply sells its products at an average price of $10/unit. The products cost $5.50 /unit. Ace Industrial pays its suppliers for inventory deliveries at the time of delivery. Ace's customers are given 30 days to pay (e.g. payments for sales from March are received in April, etc.). Ace expects to grow rapidly in the next four months. Sales in March and April were 5,000 units but with new contracts they anticipate 8,000 units to be sold in May, and 10,000 units to be sold in each of June and July. The following table presents select information for the months of March through July, 4 Ace Industrial Supply Revenue Cost of Goods Sold Operating Expenses Depreciation Inventory Purchases Taxes Ending Cash Balance Answer: Ace Industrial Supply Profit and Loss Statement Sales Activity Revenue Cost of Sales Gross Profit Operating Expenses Depreciation March $50,000 Taxes $10,400 Profit Before Taxes-Operating Profit Net Profit April $50,000 $80,000 $100,000 $44,000 $55,000 $19,000 $1,627 $27,500 $15,500 $1,627 $27,500 $1,128 1. Prepare a projected profit and loss statement for ACE Industrial Supply for each month April through July to analyze the results of the anticipated growth on profits. This profit and loss will be used for all three growth scenarios. I May Units Sold 5000 April $44,000 $3,228 June 5000 May $24,000 $1,627 $55,000 $4,068 July 10,000 lune $100,000 $55,000 $24,000 $1,627 $55,000 $4,068 10,000 July 2. Growth Scenario 1: Answer questions 2-3 Prepare a projected growth cash flow statement for Ace Industrial Supply for each month April through July. Answer: Ace Industrial Supply Cash Flow Statement Beginning Cash Balance Cash Generated from Operating Activities Collections from Accts Reci Total Cash in from Operating Activities Cash used in Operating Activities Inventory Purchases Operating expenses Taxes Total Cash Used in Operating Activities Net Operating Cash Flow Ending Cash Balance Answer: Ace Industrial Supply Cash Flow Statement Beginning Cash Balance Cash Generated from Operating Activities 3. How much additional cash does Ace Industrial Supply need to fund its growth over this period? Collections from Accts Rec Total Cash in from Operating Activities Units Sold 5000 Cash used in Operating Activities Inventory Purchases Operating expenses Taxes Total Cash Used in Operating Activities English (United States) April 4. Growth Scenario 2: Answer Questions 4-7 Prepare a projected cash flow for Ace Industrial Supply using the original information in question 2 above but assume you decided to leverage available supplier credit and take advantage of terms that would give you 30 days to pay for the inventory. OCT 28 5000 May Units Sold 5000 April 5000 10,000 June May Focus 10,000 10,000 July June P 10,000 July Net Operating Cash Flow Ending Cash Balance 5. By leveraging supplier credit, how would it change the amount needed to fund your growth? Answer: 2 6. Does it hurt or benefit your operational capacity to grow and why? Answer: 7. In your opinion, would you choose this financing option for this type of growth and give a brief explanation for your decision. Answer: 8. Growth Scenario 3: Answer questions 8-13 Prepare a projected cash flow for Ace Industrial Supply using the original information in question 2 above but this time assume your competition is offering 60 day terms to customers. To achieve your desired growth Ace Industrial Supply must match the competition and extend receivable terms to also allow customers 60 days to pay. Note: February sales were 5000 units. Ace Industrial Supply Cash Flow Statement Beginning Cash Balance Cash Generated from Operating Activities Collections from Accts Rec Total Cash in from Operating Activities Cash used in Operating Activities Inventory Purchases Operating expenses Taxes Units Sold 5000 April English (United States) 5000 May 10,000 June Focus H 10,000 Total Cash Used in Operating Activities Net Operating Cash Flow Ending Cash Balance 9. By extending customer terms from 30 to 60 days to remain competitive, how would this change the amount needed to fund this growth? Answer: 10. In your opinion, what type of funding would you use to cover the amount? Give your reasoning? Answer: July THE 11. Assuming this growth projection is completed in March and you have chosen to go with a bank loan of some type, what month should you meet with the loan officer and submit your request for the funding? Give your reasoning. Answer: 12. Use the Profit and Loss Statement you created in Question 1, calculate a margin analysis on the Gross Profit Margin, Operating Profit Margin, and Net Profit Margin for April and July to evaluate the effect on margins as a result of the anticipated growth. Answer: Ace Industrial Supply Profit and Loss Statement Sales Activity Revenue Cost of Sales Gross Profit B Operating Expenses Depreciation Profit Before Taxes-Operating Profit Taxes Net Profit Units Sold 5000 English (United States) April 10,000 3 April Margin % Focus July Margin % 13. Based on the profit margin analysis above, what might you say to convince the loan officer the growth is beneficial to the business and there will be enough money pay back the loan? generated to Answer: July th
Expert Answer:
Related Book For
Introduction to Probability and Statistics
ISBN: 978-1133103752
14th edition
Authors: William Mendenhall, Robert Beaver, Barbara Beaver
Posted Date:
Students also viewed these accounting questions
-
A bank loan of $3000 charged 8% p.a. when payment was made after the due date. If the due date was November 3, and the loan was paid December 1, how much interest was charged?
-
Five years ago, Diane secured a bank loan of $360,000 to help finance the purchase of a loft in the San Francisco Bay area. The term of the mortgage was 30 years, and the interest rate was 10% per...
-
Philander Limited requires a bank loan of R225,000 in order to finance its operations and is considering options from two banks, namely Bucks and Wealth Bank. Bucks Bank will charge an interest rate...
-
Consider the heat pump described in Example 9.14. The heat pump now operates between 0.60 MPa and 1.4 MPa. Plot the vapor-compression cycle in Ts coordinates (use NIST) and determine the cycle...
-
On January 20, 2014, Jennifer Nelson, the staff accountant for Newby Enterprises, is feeling pressure to complete the preparation of the annual financial statements. The president of the company has...
-
How should the firm go about identifying hazardous conditions that should be rectified? Use checklists such as those in Figures 16-6 and 16-8 to list at least 10 possible dry-cleaning store hazardous...
-
The velocity of the water in the pipe shown in Fig. P4.29 is given by \(V_{1}=0.50 t \mathrm{~m} / \mathrm{s}\) and \(V_{2}=1.0 t \mathrm{~m} / \mathrm{s}\), where \(t\) is in seconds. Determine the...
-
A new accountant at Leftwich Inc. is trying to identify which of the amounts shown below should be reported as the current asset Cash and cash equivalents in the year-end balance sheet, as of April...
-
Provide a brief summary of the following websites: Atwood, C. G. (2020). Succession planning basics (2nd edition.). ATD Press. Retrieved from...
-
It is early April 2021 and you, CPA, work in a mid-sized accounting firm in Regina, Saskatchewan. While you normally work on audits, you have requested to participate in the personal tax pool this...
-
The borrower makes $112,000 per year. Their most recent 2 months' bank statements have several deposits that are not from their payroll/employer in the amounts of $5000, $3150, $4800, and $4000....
-
Heineken International Case Analysis Heineken N.V. is a Dutch brewing company, founded in 1864 by Gerard Adrian Heineken in Amsterdam. As of 2017, Heineken owned over 165 breweries in more than 70...
-
You bought 2 5 0 shares of stock for $ 1 0 0 each. After 1 month, the stock price is 4 % higher and you sell x shares. After 1 year, the stock price is 9 % higher ( from the original purchase price )...
-
5. Aya rode her bicycle from her house to a friend's house, averaging 16 km per hour. It turned dark before she was ready to return home, so her friend drove her home at a rate of 8 km per hour. If...
-
The 2 0 2 4 balance sheet for Hallbrook Industries, Incorporated, is shown below. HALLBROOK INDUSTRIES, INCORPORATED Balance Sheet December 3 1 , 2 0 2 4 ( $ in thousands ) Assets Cash $ 2 0 0 Short...
-
A biologist has a 6 9 2 6 - gram sample of a radioactive substance. Find the mass of the sample after six hours if it decreases according to a continuous exponential decay model, at a relative rate...
-
Two mutually exclusive projects, M and N, have the same payback periods but M has a higher net present value NPV. What conclusion can be drawn about the projects? Question 9Answer a. Project M is...
-
Selected condensed data taken from a recent statement of financial position of Morino Ltd. are as follows. MORINO LTD. Statement of Financial Position (partial) Other current assets...
-
Calculate the area under the standard normal curve between these values: a. z = - 2.0 and z = 2.0 b. z = - 2.3 and z = - 1.5
-
When Americans eat out at restaurants, most choose American food; however, tastes for Mexican, Chinese, and Italian food vary from region to region of the United States. In a recent CBS telephone...
-
The data below are 30 waiting times between eruptions of the Old Faithful geyser in Yellowstone National Park. a. Calculate the range. b. Use the range approximation to approximate the standard...
-
Companies are facing a great amount of change in every facet of their operations today. To remain competitive, companies must keep abreast of current developments in several areas. You recently got...
-
For each of the situations listed, identify the primary standard from the IMA Statement of Ethical Professional Practice that is violated (competence, confidentiality, integrity, or credibility.)...
-
Sustainability involves more than just the impact of actions on the environment. The triple bottom line recognizes that a company has to measure its impact on its triple bottom line for its long-term...
Strategic Tax Planning For Global Commerce And Investment 1st Edition - ISBN: B08D4VSBVS - Free Book
Study smarter with the SolutionInn App