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

Time series and demand forecasting, Time Series and Demand Forecasting ...

Time Series and Demand Forecasting   The process of budgeting in many organizations starts with a forecast of demand for the products in the forthcoming year and the sales f

Balance sheet, Balance Sheet: The balance sheet measures the financial ...

Balance Sheet: The balance sheet measures the financial position of the business at a particular point in time.  It is also called Statement of Financial Position. The balan

Personnel characteristics, Workers interest in participation is also influe...

Workers interest in participation is also influenced by certain personnel or group characteristics. For example several research studies have shown that both very low and very high

Importance of financial management, Importance of Financial Management: ...

Importance of Financial Management: Proper finance is the real key to the success of any business enterprise. Without proper finance no business can survive nor can it be expa

What are the remedies for overtrading, What are the Remedies for overtradin...

What are the Remedies for overtrading Short-term solutions Speeding up collection from customers. Slowing down payment to suppliers. Maintaining lower inventory

Expert , i have Passed all three level of CFA program and i want to join y...

i have Passed all three level of CFA program and i want to join you expert team. will you please tell me will this happen

Determine the term- time value of money, Determine the term- Time Value of ...

Determine the term- Time Value of Money If an individual behaves rationally, then he wouldn't equate money in hand today with same value a year from now. As a matter of fact, h

Can you explain about overdrafts, Q. Can you explain about Overdrafts? ...

Q. Can you explain about Overdrafts? Overdraft means an agreement with a bank by which a current account-holder is allowed to withdraw more than the balance to his credit up to

Eurobond, Eurobond A corporate bond denominated in U.S. dollars or oth...

Eurobond A corporate bond denominated in U.S. dollars or other hard currencies and sold to investors outside the country whose currency is used. Eurobonds have become an impor

Major advantages of preparing a statement of cash flow, QUESTION 1 ...

QUESTION 1 Part A i) Define the terms finance lease and operating lease and explain how you would distinguish between the two leases ii) When accounting for fina

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