Complete an analysis for each ratio below. A ratio analysis includes a trend analysis, an industry comparison and a sentence summarizing your overall view of the company's financial performance in that category. Please be thorough, this is an analysis.
Part 1 - Ratio Calculations Ratio Formulas (To save you a little bit of time) Numerators / Denominators Ratios for Mystery Company 2016 2017 2018 2015 2019 Competitor Averages 2019 Gross Profits Sales 38.52% 41.45% 52.74% 49.9% Sales 28.94% 42.16% 51.30% 40.84% 28.18% 31.76% 19.03% 24.5% 46.54% 36.76% 22.75% 6.43 Sales 17.82% 28.59% Operating profits Earnings Available to SH Earnings Available to SH Earnings Available to SH Earnings Available to SH 13.7% / / / / / / 4.82 5.49 7.61 7.95 #of shares outstanding Total Assets 2.81 12.4% 11.949 15.10% 15.36% 18.02% 12.68% Common Stock Equity 63.90% -212.61%-158.87% -94.66% -73.39% -0.8% Current Liabilities 3.27 1.40 1.84 1.36 0.98 1.34 Current Assets Current Assets-Inventory / Current Liabilities 3.23 1.38 1.82 1.35 0.97 1.33 81.32% 107.10% 109.67% 118.82% 117.28% 173.3% Total Liabilities (Debt) Total Assets EBIT (Operating income) / / / Total Assets Shareholder Equity Interest Expense 5.35 -14.08 -10.34 -5.25 -5.79 2.58 -11.69 -8.88 -9.18 -8.79 -8.19 2.97 Ratios Profitability Ratios Gross Profit Margin Operating Profit Margin Net Profit Margin Earnings per Share (EPS) Return on Assets (ROA) Return on Equity (ROE) Liquidity Ratios Current Ratio Quick Ratio Debt Ratios Debt to Total Assets Equity Multiplier (FLM) Times Interest Earned Activity Ratios Average Collection Period Accounts Payable Turnover Days AP Inventory Turnove Days Inventory Total Asset Turnover Market Ratios Price/Earnings (P/E) Market/Book (M/B) Modified DuPont Analysis Net Margin Total Asset Turnover (TAT) ROA Equity Multiplier (FLM) ROE Accounts Receivable / 18.66 21.85 31.61 42.39 38.52 25.86 COGS 17.88 19.07 13.19 8.48 10.08 23.82 Sales/365) Accounts Payable AP Turnover Inventory 365 20.42 19.14 27.67 43.06 36.20 15.33 COGS 156.24 244.36 206.78 200.76 199.22 451.13 365 / / / Inventory Turnover 2.34 1.49 1.77 1.82 1.83 0.81 Sales Total Assets 0.67 0.79 0.68 0.64 0.44 0.80 24.47 22.23 26.73 22.98 24.91 22.41 Market Price per Share Market Price per Share / EPS 1 ex Kalautstanding Shar 0.28 -0.94 -0.89 -0.48 -0.41 0.16 From above =D32 19.03% 22.75% 28.18% 17.82% 0.67 28.59% 0.44 From above =D15 0.79 0.68 0.64 / / / / Me Free Xarxi 747 =D38 039 11.94% 15.10% 15.36% 18.02% 12.68% From above =D26 5.35 -14.08 -10.34 -5.25 -5.79 ROA FLM =D40041 63.90% -212.61% -158.87% -94.66% -73.39% Part 3 - Ratio Analysis Profitability: Liquidity: Debt: Activity larket: Modified DuPont Analysis
