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...
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...
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 Rent Revenue. B. a debit to Unearned Rent Revenue. C. a credit to Rent Expense. D. none...
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....
Chapter 14: Question #3 (Please provide a spreadsheet of the simulation). The Dynaco Manufacturing Company produces...
Chapter 14: Question #3 (Please provide a spreadsheet of the simulation). The Dynaco Manufacturing Company produces a product in a process consisting of operations of five machines. The probability distribution of the number of machines that will break down in a week follows: (Show your work) Machine Breakdowns per Week Probability 0 0.10 1 0.10 2 0.20 3 0.25 4 0.30 5 0.05 1.00 Simulate the machine breakdowns per week for 20 weeks. Compute the average number of machines that...
Hello please Use the following discrete probability distribution below to answer the following questions:                         &nbs
Hello please Use the following discrete probability distribution below to answer the following questions:                                       X          p(x) 1          0.16 2          0.17 3          0.33 4          0.16 5          0.10 6 UNKNOWN 1. a What is the probability that x = 6?                         P(6) = 0.08        P(6) = 0.18        P(6) = 0.24        P(6) = 0.35 1.b)    What is the mean of the probability distribution?                         µ = 2.92            µ = 3.11            µ = 3.51            µ = 4.00             1.c)         What is the standard...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT