MGMT 3150 FIN 3150 Fall 2019 Assignment 4 - 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...

1 answer below »

View more »
Answered Same DayOct 09, 2021

Answer To: MGMT 3150 FIN 3150 Fall 2019 Assignment 4 - constrained optimization of a portfolio You may do this...

Shakeel answered on Oct 11 2021
135 Votes
Instructions
    FIN 3150
    Fall 2019
    Assignment 4 - 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 analys
is 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.
    
    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
    (c) calculate the correlation coefficient for returns on each pair of stocks.
    
    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
    (c) the portfolio standard deviation.
    
    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.)
1) Prices
    Date    Netflix    Nvidia    Microsoft    Walmart    United...
SOLUTION.PDF

Answer To This Question Is Available To Download

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here
April
January
February
March
April
May
June
July
August
September
October
November
December
2025
2025
2026
2027
SunMonTueWedThuFriSat
30
31
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
1
2
3
00:00
00:30
01:00
01:30
02:00
02:30
03:00
03:30
04:00
04:30
05:00
05:30
06:00
06:30
07:00
07:30
08:00
08:30
09:00
09:30
10:00
10:30
11:00
11:30
12:00
12:30
13:00
13:30
14:00
14:30
15:00
15:30
16:00
16:30
17:00
17:30
18:00
18:30
19:00
19:30
20:00
20:30
21:00
21:30
22:00
22:30
23:00
23:30