Question

QUESTION 1 HAND CALCUALTION OR SPREADSHEET ANALYSIS. For this and the next 3 questions. Please use...

QUESTION 1

  1. HAND CALCUALTION OR SPREADSHEET ANALYSIS. For this and the next 3 questions. Please use the following data to answer the questions that follow. Calculate the covariance of Stock A and the Market. If you wish, copy over the data to Excel and use spreadsheet functions to perform the analysis. Be sure to correct for sample.

    Year

    Market

    Stock A

    Stock B

    1

    0.03

    0.16

    0.05

    2

    -0.05

    0.20

    0.05

    3

    0.01

    0.18

    0.05

    4

    -0.10

    0.25

    0.05

    5

    0.06

    0.14

    0.05

    -0.0154

    -0.00268

    0.00415

    0.00178

    0.00000

    None of the above

1 points   

QUESTION 2

  1. What is the covariance of Stock B and the Market.

    -0.0154

    -0.00268

    0.00415

    0.00178

    0.00000

    None of the above

1 points   

QUESTION 3

  1. What is the variance of Stock A?

    -0.0154

    -0.00268

    0.00415

    0.00178

    0.00000

    None of the above

1 points   

QUESTION 4

  1. Suppose you invest 45 percent of your funds in Stock B and the rest in Stock A. Calculate the standard deviation of a portfolio of the two stocks.

    0.02320

    0.04219

    0.00415

    0.00

    None of the above
Business   Finance   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Data In Excel

1. Covariance between stock A and the Market

We will use the COVARIANCE.S function in Excel as shown below

=COVARIANCE.S(B2:B6,C2:C6) = -0.00268

Answer -> -0.00268

2. Covariance of Stock B and Market:

We will use this function in Excel: =COVARIANCE.S(B2:B6,D2:D6) = 0

3. Variance of Stock A

We will use the VAR.S function in Excel as shown below:

=VAR.S(C2:C6) = 0.00178

4. Standard deviation of the portfolio

The standard deviation of A: =STDEV.S(C2:C6) = 0.04219

Standard Deviation of B = STDEV.S(D2:D6) = 0

Covariance between A and B: =COVARIANCE.S(C2:C6, D2:D6) = 0

Weight of stock A in the portfolio = WA = 0.55, Weight of stock B in the portfolio = WB = 0.45

Variance of the portfolio is calculated using the formula:

σ2P = WA2* σ2A + WB2* σ2B + 2*WA*WB*Cov(A,B)

σA = Standard deviation of A = 0.04219

σB = Standard deviation of B = 0

Cov(A,B) = Covariance between A and B = 0

σ2P = 0.552*0.042192 + 0.452* 0+ 2*0.55*0.45*0

σ2P = 0.552*0.042192 + 0 + 0

σP = 0.55*0.04219 = 0.0232045254207019

standard deviation of a portfolio of the two stocks = 0.02320

Answer

1. -0.00268

2. 0.00000

3. 0.00178

4. 0.02320

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
QUESTION 20 For this and the next 3 questions. Consider the following MUTUALLY EXCLUSIVE projects. Cost...
QUESTION 20 For this and the next 3 questions. Consider the following MUTUALLY EXCLUSIVE projects. Cost of capital is 10%. Calculate IRR. Year Project A Project B 0 -40,000 -20,000 1 8,000 7,000 2 14,000 13,000 3 13,000 12,000 4 12,000 5 11,000 6 10,000 IRR (A) = 17.47%. IRR(B) = 25.20% IRR (A) = 17.77%. IRR(B) = 25.20% IRR (A) = 17.47%. IRR(B) = 20% None of the above is completely correct 1 points    QUESTION 21 Calculate NPV...
QUESTION 3 The next three questions involve stocks A and B which have the following characteristics:...
QUESTION 3 The next three questions involve stocks A and B which have the following characteristics:    A                  B Covariance of stock’s return with the market .03 .01 Standard deviation of the stock's returns .15 .30 Correlation between returns of A and B .25 Standard deviation of the market .18 Expected rate of return of the market 8% Risk free rate of interest 1% a) If you are a fully diversified investor, does buying A or B involve more risk? b)...
Use the following dataset for the next four questions: X:     5     3     6     3     4     4    ...
Use the following dataset for the next four questions: X:     5     3     6     3     4     4     6     8 Y:    13    15    7    12    13    11    9    5 1. (3 points) What is the correlation value “r”? a. -0.98 b. -0.89 c. 0.89 d. None of the above 2. (3 points) Is the “r” signifcant at alpha = 0.05? (circle one)     Yes     No 3. (4 points) Identify the regression equation below (note: Y is the dependent variable): a. Y = 19.12...
QUESTION 18 Use the following information to answer the next Two questions: (Questions 1 of 2)...
QUESTION 18 Use the following information to answer the next Two questions: (Questions 1 of 2) On November 1, 2019, Kathie Company received five months' rent for office space for November 2019 through March 2010 totaling $50,000. The payment was originally recorded by a credit to a real account. Kathie’s required adjusting entry at December 31, 2019 would include: A. a debit to Unearned Rent Revenue. B. a credit to Rent Expense. C. a credit to Unearned Rent Revenue. D....
QUESTION 18 Use the following information to answer the next Two questions: (Questions 1 of 2)...
QUESTION 18 Use the following information to answer the next Two questions: (Questions 1 of 2) On November 1, 2019, Kathie Company received five months' rent for office space for November 2019 through March 2010 totaling $50,000. The payment was originally recorded by a credit to a real account. Kathie’s required adjusting entry at December 31, 2019 would include: A. a debit to Rent Revenue. B. a debit to Unearned Rent Revenue. C. a credit to Rent Expense. D. none...
Answer part a and b of question. (I will give a negative rating if you solved...
Answer part a and b of question. (I will give a negative rating if you solved just one part) a) Find the 85th Percentile of the data set. b) For a population represented by the sample data sets, suppose a vehicle is travelling at 40mph while the driver shifts his focus and fixates on a road object. Estimate a value for the distance traveled during the process that could be exceeded by this driver with a probability of 15%. DATA...
Answer all questions Q2. The data-mining method that can be used in market segmentation to divide...
Answer all questions Q2. The data-mining method that can be used in market segmentation to divide consumers into different homogeneous groups is _____. a. data visualization b. cluster analysis c. market analysis d. supervised learning e. None of the above 2 points    QUESTION 3 Q3. The simplest measure of similarity between observations consisting solely of categorical variables is given by _____. a. the Euclidean distance b. the standardized Euclidean distance c. matching coefficient d. Jaccard's coefficient e. None of...
Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question:...
Please use SPSS for analysis if available Will give positive feedback for answering all questions! Question: The sales data of a company's sales records is provided. a. Plot a time-series plot of the data b. Fit a Linear trend line to these data c. Conduct a hypothesis test of the linear trend model developed in part b. Use significance level of 0.05 d. State the predicted value of sales from 2005 to 2020 e. Calculate MAD and MSE for the...
You have the following data on (1) the average annual returns of the market for the...
You have the following data on (1) the average annual returns of the market for the past 5 years and (2) similar information on Stocks A and B. Which of the possible answers best describes the historical betas for A and B? Years Market Stock A Stock B 1 0.03 0.16 0.05 2 -0.05 -0.20 0.05 3 0.01 0.12 0.05 4 -0.10 -0.25 0.05 a. bA < 0; bB = 0 b. bA = 0; bB = -1 c. bA...
Use the following information regarding a variable (Y) and a variable (X) to answer the next...
Use the following information regarding a variable (Y) and a variable (X) to answer the next 7 questions. n = 8            ∑ x = 56 ∑ y = 296 ∑ x 2 = 428 ∑ y 2 = 11,920 ∑ xy = 2,257 The sample covariance equals 26.43 -9.17 9.17 12.12 3 points    QUESTION 23 Refer to above data. The sample correlation coefficient equals: a. -0.94 b. 1.67 c. .991 d. .85 3 points    QUESTION 24 Given the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT