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

Interest is deductible on schedule a, Heather & Terry have a mortgage on th...

Heather & Terry have a mortgage on their primary residence of $750,000 and a mortgage on their vacation home of $410,000. In 2013, they incurred $46,400 of mortgage interest expens

Revenue recognition, Do we recognise revenue if it will be assigned to othe...

Do we recognise revenue if it will be assigned to other party ?

Numerical question, Data for 2013 were as follows: PBO, January 1, $244,000...

Data for 2013 were as follows: PBO, January 1, $244,000 and December 31, $274,000; pension plan assets (fair value) January 1, $190,000, and December 31, $233,000. The projected be

Sequential stages of an accounting information system, Relationship between...

Relationship between these aspects is set out in Figure.                                 Figure: The accounting information system There are four sequential stages of an

International accounting, the role of international accounting toward promo...

the role of international accounting toward promotion of generally accepted accounting principle

What are the cash collections in sept. from accounts rec.?, Wright Corporat...

Wright Corporation began its operations on September 1 of the current year. Budgeted sales for the first three months of business are $243,339, $313,087, and $415,174, respectively

Apportionment-executorship laws and accounts, APPORTIONMENT (a) T he...

APPORTIONMENT (a) T he purpose of the apportionment rules The purpose of the various rules of apportionment is to provide a fair and reasonable basis for dividing certain

What do you eman by lease, Q. What do you eman by Lease? Lease - Convey...

Q. What do you eman by Lease? Lease - Conveyance of buildings orland, equipment or other ASSETS from one person (LESSOR) to another (LESSEE) for a specific period of time for m

Define the term relevance - accounting information, Define the term Relevan...

Define the term Relevance - accounting information Accounting information should have the ability to influence decisions. Except this characteristic is present, there is ac

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