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

Scheduling or budgeting, Tool Belt Store (TBS) is expanding its chain of ha...

Tool Belt Store (TBS) is expanding its chain of hardware stores across the country. TBS has more than 5,000 full-time employees and more than 20,000 part-time employees. TBS recent

Mortgage, Ask questiJohn’s away at the moment, and his email provider has a...

Ask questiJohn’s away at the moment, and his email provider has a size limit on the data that can be sent via email. What is a potential solution for John, and name a provider that

What should be didde''s 2011 earnings per common share, Didde Co. had 300,0...

Didde Co. had 300,000 shares of common stock issued and outstanding at December 31, 2010. No common stock was issued during 2011. On January 1, 2011, Didde issued 200,000 shares of

Analyse the economical performance and monetary position, The statement of ...

The statement of comprehensive income for the year ended 31 December 2009 and its comparative is shown below: 2009 2008 $m

Forecasting earnings, what if 50% of customers who switch from pisa pizza ...

what if 50% of customers who switch from pisa pizza who switch from original pizza to healthier pizza then switch to another brand from healthier pizza.

Determine the internal rate of return for a project, What is the internal r...

What is the internal rate of return for a project that has a net investment of $76,000 and net cash flows of $20,507 per year for 7 years? What is the internal rate of return fo

Basics of sundry matters, Basics of Sundry Matters Current accounts...

Basics of Sundry Matters Current accounts balances must always be equal and opposite. The head office current account in the branch books should always have a credit bal

Annual interest rate, Interest Rate on a one Payment Your parents will ...

Interest Rate on a one Payment Your parents will retire in 17 years. They presently have $270,000, and they think they will require $1 million at retirement. What annual intere

Ledger, “Ledger is said to be the principal book entry and the transactions...

“Ledger is said to be the principal book entry and the transactions can even be directly entered into the ledger account.” Elaborate and explain why journal is necessary.

Analysis on the profitability, (a) You are working as the CFO of Jeans Co. ...

(a) You are working as the CFO of Jeans Co. The company is currently seeking a new supplier for their goods. There are two main suppliers of choice, XYZ Ltd and ABC Ltd. The contra

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