I am considering investing in a portfolio of stocks. I have examined historical performance and gathered...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
I am considering investing in a portfolio of stocks. I have examined historical performance and gathered the following information for a set of six stocks I am considering (S1-stock1, S2-Stock 2....) Covariance matrix (joint risk) S1 S2 .005 S2 S3 S4 S5 S3 S4 S5 S6 .03 -.031 -.027 .01 .085 -.07 -.05 .02 -0.11 -0.02 .042 .05 -0.06 -0.02 Annual return S1 S2 S3 S4 Annual return 0.2 0.42 1.0 .5 S5 .46 S6 .3 Volatility 0.18 0.32 0.58 0.35 0.25 0.28 a) I am very risk averse, so I would like to determine how to construct a portfolio with very little risk. What percentage of my portfolio should be invested in each stock if I would like to keep the risk (variance of the portfolio) below .02? Create a spreadsheet model and solve. Write a sentence explaining how I should invest my money and what return I should expect to achieve. The sentence can be included on the Excel sheet that contains the solution. b) Now I would like to consider how much risk I would have to accept if I would like a return that is 10% better than the solution found in part a. Create a spreadsheet model and solve. Write a sentence explaining how I should invest my money and what risk level would be required to achieve that return. The sentence can be included on the Excel sheet that contains the solution. Please note I would like two separate spreadsheets (one for part a and one for part b), but you should be able to copy and paste things from one sheet to the other to avoid have to retype a lot of things. I am considering investing in a portfolio of stocks. I have examined historical performance and gathered the following information for a set of six stocks I am considering (S1-stock1, S2-Stock 2....) Covariance matrix (joint risk) S1 S2 .005 S2 S3 S4 S5 S3 S4 S5 S6 .03 -.031 -.027 .01 .085 -.07 -.05 .02 -0.11 -0.02 .042 .05 -0.06 -0.02 Annual return S1 S2 S3 S4 Annual return 0.2 0.42 1.0 .5 S5 .46 S6 .3 Volatility 0.18 0.32 0.58 0.35 0.25 0.28 a) I am very risk averse, so I would like to determine how to construct a portfolio with very little risk. What percentage of my portfolio should be invested in each stock if I would like to keep the risk (variance of the portfolio) below .02? Create a spreadsheet model and solve. Write a sentence explaining how I should invest my money and what return I should expect to achieve. The sentence can be included on the Excel sheet that contains the solution. b) Now I would like to consider how much risk I would have to accept if I would like a return that is 10% better than the solution found in part a. Create a spreadsheet model and solve. Write a sentence explaining how I should invest my money and what risk level would be required to achieve that return. The sentence can be included on the Excel sheet that contains the solution. Please note I would like two separate spreadsheets (one for part a and one for part b), but you should be able to copy and paste things from one sheet to the other to avoid have to retype a lot of things.
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Which statement about sociology as a science is true? A) Most sociologists reject the use of the scientific method. B) Sociologists almost always use hypothesis testing in their research. C) Sociolo...
-
In the network in figure, Vo = 6V, findIS. 3 kn 1 kn Vo3 2 kn 2 kn Is 7 kn
-
Lima Parts, Inc., shows the following overhead information for the current period: Required What are the variable overhead price and efficiency variances and fixed overhead price variance? Actual...
-
Financial Statements for a New Business Plan LO1-1 Penny Cassidy is considering forming her own pool service and supply company, Pennys Pool Service & Supply Inc. (PPSS). She has decided to...
-
The Johnny Ho Manufacturing Company in Columbus, Ohio, is putting out four new electronic components. Each of Hos four plants has the capacity to add one more product to its current line of...
-
The cash account for Pala Medical Co . at June 3 0 , 2 0 Y 1 , indicated a balance of $ 9 3 , 1 1 5 . The bank statement indicated a balance of $ 1 2 5 , 8 0 0 on June 3 0 , 2 0 Y 1 . Comparing the...
-
Required annuity payments Retirement income today Years to retirement Years of retirement B $35,000 10 Inflation rate 25 6.00% Savings $60,000 Rate of return 9.00% Calculate value of savings in 10...
-
_____ proposes that employees are motivated when they believe they can accomplish a task and that the rewards for doing so are worth the effort.
-
Precision Audio Company warrants its products for one year. The estimated product warranty is 3% of sales. Assume that sales were \($400,000\) for January. In February, a customer received warranty...
-
_____ proposes that employees are motivated when the ratio of their perceived outcomes to inputs is at least roughly equal to that of other referent individuals.
-
Hall Company had sales in 2010 of \(\$ 1,500,000\) on 60,000 units. Variable costs totaled \(\$ 720,000\), and fixed costs totaled \(\$ 400,000\). A new raw material is available that will decrease...
-
_____ is a higher-than-minimum, federally mandated wage, required for nonexempt employees if they work more than a certain number of hours in a week.
-
Consider the following y-values [9, 11, 12] and x-values [4, 3, 7]. Based on those values, calculate B0 [beta zero]: a) 8.7 b) 0 c) 0.42 d) -0.42
-
What tools are available to help shoppers compare prices, features, and values and check other shoppers opinions?
-
Build a stochastic volatility model for the daily log return of Cisco Systems stock from January 1991 to December 1999. You may download the data from CRSP database or the file "d-csco9199.dat." Use...
-
Build a bivariate stochastic volatility model for the monthly log returns of General Motors stock and the S\&P 500 index for the sample period from January 1950 to December 1999. Discuss the...
-
Mull plc acquired shares in two companies as follows: Skye Ltd Ordinary shares - 8 million acquired on 1 June 1996 for \( 4.50\) each. Preference shares - \( 5000008 \%\) redeemable preference shares...
Study smarter with the SolutionInn App