Create multiple portfolios standard and poor mid cap, Financial Accounting

Assignment Help:

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.


Related Discussions:- Create multiple portfolios standard and poor mid cap

Prepare the income statement and balance sheet., Business start up accounti...

Business start up accounting transactions: Jane Whitfield, a sole proprietor, established the JW Flower Shop on January 2, 2010. The following transactions have occurred during

ACCOUNTING, Ask questiThe pre - closing general ledger trial balances at De...

Ask questiThe pre - closing general ledger trial balances at December 31,2019, for Baltimore company and its Atlanta tranche are shown belowon #Minimum 100 words accepted#

rate of interest and discount rate, This is partly taken from a court case...

This is partly taken from a court case where one of my colleagues was a witness. Suppose that an employee is terminated without cause and that she sues the company for compensation

Adjustment entry, 1) A sales discount correctly taken by the charge custome...

1) A sales discount correctly taken by the charge customer was debited to Sales at the time the entry was recorded. This error will cause. A) the net income for the period to be un

Information systems implementation on company, 1. Will implementing SAP R/3...

1. Will implementing SAP R/3 across the entire PCD division provide the division with a competitive advantage?  Justify your answer carefully. 2. The Raleigh team promised IBM c

Fair market value, Stepped Up Basis -Usually, the foundation of property ac...

Stepped Up Basis -Usually, the foundation of property acquired by INHERITENCE, BEQUEST or device from a DECENDANT is the FAIR MARKET VALUE of the property on the date of decendant'

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

Explain about credit-worthiness, Q. Explain about Credit-worthiness? Th...

Q. Explain about Credit-worthiness? There are a numerous ways in which Fenton Security plc could ensure that customers are subjected to tighter credit appraisal checks before g

How many shares are now outstanding, 1. Jepsen Corp had the following trans...

1. Jepsen Corp had the following transactions relating to shares of stock: • Issued 1,000 shares • Purchased 100 shares • Re-issued 50 shares • Declared and distributed a 2-1 stock

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd