Publicly traded companies from different industries

Assignment Help Business Management

Reference no: EM132568837

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.

Reference no: EM132568837

Questions Cloud

What is collected by the company sometimes differs : The net realizable value is the amount that the company expects to actually collect. What is collected by the company sometimes differs

What is inquiry based assessment : What is inquiry based assessment and how does it help children develop tools for understanding themselves as readers?

How different entities contribute to health care industry : The Business Side of Health Care infographic was created to show individuals how different entities contribute to the health care industry.

How are testing and assessment different : How are testing and assessment different?

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

Explain the importance of crime analysis : Build upon your earlier post about CPTED and explain the importance of crime analysis in reference to secure architectural design. Remember to cite at least.

By what amount should AAA account change : In 2009 the partnership sustained a P33,000 loss before interest and salaries to partners. By what amount should AAA's account change

How conditions are currently in your state : As a future leader in health care, why is it important to understand major disease outbreaks from reliable resources such as the CDC? You may also want.

Determine the dollar amount of ocean city kite company : Determine the dollar amount of Ocean City Kite Company's fixed costs. (Round dollar value to the nearest whole dollar & enter as whole dollars only.)

User Account

All Pages