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

Arbitrage-free valuation approach, The main drawback of the tradition...

The main drawback of the tradition approach of valuation is that it discounts every cash flow using the same discount rate. For example, let us take 5-year (7.00 per ce

Regulation of mergers and acquisitions, Regulation of Mergers and acquisiti...

Regulation of Mergers and acquisitions Mergers and acquisitions are regulated by: Competition commission If office of fair trading thinks that merg

Alternative summarised version of tests of controls, Alternative summarised...

Alternative summarised version of tests of controls · Segregation of duty (staff records are separate from wages department) · Documentation ( written evidence ) ·

Illustrating a straddle, Options Traded on Legal and General August 14  200...

Options Traded on Legal and General August 14  2009 Share   Price         Exercise      Price    Calls       Puts                                 Sep        Dec        Mar

Features and purpose CDs , The distinct features of CDs are: CD is a ...

The distinct features of CDs are: CD is a document of title to a time deposit and is distinct from conventional time deposit with respect to negotiability and marketability.

the use of a preauthorized check system, In general, what type of firm wou...

In general, what type of firm would benefit from the use of a preauthorized check system and what specific types of companies have successfully used this device to accelerate cash

What is financial risk, What is Financial risk Financial risk is affe...

What is Financial risk Financial risk is affected by mixture of long-term financing or capital structure, of firm. Firms with high levels of long-term debt in proportion to t

Risks associated with investing in bonds, Interest rate risk is the risk wh...

Interest rate risk is the risk wherein the investor in bonds faces the risk of a fall in his bond price as and when there is a rise in the market interest r

Financial Management, Financial Management Initial Disclosures During the ...

Financial Management Initial Disclosures During the process of discussion and negotiation with the client with regard to the financial affairs and the manner of operations of the

Factors affecting working capital needs of firms, FACTORS AFFECTING WORKING...

FACTORS AFFECTING WORKING CAPITAL NEEDS OF FIRMS A large no. of reasons influences the working capital requirements of firms.  a number of them are as follows: 1. Nature of

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