Financial Management-Pre Work Assignment

profilenarranitin9
OperatingAndEfficiency.xls
Home>Business & Finance homework help>Management homework help>Financial Management-Pre Work Assignment

DGX

Fiscal 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 Current 5-Yr
Gross Margin % 40.88 39.46 37.63 37.85 38.58 38.79 34.59 34.80 38.50 39.02 37.20 37.14
Operating Margin % 16.27 14.01 13.22 14.21 15.42 15.11 14.67 15.93 20.89 22.07 19.74 17.73
Net Margin % 7.49 11.84 7.45 9.42 8.54 9.98 9.73 11.07 15.10 18.43 13.98 12.86
EBITDA Margin % 20.63 25.09 17.89 20.83 19.68 18.85 18.64 20.52 25.55 29.28 23.63 22.57
Tax Rate % 37.62 37.09 30.86 33.82 39.50 23.40 19.65 22.96 24.42 22.97 23.51 22.68
Return on Asset % 5.95 9.28 5.89 7.12 6.40 7.46 6.82 7.17 10.61 14.39 11.30 9.29
Return on Equity % 14.08 20.86 13.43 15.72 13.79 16.11 14.46 15.75 22.98 30.11 24.03 19.88
Return on Invested Capital % 8.61 12.78 8.70 9.85 8.73 10.32 9.64 9.77 13.69 18.47 14.75 12.38
Interest Coverage 7.37 9.32 6.08 8.16 8.54 7.73 6.48 6.98 12.35 18.10 13.96 10.33
Days Sales Outstanding 43.84 43.90 43.79 44.64 44.37 43.80 46.92 49.01 49.95 50.04 43.94 47.94
Days Inventory 7.62 7.76 7.91 7.60 6.56 6.85 7.19 8.04 10.88 11.96 10.60 8.98
Payables Period 17.51 19.47 20.27 21.00 21.35 18.76 16.52 17.57 22.29 22.28 - 19.48
Cash Conversion Cycle 33.94 32.19 31.43 31.24 29.58 31.88 37.58 39.49 38.54 39.72 - 37.44
Recieveables Turnover 8.33 8.31 8.34 8.18 8.23 8.33 7.78 7.45 7.31 7.29 8.31 7.63
Inventory Turnover 47.92 47.01 46.14 48.01 55.61 53.32 50.78 45.38 33.55 30.53 34.43 42.71
Fixed Assets Turnover 9.49 9.16 8.56 8.07 7.69 7.09 6.19 4.74 4.49 4.76 4.73 5.45
Asset Turnover 0.79 0.78 0.79 0.76 0.75 0.75 0.70 0.65 0.70 0.78 0.81 0.72