Hello my friend Sami Halik said you helped him with his assignment can you help me too.

My company's name is JNJ.

The instructions are attached if anything is unclear please let me know. and you have around 12 to 13 hours to do it.

Goals for this assignment: Calculate monthly returns for your stock and for the S&P500 Plot a graph Your task: Calculate monthly returns. During the first lab you chose a company that you would be analyzing during the semester. For the first lab assignment you collected monthly stock price data for the company and monthly data for the S&P500. This time we will calculate monthly returns. Monthly returns report gains or losses in percentage terms. For example, we will look at our sample company Valero Energy, VLO. Assume that I bought VLO stock at the beginning of January for $23.09 per share. If I wanted to sell the same share one month later, at the beginning of February, I would have been able to sell it for $22.76. Thus, I would have lost $0.33. Looking at percentage returns gives us an ability to compare how poorly (or well) this VLO investment did relative to other investments. For example, let's take a hypothetical company, Roadrunner Enterprises. Assume that Roadrunner's stock was selling for $200 a share at the beginning of January. By the beginning of February, the stock was selling for only $199. If you had bought one share of Roadrunner stock over this time period, you would have lost $1.00. In absolute (dollar) terms, you would have lost more on the Roadrunner investment. However, looking at percentage returns, we get a different (and more accurate) picture. VLO Returns: (P2-P1)/P1 = (22.76-23.09)/23.09 = - 0.01429 or -1.429% Roadrunner Returns: (P2-P1)/P1 = (199-200)/200 = -0.005 or -0.5% This allows us to compare different investments relative to the amount of money we have invested in the stock. For example, if we had had $10,000 at the beginning of January and invested it all in VLO, we would have lost ($10,000)*0.01429 or $142.90. If, instead, we had invested the money in Roadrunner, we would have lost only ($10,000)*.005 or $50. Using excel, calculate monthly returns for both your stock and the S&P500 for each month from January 1, 2012 and ending December 31, 2015. Calculating these returns will require the \"Adjusted Close\" for each month-end from January 1, 2012 and ending December 31, 2015 Plot a graph. You will want dates on the X axis, the returns of your stock and the S&P500 on the Y axis. Make sure that your graph is properly labeled, has a title, and is easy for the reader to understand. Make observations. Look at your graph and see what observations you can make. This observation will vary greatly depending upon the company you are analyzing. Some things you may want to consider are: Has the return on your stock varied significantly from the S&P500? Has the return on your stock been much higher or lower than the S&P500? Has the return on your stock been more variable than the return on the S&P500? Looking Forward This will be part of your company analysis that you will complete later this semester. Be sure to keep your electronic files so that you do not have to recreate the work that you have done