Question: Continuing the previous problem, determine the portfolio that minimizes the chance that you will lose money during any month, subject to a lower bound constraint

Continuing the previous problem, determine the portfolio that minimizes the chance that you will lose money during any month, subject to a lower bound constraint on your expected monthly return. (The lower bound will depend on your data. It must not be above the largest average return of your stocks. For example, if you require the mean portfolio return to be greater than 1% and all stocks average less than1%, the constraint can’t possibly be satisfied.)


Data from Previous Problem:

Visit http://biz.yahoo.com/r/. Under Research Tools, click on Historical Quotes, and then download the monthly returns on at least four stocks for the preceding 60 months. Use this data to determine the portfolio that maximizes the chance of beating the S&P 500 for these years.

Step by Step Solution

3.46 Rating (156 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Model Beating the SP 500 Weights for portfolio American Express Cisco Disney FedEx Johnson Johnson Coca Cola Sum Required Difference 00997 02145 02187 02065 01542 01063 1000 1 0 Constraint on expected ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

1497_60471d4712557_695330.xlsx

300 KBs Excel File

Students Have Also Explored These Related Practical Management Science Questions!