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

Basic interest rate and maximum interest rate, Suppose a risk neutral agent...

Suppose a risk neutral agent has $100,000 today that he wants to save for one year. Compare the following two savings plans. Bank A offers a standard savings account with 4% p.a

Calculate and interpret the two revenue variances, Consider the following 2...

Consider the following 2008 data for Newark General Hospitals (in millions of dollars Simple Budget_______Flexible Budget_ Actual Budget__ Revenue______$4.7$____4.8_____$4.5_

Record the estimated bad debts expense, At year-end (December 31), Chan Com...

At year-end (December 31), Chan Company estimates its bad debts as 0.30% of its annual credit sales of $753,000. Chan records its Bad Debts Expense for that estimate. On the follow

Calculate break-even point and qualitative factors, Evaluating a Company's ...

Evaluating a Company's Budget Procedures Springfield Corporation operates on a calendar-year basis.  It begins the annual budgeting process in late August, when the president

Illustrations of changes in accounting estimates, Illustrations of Changes ...

Illustrations of Changes in accounting estimates B Ltd., bought an item of plant at a total cost of £100,000. The estimated useful life commencing from 1st January 2000 was 10

Calculate the net present value of the investment, Calculate the Net Presen...

Calculate the Net Present Value of the Investment XYZ Ltd is a manufacturer of household goods located in Ang Mo Ko. They presently make and wholesale fruit juicers, blenders

Journal entry, XYZ Corporation recieves $100,000 from investors for issuing...

XYZ Corporation recieves $100,000 from investors for issuing them shares of its stock. XYZ's journal entry to record this transaction would include a a debit to investment b credit

Provision for bad debts, A business had always made a provision for doubtfu...

A business had always made a provision for doubtful debts at the rate of 5% of debtors. On 1 January 2017 the provision for doubtful debts brought forward from the previous year wa

Cash cycle, Explain the movements in working capital in terms of a business...

Explain the movements in working capital in terms of a business''s cash cycle. Explain some of the options available and their effect on the cash cycle.

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