24 Jul Portfolio Analysis
a. Download 5 years of monthly closing prices for any ten companies. You can use any database to obtain the prices e.g. datastream, yahoo finance (click the Investing tab followed by the Historical Prices tab) etc. For each stock, calculate the monthly return over the last five years (use the adjusted close prices). Draw a graph (using Excel) showing these monthly returns. (Don’t include the entire Excel file with all your stock prices and monthly returns. Also, the data does not count towards the word limit).
b. Calculate the average (annualized) return and the standard deviation of the monthly return for each stock. Show your working clearly and make a table showing these values. Discuss whether there is any violation of riskreturn trade-off relationship.
c. Compute the correlation matrix and the variance-covariance matrix of the 10 stocks. Discuss the relationship between covariance and correlation coefficient.
d. Draw on the same graph, all combinations of risk and return for three different portfolios containing two of the stocks in your sample and show the efficient frontiers for the portfolios, where:
(i) Portfolio One contains the two stocks with the highest positive correlation,
(ii) Portfolio Two contains two stocks with a correlation close to zero and
(iii) Portfolio Three contains two stocks with the largest negative correlation. Explain your observation on this graph. Interpret your answer taking into consideration the effects of diversification by comparing the frontiers that you have derived.
Notes:
The total word count must be printed on the front page. There is a maximum limit of 1,500 words ± 10%.
Referencing in your assignment should take the following forms:
The structural approach of Gilbert (1989) demonstrated that two demand side variables…..
The behaviour of primary commodity prices is particularly important to many developing countries where a significant proportion of national income is generated by a small number of primary products (see Cashin et al., 2000).
A good explanation of the concept of cointegration can be found in Engle and Granger (1991).
These would be listed in the bibliography is follows:
Cashin, P., Liang, H. and C. McDermott (2000) How persistent are shocks to world commodity prices?, IMF Staff Papers, 47, 177-217.
Engle, R.F. and C.W.J. Granger (1991) Long-run economic relationships: readings in cointegration, Oxford University Press, Oxford.
Gilbert, C.L. (1989) The impact of exchange rates and developing country debt on commodity prices, Economic Journal, 99, 773-84.
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.