Question: Please show all work on excel please Suppose that the index model for stocks A and B is estimated from excess returns with the following

for stocks A and B is estimated from excess returns with the following results: = 3.2% + 1.10RM + CA RB = -1.4% + Please show all work on excel please

Suppose that the index model for stocks A and B is estimated from excess returns with the following results: = 3.2% + 1.10RM + CA RB = -1.4% + 1.25RM + eB OM = 30%; R-squarea = 0.28; R-squarep = 0.12 Assume you create a portfolio Q, with investment proportions of 0.40 in a risky portfolio P, 0.35 in the market index, and 0.25 in T-bill. Portfolio Pis composed of 70% Stock A and 30% Stock B. a. What is the standard deviation of portfolio Q? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 2 decimal places.) Standard deviation b. What is the beta of portfolio Q? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Portfolio beta c. What is the "firm-specific" risk of portfolio Q? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 4 decimal places.) Firm-specific d. What is the covariance between the portfolio and the market index? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 2 decimal places.) Covariance Suppose that the index model for stocks A and B is estimated from excess returns with the following results: = 3.2% + 1.10RM + CA RB = -1.4% + 1.25RM + eB OM = 30%; R-squarea = 0.28; R-squarep = 0.12 Assume you create a portfolio Q, with investment proportions of 0.40 in a risky portfolio P, 0.35 in the market index, and 0.25 in T-bill. Portfolio Pis composed of 70% Stock A and 30% Stock B. a. What is the standard deviation of portfolio Q? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 2 decimal places.) Standard deviation b. What is the beta of portfolio Q? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Portfolio beta c. What is the "firm-specific" risk of portfolio Q? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 4 decimal places.) Firm-specific d. What is the covariance between the portfolio and the market index? (Calculate using numbers in decimal form, not percentages. Do not round intermediate calculations. Round your answer to 2 decimal places.) Covariance

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

Need answer for part C. Please workout using equation, not excel. Thanks! Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA - 1.5% + 0.55...

Check my work 3 Problem 8-9 Suppose that the index model for stocks A and B is estimated from excess returns with the following results: polnts 1.0% 0.45RM eA RA = -1.0 % 1.0RM eBook RB M=16%;...

Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA = 3.2% + 1.10RM + EA Rg = -1.4% + 1.25RM + es OM - 30%; R-squarea - 0.28; R-squareg -...

1. Suppose that the index model for stocks A and B is estimated from excess returns with the following results: R A = 2.2% + 0.80 R M + e A R B = -2.2% + 1.20 R M + e B M = 24%; R -square A = 0.16; R...

What is the covariance? Please show all work on excel Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA = 2.0% + 0.40 RM + EA RB = 1.8% +...

es Suppose that the index model for stocks A and B is estimated from excess returns with the following results: RA= 2.5% +0.95RM + eA RB = -1.8% + 1.10RM + eB OM= 27%; R-square = 0.23; R-squareg =...

Suppose that the index model for stocks A and B is estimated from excess returns with the following results: R A = 1.8% + 0.75 R M + e A R B = 2.0% + 1.10 R M + e B M = 23%; R -square A = 0.18; R...

need help with work sheet. Consider historical data showing that the average annual rate of return on the S\&P 500 portfolio over the past 85 years has averaged roughly 8% more than the Treasury bill...

Check my work 00 b. What is the beta of portfolio Q? (Do not round intermediate calculations. Round your answer to 2 decimal places.) Portfolio beta 1.15 Ints eBook Print References c. What is the...

Suppose that the index model for stocks A and B is estimated from excess returns with the following results: R A = 3.2% + 1.10 R M + e A R B = 1.4% + 1.25 R M + e B M = 30%; R -square A = 0.28; R...

Klare has operated a successful accounting business out of his home for the past 30 years but, he has decided it is now time to retire. What is the biggest financial change that Klare will LIKELY...

gross profit margin of two companies 2019 and 2020 + Gross Profit Margin= Name of the company EasyJet Airways Virgin Atlantic Airways Revenue - Cost of goods sold Revenue 2019 2020

Which one of the following is included in gress income? A . Tax eredit B . Bremption C . Bxelusion D . Earned income D . Tnx deduction

Calculate the minimum and maximum takt time for the given

2. How did business and political interests influence what early intercultural communication researchers studied and learned?

4. Explain the strengths and weaknesses of each approach.

1. Identify four early foci in the development of intercultural communication.