Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers...

    

Transcribed Image Text:

Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity Dover Water Cooler Company is a medium sized company that manufactures drinking fountains and water coolers and markets their products nationally as well as overseas. The CEO of the company laid out some aggressive growth plans for 2019 and pushed his key executive staff to increase sales of its products by twenty percent. Sales management has been asked to aggressively pursue new customers, and expand sales with existing customers. The Credit manager has been asked to revisit their historically conservative credit policies to help achieve the aggressive growth plans. The Manufacturing manager has been asked to look at possible ways to reduce product cost without sacrificing overall product quality. Dover Water Cooler operates in a market where overall unit sales are relatively flat, so increasing sales means garnering a greater market share. In 2018 they sold 150,000 units and had a respectable twenty-five percent market share. The company has seen some signs of inflation in the price of manufacturing components (materials, labor, employee benefits), but its hope is that it can make up for the cost increases with a higher volume of sales. Dover Water Cooler Company is a closely held company and the capital structure consists of contributed capital, retained earnings and long term bank loans. It relies on its credit line of S10 million with First National Bank (Long-term debt) to finance its working capital requirements. Its standard credit terms are net 30 days. As 2019 came to a close, the CEO was somewhat satisfied with the growth in unit sales (from 150,000 to 180,000 units) the company had achieved, but was very disappointed in the overall financial performance of the company. The company's controller assembled the following financial information for 2019 and 2018 (figures in $000's): 2019 (000's) 2018 (000's) $ 39,000 25,300 $ 46,000 Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) 32,200 6,000 4,800 2,000 4,000 4,000 1,700 500 300 700 100 Cash 200 500 Accounts receivable 6,000 5,000 22,000 3,500 Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt 3,200 20,000 1,400 500 10,000 16,000 5,300 700 500 6,000 Common Stock & APIC 15,000 5,000 Retained Earnings Dover Water Cooler Company historically pays out 25 percent of net income as dividends to shareholders (assuming income vs. loss), and has a 20 percent tax rate. As a financial consultant, you have been asked to prepare the following financial reports and ratio analysis for Dover Water Cooler Company, and answer the questions noted below: Financial Statement & Ratio Analysis Requirements: 1. A comparative Balance Sheet for 2019 and 2018 incorporating a horizontal analysis (S change & % change). 2. A comparative Income Statement for 2019 and 2018 incorporating a vertical analysis (percentage of sales calculations). 3. A Sales and Cost of Sales Analysis for 2019 and 2018 (Calculate % of sales & S/Unit). Include comments on these figures in your narrative. 4. A ratio analysis for 2019 and 2018. Ratios computed should include current ratio, quick (acid-test) ratio, days' sales in inventory, inventory turnover, days' sales uncollected, accounts receivable turnover, total debt ratio, debt-equity ratio, times interest earned ratio, profit margin, ROA & ROE ratios (Excel template available). Where the ratio requires a two year average and the prior year is unavailable, use the current year amount only. K DOVER WATER COOLER COMPANY Sales & Cost of Sales Analysis with Market Analysis For the Years Ended December 31, 2019 & 2018 2019 2018 $ Change % Change Dollar Sales ($ 000's) Unit Sales Average Selling Price Cost of goods sold Average Cost per Unit Total Market (Units) Market Share (Pèrcentage) Remember, Sales are in 000's, units are not. DOVER WATER COOLER COMPANY CASE STUDY, S'20 Student Name: 0.00 2019 2018 Notes Short-term solvency ratios: Current ratio Acid-test (Quick) ratio Asset utilization ratios: Inventory turnover Days' Sales in inventory Receivables turnover Days' Sales uncollected Long-term solvency ratios: Total debt ratio Debt-equity ratio Times interest earned ratio Profitability ratios: Profit margin Return on assets Return on equity

Answer rating: 100% (QA)

Balance Sheet Horizontal analysis Amt 000 Assets 2019 2018 Change age change Cash 200 500 300 6000 Accounts receivable 6000 3500 2500 7143 Inventory 5... View the full answer