Data analytics (Data should be presented in Excel) Summarizing Data by Using Histograms and Pareto Charts

profilebullriser
JNJdataanalysis.xlsx

2016,2017, 2018 Balance sheet

Johnson & Johnson (JNJ)
Exchange rate used is that of the Year End reported date
As Reported Annual Balance Sheet year 2018 2017 2016
Report Date 12/30/18 12/31/17 1/1/17 average of total curents 8773400.0 8201400.0 12506200.0
Currency USD USD USD avergae of long-term assets 19093500.0 20220000.0 13720666.7
Audit Status Not Qualified Not Qualified Not Qualified average of current liabalities 3663666.7 3554333.3 3197666.7
Consolidated Yes Yes Yes Average of longterem liabilities 30986000.0 33303000.0 22251500.0
Scale Thousands Thousands Thousands
Cash & cash equivalents 18,107,000 17,824,000 18,972,000 Current ratio 3.9911745974 3.8457282191 6.5183988325
Short-term Investments 1,580,000 472,000 22,935,000 Debt ratio 0.5882924736 0.5984401856 0.4886955921
Net Receivables 14,098,000 13,490,000 11,699,000 Debt-t0-equity 1.5598138974 1.614744016 1.0052827402
Inventory 8,599,000 8,765,000 8,144,000
Other Current Assets 1,483,000 456,000 781,000
Total Current Assets 43,867,000
Frankline: Sum If
41,007,000
Frankline: Sum If
62,531,000
Frankline: Sum if function
Long Term Investments 517,000 758,000 900,000
Property Plant and Equipment 17,035,000 17,005,000 15,912,000
Goodwill 30,453,000 31,906,000 22,805,000
Intangible Assets 47,611,000 53,228,000 26,876,000
Other Assets 11,305,000 11,318,000 9,683,000
Deferred Long Term Asset Charges 7,640,000 7,105,000 6,148,000
total long-term assets 114,561,000
Frankline: Sumif function
121,320,000
Frankline: sum if
82,324,000
Frankline: Sum if function
Total Assets 158,428,000 162,327,000 144,855,000
Current Liabilities
Accounts Payable 7,537,000 7,310,000 6,918,000
Short/Current Long Term Debt 2,636,000 1,499,000 1,704,000
Other Current Liabilities 818,000 1,854,000 971,000
Total Current Liabilities 10,991,000
Frankline: Sumif
10,663,000
Frankline: Sum If
9,593,000
Frankline: susmif
Long Term Debt 27,687,000 30,684,000 22,824,000
Other Liabilities 34,285,000 35,922,000 21,679,000
long term liabilities 61972000
Frankline: Sumif
66606000
Frankline: sum if
44503000
Frankline: sumif
Minority Interest _ _ _
Negative Goodwill _ _ _
Total Liiabilities 93,202,000 97,143,000 70,790,000
Stockholder's Equity
Misc. Stocks Options Warrants _ _ _
Redeemable Preferred Stock _ _ _
Preferred Stock _ _ _
Common Stock 3,120,000 3,120,000 3,120,000
Retained Earnings 106,216,000 101,793,000 110,551,000
Treasury Stock -49,584,000 -44,753,000 -43,253,000
Capital Surplus _ _ _
Other Stockholder Equity -15,222,000 -13,199,000 -14,901,000
Total Stockholder Equity 59,752,000 60,160,000 70,418,000
Total Liabilities and shareholder's equity 152,954,000 157,303,000 141,208,000
Net Tangible assets -18,312,000 -24,974,000 20,737,000
From all Balance sheets: Total assets=Total Liabilities+Shareholder's Equity
References
Yahoo Finance. (2018). Johnson & Johnson (JNJ) Retrieved June 22, 2019 from: https://finance.yahoo.com/quote/JNJ/balance-sheet?p=JNJ
C

overview

Overview
This data is derived from Jonhson &Johnson which is American multinational medical devices, pharmaceutical and consumer packaged goods manufacturing company founded in 1886.It is one of the largest multinational companies in the US and has its shares trade publicly in the New York Security Exchange with the name JNJ. The data from the comprehensive income statement for three years, 2016, 2017 and 2018 will be analysed.
Summary
One of the factors that investors consider before deciding to invest on the company on the particular company is the performance of the company. There are number of the rations that may be used to determine the perfomance of the company but liduitity ratios is one of the rations that is common used. It is used to determine if the firm the firm is capable of paying its currents obligations comfortably. In the event bthe firm is struggling paying its obligations, investors consider such venture risky because they may invest on them and finally firm defuakts its liabilities. Using balance sheet of the JNJ for three years, we will compare its health status and determine stability of the firm based in the current ratio. Other rations that ill be used are debt ratio and debt-to-equity ratio. In the balance sheet, there are various items like current assets, total assets and current liabilities and total liabiliies Before getting these figures which will help to calculate the identified financial ratios , there are summation which is done using the the follwoing excel functions SUMIF and SUMIFS. Additionally, we would like to find average perforamance of various itnmes such as currents assets, total assets, liabilities and capital contribution.