finance presentation EXCEL WORD included.
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