toeve Johnson & Johnson STUDENTER) - Excel ile Home e sourch A Colors A Fonts Insert Draw Page Layout Formas Data Review View width: Automatic Oright Automatic Margins Orientation Se Prints Background Print mes Codines Headings Themes View Big Send Selection fond Bad H D F G JOHNSON & JOHNSON (IN) S Year. Consolidated Financial Statements fall values in millions) 12/31/2015 12/11/2016 12/31/2017 12/31/2018 12/31/2019 Common Stock (19.5640) (25.2120 (28.43401 01.24201 (35.29701 Retained Earnings 90.7140 95,650.0 BR 5940 90.9940 94.7680 Total Common Equity Total Stockholders' Equity Total Lab & Equity Common Shares Outstanding Stock Price per share 2.755.162 2.706 511 2.682 535 5 102.725 115 215 119.725 2.632 507 129.055 145.87 $ 70,0740 57100 576.4500 $81.581 582059.0 17,7090 1760 189870 19.900 20.3960 3,745.0 3.754.0 5.620 69290 30,249.0 29.0400 31,9740 13150 23.510 Income Statement Sales Costs of Goods Sold Depreciation and Amortization Selling General Administrative Expense Earnings Before Interest and Taxes (EBIT) Interest EST (Before Unusual items) Extraordinary Expenses Earnings Before Towes (ET) Taxes Net Income Common Dividends Other Dividends & Distributions Addition to retained Earnings 6540 BO 10280 1.0910 (1.480.0 5790 1,146 2.299.0 3.405.0 3.7870 263.0 16110 2.7020 2.2010 8,173.0 3,0450 8.621.0 7.983.0 15870 94140 34010 9,9170 1.4.80 FinSims Ratos CF SFCF-Gen FCF. Dun Port Type here to search Prisen Home End A & 2 3 5 6 7 8 9 0 X General 3 Calibri 11AA Wrap Test BIUD-A EEEE Merge & Center Alignment x $ . % *-* Insert Conditional Formatas Cell Formatting Table Styles Shes Font Number H B D JOHNSON & JOHNSON (NI) 5 Year - Consolidated Financial Statements (all values in millions) 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 . Balance Sheet 5 Assets 5 Cash $ 13,7320 S 18,9720 $ 17.8240 $ 18,107,0 $ 17,305.0 7 Short-Term Investments 24,644.0 23.2670 472.0 1,580.0 1,982.0 B Accounts Receivable 10,734,0 11,699.0 13,490.0 14.0980 14,4810 9 Inventory 8,053.0 8.144.0 8,765.0 8,599.0 9.020,0 10 Other Current Assets 3,047.0 2.950.0 2.5370 306490 2.486.0 11 Current Assets 12 Net Property Plant & Equipment 15,905.0 15.912.0 17,005.0 17,035.0 18.615.0 13 Intangibles 47,393.0 49,6810 85,1140 78,0640 81,282.0 14 Other Long-Term Aves 9.903.0 10.583.0 12.076.0 11.822.0 12,5570 15 Total Long-Term Assets 16 Total Assets 17 18 Uabilities 19 Accounts Payable 5 6,6680 69180 7.3100 S 20 7,537.0 S 8.5440 Accrued Expenses 13,3250 117140 17,4670 20,079.0 23,6830 20 Notes Payable 4.900.0 2.980.0 2,4070 1600 1020 22 Current Portion of Long Term Debt 2,104,0 1,704.0 1,4990 2,6160 1,359.0 23 Other Current Labrities 750.0 9710 1,854.0 8180 Current Liabilities 25 Long Term Debt 12,857.0 10,6750 27,684.0 27,2100 26 Other Long-Term Liabilities 21.657.0 22,0610 359110 34,2880 27 35.00 Total abilities 29 30 31 32 Toy Minority interest Preferred Stock Common Stock 119,564 01 125.212.03 Finstms Ratios CF S FCF en Fr. Perf Measures 128.434.0 (31,242.01 35.297.00 Type here to search co Prisen Home 6 7 8 W ERT U A S D F G H K AutoSave Search om Johnson & Johnson STUDENT(U) () - Excel File Home Insert Draw Page Layout Formulas Data Review View Help X - 10 AA 2 Wrap Text General LE BIU-B-a.A. Merge Center $ - % 92.92 Clipboard 5 Font Alignment Number Conditional Format as Cell Formatting Table Styles Styles Al G H B D JOHNSON & JOHNSON (JNJ) Year - Ratio Analysis 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 RATIOS Liquidity Current ratio Quick ratio Asset Management Total asset turnover Fixed asset tumover Receivables turnover Days sales outstanding Inventory turnover Days sales in inventory use 365 days per year 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Debt Management AMOUNT Debt ratio Debt to Equity ratio Market Debt ratio Liabilities to Assets ratio COVERAGE Times interest earned > Profitability Net profit margin Operating profit margin Basic earning power Return on total assets Return on common equity 31 32 Market Value FinStm Ratios CF Stm FCF Gen FCF.Din Perf Measures Type here to search Bib Prisen F3 a 3 4 5 6 7 8 Fort Alignment Number fo B G H JOHNSON & JOHNSON (JNJ) 5 Year - Ratio Analysis 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 RATIOS Profitability Net profit margin Operating profit margin Basic earning power Return on total assets Return on common equity Market Value Price/Earnings ratio Market/Book ratio Price/Sales ratio Dupont Equation Net profit margin Total asset turnover 0 Equity multiplier -1 Return on common equity 12 43 Cash Management 44 Operating Cycle 45 Days Payables Outstanding 46 Cash Conversion Cycle 47 48 49 50 51 52 Finstms Ratios CF Stm FCF-Gen FCF-Dan Perf Measures Type here to search BE Prts. $ & 2 3 4 5 6 7 8 toeve Johnson & Johnson STUDENTER) - Excel ile Home e sourch A Colors A Fonts Insert Draw Page Layout Formas Data Review View width: Automatic Oright Automatic Margins Orientation Se Prints Background Print mes Codines Headings Themes View Big Send Selection fond Bad H D F G JOHNSON & JOHNSON (IN) S Year. Consolidated Financial Statements fall values in millions) 12/31/2015 12/11/2016 12/31/2017 12/31/2018 12/31/2019 Common Stock (19.5640) (25.2120 (28.43401 01.24201 (35.29701 Retained Earnings 90.7140 95,650.0 BR 5940 90.9940 94.7680 Total Common Equity Total Stockholders' Equity Total Lab & Equity Common Shares Outstanding Stock Price per share 2.755.162 2.706 511 2.682 535 5 102.725 115 215 119.725 2.632 507 129.055 145.87 $ 70,0740 57100 576.4500 $81.581 582059.0 17,7090 1760 189870 19.900 20.3960 3,745.0 3.754.0 5.620 69290 30,249.0 29.0400 31,9740 13150 23.510 Income Statement Sales Costs of Goods Sold Depreciation and Amortization Selling General Administrative Expense Earnings Before Interest and Taxes (EBIT) Interest EST (Before Unusual items) Extraordinary Expenses Earnings Before Towes (ET) Taxes Net Income Common Dividends Other Dividends & Distributions Addition to retained Earnings 6540 BO 10280 1.0910 (1.480.0 5790 1,146 2.299.0 3.405.0 3.7870 263.0 16110 2.7020 2.2010 8,173.0 3,0450 8.621.0 7.983.0 15870 94140 34010 9,9170 1.4.80 FinSims Ratos CF SFCF-Gen FCF. Dun Port Type here to search Prisen Home End A & 2 3 5 6 7 8 9 0 X General 3 Calibri 11AA Wrap Test BIUD-A EEEE Merge & Center Alignment x $ . % *-* Insert Conditional Formatas Cell Formatting Table Styles Shes Font Number H B D JOHNSON & JOHNSON (NI) 5 Year - Consolidated Financial Statements (all values in millions) 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 . Balance Sheet 5 Assets 5 Cash $ 13,7320 S 18,9720 $ 17.8240 $ 18,107,0 $ 17,305.0 7 Short-Term Investments 24,644.0 23.2670 472.0 1,580.0 1,982.0 B Accounts Receivable 10,734,0 11,699.0 13,490.0 14.0980 14,4810 9 Inventory 8,053.0 8.144.0 8,765.0 8,599.0 9.020,0 10 Other Current Assets 3,047.0 2.950.0 2.5370 306490 2.486.0 11 Current Assets 12 Net Property Plant & Equipment 15,905.0 15.912.0 17,005.0 17,035.0 18.615.0 13 Intangibles 47,393.0 49,6810 85,1140 78,0640 81,282.0 14 Other Long-Term Aves 9.903.0 10.583.0 12.076.0 11.822.0 12,5570 15 Total Long-Term Assets 16 Total Assets 17 18 Uabilities 19 Accounts Payable 5 6,6680 69180 7.3100 S 20 7,537.0 S 8.5440 Accrued Expenses 13,3250 117140 17,4670 20,079.0 23,6830 20 Notes Payable 4.900.0 2.980.0 2,4070 1600 1020 22 Current Portion of Long Term Debt 2,104,0 1,704.0 1,4990 2,6160 1,359.0 23 Other Current Labrities 750.0 9710 1,854.0 8180 Current Liabilities 25 Long Term Debt 12,857.0 10,6750 27,684.0 27,2100 26 Other Long-Term Liabilities 21.657.0 22,0610 359110 34,2880 27 35.00 Total abilities 29 30 31 32 Toy Minority interest Preferred Stock Common Stock 119,564 01 125.212.03 Finstms Ratios CF S FCF en Fr. Perf Measures 128.434.0 (31,242.01 35.297.00 Type here to search co Prisen Home 6 7 8 W ERT U A S D F G H K AutoSave Search om Johnson & Johnson STUDENT(U) () - Excel File Home Insert Draw Page Layout Formulas Data Review View Help X - 10 AA 2 Wrap Text General LE BIU-B-a.A. Merge Center $ - % 92.92 Clipboard 5 Font Alignment Number Conditional Format as Cell Formatting Table Styles Styles Al G H B D JOHNSON & JOHNSON (JNJ) Year - Ratio Analysis 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 RATIOS Liquidity Current ratio Quick ratio Asset Management Total asset turnover Fixed asset tumover Receivables turnover Days sales outstanding Inventory turnover Days sales in inventory use 365 days per year 2. 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 Debt Management AMOUNT Debt ratio Debt to Equity ratio Market Debt ratio Liabilities to Assets ratio COVERAGE Times interest earned > Profitability Net profit margin Operating profit margin Basic earning power Return on total assets Return on common equity 31 32 Market Value FinStm Ratios CF Stm FCF Gen FCF.Din Perf Measures Type here to search Bib Prisen F3 a 3 4 5 6 7 8 Fort Alignment Number fo B G H JOHNSON & JOHNSON (JNJ) 5 Year - Ratio Analysis 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 RATIOS Profitability Net profit margin Operating profit margin Basic earning power Return on total assets Return on common equity Market Value Price/Earnings ratio Market/Book ratio Price/Sales ratio Dupont Equation Net profit margin Total asset turnover 0 Equity multiplier -1 Return on common equity 12 43 Cash Management 44 Operating Cycle 45 Days Payables Outstanding 46 Cash Conversion Cycle 47 48 49 50 51 52 Finstms Ratios CF Stm FCF-Gen FCF-Dan Perf Measures Type here to search BE Prts. $ & 2 3 4 5 6 7 8