In this project you will use your many skills to create multiple portfolios, using the Standard and Poor's Mid Cap 400 as your dataset.

First, construct an index fund using a stratified sample of 100 stocks from the Mid Cap 400. Follow the selection process we used in class, sorting by size and P/B. Be sure to use the random numbers in your data file as the random numbers to select your stocks. Use the weight of the 20th largest stock as your threshold for stocks that have to be selected, as discussed in class.

Note: Stocks with no P/B value should be treated as extreme growth stocks.

2. Be within 10% of the average market cap, average P/B and sector weights. What is your minimized tracking error value?

Now change your range from 10% to 5% and reoptimize. What is your new optimized tracking error? Is the new value larger or smaller? Explain your result (put it directly on your Excel sheet).

Now switch to an "index-plus" portfolio. The goal here is to be mindful of tracking error, but to also try to add some utility by overweighting the portfolio with stocks that have positive alphas 2. Be within 10% of the average market cap, average P/B and sector weights. What is the maximized value of your utility function? 

Now remove the restriction of all weights being greater than or equal to zero and reoptimize. What is your new maximized utility value, and which stock have the biggest positive and negative weights?

Be sure that your sampling technique is correct. Errors in sampling will cause more errors in your later analysis.

Posted Date: 2/28/2013 12:05:23 AM | Location : United States

Ask an Expert

Related Discussions:- Create multiple portfolios standard and poor mid cap, Assignment Help, Ask Question on Create multiple portfolios standard and poor mid cap, Get Answer, Expert's Help, Create multiple portfolios standard and poor mid cap Discussions

Write discussion on Create multiple portfolios standard and poor mid cap
Your posts are moderated

Write your message here..

Related Questions

Prepare mehring''s statement of cash flows, The following information is av... The following information is available for Mehring Corporation for the year ended December 31, 2012: Collection of principal on long-term loan to a supplier

Home work help, Are u there? Are u there?

Capital expenditure as a percentage of total asset, Analyze one completed M... Analyze one completed M&A transaction from recent times There are two main requirements (1) an analysis of the strategic and economic rationale behind the merger, and (2) an analy

Shorter discounting periods, Occasionally cash flows may have to be discoun... Occasionally cash flows may have to be discounted more often than once a year semi- monthly, daily, annually or quarterly.  The outcome of this is as fold (i)  The number of per

Determine the payback period for a project, GoFlo is a small growing firm t... GoFlo is a small growing firm that is considering the purchase of another truck to serve GoFlo's expanding customer base. The new truck will cost $21,000 and should generate annual

Lack of assets available to offer as collateral or security, Q. Lack of ass... Q. Lack of assets available to offer as collateral or security? If SMEs wish to access bank finance for instance, then banks will wish to address the information problem referr

Unrealized profit on property, Unrealized profit on Property, Plant and Equ... Unrealized profit on Property, Plant and Equipment Where one company sells an item of PPE  to the other company in the group then, this will lead to two main problems. a) The se

Binary coded decimal, Binary Coded Decimal BCD stands for Binary Coded ... Binary Coded Decimal BCD stands for Binary Coded Decimal. The information given to the computer is stored temporarily before it is processed.  Consider a number 827. The bin

#accounting concepts, #what are the limitations or disadvantages of account... #what are the limitations or disadvantages of accounting concept?

Demostrate a labour-leisure trade-off model, Much of the supply-side, fisca... Much of the supply-side, fiscally conservative economic policies of Margaret Thatcher, Ronald Reagan, and even Mike Harris in Ontario were predicated on the belief that high income