Data analytics (Data should be presented in Excel) NEED THE SOLUTION IN 8 Hours !!
bullriser
JNJdataanalysis.xlsx2016,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 |
Frankline: Sum If | 10,663,000 Frankline: Sum If |
Frankline: Sum If | 9,593,000 Frankline: susmif |
||
|
Frankline: Sum if function | 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 |
||||
|
Frankline: Sumif function |
Frankline: sum if |
Frankline: Sum if function | 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. | |
