Short Essay

profilekm123
Question3MotorVehicleIndustryRatios1.xlsx
Home>Business & Finance homework help>Management homework help>Short Essay

FI1405US

United States / Motor Vehicles -IND
FI1405US
Source: FactSet Market Aggregrates
DEC '19 DEC '18 DEC '17 DEC '16 DEC '15 DEC '14 DEC '13 DEC '12 DEC '11 DEC '10
Profitability (%)
Gross Margin 10.36 10.72 11.73 15.32 13.86 11.10 12.13 13.36 13.85 13.82
Operating Margin 2.83 2.64 3.14 5.56 4.40 2.31 3.30 4.80 5.34 4.82
Net Margin 3.00 1.19 3.20 6.29 3.74 3.53 11.08 8.26 5.81 4.08
EBIT Margin 2.83 2.64 3.14 5.56 4.40 2.31 3.30 4.80 5.34 4.82
EBITDA Margin 10.81 10.07 10.41 11.80 9.44 6.64 7.52 8.90 9.45 10.20
Return on Assets 1.88 0.75 2.02 4.33 2.70 2.74 8.96 6.82 5.22 3.37
Return on Equity 11.34 4.82 12.68 25.45 17.42 14.95 56.10 37.70 31.08 35.54
Return on Invested Capital 3.67 1.46 3.99 8.86 5.75 5.96 19.00 16.50 11.46 7.90
Free Cash Flow Margin 1.34 -0.51 -2.25 -0.51 0.01 1.64 1.40 2.22 2.32 3.71
Valuation (x)
Price/Earnings 17.13 35.83 16.32 7.13 12.97 14.37 4.44 4.58 5.04 11.63
Price/Earnings (excl negatives) 8.85 - 9.85 5.20 9.64 11.60 3.88 4.35 4.80 11.26
Price/Sales 0.51 0.43 0.52 0.45 0.49 0.51 0.49 0.38 0.29 0.47
Price/Book Value 1.94 1.73 2.07 1.81 2.26 2.15 2.49 1.73 1.57 4.13
Price/Cash Flow 4.66 4.00 5.31 4.15 5.07 6.62 7.18 5.23 4.93 6.94
Price/Cash Flow (excl negatives) 4.66 3.99 3.55 4.14 3.91 6.62 7.18 4.99 4.72 6.77
Price/Free Cash Flow 38.25 -83.03 -23.23 -87.82 8,167.06 30.93 35.04 17.09 12.61 12.79
Enterprise Value/EBIT 40.51 40.61 35.77 16.99 20.91 36.64 23.54 12.38 9.12 14.29
Enterprise Value/EBITDA 10.61 10.65 10.80 8.01 9.76 12.73 10.33 6.67 5.15 6.76
Enterprise Value/Sales 1.15 1.07 1.12 0.94 0.92 0.85 0.78 0.59 0.49 0.69
Coverage (x)
Net Debt/EBITDA 5.70 6.28 5.70 4.20 4.59 4.89 3.40 1.96 1.63 1.81
Net Debt/(EBITDA-Capex) 54.06 -56.01 -35.01 100.58 -306.76 52.52 12.34 4.50 2.64 2.61
Total Debt/EBITDA 7.71 8.27 7.62 5.85 6.65 8.10 6.39 4.77 4.10 4.77
Total Debt/EBIT 29.45 31.52 25.21 12.41 14.25 23.32 14.55 8.85 7.26 10.10
EBIT/Interest Expense (Int. Coverage) 3.67 3.25 4.13 9.25 9.58 4.93 9.55 10.29 9.34 3.92
EBITDA/Interest Expense 14.02 12.37 13.67 19.63 20.52 14.20 21.77 19.09 16.53 8.29
CFO/Interest Expense 14.45 13.72 13.72 18.66 21.54 16.86 20.26 15.76 10.56 5.59
LT Debt/EBITDA 5.12 5.68 5.29 3.92 4.63 5.37 5.13 3.17 3.39 3.94
Net Debt/FFO 543.79 565.99 481.24 473.04 506.31 314.47 322.91 197.66 232.03 -3,057.18
LT Debt/FFO 488.05 512.03 447.10 441.97 510.03 345.88 487.82 319.09 482.09 -6,643.35
FCF/Total Debt 1.61 -0.62 -2.84 -0.74 0.01 3.05 2.93 5.22 6.00 7.62
CFO/Total Debt 13.21 12.83 12.43 15.65 15.27 14.25 14.27 17.03 15.35 14.04
Leverage (%)
LT Debt/Total Equity 209.15 231.27 218.14 187.14 203.15 151.03 195.28 128.50 171.19 350.05
LT Debt/Total Capital 50.36 52.95 52.71 49.36 51.81 46.08 56.93 43.74 55.75 66.76
LT Debt/Total Assets 34.67 36.10 34.76 31.87 31.47 27.71 31.19 23.23 28.75 33.16
Total Debt/Total Assets 52.26 52.56 50.01 47.54 45.25 41.78 38.82 35.03 34.78 40.20
Total Debt/Total Equity 315.29 336.77 313.87 279.14 292.13 227.73 243.05 193.77 207.10 424.31
Net Debt/Total Capital 56.11 58.53 56.73 52.83 51.43 41.90 37.68 27.10 26.83 30.72
Total Debt/Total Capital 75.92 77.10 75.84 73.62 74.50 69.49 70.85 65.96 67.44 80.93