Hello my group members sami and sanath have both asked you for help. Attached is my instructions.

My company name is JNJ.

I am giving you my work ahead of time so that you cana take ur time in doing it.

FIN3014PRINCIPLES OF BUSINESS FINANCE LAB Beta Calculation Assignment Due Date: August 8 No late assignments will be accepted. This assignment will build toward a larger assignment at the end of the semester. Turning in this assignment gives you the opportunity to receive valuable feedback for completing future assignments. Be sure to save your work. Goals for this assignment: Gather historical return data Use excel to plot a scatter graph Use excel to calculate beta for your stock (the slope of the regression line) Your task: Gather data. In this exercise, you will be using the monthly return data that you calculated for your stock and for the S&P500 in your Stock Prices and Returns assignment. You should have monthly return data for your company and for the S&P500 from January 2012 through December 2015. Manipulate data. There are several methods for calculating a regression in excel. For this assignment, we will use the charting capability to calculate beta for our stock. You will begin by choosing the \"insert\" option above the excel spreadsheet. You will choose \"chart\" and then \"XY (scatter)\" for the type of chart. The chart wizard will guide you through the process. You will want to choose the \"series\" option to tell excel what data you want to use. Be sure to use your S&P500 return column for your \"X value\" and your stock return column for your \"Y value\". This process will give you a scatter graph that plots your stock's return and the S&P500 return. However, it does not give you a regression line or slope. To get a regression line, you will need to click your left mouse key to make several of the data points turn yellow. With your mouse pointing to one of these yellow data points, right click your mouse. Choose \"add trendline\". We will use the default (linear) trend line. However, you will want to choose \"options\" so that you can place \"display equation on chart\". You may find that your regression equation is difficult to read if it is placed over the data points. You can move this equation to the side of the graph (it is in a text box) so that it will be easier to read. Make sure that you have properly labeled your graph and that your graph has a title. Using the beta you calculated, explain how risky your stock is relative to the S&P500. Compare the beta that you calculate with the beta that is provided on the http://finance.yahoo.com website (or some alternative source) for your stock. If they differ, why do you think this might be the case? Net Income Sales Cash Inventory Current Assets Total Assets Current Liabilities Total Equity 12/31/2013 13,831,000 71,312,000 20,927,000 7,878,000 56,407,000 132,683,000 25,675,000 74,053,000 12/28/2014 16,323,000 74,331,000 14,523,000 8,184,000 55,744,000 130,358,000 25,031,000 69,752,000 1/3/2016 15,409,000 70,074,000 13,732,000 8,053,000 60,210,000 133,411,000 27,747,000 71,150,000 Source: http://finance.yahoo.com/quote/JNJ/financials Determined Ratios: NI/Equity NI/Sales Sales/Assets Current Ratio 2.1970 Quick Ratio 1.8901 Cash Ratio 0.8151 Check 0.5375 Assets/Equit y 1.7917 12/31/2013 18.6772% 19.3951% 12/28/2014 23.4015% 21.9599% 0.5702 1.8689 2.2270 1.9000 0.5802 23.4015% 1/3/2016 21.6571% 21.9896% 0.5252 1.8751 2.1700 1.8797 0.4949 21.6571% 18.6772% Analysis: Ratio analysis provides better insight into the performance and position of the company. Liquidity ratio of the company is fluctuating every year, but they are stable. The current ratio is always maintained above 2.10 level but it has slightly decreased during 1/3/2016 when compared to 12/28/2014, and it can be noticed in all the three ratios. Current ratio and quick ratio follow the same trend, unlike cash ratio. There was a dramatic decrease in the cash ratio from 12/31/2013 to 12/28/2014 indicating about decrease in cash reserve and this decrease was continuing in the current year too. Return on equity is an important measure that every investor looks at. There is a continuous increase in the level of debt from 12/31/2013 to 1/3/2016 indicating that company is making use of financial leverage as an important component to boost the ROE and it is evident from the Asset/Equity ratio increase. Asset turnover ratio of the company is fluctuating, and it was high during 12/28/2014 and dropped during 1/3/2016. In other words, assets are not utilized appropriately to boost the sales of the company, and it is not boosting the ROE. The net profit margin indicates the operating results of the company. There is continuous improvement in the net profit margin to some extent. From the observation, it is clear that net profit margin is having great influence over the ROE. But the movement in ROE is in line with the movement in the asset turnover ratio that is ROE increased when the asset turnover ratio increased and fell with the fall in asset turnover ratio. The company is steadily generating profit, and it is the major contributor for ROE that is positive for the investor, but there is a requirement for improving the asset turnover ratio for improving the overall performance. Over the period there is no major or significant changes in the ratios, there are continuing fluctuation, but they are fluctuating with in a range which is unavoidable. Company JNJ Year Revenue Net Income Equity Total Assets Current Assets 71,312,000 13,831,000 74,053,000 132,683,000 56,407,000 12/31/2013 12/28/2014 74,331,000 16,323,000 69,752,000 130,358,000 55,744,000 70,074,000 15,409,000 71,150,000 133,411,000 60,210,000 1/3/2016 Net Income 12/31/2013 12/28/2014 1/3/2016 13,831,000 16,323,000 15,409,000 Sales Cash 71,312,000 74,331,000 70,074,000 20,927,000 14,523,000 13,732,000 Inventory 7,878,000 8,184,000 8,053,000 Current Assets 56,407,000 55,744,000 60,210,000 NI/Equity NI/Sales Sales/Assets Assets/Equity Current Ratio 12/31/2013 18.6772% 19.3951% 0.5375 1.7917 2.1970 12/28/2014 23.4015% 21.9599% 0.5702 1.8689 2.2270 1/3/2016 21.6571% 21.9896% 0.5252 1.8751 2.1700 Current Liabilities Inventory Cash Debt 25,675,000 7,878,000 20,927,000 $ 18,180,000.00 25,031,000 8,184,000 14,523,000 $ 18,760,000.00 27,747,000 8,053,000 13,732,000 $ 19,861,000.00 Current Total Equity Liabilities 132,683,000 25,675,000 74,053,000 130,358,000 25,031,000 69,752,000 133,411,000 27,747,000 71,150,000 Total Assets Quick Ratio Cash Ratio Check 1.8901 0.8151 18.6772% 1.9000 0.5802 23.4015% 1.8797 0.4949 21.6571% Date JNJ Adj Close S&P 500 Adj Close 1/3/2012 57.463421 1312.410034 2/1/2012 57.240974 1365.680054 3/1/2012 58.014973 1408.469971 4/2/2012 57.258564 1397.910034 5/1/2012 55.444729 1310.329956 6/1/2012 60.000732 1362.160034 7/2/2012 61.474998 1379.319946 8/1/2012 60.429447 1406.579956 9/4/2012 61.755798 1440.670044 10/1/2012 63.467499 1412.160034 11/1/2012 63.043278 1416.180054 12/3/2012 63.377792 1426.189941 1/2/2013 66.831474 1498.109985 2/1/2013 69.361885 1514.680054 3/1/2013 74.301338 1569.189941 4/1/2013 77.673286 1597.569946 5/1/2013 77.29306 1630.73999 6/3/2013 78.835617 1606.280029 7/1/2013 85.850578 1685.72998 8/1/2013 79.9384 1632.969971 9/3/2013 80.197433 1681.550049 10/1/2013 85.674057 1756.540039 11/1/2013 88.18187 1805.810059 12/2/2013 85.32196 1848.359985 1/2/2014 82.415482 1782.589966 2/3/2014 86.433205 1859.449951 3/3/2014 92.166023 1872.339966 4/1/2014 95.037117 1883.949951 5/1/2014 95.860077 1923.569946 6/2/2014 98.845673 1960.22998 7/1/2014 94.565689 1930.670044 8/1/2014 98.667694 2003.369995 9/2/2014 101.388115 1972.290039 10/1/2014 102.520042 2018.050049 11/3/2014 103.637711 2067.560059 12/1/2014 100.11451 2058.899902 1/2/2015 95.87326 1994.98999 2/2/2015 98.829277 2104.5 3/2/2015 96.987854 2067.889893 4/1/2015 95.638123 2085.51001 5/1/2015 97.24839 2107.389893 6/1/2015 94.645775 2063.110107 7/1/2015 97.316368 2103.840088 8/3/2015 91.964447 1972.180054 9/1/2015 91.347954 1920.030029 10/1/2015 98.863243 2079.360107 Graph JNJ Sto 120 100 80 JNJ stock price 60 40 20 0 1/1/2012 8/1/2012 3/1/2 Observations: The movement of JNJ stock price and S&P 500 are in the same dire the market. From 2012 to 2015 there was a continuous increase in during which the stock price movement were volatile. There was n highly volatile stock when compared to the market. They have alway slightly higher than the market but they are not too volatile stock wh Overall JNJ is a stable stock whose movem 11/2/2015 12/1/2015 99.799049 101.257988 2080.409912 2043.939941 k price JNJ Stock and S&P 500 index movement 120 2500 100 2000 80 1500 60 S&P 500 JNJ Adj Close S&P 500 Adj Close 1000 40 500 20 0 1/1/2012 8/1/2012 3/1/2013 10/1/2013 5/1/2014 12/1/2014 7/1/2015 0 Date ock price and S&P 500 are in the same direction and there is no significant difference in the movement of stock price when compared to to 2015 there was a continuous increase in the stock price, there was fluctuation in the stock price between july 2013 and febuary 2014 price movement were volatile. There was no significant fluctuation in the stock price except during the last of 2013. JNJ stock is not a n compared to the market. They have always move in the same direction as the market with slight increase or decrease. Their volatality is market but they are not too volatile stock when compared to the market. From the graph it is clear that JNJ will have their beta close to 1. Overall JNJ is a stable stock whose movement is similar to index with slightly higher volatality than the market. Adj Close 500 Adj Close Date Open High Low Close Volume Adj Close 12/1/2015 101.730003 105.489998 100.309998 102.720001 7570500 101.257988 11/2/2015 101.18 103 99.739998 101.239998 6757800 99.799049 10/1/2015 93.43 102.120003 91.760002 101.029999 9173900 98.863243 9/1/2015 92.290001 96.190002 89.900002 93.349998 10143300 91.347954 8/3/2015 100 101 81.790001 93.980003 9701800 91.964447 7/1/2015 98.300003 101.360001 96.639999 100.209999 7184200 97.316368 6/1/2015 100.279999 100.839996 97.010002 97.459999 8135900 94.645775 5/1/2015 99.620003 104.480003 98.660004 100.139999 7686800 97.24839 4/1/2015 100.459999 102.139999 98.040001 99.199997 8654700 95.638123 3/2/2015 102.510002 103.410004 98.220001 100.599998 8431400 96.987854 2/2/2015 100.489998 103.330002 97.150002 102.510002 10514200 98.829277 1/2/2015 105.050003 106.5 100.089996 100.139999 10284800 95.87326 12/1/2014 107.889999 108.989998 102.5 104.57 8256400 100.11451 11/3/2014 107.830002 109.489998 106.599998 108.25 6922700 103.637711 10/1/2014 105.980003 108.18 95.099998 107.779999 10578400 102.520042 9/2/2014 103.300003 108.769997 103.019997 106.589996 6542500 101.388115 8/1/2014 99.760002 104.419998 98.800003 103.730003 5973800 98.667694 7/1/2014 105.150002 106.739998 100.050003 100.089996 7178900 94.565689 6/2/2014 101.540001 106 101.010002 104.620003 6235100 98.845673 5/1/2014 100.769997 101.540001 98.879997 101.459999 6220400 95.860077 4/1/2014 98.309998 101.980003 96.050003 101.290001 8988300 95.037117 3/3/2014 91.129997 98.599998 90.830002 98.230003 8993800 92.166023 2/3/2014 88.75 92.989998 86.089996 92.120003 9046200 86.433205 1/2/2014 91.139999 95.379997 88.150002 88.470001 9761800 82.415482 12/2/2013 94.410004 94.790001 89.769997 91.589996 7496800 85.32196 11/1/2013 92.379997 95.989998 92.279999 94.660004 6756600 88.18187 10/1/2013 86.589996 93.449997 85.5 92.610001 7860700 85.674057 9/3/2013 86.889999 90.720001 86 86.690002 8341900 80.197433 8/1/2013 94.160004 94.400002 85.849998 86.410004 9624100 79.9384 7/1/2013 85.720001 94.419998 85.5 93.5 9621800 85.850578 6/3/2013 84.279999 87.82 82.120003 85.860001 11122400 78.835617 5/1/2013 84.5 89.989998 83.879997 84.18 10637500 77.29306 4/1/2013 81.389999 85.889999 80.309998 85.230003 10491900 77.673286 3/1/2013 75.790001 81.589996 75.730003 81.529999 10236400 74.301338 2/1/2013 74.139999 77.019997 73.559998 76.110001 9988600 69.361885 1/2/2013 71.019997 74.800003 70.300003 73.919998 10488600 66.831474 12/3/2012 69.800003 71.620003 69.18 70.099998 12268600 63.377792 11/1/2012 71.099998 71.900002 68.510002 69.730003 10721100 63.043278 10/1/2012 68.919998 72.739998 67.800003 70.82 13195100 63.467499 9/4/2012 67.489998 69.639999 66.970001 68.910004 11079800 61.755798 8/1/2012 69.480003 69.75 66.849998 67.43 10184900 60.429447 7/2/2012 67.419998 69.699997 67 69.220001 13507600 61.474998 6/1/2012 62.040001 67.699997 61.709999 67.559998 22353700 60.000732 5/1/2012 64.910004 65.489998 62 62.43 13241200 55.444729 4/2/2012 66.040001 66.300003 62.759998 65.099998 12051400 57.258564 3/1/2012 65.110001 66.18 64.120003 65.959999 9975900 58.014973 2/1/2012 65.970001 66.32 64.019997 65.080002 10192900 57.240974 1/3/2012 65.589996 66 64.339996 65.910004 11284900 57.463421 Source http://finance.yahoo.com/quote/JNJ/history?period1=1325356200&period2=1451500200&interval=1mo&filter= 0&interval=1mo&filter=history&frequency=1mo Date Open High Low Close Volume Adj Close 12/1/2015 2082.929932 2104.27002 1993.26001 2043.939941 3922935900 2043.939941 11/2/2015 2080.76001 2116.47998 2019.390015 2080.409912 4007931000 2080.409912 10/1/2015 1919.650024 2094.320068 1893.699951 2079.360107 4095504500 2079.360107 9/1/2015 1970.089966 2020.859985 1871.910034 1920.030029 4024497100 1920.030029 8/3/2015 2104.48999 2112.659912 1867.01001 1972.180054 4216280400 1972.180054 7/1/2015 2067 2132.820068 2044.02002 2103.840088 3709178600 2103.840088 6/1/2015 2108.639893 2129.870117 2056.320068 2063.110107 3513296300 2063.110107 5/1/2015 2087.379883 2134.719971 2067.929932 2107.389893 3455756000 2107.389893 4/1/2015 2067.629883 2125.919922 2048.379883 2085.51001 3521458000 2085.51001 3/2/2015 2105.22998 2117.52002 2039.689941 2067.889893 3638745400 2067.889893 2/2/2015 1996.670044 2119.590088 1980.900024 2104.5 3806470500 2104.5 1/2/2015 2058.899902 2072.360107 1988.119995 1994.98999 4091934500 1994.98999 12/1/2014 2065.780029 2093.550049 1972.560059 2058.899902 3788631300 2058.899902 11/3/2014 2018.209961 2075.76001 2001.01001 2067.560059 3479201500 2067.560059 10/1/2014 1971.439941 2018.189941 1820.660034 2018.050049 4260310800 2018.050049 9/2/2014 2004.069946 2019.26001 1964.040039 1972.290039 3364623800 1972.290039 8/1/2014 1929.800049 2005.040039 1904.780029 2003.369995 2875718500 2003.369995 7/1/2014 1962.290039 1991.390015 1930.670044 1930.670044 3214440400 1930.670044 6/2/2014 1923.869995 1968.170044 1915.97998 1960.22998 3158130000 1960.22998 5/1/2014 1884.390015 1924.030029 1859.790039 1923.569946 3185100900 1923.569946 4/1/2014 1873.959961 1897.280029 1814.359985 1883.949951 3589287600 1883.949951 3/3/2014 1857.680054 1883.969971 1834.439941 1872.339966 3579015700 1872.339966 2/3/2014 1782.680054 1867.920044 1737.920044 1859.449951 3875949400 1859.449951 1/2/2014 1845.859985 1850.839966 1770.449951 1782.589966 3806266600 1782.589966 12/2/2013 1806.550049 1849.439941 1767.98999 1848.359985 3203412300 1848.359985 11/1/2013 1758.699951 1813.550049 1746.199951 1805.810059 3261324500 1805.810059 10/1/2013 1682.410034 1775.219971 1646.469971 1756.540039 3498866500 1756.540039 9/3/2013 1635.949951 1729.859985 1633.410034 1681.550049 3474152000 1681.550049 8/1/2013 1689.420044 1709.670044 1627.469971 1632.969971 3069868600 1632.969971 7/1/2013 1609.780029 1698.780029 1604.569946 1685.72998 3270645900 1685.72998 6/3/2013 1631.709961 1654.189941 1560.329956 1606.280029 3996199000 1606.280029 5/1/2013 1597.550049 1687.180054 1581.280029 1630.73999 3661220400 1630.73999 4/1/2013 1569.180054 1597.569946 1536.030029 1597.569946 3674685000 1597.569946 3/1/2013 1514.680054 1570.280029 1501.47998 1569.189941 3591577500 1569.189941 2/1/2013 1498.109985 1530.939941 1485.01001 1514.680054 3851884200 1514.680054 1/2/2013 1426.189941 1509.939941 1426.189941 1498.109985 3802304200 1498.109985 12/3/2012 1416.339966 1448 1398.109985 1426.189941 3479625500 1426.189941 11/1/2012 1412.199951 1434.27002 1343.349976 1416.180054 3593110000 1416.180054 10/1/2012 1440.900024 1470.959961 1403.280029 1412.160034 3587115700 1412.160034 9/4/2012 1406.540039 1474.51001 1396.560059 1440.670044 3857553100 1440.670044 8/1/2012 1379.319946 1426.680054 1354.650024 1406.579956 3183567800 1406.579956 7/2/2012 1362.329956 1391.73999 1325.410034 1379.319946 3663113300 1379.319946 6/1/2012 1309.869995 1363.459961 1266.73999 1362.160034 4103472300 1362.160034 5/1/2012 1397.859985 1415.319946 1291.97998 1310.329956 4158095900 1310.329956 4/2/2012 1408.469971 1422.380005 1357.380005 1397.910034 3916786000 1397.910034 3/1/2012 1365.900024 1419.150024 1340.030029 1408.469971 3980752200 1408.469971 2/1/2012 1312.449951 1378.040039 1312.449951 1365.680054 4143404000 1365.680054 1/3/2012 1258.859985 1333.469971 1258.859985 1312.410034 4190155500 1312.410034 Source http://finance.yahoo.com/quote/%5EGSPC/history?period1=1325356200&period2=1451500200&int riod2=1451500200&interval=1mo&filter=history&frequency=1mo Date JNJ Adj Close JNJ Return S&P 500 Adj Close S&P 500 Return 1/3/2012 57.463421 1312.410034 2/1/2012 57.240974 -0.39% 1365.680054 4.06% 3/1/2012 58.014973 1.35% 1408.469971 3.13% 4/2/2012 57.258564 -1.30% 1397.910034 -0.75% 5/1/2012 55.444729 -3.17% 1310.329956 -6.27% 6/1/2012 60.000732 8.22% 1362.160034 3.96% 7/2/2012 61.474998 2.46% 1379.319946 1.26% 8/1/2012 60.429447 -1.70% 1406.579956 1.98% 9/4/2012 61.755798 2.19% 1440.670044 2.42% 10/1/2012 63.467499 2.77% 1412.160034 -1.98% 11/1/2012 63.043278 -0.67% 1416.180054 0.28% 12/3/2012 63.377792 0.53% 1426.189941 0.71% 1/2/2013 66.831474 5.45% 1498.109985 5.04% 2/1/2013 69.361885 3.79% 1514.680054 1.11% 3/1/2013 74.301338 7.12% 1569.189941 3.60% 4/1/2013 77.673286 4.54% 1597.569946 1.81% 5/1/2013 77.29306 -0.49% 1630.73999 2.08% 6/3/2013 78.835617 2.00% 1606.280029 -1.50% 7/1/2013 85.850578 8.90% 1685.72998 4.95% 8/1/2013 79.9384 -6.89% 1632.969971 -3.13% 9/3/2013 80.197433 0.32% 1681.550049 2.97% 10/1/2013 85.674057 6.83% 1756.540039 4.46% 11/1/2013 88.18187 2.93% 1805.810059 2.80% 12/2/2013 85.32196 -3.24% 1848.359985 2.36% 1/2/2014 82.415482 -3.41% 1782.589966 -3.56% 2/3/2014 86.433205 4.87% 1859.449951 4.31% 3/3/2014 92.166023 6.63% 1872.339966 0.69% 4/1/2014 95.037117 3.12% 1883.949951 0.62% 5/1/2014 95.860077 0.87% 1923.569946 2.10% 6/2/2014 98.845673 3.11% 1960.22998 1.91% 7/1/2014 94.565689 -4.33% 1930.670044 -1.51% 8/1/2014 98.667694 4.34% 2003.369995 3.77% 9/2/2014 101.388115 2.76% 1972.290039 -1.55% 10/1/2014 102.520042 1.12% 2018.050049 2.32% 11/3/2014 103.637711 1.09% 2067.560059 2.45% 12/1/2014 100.11451 -3.40% 2058.899902 -0.42% 1/2/2015 95.87326 -4.24% 1994.98999 -3.10% 2/2/2015 98.829277 3.08% 2104.5 5.49% 3/2/2015 96.987854 -1.86% 2067.889893 -1.74% 4/1/2015 95.638123 -1.39% 2085.51001 0.85% 5/1/2015 97.24839 1.68% 2107.389893 1.05% 6/1/2015 94.645775 -2.68% 2063.110107 -2.10% 7/1/2015 97.316368 2.82% 2103.840088 1.97% 8/3/2015 91.964447 -5.50% 1972.180054 -6.26% 9/1/2015 91.347954 -0.67% 1920.030029 -2.64% 10/1/2015 98.863243 8.23% 2079.360107 8.30% 11/2/2015 99.799049 0.95% 2080.409912 0.05% 12/1/2015 101.257988 1.46% 2043.939941 -1.75% Monthly return in Observations: The above graph clearly indi the both JNJ stock returns an and the market return are m The return observation indica when they are moving in a po variation in the JNJ stock re like during mid of 2012, duri was either significant Graph JNJ stock return and S&P500 market return on monthly basis 10.00% 8.00% 6.00% 4.00% 2.00% JNJ S& Monthly return in % 0.00% 1/1/2012 7/1/2012 1/1/2013 7/1/2013 1/1/2014 7/1/2014 1/1/2015 7/1/2015 -2.00% -4.00% -6.00% -8.00% Date Observations: The above graph clearly indicates that return of JNJ and the market that is S&P 500 moves in the same direction. During initial 2012 the both JNJ stock returns and market returns were negative, and the market was providing worst return than the stock. Stock return and the market return are moving in the same direction, and JNJ stock return is more volatile when compared to the market return. The return observation indicates that the beta of the stock will be positive. JNJ stock return was always higher than the market return when they are moving in a positive direction, and they provide lower return when the market is generating a negative return. There is variation in the JNJ stock return when compared to the stock market return, but there is significant variation during a certain period like during mid of 2012, during entire 2013 and during April 2014. These variations were in the same direction, but the rate of return was either significantly higher than the market or lower than the market depending upon the return market movement. nthly basis JNJ Return S&P 500 Return 1/2015 n. During initial 2012 he stock. Stock return to the market return. than the market return gative return. There is uring a certain period , but the rate of return ket movement. Date Open High Low Close Volume Adj Close 12/1/2015 101.730003 105.489998 100.309998 102.720001 7570500 101.257988 11/2/2015 101.18 103 99.739998 101.239998 6757800 99.799049 10/1/2015 93.43 102.120003 91.760002 101.029999 9173900 98.863243 9/1/2015 92.290001 96.190002 89.900002 93.349998 10143300 91.347954 8/3/2015 100 101 81.790001 93.980003 9701800 91.964447 7/1/2015 98.300003 101.360001 96.639999 100.209999 7184200 97.316368 6/1/2015 100.279999 100.839996 97.010002 97.459999 8135900 94.645775 5/1/2015 99.620003 104.480003 98.660004 100.139999 7686800 97.24839 4/1/2015 100.459999 102.139999 98.040001 99.199997 8654700 95.638123 3/2/2015 102.510002 103.410004 98.220001 100.599998 8431400 96.987854 2/2/2015 100.489998 103.330002 97.150002 102.510002 10514200 98.829277 1/2/2015 105.050003 106.5 100.089996 100.139999 10284800 95.87326 12/1/2014 107.889999 108.989998 102.5 104.57 8256400 100.11451 11/3/2014 107.830002 109.489998 106.599998 108.25 6922700 103.637711 10/1/2014 105.980003 108.18 95.099998 107.779999 10578400 102.520042 9/2/2014 103.300003 108.769997 103.019997 106.589996 6542500 101.388115 8/1/2014 99.760002 104.419998 98.800003 103.730003 5973800 98.667694 7/1/2014 105.150002 106.739998 100.050003 100.089996 7178900 94.565689 6/2/2014 101.540001 106 101.010002 104.620003 6235100 98.845673 5/1/2014 100.769997 101.540001 98.879997 101.459999 6220400 95.860077 4/1/2014 98.309998 101.980003 96.050003 101.290001 8988300 95.037117 3/3/2014 91.129997 98.599998 90.830002 98.230003 8993800 92.166023 2/3/2014 88.75 92.989998 86.089996 92.120003 9046200 86.433205 1/2/2014 91.139999 95.379997 88.150002 88.470001 9761800 82.415482 12/2/2013 94.410004 94.790001 89.769997 91.589996 7496800 85.32196 11/1/2013 92.379997 95.989998 92.279999 94.660004 6756600 88.18187 10/1/2013 86.589996 93.449997 85.5 92.610001 7860700 85.674057 9/3/2013 86.889999 90.720001 86 86.690002 8341900 80.197433 8/1/2013 94.160004 94.400002 85.849998 86.410004 9624100 79.9384 7/1/2013 85.720001 94.419998 85.5 93.5 9621800 85.850578 6/3/2013 84.279999 87.82 82.120003 85.860001 11122400 78.835617 5/1/2013 84.5 89.989998 83.879997 84.18 10637500 77.29306 4/1/2013 81.389999 85.889999 80.309998 85.230003 10491900 77.673286 3/1/2013 75.790001 81.589996 75.730003 81.529999 10236400 74.301338 2/1/2013 74.139999 77.019997 73.559998 76.110001 9988600 69.361885 1/2/2013 71.019997 74.800003 70.300003 73.919998 10488600 66.831474 12/3/2012 69.800003 71.620003 69.18 70.099998 12268600 63.377792 11/1/2012 71.099998 71.900002 68.510002 69.730003 10721100 63.043278 10/1/2012 68.919998 72.739998 67.800003 70.82 13195100 63.467499 9/4/2012 67.489998 69.639999 66.970001 68.910004 11079800 61.755798 8/1/2012 69.480003 69.75 66.849998 67.43 10184900 60.429447 7/2/2012 67.419998 69.699997 67 69.220001 13507600 61.474998 6/1/2012 62.040001 67.699997 61.709999 67.559998 22353700 60.000732 5/1/2012 64.910004 65.489998 62 62.43 13241200 55.444729 4/2/2012 66.040001 66.300003 62.759998 65.099998 12051400 57.258564 3/1/2012 65.110001 66.18 64.120003 65.959999 9975900 58.014973 2/1/2012 65.970001 66.32 64.019997 65.080002 10192900 57.240974 1/3/2012 65.589996 66 64.339996 65.910004 11284900 57.463421 Source http://finance.yahoo.com/quote/JNJ/history?period1=1325356200&period2=1451500200&interval=1mo&filter= 0&interval=1mo&filter=history&frequency=1mo Date Open High Low Close Volume Adj Close 12/1/2015 2082.929932 2104.27002 1993.26001 2043.939941 3922935900 2043.939941 11/2/2015 2080.76001 2116.47998 2019.390015 2080.409912 4007931000 2080.409912 10/1/2015 1919.650024 2094.320068 1893.699951 2079.360107 4095504500 2079.360107 9/1/2015 1970.089966 2020.859985 1871.910034 1920.030029 4024497100 1920.030029 8/3/2015 2104.48999 2112.659912 1867.01001 1972.180054 4216280400 1972.180054 7/1/2015 2067 2132.820068 2044.02002 2103.840088 3709178600 2103.840088 6/1/2015 2108.639893 2129.870117 2056.320068 2063.110107 3513296300 2063.110107 5/1/2015 2087.379883 2134.719971 2067.929932 2107.389893 3455756000 2107.389893 4/1/2015 2067.629883 2125.919922 2048.379883 2085.51001 3521458000 2085.51001 3/2/2015 2105.22998 2117.52002 2039.689941 2067.889893 3638745400 2067.889893 2/2/2015 1996.670044 2119.590088 1980.900024 2104.5 3806470500 2104.5 1/2/2015 2058.899902 2072.360107 1988.119995 1994.98999 4091934500 1994.98999 12/1/2014 2065.780029 2093.550049 1972.560059 2058.899902 3788631300 2058.899902 11/3/2014 2018.209961 2075.76001 2001.01001 2067.560059 3479201500 2067.560059 10/1/2014 1971.439941 2018.189941 1820.660034 2018.050049 4260310800 2018.050049 9/2/2014 2004.069946 2019.26001 1964.040039 1972.290039 3364623800 1972.290039 8/1/2014 1929.800049 2005.040039 1904.780029 2003.369995 2875718500 2003.369995 7/1/2014 1962.290039 1991.390015 1930.670044 1930.670044 3214440400 1930.670044 6/2/2014 1923.869995 1968.170044 1915.97998 1960.22998 3158130000 1960.22998 5/1/2014 1884.390015 1924.030029 1859.790039 1923.569946 3185100900 1923.569946 4/1/2014 1873.959961 1897.280029 1814.359985 1883.949951 3589287600 1883.949951 3/3/2014 1857.680054 1883.969971 1834.439941 1872.339966 3579015700 1872.339966 2/3/2014 1782.680054 1867.920044 1737.920044 1859.449951 3875949400 1859.449951 1/2/2014 1845.859985 1850.839966 1770.449951 1782.589966 3806266600 1782.589966 12/2/2013 1806.550049 1849.439941 1767.98999 1848.359985 3203412300 1848.359985 11/1/2013 1758.699951 1813.550049 1746.199951 1805.810059 3261324500 1805.810059 10/1/2013 1682.410034 1775.219971 1646.469971 1756.540039 3498866500 1756.540039 9/3/2013 1635.949951 1729.859985 1633.410034 1681.550049 3474152000 1681.550049 8/1/2013 1689.420044 1709.670044 1627.469971 1632.969971 3069868600 1632.969971 7/1/2013 1609.780029 1698.780029 1604.569946 1685.72998 3270645900 1685.72998 6/3/2013 1631.709961 1654.189941 1560.329956 1606.280029 3996199000 1606.280029 5/1/2013 1597.550049 1687.180054 1581.280029 1630.73999 3661220400 1630.73999 4/1/2013 1569.180054 1597.569946 1536.030029 1597.569946 3674685000 1597.569946 3/1/2013 1514.680054 1570.280029 1501.47998 1569.189941 3591577500 1569.189941 2/1/2013 1498.109985 1530.939941 1485.01001 1514.680054 3851884200 1514.680054 1/2/2013 1426.189941 1509.939941 1426.189941 1498.109985 3802304200 1498.109985 12/3/2012 1416.339966 1448 1398.109985 1426.189941 3479625500 1426.189941 11/1/2012 1412.199951 1434.27002 1343.349976 1416.180054 3593110000 1416.180054 10/1/2012 1440.900024 1470.959961 1403.280029 1412.160034 3587115700 1412.160034 9/4/2012 1406.540039 1474.51001 1396.560059 1440.670044 3857553100 1440.670044 8/1/2012 1379.319946 1426.680054 1354.650024 1406.579956 3183567800 1406.579956 7/2/2012 1362.329956 1391.73999 1325.410034 1379.319946 3663113300 1379.319946 6/1/2012 1309.869995 1363.459961 1266.73999 1362.160034 4103472300 1362.160034 5/1/2012 1397.859985 1415.319946 1291.97998 1310.329956 4158095900 1310.329956 4/2/2012 1408.469971 1422.380005 1357.380005 1397.910034 3916786000 1397.910034 3/1/2012 1365.900024 1419.150024 1340.030029 1408.469971 3980752200 1408.469971 2/1/2012 1312.449951 1378.040039 1312.449951 1365.680054 4143404000 1365.680054 1/3/2012 1258.859985 1333.469971 1258.859985 1312.410034 4190155500 1312.410034 Source http://finance.yahoo.com/quote/%5EGSPC/history?period1=1325356200&period2=1451500200&int riod2=1451500200&interval=1mo&filter=history&frequency=1mo