Ask Question, Ask an Expert


Ask Portfolio Management Expert

Tangency Portfolio Problem. 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) Corresponding weights of the Tangency and T-Bill portfolios;

(b) Expected return and volatility of the complete portfolio.

Apply 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

Portfolio Management, Finance

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

Have any Question? 

Related Questions in Portfolio Management

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 ...

Portfolio project - advanced managerial financepurpose to

Portfolio Project - Advanced Managerial Finance Purpose: To learn and practice the skills associated with the development of a corporate financial portfolio. Scope: The student will choose a company and upon approval of ...

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 ...

Homework1 how to be a portfolio managerdo basic research

Homework (1) How to be a portfolio manager: Do basic research (Google?) on how you would become a licensed portfolio manager in a developed market (your choice of US, Hong Kong, Japan, Taiwan, etc). In half a page, descr ...

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 ...

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 ...

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 ...

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 ...

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 text web site provides data on 82 countries from a 2002

The text Web site provides data on 82 countries from a 2002 study on government bank ownership. For each country, the data include (a) the percentage of bank assets at government-owned banks in 1970, (b) the average grow ...

  • 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