Using the data, calculate on the following ratios Balance Sheet Assets Current Assets Cash AR Inventory Fixed

Using the data, calculate on the following ratios
  

Transcribed Image Text:

Balance Sheet Assets Current Assets Cash AR Inventory Fixed assets (net) Total AP Long-term debt Stockholder's Equity Common stock Paid-in Capital Retained Earnings Income statement Net sales Cost of goods sold Gross Margin Operating expenses Seling expenses Administrative expenses Net income Additional Information Average net receivables Average inventory Average assets Year 1 Current ratio Quick ratio A/R turnover Vertical Analysis 45.000 150,000 75.000 60.000 330,000 95,000 60,000 25,000 75,000 75.000 $330.000 50,000 60,000 15.000 155,000 65,000 330,000 14% 45% 23% 18% 100% 250,000 100% 125,000 50% 125,000 50% Collection ratio Inventory turnover Average number of days inventory is in stock Debt-to-Equity ratio Profit margin Asset turnover 8% 23% 29% 215,000 18% 60,000 Year 2 15,000 200,000 150,000 60,000 425,000 20% 24% 6% 23% 100% $425.000 25,000 75,000 50.000 450,000 300,000 150,000 4% 47% 210,000 130,000 425,000 35% 14% 100% 51% 14% 6% 18% 12% 100% 67% 33% 75,000 17% 100,000 22% (25.000) -6% Horizontal Analysis Change (30,000) 50,000 75,000 95,000 120,000 (25.000) 95.000 200,000 175,000 25,000 From the balance sheet and income statement shown above calculate and comment on the following ratios 25,000 40,000 (40,000) % Change -67% 33% 100% 0% 29% 126% 0% 0% 0% -33% 29% 80% 140% 20% 50% 67% -267% Balance Sheet Assets Current Assets Cash AR Inventory Fixed assets (net) Total AP Long-term debt Stockholder's Equity Common stock Paid-in Capital Retained Earnings Income statement Net sales Cost of goods sold Gross Margin Operating expenses Seling expenses Administrative expenses Net income Additional Information Average net receivables Average inventory Average assets Year 1 Current ratio Quick ratio A/R turnover Vertical Analysis 45.000 150,000 75.000 60.000 330,000 95,000 60,000 25,000 75,000 75.000 $330.000 50,000 60,000 15.000 155,000 65,000 330,000 14% 45% 23% 18% 100% 250,000 100% 125,000 50% 125,000 50% Collection ratio Inventory turnover Average number of days inventory is in stock Debt-to-Equity ratio Profit margin Asset turnover 8% 23% 29% 215,000 18% 60,000 Year 2 15,000 200,000 150,000 60,000 425,000 20% 24% 6% 23% 100% $425.000 25,000 75,000 50.000 450,000 300,000 150,000 4% 47% 210,000 130,000 425,000 35% 14% 100% 51% 14% 6% 18% 12% 100% 67% 33% 75,000 17% 100,000 22% (25.000) -6% Horizontal Analysis Change (30,000) 50,000 75,000 95,000 120,000 (25.000) 95.000 200,000 175,000 25,000 From the balance sheet and income statement shown above calculate and comment on the following ratios 25,000 40,000 (40,000) % Change -67% 33% 100% 0% 29% 126% 0% 0% 0% -33% 29% 80% 140% 20% 50% 67% -267%

Answer rating: 100% (QA)

Return on Assets ROA Year 1 Net Income Average Assets 40000 210000 19 Return on Assets ROA Year 2 Ne... View the full answer