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

Estimate parametric market var, You have an investment in a portfolio with ...

You have an investment in a portfolio with a counterparty whose current credit rating is Baa. The current market value of the portfolio is $50,000,000 and its annual volatility is

What is contractor ledger, Q. What is Contractor Ledger? Accounts relat...

Q. What is Contractor Ledger? Accounts relating to contractors should be kept as personal accounts in contractor's ledger and a separate folio should be opened in the Contracto

Division of the trust-trusts laws and accounts, Division of the trust T...

Division of the trust The safeguards consist in the division of the trust funds into portions.  Before this division takes place, the investments are revalued in order to deter

Receiver necessary statement-bankruptcy, Receiver necessary statement T...

Receiver necessary statement The receiver may, if necessary, require the statement to be submitted by: Past or present officers of the company Persons who have taken

Assessing project risk, In assessing project risk it is significant to be c...

In assessing project risk it is significant to be clear about the meaning of risk. From an academic perspective risk demotes to a set of circumstances regarding a given decision wh

Financial management, What can a financial institution often do for a defic...

What can a financial institution often do for a deficit economic unit (DEU)that it would have difficulty doing for itself if the DEU were to deal directly with an SEU?

#title.Current Issue in financial Accounting, 2 Individual Research Assignm...

2 Individual Research Assignment This assignment is an individual assessment. The research and written submission should therefore be your own work. You will need to submit this as

HELP!!, Calculate the DuPont Model, given the following information: cash=$...

Calculate the DuPont Model, given the following information: cash=$16,080; accounts receivable= $9,500; prepaid = $3,150; supplies =$675; equipment =$25,200; accumulated depreciati

Simple balance sheet statement, Current analysis You will need about $1...

Current analysis You will need about $150,000 in start-up costs but you can only borrow half of that amount from your family's home equity (at 13% interest). You will have to b

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