Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask Portfolio Management Expert

problem: Collect 10 years of monthly returns for four stocks. Sample of ten years of monthly data should be a pretty reasonable estimate of expected returns, variances, and covariance.

[A]   Using this information, find out the tangency portfolio. You have to report

(a)                Weights of the individual stocks in the tangency portfolio;

(B)                Expected returns and volatilities of the individual stocks;

(c)                Variance-covariance matrix;

(d)                Expected return and volatility of the tangency portfolio;

(e)                Sharpe ratio of the tangency portfolio;

Use solver to find out the tangency portfolio in M.S. Excel. Print and submit two Excel spreadsheets: one with the starting values for portfolio weights, another with the optimal portfolio weights. The Excel Spreadsheet Tangency Portfolio.xls with similar problem is placed on ANGEL in the "Excel exs" folder. You can use it as a template for this problem. This problem aims at demonstrating that the concepts we discussed in class hold in a more general setting than just a two-stock market. If you like, you can easily make the tangency using 5 & more stocks.

Suggestion: Apply vector formulation; it is very easy to compute portfolio's variance! If ω is the N Χ 1 vector of portfolio weights and Ω is the N Χ N variance-co variance matrix, then the portfolio variance is

1111_Volatality and Variances.jpg

Portfolio Management, Finance

  • Category:- Portfolio Management
  • Reference No.:- M919639

Have any Question? 


Related Questions in Portfolio Management

Getty image and agile portfolio managementread the case

Getty Image and Agile Portfolio Management Read the case study titled Agile Portfolio Management: Getty Images Gains Visibility and Alignment with Kanban Portfolios. Write a four to five page paper in which you: 1. Expla ...

The portfolio projectfor this portfolio project option you

The Portfolio Project For this Portfolio Project option, you will choose and build a training plan. Identify a common training problem that organizations struggle with and the best way to address this problem. Examples i ...

The data set required for the completion of the applied

The data set required for the completion of the Applied Problems and the Portfolio project can be obtained from the course website. The EXCEL file contains sheets labelled: DAILY WEEKLY MONTHLY Presenting your solutions ...

Assignment portfolio managementwrite a five to seven page

Assignment: Portfolio Management Write a five to seven page paper in which you: 1. Analyze the relationship between risk and rate of return, and suggest how you would formulate a portfolio that will minimize risk and max ...

Suppose that there are two types of people in the country

Suppose that there are two types of people in the country of Dipolia: unskilled people who value only food and skilled, lazy people who value only alcoholic drinks. The government of Dipolia is considering moving from a ...

1in the context of prospect theory state the four-fold

1. In the context of prospect theory, state the four-fold pattern of risk attitudes and how it arises. Be specific. 2. A problem that plagues many investors is failure to diversify. (a) What is the name given to a failur ...

From the text web site link to the st louis fed site for

From the text Web site, link to the St. Louis Fed site for data on the high-yield spread and on the unemployment rate. a. Graph unemployment on the horizontal axis and the spread on the vertical axis, with a point for ea ...

Explain how each of these events affects the amount of m1

Explain how each of these events affects the amount of M1 that people hold: a. ATMs are invented. b. Credit cards are invented. c. Debit cards are invented. d. Stored-value cards are invented. e. Interest rates on bonds ...

Instructions for tradestep 2 buy securitiesthis section is

Instructions for Trade Step 2 Buy Securities This section is to make sure you are able to understand a brokerage statement and track returns. You generate such a statement using information from the portfolio you create ...

Assessment portfoliofocus of the final projectas you have

Assessment Portfolio Focus of the Final Project: As you have learned throughout this course, assessments are used for many purposes. As professionals working with children, we must look at assessment as a driving force b ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate