o Describe how and why each of the ratios has changed over the three-year period. For example, did the current ratio increase or decrease? Why? Describe how three of the ratios you calculated for your company compare to the general industry. Find general industry data by entering your specific companys ticker symbol here. Be sure to watch the Mergent Online video (written instructions can be found here), as it will help you find the industry data. 4. Professionalism, References, and Mechanics Format the data on all worksheets so that the file has a neat and professional appearance. Include links and properly formatted citations referencing the location of the data used. Your written responses should be free of errors in organization, grammar, and style.
Profitability Ratios | 12/31/2019 | | 12/31/2018 | | 12/31/2017 | |
? | ROA % (Net) | (6.31) | > | (8.25) | > | (18.93) | > |
? | ROE % (Net) | (9.75) | > | (12.35) | > | (27.04) | > |
? | ROI % (Operating) | (5.58) | > | (6.96) | > | (14.48) | > |
? | EBITDA Margin % | (13.92) | > | (15.97) | > | (36.74) | > |
? | Calculated Tax Rate % | EBT<0 | > | EBT<0 | > | EBT<0 | > |
? | Revenue per Employee | 230,545 | > | 208,954 | > | 189,504 | > |
Liquidity Ratios | 12/31/2019 | | 12/31/2018 | | 12/31/2017 | |
? | Quick Ratio | 6.37 | > | 8.36 | > | 3.7 | > |
? | Current Ratio | 6.52 | > | 8.53 | > | 3.87 | > |
? | Net Current Assets % TA | 31.06 | > | 30.76 | > | 14.06 | > |
Debt Management | 12/31/2019 | | 12/31/2018 | | 12/31/2017 | |
? | LT Debt to Equity | 0.43 | > | 0.41 | > | 0.37 | > |
? | Total Debt to Equity | 0.43 | > | 0.41 | > | 0.37 | > |
Asset Management | 12/31/2019 | | 12/31/2018 | | 12/31/2017 | |
? | Total Asset Turnover | 0.35 | > | 0.36 | > | 0.41 | > |
? | Receivables Turnover | 11.01 | > | 11.83 | > | 11.41 | > |
? | Accounts Payable Turnover | 65.7 | > | 71.73 | > | 76.23 | > |
? | Accrued Expenses Turnover | 11.78 | > | 12.12 | > | 11.37 | > |
? | Property Plant & Equip Turnover | 54.13 | > | 43.73 | > | 28.38 | > |
? | Cash & Equivalents Turnover | 1.18 | > | 1.79 | > | 5.03 | > |
Per Share | 12/31/2019 | | 12/31/2018 | | 12/31/2017 | |
? | Cash Flow per Share | 0.42 | > | (0.07) | > | (0.62) | > |
? | Book Value per Share | 13.94 | > | 14.37 | > | 9.08 | > |