This was all that's given to us to read the report and do 4 analysis: Balance sheet, income statement, sales cost analysis and ratio computed as in the image. can you please help me out

DOVER WATER COOLER COMPANY over 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 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): Sales Cost of goods sold Selling expense Administrative expense Depreciation Interest expense Income taxes (rounded) Cash Accounts receivable Inventory Net fixed assets Accounts payable Notes payable (short term) Long-term debt Common Stock & APIC Retained Earnings 2019 (000's) $ 46,000 32,200 6,000 4.800 2,000 500 100 200 6,000 5,000 22,000 1,400 500 10,000 16,000 5,300 2018 (000's) $ 39,000 25,300 4.000 4,000 1,700 300 700 500 3,500 3,200 20,000 700 500 6,000 15.000 5,000 DWCC Case Study, Prof. Whitaker, Spring 2020 Page 1 Case Study, Dover Water Cooler Company (Continued) 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 ($ 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 & $/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. M N O P Q DOVER WATER COOLER COMPANY CASE STUDY, S'20 0.00 Student Name: 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 (Percentage) * Remember, Sales are in 000's, units are not. utoSave Of A - DWCC Case Study - Excel financial analysis, Spring.xlsx - Excel Home Insert Page Layout Formulas Data Review View Help . for X C D E F G H 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 Retum on equity 35 F.S. Analysis-BS F.S. Analysis IS F.S. Market Analysis F.S. Ratios Read Type here to search