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

Derivatives, On April 10, ABC inc. Enters in a swap contract for 10 years w...

On April 10, ABC inc. Enters in a swap contract for 10 years with a chartered bank to turn a fixed rate on liability of $150 million to floating rate. ABC wants to receive interest

Prepare the journal entry at december 31, On December 31, 2004, Internation...

On December 31, 2004, International Refining Company purchased machinery having a cash selling price of $85,933.75. The company paid $10,000 down and agreed to finance the remainde

Grants are not necessarily recognized as revenue, Grants are not necessaril...

Grants are not necessarily recognized as revenue when they are awarded. Columbus City was awarded a state reimbursement grant of $150,000 to assist its adult literacy program. The

Acquisition Merger, Can you combined the PVH & Warnaco Group Balance Sheet ...

Can you combined the PVH & Warnaco Group Balance Sheet after merger?I will an attached the excel worksheet that includes the instructions

Benefits of common stock and preferred stock, Evaluate the following statem...

Evaluate the following statements, and explain why you agree or disagree. (a)    In a recent interview, a Wall Street investment banker commented on the infrequent use of Prefer

Current market cost of debt, The cost of debt must be based upon the curren...

The cost of debt must be based upon the current market cost of debt. Where different kinds of debt are used estimates of more than one debt cost may be necessary and these costs we

Question, A. Material Sampling -Analyzing Direct Material Costs You are r...

A. Material Sampling -Analyzing Direct Material Costs You are reviewing a cost proposal, which includes an $800,200 direct material estimate. After Initial examination of the pr

Accounting information system, REA diagram for (1) PEGASUS PAPER PRODUCTS a...

REA diagram for (1) PEGASUS PAPER PRODUCTS and (2)PIECES BOUTIQUE

Financial transaction reports , Answer both parts in this task. Part (i) is...

Answer both parts in this task. Part (i) is worth a maximum of 10 Marks, while part (ii) is worth a maximum of 5 Marks. (i) Minnie owes Micky Mouse $500 and hands him a cheque p

Illustration of marked up by an additional amount, Illustration of marked u...

Illustration of marked up by an additional amount E Limited sent goods to its branch in Thika invoiced at selling price, which was cost plus 505 of cost.  On 1st July 20X2, the

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