Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Formulas with terms from MarketWatch 2016 2017 2018 2019 2020 Current Industry Current Ratio Total Current Assets/Total Current Liabilities 1.18 1.22 1.15 1.11 1.19 1.48
Formulas with terms from MarketWatch | 2016 | 2017 | 2018 | 2019 | 2020 | Current | Industry | ||
Current Ratio | Total Current Assets/Total Current Liabilities | 1.18 | 1.22 | 1.15 | 1.11 | 1.19 | 1.48 | 1.15 | |
Quick Ratio | (Total Current Assets-Inventories)/Total Current Liabilities | 1.15 | 1.19 | 1.12 | 1.08 | 1.15 | NA | 1.08 | |
Debt to Equity Ratio | Total Liabilities/Common Equity (Total) | 98.64 | 44.82 | 15.56 | 16.69 | 93.97 | 1.73 | 1.15 | |
Times Interest Earned Ratio | EBIT after Unusual Expense/Interest Expense | 14.15 | 0.11 | 12.20 | 12.10 | 10.98 | NA | NA | |
Gross Profit Margin (%) | Gross Income/(Sales/Revenue) | 20.40% | 20.06% | 19.71% | 21.77% | 25.80% | 78.48% | 33.30% | |
Return on Sales (%) (Net Profit Margin) | Net Income/(Sales/Revenue) | 5.67% | 7.38% | 6.66% | 6.01% | 1.59% | 1.59% | 4.89% | |
Return on Total Assets (%) | Net Income/Total Assets | 8.49% | 10.77% | 9.58% | 7.67% | 2.15% | 10.07% | 4.81% | |
Return on Common Equity (%) | Net Income/Common Equity (Total) | 846.91% | 493.96% | 158.61% | 135.78% | 203.96% | 73.16% | 12.01% | |
Price/Earnings Ratio | Market price per share of common stock/ Earning per share (see note in #1 above) | 29.47 | 21.16 | 17.64 | 22.77 | 108.65 | 28.74 | NA |
1. Time Series Analysis (Describe the 5-year trend for each ratio and what it tells you about the company)
2. Cross-Sectional Analysis (For each ratio, explain how your company compares to the industry)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started