finance presentation EXCEL WORD included.

profileldxbi19
group_work_2_excel.pdf

JNJ DOW LLY PFE JNJ DOW LLY PFE JNJ DOW LLY PFE JNJ DOW LLY PFE JNJ DOW LLY PFE 1/3/2016 12/31/2015 12/31/2015 12/31/2015 12/28/2014 12/13/2014 12/31/2014 12/31/2014 12/29/2013 12/31/2013 12/31/2013 12/31/2013 12/30/2012 12/31/2012 12/31/2012 12/31/2012 1/1/2012 12/31/2011 12/31/2011 12/31/2011

ROE 21.87% 37.10% 16.07% 10.23% 22.70% 16.76% 14.47% 12.38% 19.92% 22.53% 28.89% 27.93% 17.81% 4.83% 28.88% 17.83% 17.02% 13.35% 33.53% 11.78%

Net  Profit  Margin 21.99% 15.06% 12.07% 14.25% 21.96% 5.90% 12.19% 18.42% 19.40% 7.79% 20.27% 42.65% 16.14% 1.48% 18.09% 24.70% 14.87% 4.00% 17.90% 14.84% Gross  Profit  Margin 69.27% 22.43% 74.76% 80.25% 69.40% 18.40% 74.85% 80.69% 68.67% 16.62% 78.76% 81.42% 67.78% 15.84% 78.78% 80.79% 68.69% 14.93% 79.13% 77.63% EBITDA  Margin 33.53% 27.47% 21.94% 31.41% 33.62% 15.46% 23.08% 38.77% 28.13% 18.55% 32.43% 86.97% 26.74% 9.92% 31.18% 53.19% 24.74% 13.04% 28.45% 38.70% Operating  Profit  Margin 25.78% 22.15% 13.47% 19.84% 28.20% 10.65% 13.56% 26.56% 25.77% 13.78% 23.24% 32.43% 23.61% 5.09% 20.94% 22.41% 24.84% 8.17% 22.76% 20.74% Pre-­‐tax  Margin 27.39% 20.36% 13.98% 18.35% 27.66% 9.05% 15.30% 24.67% 21.69% 11.92% 25.48% 30.47% 20.49% 2.93% 23.93% 20.48% 19.01% 6.00% 22.03% 18.93% Revenue  per  employee  ($) 551,329.66     985,414.14     483,554.21     498,988.76           587,596.84     1,097,490.57     501,229.08           633,524.90           556,690.09     1,076,981.13     609,442.32           663,886.74     526,833.86     1,051,592.59     589,397.65           644,655.74           551,569.13     1,160,139.25     637,775.74     650,192.86     Net  income  per  employee  ($) 121,235.25     148,383.84     58,350.09         71,092.95                 129,035.57     64,754.72                 61,083.43                 116,666.67           107,970.34     83,905.66                 123,528.02           283,178.89     85,054.86         15,592.59                 106,612.78           159,234.97           82,035.62         46,455.86                 114,172.79     96,518.80         Effective  tax  rate 19.73% 21.62% 13.68% 22.20% 20.62% 27.08% 20.32% 25.49% 10.60% 29.22% 20.45% 27.40% 23.67% 33.93% 24.40% 21.21% 21.75% 22.69% 18.73% 31.52%

Total  Asset  Turnover  (times) 0.53 0.71 0.55 0.29 0.56 0.84 0.54 0.29 0.56 0.82 0.66 0.29 0.57 0.82 0.66 0.32 0.60 0.86 0.75 0.35 Receivables  Turnover  (times) 6.45 11.13 5.92 5.80 6.55 12.09 5.88 5.50 6.20 11.41 6.83 4.75 6.14 11.39 6.52 4.54 6.39 12.61 6.85 4.78 Receivables  Period  (days) 57.00 33.00 62.00 63.00 56.00 31.00 63.00 67.00 59.00 33.00 54.00 77.00 60.00 33.00 56.00 81.00 58.00 29.00 54.00 77.00 Inventory  Turnover  (times) 2.65 5.05 1.63 1.46 2.83 5.79 1.74 1.62 2.91 5.67 1.76 1.45 3.14 5.95 1.94 1.53 3.49 6.96 2.10 1.87 Inventory  Period  (days) 138.00 73.00 225.00 250.00 129.00 64.00 210.00 226.00 126.00 65.00 208.00 252.00 117.00 62.00 189.00 239.00 105.00 53.00 174.00 196.00 Net  Fixed  Asset  Turnover  (times) 0.97 1.11 0.83 0.42 1.00 1.31 0.83 0.44 0.94 1.26 1.06 0.43 1.00 1.24 1.11 0.46 1.13 1.31 1.37 0.51 PPE  Turnover  (times) 4.38 2.72 2.49 3.83 4.53 3.28 2.46 4.11 4.35 3.26 2.94 3.84 4.36 3.26 2.91 3.76 4.44 3.43 3.09 3.74 Payables  Turnover  (times) 3.01 9.39 4.08 2.73 3.27 10.46 4.39 2.87 3.69 9.92 4.25 2.56 3.75 9.77 4.15 2.80 3.59 11.17 4.61 3.84 Payables  Period  (days) 122.00 39.00 90.00 134.00 112.00 35.00 84.00 128.00 99.00 37.00 86.00 143.00 98.00 38.00 89.00 131.00 102.00 33.00 80.00 96.00 Cash  Ratio  (times) 0.53 0.62 0.39 0.14 0.70 0.49 0.38 0.12 0.72 0.44 0.45 0.24 0.84 0.39 0.57 0.25 0.96 0.45 0.74 0.09 Current  Ratio  (times) 2.26 2.14 1.27 1.99 2.28 2.09 1.26 2.53 2.05 2.07 1.51 2.26 2.13 1.87 1.58 2.10 2.21 1.71 1.81 2.09 Quick  Ratio  (times) 1.95 1.48 0.96 1.73 1.96 1.39 0.97 2.27 1.75 1.36 1.19 2.01 1.84 1.24 1.29 1.84 1.96 1.18 1.51 1.80 Operating  Cycle  (days) 195.00 106.00 287.00 313.00 185.00 95.00 273.00 293.00 185.00 98.00 262.00 329.00 177.00 95.00 245.00 320.00 163.00 82.00 228.00 273.00 Cash  Cycle  (days) 73.00 67.00 197.00 179.00 73.00 60.00 189.00 165.00 86.00 61.00 176.00 186.00 79.00 57.00 156.00 189.00 61.00 49.00 148.00 177.00

Equity  Multiplier  (times) 1.88 3.46 2.43 2.48 1.83 3.38 2.19 2.31 1.83 3.52 2.15 2.27 1.93 3.98 2.40 2.29 1.91 3.86 2.49 2.25 Long-­‐Term  Debt/Equity  Ratio  (times) 0.50 1.63 0.78 1.10 0.48 1.55 0.58 1.00 0.47 1.67 0.61 0.94 0.54 1.97 0.79 0.93 0.50 1.82 0.88 0.91 Interest-­‐bearing  Debt/Equity  Ratio  (times) 0.27 0.93 0.53 0.56 0.26 0.92 0.40 0.50 0.25 0.99 0.33 0.47 0.29 1.22 0.44 0.47 0.32 1.26 0.54 0.49 Long-­‐Term  Debt  Ratio  (times) 0.33 0.62 0.44 0.52 0.32 0.61 0.37 0.50 0.32 0.63 0.38 0.48 0.35 0.66 0.44 0.48 0.33 0.64 0.47 0.48 Times  Interest  Earned  Ratio  (times) 35.78 11.50 18.31 8.50 39.58 6.36 21.16 10.07 33.10 7.18 37.79 27.20 26.89 2.31 31.42 15.59 22.65 3.69 29.76 10.15 Cash  Coverage  Ratio  (times) 42.56 14.16 27.16 12.80 46.89 9.15 30.43 14.14 41.61 9.61 46.81 31.73 33.78 4.44 39.64 20.59 28.18 5.84 37.15 15.52 Cash  Flow  to  Debt  Ratio  (times) 0.99 0.46 0.50 0.34 1.10 0.30 0.59 0.43 1.04 0.34 1.17 1.07 0.80 0.19 0.92 0.74 0.72 0.25 0.85 0.52 Additional  Ratios

Asset  Management

Financial  Leverage

FY  2013FY  2015 FY  2014 FY  2012 FY  2011

Operatng  Efficiency