Calculate the standard deviation , Financial Management

The attached file (MFR & FFM Ass Returns Data.xls) gives 132 months returns for thirty securities drawn from the FT ALL share index as well as the returns on the FT ALL share index

a)   Choose any ten securities at random and form an equally weighted portfolio of these securities

i.  Choose any five securities at random and determine the average returns for each company for the 132 months along with the variance and standard deviation of these returns. Next construct an equally weighted portfolio made up of the five securities, and determine the series of monthly returns. On this basis determine the average return for the portfolio and the associated variance and standard deviation.  The averages, variances, and standard deviations can be derived using the relevant Excel functions. Utilise the Excel specification for population variance and standard deviation - STDEVP and VARP - in the calculations. Explain the discuss the relationship between the average returns, average variance, and average standard deviation for the five securities and the average returns, variance, and standard deviation for the portfolio.

ii.  Calculate the co-variances for each pair of securities in the portfolio and on the basis of this information, and using the relevant portfolio equations, calculate the standard deviation of the returns on the portfolio.  Compare your results to those obtained for the portfolio in part i above. Comment and explain your findings.

b)  Choosing securities at random form equally weighted portfolios of 2, 5, 10, 15 and 20 securities determine the standard deviation of these portfolios and plot the standard deviations against the number of securities in the portfolios.  Comment on your results and compare these with the results of the studies of naïve diversification. (In undertaking this analysis you can derive the results for each of the portfolios using the Excel spreadsheet - there is no need to employ the portfolio equations and estimates of co-variances etc.                                                                           

c)   i.   Determine the beta of one security by regressing the returns for the share on the returns for the FT ALL Share Index (the last column in the spreadsheet).  Comment on what the value of the beta (the slope coefficients in the regression) indicates.

ii.  Discuss the primary determinants of a share's beta.  (This part of the questions relates to betas in general and does not require you to focus on the company analysed in part (i)

Posted Date: 2/22/2013 4:17:15 AM | Location : United States







Related Discussions:- Calculate the standard deviation , Assignment Help, Ask Question on Calculate the standard deviation , Get Answer, Expert's Help, Calculate the standard deviation Discussions

Write discussion on Calculate the standard deviation
Your posts are moderated
Related Questions
Q. Degree of uncertainty in predicting cash balances? Probability approaches identify a degree of uncertainty in predicting cash balances and allow for a range of outcomes to

Question 1 (a) These are merely the differences of the two prices. Consequently the mark to market losses are given by { Q 1 - Q 0 ,Q 2 - Q 0 ,Q 3 - Q 0

Q. Explain about Baumol Model? Baumol Model: - Baumol model is a mechanism of cash management which is used to determine optimum cash balance. Optimum cash balance is resolute

PLAYERS IN THE PRIMARY MARKET Some important players in the primary market are: Merchant Bankers When a company approaches the public for funds, merchant bankers manage

DISCUSS THE APPLICABILITY OF OPERATING CYCLE IN VEGETABLE GROWING.

Methods of workers participation in management: the various methods of workers participation in management are as follows: 1. Informative participation: it refers to sharing of

What does it mean when we say that the correlation coefficient for two variables is -1? What does it mean if this value were zero? What does it mean if it were +1? Correlation is

Describe the difference between a parallel loan and a back-to-back loan. Answer:  A parallel loan contains four parties.  One MNC (multinational company) borrows and re-lends to

Floating Rate Notes (FRNs): When interest rates are high and the general outlook is either stable or indicating the possibility of a downward trend in return, then an investor

The Final Project for this module is a consultancy report to Anthony’s Orchard, an expanding apple orchard and distributor. The company has been entertaining the idea of expanding