Calculate your portfolio mean monthly return

Reference no: EM132295895

Question: 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).

Please refer to the Grading Criteria for Comprehensive Learning Assessments (CLAs) on page 20-21 of the syllabus for specific guidelines and expectations.

Reference no: EM132295895

Questions Cloud

Write the response memo at the bottom of the case study : Write a formal memo to the head of the company, explaining the issue and making sound recommendations to solve the problem.

Division of company overseas operations : Assume that you are being sent to Japan to run a division of your company's overseas operations. Let's assume that I have been managing

Affect prices for wide range of apple products : Apple forecasts that the proposed tariffs would affect prices for a “wide range” of Apple products

Are there any differences in how they are reported : What likely effect will its emphasis on electronically stored information (ESI) have on an organization's need for a digital forensic capability?

Calculate your portfolio mean monthly return : BUS 550 Financial Management (Westclief university - College Of Business). Select the stocks of three publicly traded companies from different industries.

What are some ways that warehousing may be changing : With current technology, what are some ways that warehousing may be changing?

Stress in the evaluation and reward design : What factors would you stress in the evaluation and reward design and why

Identify the inputs of the validate scope process : Discuss the tools and techniques used in the Validate Scope process as well as the outputs of the process.

Describe what role social entrepreneurship plays in society : Describe what role social entrepreneurship plays in society.

User Account

All Pages