Answered step by step
Verified Expert Solution
Link Copied!

Question

...
1 Approved Answer

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

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.

image text in transcribedimage text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John J Wild, Ken Shaw

25th Edition

9781260247985

Students also viewed these Finance questions