Compute the mean and standard deviation

Reference no: EM13883856

I/. choose a stock and S& P 500 Index (ETF) and import 1 year of daily stock prices into MS Excel,a. Compute the daily return of the stock and S & P 500,b. Compute the mean and standard deviation of the stock's return and S & P 500,

II/ . Use the Data Analysis ADD-In of Excel to compute the stock's beta coefficient. Regress thestock's return on the return of the S & P 500.

III/ . Using the regression output, determine the stock's systematic and unsystematic risks.Var(R) = β^2Var [S&P 500] + Var [e] = systematic risk and unsystematic risk

IV/ . Provide an explanation.

V/ . Repeat above steps for another stock (not S & P 500, you already have that)

Reference no: EM13883856

Questions Cloud

What is the corporation''s federal tax obligation : What is the corporation's Federal Tax Obligation? Taxable Income: $2,000 Taxable Income: $65,000

Short term investments : The following December 31, 2013, fiscal year end account balance information is available for the Stonebridge Corporation:

Abc golf equipment corporation : You are the CFO (Chief Financial Officer) of ABC Golf Equipment Corporation, a small company that sells golf equipment. Mr. Hillbrandt, the new CEO (Chief Executive Officer) has a marketing background and is trying to learn more about the financial s..

Forecasts for the pet-px margin : Develop forecasts for the PET-PX margin based on contract pricing using data from (a) Jan. 2000-Oct. 2010, (b) Jan. 2006-Oct. 2010, and (c) Oct. 2009-Oct. 2010. In each case, predict the PET-PX margin in Jan. 2020. Which forecast appears to be mos..

Compute the mean and standard deviation : I/. choose a stock and S& P 500 Index (ETF) and import 1 year of daily stock prices into MS Excel,a. Compute the daily return of the stock and S & P 500,b. Compute the mean and standard deviation of the stock's return and S & P 500,

Influence of organizational culture on positive hrm outcomes : Influence of organizational culture on positive HRM outcomes,Organizational culture and its impact on employee motivation,Organizational culture and its impact on employee engagement,Manner in which outcomes can be improved.

What are the major piece of information : q1. What are the major piece of information that a company can get by monitoring it's sources and uses of cash? How can that information be used to maximize shareholder wealth?

What is the crossover rate between project : What is the crossover rate between Project A and Project B given the following cash flows:

Chlorination of ethylene to produce dichloromethane : In the chlorination of ethylene to produce dichloromethane (DCE), the conversion of ethylene is reported as 99.0%. If 94 mol of DCE are produced per 100 moll of ethylene reacted, calculate the selectivity and the overall yield based on ethylene. T..

User Account

All Pages