Find the minimum variance portfolio among these assets

Reference no: EM131937836 , Length: 3 pages

Problem:

Suppose you are an associate at a prestigious investment firm. One day, your boss gives you the following exercise to test your basic quantitive skill you learned from FINM7008. Your investment opportunities are limited to five assets (1) ASX All Ordinaries Index; (2) Heng Seng Index; (3) Nikkei 225 Index; (4) S&P 500 Index; (5) CSI 300 Index. (See the Description sheet for details of these assets). He gives you the time series of 5 asset class monthly adjusted prices between 12/2008 and 12/2016 and assume a risk aversion coefficient of 3. Please report all answers in monthly terms.

(a). Find the minimum variance portfolio among these assets, and also report the resulting portfolio expected return, standard deviation and sharpe ratio.

(b). Do (a) again, but this time you are not allowed to short assets. How the results (e.g. expected return and sharpe ratio) change?

(c). Find the optimal allocation among these assets, and also report the resulting optimal complete portfolio expected return, standard deviation and sharpe ratio.

(d). Do (c) again, but this time you are not allowed to short assets. How the results (e.g. expected return and sharpe ratio) change?

(e). Do (c) again, besides no short sell, this time your boss gives one more restriction, the maximum weight of single type of asset can not exceed 30% (similar restriction as in mutual funds). How the results change?

Attachment:- Assignment Optimal Portfolio.xlsx

Reference no: EM131937836

Questions Cloud

How the strategies might bring about positive social change : Develop 2-3 strategies for mitigation and explain how each strategy might support mitigation of the topic problem. Describe how digital technology is relevant.

How might the different religions explain the world for pi : How does scientific language and classification fit in with Pi's father's world view? How might the different religions explain the world for Pi?

Describe the authors performance style or interests : Write a paragraph describing the author's performance style or interests. Which the author describes his or her relationship to performance.

Steps that can be taken to minimize the number of divorces : Steps that can be taken to minimize the number of divorces. Steps that can be taken to help children cope more effectively with their parents' divorce involved.

Find the minimum variance portfolio among these assets : Find the minimum variance portfolio among these assets, and also report the resulting portfolio expected return, standard deviation and sharpe ratio

What will be the value of call provision to company : What will be the value of the call provision to the company? What will the market value of these bonds be if they are noncallable?

Perpetual bonds with annual coupon payments : Bowdeen Manufacturing intends to issue callable, perpetual bonds with annual coupon payments.

What are the elements required for an effective introduction : What are the elements required for an effective introduction and Are there aspects of class could have been more clearly explained

Preclude arbitrage on such forward contract : What is the forward price that would preclude arbitrage on such a forward contract?

User Account

All Pages