Constrained optimization of a portfolio- Assignment

Reference no: EM132397248

FIN 3150 - Personal Financial Planning, Metropolitan State College of Denver USA

Assignment - constrained optimization of a portfolio

You may do this assignment individually or with one other person. If you work with another, be sure that both know how to set up the analysis and calculate optimal portfolios.

1. Prices

Obtain monthly closing prices for five stocks from different industries for the last twelve years. Each stock must have traded publicly for the last twelve (so no recent IPO's and no stocks with a bankruptcy filing during that period).

2. Returns

Calculate monthly returns for each stock. (Be sure to account for dividends, e.g., by using the "adjusted closing price" from yahoo finance.)

3. Average return and risk

Determine:

(a) the average monthly return for each stock,

(b) the standard deviation of monthly returns for each stock, and

4. Equally weighted portfolio

Determine the average return and standard deviation for an equally weighted portfolio of the five stocks.

For each of 5-8 use constrained optimization (e.g., the "solver" in excel) to determine the investment in each stock needed to obtain the portfolio described.

For each portfolio, specify:

(a) the weight for each stock in the portfolio,

(b) the average portfolio return and

5. Lowest risk portfolio

Find the portfolio that has the lowest possible risk (that is, the lowest standard deviation).

6. Highest return portfolio

Find the portfolio that has the highest average return.

7. Highest return portfolio with the same risk as the equally weighted portfolio

Find the portfolio that has the highest possible return and the same risk as the equally weighted portfolio (i.e., the same standard deviation as in question 4).

8. Lowest risk portfolio with a return selected by you

Select a specific monthly return that is between the monthly return on the equally weighted portfolio (i.e., from question 4) and the return on the highest return portfolio (i.e., from question 6). Find the portfolio with the selected return that has the lowest possible risk (standard deviation).

9. Comment (briefly) on your findings.

(Turn in the spreadsheet you use to do the calculations with the answers to each question highlighted to make them easy to locate.)

Reference no: EM132397248

Questions Cloud

Emergency preparedness-health care and food safety : There are many agencies that oversee a variety of public health functions, including: emergency preparedness, health care, food safety, drug safety

About ig best business practices : We continue to enhance our knowledge and understanding about IG best business practices

ICTPRG604 Create Cloud Computing Services Assignment : ICTPRG604 Create Cloud Computing Services Assignment Help and Solution. Academies Australasia - Sydney, Australia. Case Study Scenario: BitShop Pty Ltd

Immunology Case Study Assignment : Immunology Case Study Assignment - Department of Laboratory Immunology - Oxford University Hospitals, UK. Describe Alternative pathway of complement activation

Constrained optimization of a portfolio- Assignment : FIN 3150 - Personal Financial Planning Assignment Help and Solutions Metropolitan State College of Denver USA- Calculate monthly returns for each stock.

ECON 3730 - Forestry Economics Assignment Problem : ECON 3730 - Forestry Economics Assignment Help and Solution, Thompson Rivers University, Canada. What is the equilibrium price

Create a mini-monograph for ketoprofen drug : Create a mini-monograph for Ketoprofen drug. A drug monograph is a summary about the clinical aspects of a drug or pharmaceutical agent.

MRE5003 Industrial Techniques in Maintenance Management : MRE5003 Industrial Techniques in Maintenance Management Assignment Help and Solution, Federation University Australia. Discuss leadership and management

Do you know anything about the design of the organization : Think back to an experience you have had with poor customer service from an organization. Whom did you blame for it? Do you know anything about the design.

User Account

All Pages