Complete the case study questions using the information gesach of the 3 growth f Ace Industrial Supply Ace Industrial Supply sells its products at an average price of $30. 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 (eg payments for sales from March are received in April, Ace expects to grow rapidly in the next four months Sales in March and April were 5,000 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 them of March through but Inventory Purch March L 1. Prepare a projected profit and loss statement for ACE Industrial Supply for each month April through July to analyze the rests of the anticipated growth on pets. This profit and less will be used for all three growth scenari Ace Industrial Supply Profit and Loss Statement Sales Activity Reverse Gross Profit Depreciation Profit Before Taxes Operating P Net Profit 1000 2. Growth Scenario 1: Answer questions 2-3 Prepare a pred growth 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 Total Cash in free Operating Activities Cash used in Operating Activities Inventory Purcha Opening Taars Total Cash Used in Operating Activities Net Operating Cash Flee Ending Gosh Belance April May June July How much additional cast does Ace Industrial Supply need to fund it growth over this 4. Growth Scenario 2 Answer Questions 4-7 Prepare a projected cash Supply using the original information in question 1 above but as leverage available supplier credit and take advantage of t for Ace Industrial you decided to give you 30 days to pay for the inventory. Don't forget in the table there were 5000 units sold for March Ace Industrial Supply Cash Flow Statement Beginning Cash Balance April July Complete the case study questions using the information given in each of the growth for Ace Industrial Supply Ace Industrial Supply sells its products at an average price of $10/unt. The products $5.50 unit. Ace Industrial pays its suppliers for inventory deliveries at the time of delivery. Ar's customers are given 30 days to pay (eg 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 1,000 units to be sold in May, and 10,000 units to be sold in each of Jane and July. The following table presents select information for the months of March through 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 somri Anwer Ace Industrial Supply Profit and Loss Statement 5000 8000 April May 10.000 June 10,000 July Sales Activity Gross Profit Operating Expenses Depreciation Profit Before Taxes-Operating Prod Tases Net Profit 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 Collect from Acts Rec Total Cash in free Operating Activities April May June July Operating expe Taxm Total Cash Used in Operating Activities Net Operating Cash Flow Ending Cash Balance 3. How much additional cash does Ace Industrial Supply need to fund its growth over this Anwen 4. Growth Somara 2 Anower Questions 4-7 Prepare a projected cash flow for Ace Industrial Supply using the original information in question 1 above but as you decided to leverage available supplier credit and take advantage of terms that would give you 30 days to pay for the inventory. Don't forget in the table there were 5000 units sold for March Ace Industrial Supply Cash Flow Statement Begissing Cash Balance April May June July 4. Growth Scenario 2: Answer Questions 4-7 Prepare a projected cash flow for Ace Industrial Supply using the original information in question 1 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. Don't forget in the table there were 5000 units sold for March 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 Operating expenses Total Cash Used in Operating Activities April May June July Net Operating Cash Flow Ending Cash Balance 5. By leveraging supplier credit, how would a change the amount of addal cash needed to fund your growth? Answer: 6. By leveraging supplier credit, does it hurt or benefit your operational capacity to grow and Answer: 7. In your opinion, would you choose a supplier credit 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 amume 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 Acts Rec Total Cash in from Operating Activities Cash used in Operating Activities Inventory Purchas Operating expenses Total Cash Used in Operating Activities Net Operating Cash Flow April May July 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: 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 Units Sold Profit and Loss Statement 5000 10,000 Margin % Margin 96 April July April July Sales Activity Revenue Cost of Sales Gross Profit Operating Expenses Depreciation Profit Before Taxes-Operating Profit Taxes Net Profit 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 generated to pay back the loan? Answer: Complete the case study questions using the information given in each of the 3 growth scenarios for Ace Industrial Supply. 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. Ace Industrial Supply March April May June July Revenue $50,000 $50,000 Cost of Goods Sold $27,500 $80,000 $44,000 $100,000 $100,000 $55,000 $55,000 Operating Expenses $15,500 $19,000 $24,000 $24,000 Depreciation $1,627 $1,627 $1,627 $1,627 Inventory Purchases $27,500 $44,000 $55,000 $55,000 Taxes $1,128 $3,228 $4,068 $4,068 Ending Cash Balance $10,400 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. Answer: Ace Industrial Supply Profit and Loss Statement Sales Activity 5000 Units Sold 8000 10,000 10,000 April May June July Revenue Cost of Sales Gross Profit Operating Expenses Depreciation Profit Before Taxes-Operating Profit Taxes Net Profit 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 April May June July Beginning Cash Balance Cash Generated from Operating Activities Collections from Accts Rec Total Cash in from Operating Activities Cash used in Operating Activities Inventory Purchase Operating expenses Taxes Total Cash Used in Operating Activities Net Operating Cash Flow Ending Cash Balance 3. How much additional cash does Ace Industrial Supply need to fund its growth over this period? Answer: 4. Growth Scenario 2: Answer Questions 4-7 Prepare a projected cash flow for Ace Industrial Supply using the original information in question 1 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. Don't forget in the table there were 5000 units sold for March. Ace Industrial Supply Cash Flow Statement Beginning Cash Balance April May June July 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 Total Cash Used in Operating Activities Net Operating Cash Flow Ending Cash Balance 5. By leveraging supplier credit, how would it change the amount of additional cash needed to fund your growth? Answer: 6. By leveraging supplier credit, does it hurt or benefit your operational capacity to grow and why? Answer: 6. By leveraging supplier credit, does it hurt or benefit your operational capacity to grow and why? Answer: 7. In your opinion, would you choose a supplier credit 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 April May June July Cash Generated from Operating Activities Collections from Acces Rec Total Cash in from Operating Activities Cash used in Operating Activities Inventory Purchases Operating expenses Tax 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: 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: 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: 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 Units Sold Margin Margin Profit and Loss Statement 5000 10,000% April July April July Sales Activity Revenue Cost of Sales Gross Profit Operating Expenses Depreciation Profit Before Taxes-Operating Profit Taxes Net Profit 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 generated to pay back the loan