Calculate the standard deviation , Financial Management

Assignment Help:

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)


Related Discussions:- Calculate the standard deviation

Three-phase source voltages and phase sequence, Q. Three-phase source volta...

Q. Three-phase source voltages and phase sequence? The elementary three-phase, two-pole generator shown in Figure has three identical stator coils (aa, bb, and cc) of one or

Assessing impact on management risk, Assessing Impact: As with the asse...

Assessing Impact: As with the assessment of likelihood, a valuable way of assessing impact would be the creation of categories of impact as follows: Level

Debt and payment, Jane has agreed to sell her Porshe 911 Cabriolet worth RM...

Jane has agreed to sell her Porshe 911 Cabriolet worth RM1.3 million to Lim for the price of RM 500,000. The decision was made rather hastily as Jane need money to pay her creditor

Active management in practice, Constant Duration To ...

Constant Duration To improve a buy and hold strategy a constant average duration is imposed for the managed portfolio during the full interest rate cy

Research and development and marketing costs, a) Product orientated busines...

a) Product orientated businesses tend to be produce products and inward looking that they hope will sell in the marketplace. For example, Sony hoped that its $101,500 audio systems

Strategies to achieve financial targets, The XYZ company supplies products ...

The XYZ company supplies products to a number of original equipment manufacturers (OEM's). It employs 5,000 mostly unionized workers and generates about $2.2 billion in revenue ann

Collection of amounts due - account receivable management, Preferably all c...

Preferably all customers will settle within the agreed terms of trade. If this doesn't happen a company needs to have in place agreed procedures for dealing with overdue accounts.

Help with 4 questions, I need assistance with 4 questions. How do I know s...

I need assistance with 4 questions. How do I know someone can help me and have some idea of what it would cost before submitting the information? Also, how fast is the turnaround

Securities analysis, 7. Bill Peters is the investment officer of a $60 mill...

7. Bill Peters is the investment officer of a $60 million pension fund. He has become concerned about the big price swings that have occurred lately in the fund’s fixed income sec

Time series analysis, In Time Series Analysis, we try to identify and deter...

In Time Series Analysis, we try to identify and determine the pattern of changes in the data collected over regular intervals of time. The data collected can be at a periodical int

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd