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

Impairment of Long-lived assets, How to calculate fair value of long-lived ...

How to calculate fair value of long-lived asset when the information about fair value is not available?

The notes to the accounts-financial statement, THE NOTES TO THE ACCOUNTS ...

THE NOTES TO THE ACCOUNTS The notes to the accounts provide additional information on the a/c policies that the company has adopted the make-up of some of the items appearing on

HELP!, How do you know what goes on an income statement? P.S. This is a bas...

How do you know what goes on an income statement? P.S. This is a basic income statement.

Project Assistance, How do you create an Excel document with several financ...

How do you create an Excel document with several financial statements, all linked together with specific financial data?

Which is not necessary in order for corporation to pay cash, Q. Which one o...

Q. Which one of the following is not necessary in order for a corporation to pay a cash dividend? a. Adequate cash b. Approval of stockholders c. Declaration of dividends by the bo

Determine the optimal liquidation quantity, The bid-offer spread as a funct...

The bid-offer spread as a function of daily trading volume is given by :p(q) = a + b*exp(cq) where q = daily trading volume a = 0.08 b= 0.10 c = 0.05 A trader wants to unwind

Calculate the average issue price of the common stock, Star corporation iss...

Star corporation issued both common and predered stock during 20X6. The stockholders' equity section of the company's balance sheets at the end of 20X6 and 20X5 follow: 20X6 20X5 P

Nikki., Trying to calculate earnings per share. Is net income the same as ...

Trying to calculate earnings per share. Is net income the same as earnings before interest and taxes?

Survivorship policy, SURVIVORSHIP POLICY The partners may take out a su...

SURVIVORSHIP POLICY The partners may take out a survivorship policy to safeguard against future cashflow problems incase a partner dies or the business is dissolved. E.g. incas

Liquidation, The liquidation of the Marks, Norris, Smith, and Savannah part...

The liquidation of the Marks, Norris, Smith, and Savannah partnership:

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