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

Define the tactics of shareholders used after the bid, After the bid Ta...

After the bid Tactics can be undertaken by directors to ensure that their shareholders don't accept the bid, if that is what they desire. Reject Share

State the goal of shareholders wealth maximisation, Goal of Shareholders we...

Goal of Shareholders wealth maximisation Shareholders' wealth maximisation goal gives us the best results since effectsof all the decisions taken by company and its managers ar

Activity-based budgeting - abb, It is a method of budgeting in which the ac...

It is a method of budgeting in which the actions that incur costs in every functional area of a company are recorded and their relationships are defined and evaluated. Activities a

Define production limits used in practice to raise prices, How are producti...

How are production limits used in practice to raise the prices of the following goods or services: (a) taxi rides, (b) drinks in a restaurant or bar, (c) wheat or

Financial market, Financial Market: Being entrusted with different func...

Financial Market: Being entrusted with different functions having macro level implications on the nation's economy, the financial system tries to fulfill its role through the f

How amount of financing affecting cost of capital, Q. How Amount of financi...

Q. How Amount of financing affecting cost of capital? Amount of financing as the financing require of the firm become larger , the weighted cost of capital increased several re

Prosthetic components in implantology, Implants and implant systems since i...

Implants and implant systems since inception have been in continuous state of flux in terms of its design and surface. Likewise there has been a subtle change in the implant surgic

Working capital cycle for a trade, Working capital cycle for a trade ...

Working capital cycle for a trade Inventories days (time inventories are held before being sold)   Plus   Trade receivables days (how long

Fundamental ingredients of management of working capital, Fundamental ingre...

Fundamental ingredients of Management of working capital Management of working capital has two fundamental ingredients: (1) an overview of working capital management as a wh

What are the financing and investing decision, What are the Financing and i...

What are the Financing and investing decision Financing and investing decisions are closely related as the company is going toraise money to invest in a project or assets. Thos

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