utoSave On Search 2- JNJ Homework - Last Modified: 15m ago Insert Draw Page Layout Formulas Data Review le Home View Help Arial 10 AM a-A- General 2 Wrap Text Merge & Center ste BIU $ -% 9 ipboard Font Alignment Number A B F G JOHNSON & JOHNSON (JNU) 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 MarketBook ratio Price/Sales ratio Dupont Equation Net profit margin Total asset turnover Equity multiplier Return on common equity 1 5 5 7 Cash Management Operating Cycle Days Payables Outstanding Cash Conversion Cycle 3 3 1 2 FinStms Ratios CF Stm FCF-Gen FCF-Dan Perf Measures Type here to search C AutoSave 2 JNI Homework - Last Modified: 15m ago View IN File Home Insert Draw Page Layout Formulas Data Review Help Calibri 11 AA == Waplex General Paste BIU - OA Merge Center $ -% 42 Conditional Formats Cell Inger Formatting Table Styles Clipboard Font Alignment Number Styles 1 fx JOHNSON & JOHNSON (N) 5 Year - Consolidated Financial Statements A D E G H 1 JOHNSON & JOHNSON (II) 5 Year - Consolidated Financial Statements fall values in millions) 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 Balance Sheet Assets Cash $ 13,732,0 $ 18,972.0 $ 17,824,0 $ 18,1070 $ 17,305.0 Short-Term Investments 24,644,0 23,2670 472.0 1,580.0 1.982.0 Accounts Receivable 10,7340 11,699.0 13,490.0 14,0980 14,481.0 Inventory 8,053.0 8,144.0 8.765,0 8,599.0 9,020.0 Other Current Assets 3,047.0 2.950.0 2,537.0 3,649.0 2,486.0 Current Assets 60,210.0 65,032.0 43,088.0 46,033.0 45,274,0 259,637 Net Property Plant & Equipment 15,905.0 15,9120 17,005.0 17,035.0 18,615.0 Intangibles 47,393.0 49,6810 85,1340 78,064,0 81,282.0 Other Long-Term Assets 9,903.0 10,583.0 12,0760 11,822.0 12.557.0 Total Long-Term Assets 73,2010 76,176.0 114.215.0 106,9210 112,454.0 482,967 Total Assets $ 133,411,0 $ 141,208.0 $ 157,303,0 $ 152,9540 $ 157,728.0 742.604 $ Liabilities Accounts Payable Accrued Expenses Notes Payable Current Portion of Long-Term Debt Other Current Liabilities Current Liabilities Long-Term Debt Other Long-Term Liabilities Total abilities 6,668.0 13,325.0 4,900.0 2.104.0 750.0 27,747.0 12,857.0 21,657.0 62,261.0 6,91805 13,7140 2.980.0 1,704.0 971.0 26,287.0 22,442.0 22,0610 70,790.0 7,310,0 $ 17,4670 2,4070 1,499.0 1,854.0 30,537.0 30,675.0 35,931.0 97,143.0 7,537.0 $ 20,079.0 160.0 2,636.0 8180 31,230.0 27,684.0 34,2880 93.202.0 8,544.0 23.683.0 1020 1,369.0 2,266.0 35,964.0 27,210,0 35.083.0 98,2570 151,765 421,653 Equity Minority interest Preferred Stock Common Stock (19,564.0) (25.232.01 FinStms Ratios CF Stm FCF-Gen FCF-Dan Perf Measures (28,434.0) (31.242.0) (35.297.01 Type here to search BI Prtson 2 3 % 5 & 7 6 8 AutoSave On JNI Homework - Last Modified: 16 ago e Search File Home Insert Draw Page Layout Formulas Data Review View Help X Calibri 2 Wrap Test General Merge Center $ % 98-93 Alignment Number JOHNSON & JOHNSON (IN) 5 Year - Consolidated Financial Statements Conditional Formatas Cell Formatting Table Styles Clipboard Font fx A B ! 1 D F G H JOHNSON & JOHNSON (NU) 5 Year - Consolidated Financial Statements (all values in millions 12/31/2015 12/31/2016 12/31/2017 12/31/2018 12/31/2019 3 2 Preferred Stock Common Stock Retained Earnings Total Common Equity Total Stockholders' Equity (19,564,0) 90,714,0 71.150.0 133,4110 125.232.0) 95,650.0 70,418,0 141,2080 (28,434.0) 88,594,0 60,1600 157,303.0 (31.242.0) 90,994.0 59,752.0 152,9540 (35,297.0) 94,7680 59.471.0 157,728.0 320,951 742,604 5 6 7 8 Total Liab & Equity $ 133,4110 S 141,208.0 S 157,303,0 S 152,954.0 S 157,728.0 742604 Common Shares Outstanding Stock Price (per share) S 2.755.162 102.725 2,706 511 115.21 5 2,682.525 139.72 S 2,662.324 129.05 S 2,632.507 145.87 101,937 Income Statement Sales Costs of Goods Sold Depreciation and Amortization Selling General & Administrative Expense Earnings Before Interest and Taxes (EBIT) Interest EBT (Before Unusual Items) Extraordinary Expenses Earnings Before Taxes (CBT) Taxes Net Income Common Dividends Other Dividends & Distributions Addition to Retained Earnings $ 70,0740 $ 71,890.0 $ 76,450.0 S 81,581.0 S 82,059.0 17,709.0 17,886,0 18,987.0 19,948.0 20,3960 3,746.0 3.7540 5,642.0 6,929.0 7,009.0 30,249.0 29,040.0 31.974.0 33,315.0 33,533.0 18,37000 21.210.0 19,847.0 21,389.0 21,121.0 654,0 828.0 1,028.0 1.091.0 388.0 + 17,716,0 20,382,0 18,819.0 20,298.0 20,733.0 (1.480.0) 579.0 1,1460 2.299.0 3,405.0 16,236.0 20,9610 19,965.0 22,597,0 24,138 0 3,7870 3.263.0 16,373.0 2,702.0 2,209.0 $ 12,449,0 $17.698.0 S 3,592,0 $ 19,895.0 $ 21,929.0 8,173.0 8.621.0 8,943.0 9,4940 9.917.0 3,045.0 2,983.0 3,403.0 1,428,0 $ 1,231.0 $ 6,0940 $ 14.764,0) $ 6,998.0 S 10,584.0 97,948 103,897 75,563 (587.0) 20143 FinStms Ratios CF Stm FCF-Gen FCF-Dsn Perf Measures Type here to search RI Dll Prison 2 5
