financial analysis

realCJY
factset.xlsx
Home>Business & Finance homework help>financial analysis

restaurant

United States / Restaurants -IND
FI3435US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Gross Margin 24.59 24.60 23.63 23.42 25.45
Operating Margin 16.30 16.44 15.14 15.19 16.49
Net Margin 12.31 10.61 10.01 9.47 11.09
EBIT Margin 16.30 16.44 15.14 15.19 16.49
EBITDA Margin 21.19 21.22 20.11 20.10 21.53
Return on Assets 13.20 12.39 11.95 11.00 12.33
Return on Equity -700.58 180.41 87.91 38.93 34.20
Return on Invested Capital 20.94 17.97 17.42 15.57 17.29
Free Cash Flow Margin 14.92 8.06 9.65 9.36 6.55
United States / Restaurants -IND
FI3435US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Price/Earnings 21.82 26.33 23.14 26.94 22.93
Price/Earnings (excl negatives) 21.71 25.99 22.97 26.68 22.60
Price/Sales 2.69 2.79 2.32 2.55 2.54
Price/Book Value -152.87 47.50 20.34 10.49 7.84
Price/Cash Flow 12.35 19.99 14.54 16.04 18.04
Price/Cash Flow (excl negatives) 12.35 19.99 14.53 16.02 18.04
Price/Free Cash Flow 17.99 34.63 23.99 27.25 38.83
Enterprise Value/EBIT 19.42 19.72 17.85 18.77 16.86
Enterprise Value/EBITDA 14.94 15.28 13.44 14.18 12.92
Enterprise Value/Sales 3.17 3.24 2.70 2.85 2.78
United States / Restaurants -IND
FI3435US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Net Debt/EBITDA 2.26 2.12 1.91 1.48 1.10
Net Debt/(EBITDA-Capex) 3.33 2.93 2.78 2.19 1.69
Total Debt/EBITDA 2.89 2.54 2.32 1.85 1.52
Total Debt/EBIT 3.76 3.28 3.09 2.45 1.98
EBIT/Interest Expense (Int. Coverage) 7.02 7.72 9.03 10.32 11.47
EBITDA/Interest Expense 9.13 9.90 11.88 13.66 14.93
CFO/Interest Expense 9.39 6.50 9.39 10.92 9.90
LT Debt/EBITDA 2.86 2.50 2.29 1.82 1.47
Net Debt/FFO 284.10 309.94 253.26 197.45 149.03
LT Debt/FFO 359.16 366.52 303.27 242.31 200.00
FCF/Total Debt 24.36 14.96 20.66 25.16 20.06
CFO/Total Debt 35.50 25.91 34.11 42.74 43.17
United States / Restaurants -IND
FI3435US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
LT Debt/Total Equity -3,445.10 903.82 404.57 150.03 97.78
LT Debt/Total Capital 101.69 88.85 79.28 59.32 48.73
LT Debt/Total Assets 64.93 62.06 55.00 42.39 35.27
Total Debt/Total Assets 65.74 62.98 55.78 43.20 36.31
Total Debt/Total Equity -3,487.83 917.22 410.27 152.92 100.67
Net Debt/Total Capital 80.44 75.14 66.21 48.34 36.31
Total Debt/Total Capital 102.95 90.17 80.40 60.46 50.17
United States / Restaurants -IND
FI3435US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Sales/Revenue Growth 4.46 -4.50 1.85 1.81 3.02
COGS Growth 4.74 -5.78 0.86 1.71 3.25
Gross Income Growth 3.61 -0.38 5.22 2.28 2.43
SG&A Growth 4.89 -7.78 6.70 2.40 -0.05
EBIT Growth 1.90 3.59 4.24 2.32 3.81
EBITDA Growth 3.32 0.77 3.68 2.54 4.49
Pretax Income Growth 15.64 6.76 8.93 -0.94 25.96
Net Income Growth 18.87 0.74 9.96 -3.02 3.09
Dividend Growth 12.15 0.06 1.34 7.36 8.71

aerspace & defense

United States / Aerospace & Defense -IND
FI1330US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Sales/Revenue Growth 7.54 1.70 0.02 2.25 1.14
COGS Growth 6.43 -0.22 0.88 2.14 0.60
Gross Income Growth 11.98 9.66 -3.49 2.72 3.45
SG&A Growth 8.73 -2.43 5.91 0.91 -1.03
EBIT Growth 14.84 20.77 -5.13 -1.67 7.23
EBITDA Growth 13.81 18.09 -3.56 -1.59 6.76
Pretax Income Growth 11.34 27.32 -5.79 -6.55 16.97
Net Income Growth 17.20 15.31 -4.49 -0.78 12.92
Dividend Growth 12.74 14.50 8.21 12.20 14.79
United States / Aerospace & Defense -IND
FI1330US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Gross Margin 20.94 20.49 19.13 19.79 19.48
Operating Margin 12.47 11.79 9.96 10.45 11.24
Net Margin 8.51 7.85 6.95 7.25 7.38
EBIT Margin 12.47 11.79 9.96 10.45 11.24
EBITDA Margin 14.92 14.29 12.34 12.72 13.62
Return on Assets 7.33 6.95 6.44 6.74 6.67
Return on Equity 46.53 36.32 34.39 33.39 21.60
Return on Invested Capital 18.24 16.28 15.27 16.71 13.71
Free Cash Flow Margin 8.25 9.23 8.27 7.08 7.67
United States / Aerospace & Defense -IND
FI1330US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Price/Earnings 19.27 24.77 20.49 17.64 17.81
Price/Earnings (excl negatives) 18.96 24.49 19.69 17.55 17.62
Price/Sales 1.64 1.95 1.42 1.28 1.31
Price/Book Value 8.97 9.00 7.05 5.36 3.85
Price/Cash Flow 15.37 16.46 13.12 13.39 13.24
Price/Cash Flow (excl negatives) 15.26 16.36 13.09 12.81 13.20
Price/Free Cash Flow 19.88 21.08 17.20 18.06 17.13
Enterprise Value/EBIT 15.04 18.14 16.02 13.49 12.62
Enterprise Value/EBITDA 12.56 14.96 12.93 11.08 10.42
Enterprise Value/Sales 1.87 2.14 1.60 1.41 1.42
United States / Aerospace & Defense -IND
FI1330US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
Net Debt/EBITDA 1.55 1.34 1.38 1.01 0.76
Net Debt/(EBITDA-Capex) 1.85 1.63 1.74 1.25 0.91
Total Debt/EBITDA 2.04 1.97 2.13 1.79 1.57
Total Debt/EBIT 2.44 2.38 2.64 2.17 1.91
EBIT/Interest Expense (Int. Coverage) 9.87 9.66 8.41 10.03 11.51
EBITDA/Interest Expense 11.82 11.71 10.41 12.21 13.94
CFO/Interest Expense 8.69 10.05 9.62 9.65 10.55
LT Debt/EBITDA 1.90 1.86 2.05 1.71 1.50
Net Debt/FFO 172.51 162.29 165.90 123.16 96.67
LT Debt/FFO 211.92 226.37 247.21 208.80 191.30
FCF/Total Debt 27.15 32.84 31.50 31.17 35.79
CFO/Total Debt 35.12 42.07 41.29 42.03 46.32
United States / Aerospace & Defense -IND
FI1330US
Source: FactSet Market Aggregrates
DEC '18 DEC '17 DEC '16 DEC '15 DEC '14
LT Debt/Total Equity 155.10 123.09 125.22 90.42 60.89
LT Debt/Total Capital 58.28 53.53 54.39 45.78 37.01
LT Debt/Total Assets 24.44 23.54 23.45 20.41 18.47
Total Debt/Total Assets 26.18 24.85 24.35 21.45 19.39
Total Debt/Total Equity 166.14 129.94 130.05 95.06 62.77
Net Debt/Total Capital 47.44 38.38 36.53 28.86 18.51
Total Debt/Total Capital 62.43 56.51 56.53 48.73 38.57