Question: please use excell not sure how to use the formulas The return statistics for two stocks are given below: Stock A Stock B 0.140.07 2

please use excell not sure how to use the formulas

The return statistics for two stocks are given below: Stock A Stock B 0.140.07 2 Expected return 3 Variance 4 Standard deviation 5 Covariance 6 Correlation 0.16 0.0576 0.4 0.24 0.048 -0.5 Part 1 What is the fraction of stock A in the minimum variance portfolio? Attempt 1/5 for 1 pts 3+ decimals Submit Part 2 Attempt 1/5 for 1 pts. What is the standard deviation of a portfolio with 20% invested in stock A and the rest in stock B? 3+ decimals Submit Part 3 Attempt 1/5 for 1 pts. What is the standard deviation of a portfolio with 90% invested in stock A and the rest in stock B? 3+ decimals

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!

The answer is not those two!!!!!!!!! The answer is not those two!!!!!!!!! The answer is not those two!!!!!!!!! The answer is not those two!!!!!!!!! The answer is not those two!!!!!!!!! The answer is...

PLEASE ANSWER BOTH PARTS: PART A: The return statistics for two stocks and T-bills are given below: A B C D 1 Stock A Stock B T-bills 2 Expected return 0.094 0.061 0.02 3 Variance 0.1521 0.0729 4...

Attempt 3/10 for 10 pts. Part 2 What is the Sharpe ratio of the optimal risky portfolio? 3+ decimals Submit The return statistics for two stocks and the risk-free asset, Treasury bills, are given...

PLEASE ANSWER ALL PARTS: PART A: A stock just paid an annual dividend of $2. The dividend is expected to grow by 8% per year for the next 3 years. The growth rate of dividends will then fall steadily...

1. The return statistics for two stocks and T-bills are given below: A B C D 1 Stock A Stock B T-bills 2 Expected return 0.094 0.08 0.02 3 Variance 0.1369 0.0729 4 Standard deviation 0.37 0.27 5...

PLEASE ANSWER BOTH PARTS: PART A: The return statistics for two stocks and the risk-free asset, Treasury bills, are given below: A B C D 1 Stock A Stock B T-bills 2 Expected return 0.096 0.079 0.02 3...

please show me the excell, how to Intro The return statistics for two stocks and the risk-free asset (Treasury bils) are given below Stock A Stock BT-bills 0.063 0.07 0.015 2Expected return 3...

1. You found the following covariance matrix for 3 stocks: A ... D E F 1 Amazon Exxon Walmart 2 Amazon 0.35 0.025 0.01 3 Exxon 0.025 0.21 0.02 4 Walmart 0.01 0.02 0.15 a. Add the border-multiplied...

Problem 9 Intro The return statistics for two stocks and T-bills are given below: A B D 1 Stock A Stock B T-bills 0.094 0.073 0.02 0.1225 0.0729 2 Expected return 3 Variance 4 Standard deviation 5...

The Steiben Company has an ROE of 13.1 percent and a payout ratio of 40 percent. a. What is the companys sustainable growth rate? b. Can the companys actual growth rate be different from its...

The heaviest and lightest strings on a certain violin have linear densities of 3.0 and 0.29 g/m. What is the ratio of the diameter of the heaviest string to that of the lightest string, assuming that...

Given the level of long - term debt, why does it make sense that 2 0 2 2 has the highest level of interest expense as a percentage of sales? The year 2 0 2 0 had both the highest gross profit margin...

X Ltd. produces a single article. Following cost data is given about its product: Selling price per unit = Rs.80 Variable cost per unit =Rs.48 Fixed cost per annum=Rs. 32000. Calculate: (i)P/V ratio...

=+c. If the CobbDouglas parameter takes the conventional value of about 1/3, how much higher should income per worker be in Richland compared to Poorland?

=+a less educated labor force. Assume that education affects only the level of the effi ciency of labor. Also assume that the countries are otherwise the same: they have the same saving rate, the...

=+3 percent. (The numbers in this problem are chosen to be approximately realistic descriptions of rich and poor nations.) Both nations have technological progress at a rate of 2 percent per year and...