Variance and standard deviation of stocks

Assignment Help Business Management

Reference no: EM132538221

This is complete write up of your portfolio formation in a Word file, with calculations copied and pasted in it from your Excel file.

1. Select the stocks of three publicly traded companies from different industries. State the criteria for selecting those securities.

2. Retrieve monthly data on adjusted closing prices of your securities from Yahoo Finance for the past 10 years and calculate the monthly rate of return of the stocks for every month.

3. Calculate the mean, variance, and standard deviation of the stocks' monthly returns.

4. Calculate the correlation coefficient between every possible pair of stocks' returns.

5. Decide what percentage of your money (weights) you want to invest in each stock and state the criteria you used to select those weights.

6. Now calculate your portfolio's mean monthly return, variance, and standard deviation.

7. Assuming your portfolio return follows a normal distribution, calculate the chance that your portfolio loses 10% of its value during any month?

8. Assuming you have invested $100,000 in your portfolio, what is value at risk (VaR) of your portfolio at any particular month at 99% confidence level?

9. Now randomly change your portfolio's weights 100 times (note total weights should always be 100%), for each weight combination calculate the mean and standard deviation of your portfolio, and then draw the efficient frontier.

10. For each item mentioned above explain your rationale and cite peer-reviewed and/or seminal sources.

Provide your explanations and definitions in detail and be precise. Comment on your findings. Provide references for content when necessary. Provide your work in detail and explain in your own words. Support your statements with peer-reviewed in-text citation(s) and reference(s).

Reference no: EM132538221

Questions Cloud

Evaluate your company environmental risk factors : Evaluate your company's environmental risk factors. Discuss the areas you believe are the greatest risk or concern for your company to manage

Find the expected rate of return for the stock : What is the value of the stock to you, given a 11% required rate of return? Determine the expected rate of return for the stock.

What are the implications of generational differences : What are the implications of generational differences in the workforce? What strategies should companies consider from a training and development perspective.

What yield to maturity and how much would be willing to pay : Will you buy this bond? Explain in detail what key factors you will consider in making your decision. what is the yield to maturity?

Variance and standard deviation of stocks : Calculate the mean, variance and standard deviation of stocks' monthly returns. Calculate correlation coefficient between every possible pair of stocks returns

Summarize ibms choices and the effects : Evaluate whether the employees' salaries should be reduced for the time they attend training programs. Evaluate recommendations for additional ways through.

Calculate the cost of debt of the bond and the bank debt : Calculate the Cost of Equity using the CAPM method and Dividend Valuation Method. Calculate the cost of debt of the bond and the bank debt

What are bob total sales : Its inventory turnover ratio is 5 and quick ratio is 0.8. If cost of goods sold run 60% of sales, what are Bob's total sales?

Present value of the planned investment project : Orchestra Inc. wants to embark on capital investment project whose initial capital requirement is GHC 70 million. This amount is payable at the beginning

User Account

All Pages