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

present price of the common stock , Church Inc. is currently enjoying rela...

Church Inc. is currently enjoying relatively high growth because of a surge in the demand for its latest product.  Management expects earnings and dividends to grow at a rate of 25

Discount rate, #quA stock has a current dividend of $0.32 with a growth rat...

#quA stock has a current dividend of $0.32 with a growth rate of 8% annually. Assuming a 10% annual discount rate, what should the price of the stock be one year from today? Answer

Dual aspect concept - accounting principle, Dual Aspect Concept - Accountin...

Dual Aspect Concept - Accounting Principle This is, no doubt, the basic concept in accounting.  Under this concept, each transaction has got a two-fold aspect: (i) yielding

Define relationship between bond''s market price and its ytm, What is the r...

What is the relationship between a bond's market price and its promised yield to maturity?  Explain. A bond's market price relies on its yield to maturity abbreviated as YTM.  Wh

Answer to an exercise, dear, I found an exercise on the Internet which coul...

dear, I found an exercise on the Internet which could help me has better to understand the finance, but there were no answers. What is that you can help me has to solve it. I''m fr

What are the types of theft threats, What are the types of theft threats?  ...

What are the types of theft threats?  Describe the methods to access and overcome theft threats. Types of theft threats - Mass theft, Pilferage theft. Steps to assess threats

Price hike, should a company pursue price hike or focus on increased sales

should a company pursue price hike or focus on increased sales

Banking sector securities, The banking sector has a vital and active ...

The banking sector has a vital and active role in the money market. The transactions taking place in these securities are large in size, both in terms of volumes

Walters model, A Ltd sells goods at Rs.10.P.U. Its variable cost Rs.7.P.U a...

A Ltd sells goods at Rs.10.P.U. Its variable cost Rs.7.P.U and fixed cost amount to Rs.1,70,000 it finances all its assets by equity funds. It pays 40% tax on its income. Z Ltd is

Discuss risk from perspective of capital asset pricing model, Discuss risk ...

Discuss risk from the perspective of the Capital Asset Pricing Model (CAPM). The Capital Asset Pricing Model or CAPM be able to be used to compute the appropriate required rate

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