A. Using the two stocks you selected from Homework #1, identify the Beta for each stock. In your own words, what conclusion can you draw from the stocks? current and historical beta? If the stock market went up 10% today, what would be the impact on each of your stocks?

B. Using the 2015 financial statements from your stocks above and the equations from your textbook, prepare the Historical Average and Standard Deviation for each stock.

Can you assist me with if the sock market went up 10% today what would be the impact? The two I choose were JPM and Wells Fargo.

Also B?

Attached is what the teacher provided.

Date 1/1/2015 1/8/2015 1/15/2015 1/22/2015 1/29/2015 2/5/2015 2/12/2015 2/19/2015 2/26/2015 3/5/2015 3/12/2015 3/19/2015 3/26/2015 4/2/2015 4/9/2015 4/16/2015 4/23/2015 4/30/2015 5/7/2015 5/14/2015 5/21/2015 5/28/2015 6/4/2015 6/11/2015 6/18/2015 6/25/2015 7/2/2015 7/9/2015 7/16/2015 7/23/2015 7/30/2015 8/6/2015 8/13/2015 8/20/2015 8/27/2015 9/3/2015 9/10/2015 9/17/2015 9/24/2015 10/1/2015 10/8/2015 10/15/2015 10/22/2015 STOCK 1 STOCK 1 Close. PR S&P 500 Return PR Return S&P BETA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! STOCK 2 Close. PR 10/29/2015 11/5/2015 11/12/2015 11/19/2015 11/26/2015 12/3/2015 12/10/2015 12/17/2015 12/24/2015 12/31/2015 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! STOCK 2 S&P 500 Return PR Return S&P BETA #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! STOCK 1 STOCK 2 Standard Dev Average #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! STOCK 1 Copy & Paste your BETA value here = F3 on sheet 1 Explain the changes in the BETA and what it means to the company Wells Fargo BETA 2017 is 1.03. BETA is the risk of a stock. When BETA is positive it moves in the same direction. If it is greater than 1 which it is by .03 which means it is expected to keep rising. Explain what the STANDARD DEVIATION MEANS to the company. The standard deviation for Wells Fargo is 16.2 this gives an average of prices and returns. The are considered closely around the means according to these numbers. Explain what the AVERAGE MEANS to the company. The average is the value of stock in the beginning and the end divided by two. REFERENCES:www.macroaxis.com, www.yahoo.com/finances, www.dictionay.com STOCK 2 Copy & Paste your BETA value here = L3 on sheet 1 Explain the changes in the BETA and what it means to the company .08 is the BETA. Explain what the STANDARD DEVIATION MEANS to the company Explain what the AVERAGE MEANS to the company REFERENCES