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

Prepare an investment plan proposal, Yanni and Joanna need some investment ...

Yanni and Joanna need some investment advice. Joanna has sold $660,000 worth of Woolworths Limited (WOW) shares that she inherited late last financial year. She has $616,000 remain

What is nondiversifiable risk? how is it measured, What is nondiversifiable...

What is nondiversifiable risk? How is it measured? But for the returns of one-half the assets in a portfolio are flawlessly negatively correlated with the other half-which is e

Explain the meaning of ledger, Question 1 Write short notes on following- ...

Question 1 Write short notes on following- Explain any five important functions of accounting What is Book-Keeping? Explain features of book-keeping Question 2 Ex

Explain the bird in the hand theory of cash dividends, Explain the bird in ...

Explain the bird in the hand theory of cash dividends. The bird in the hand dividends theory states that dividends received now are better as compared to a promise of future divi

Defqa, Ask question #Minimum 100 words acceptedaqs #

Ask question #Minimum 100 words acceptedaqs #

Profitability ratios, Profitability Ratios   Profit Margin  ...

Profitability Ratios   Profit Margin  It is a measure of the profit margin of the company. This is important to gauge the financial position of the company.

International financial system, International financial system has always b...

International financial system has always been a debatable and crucial focus of the world discussion and it is mainly due to the repression of the economies especially after the cu

Explain the term stakeholders, Explain the term StakeHolders The range ...

Explain the term StakeHolders The range of stakeholders may comprise directors/managers, lenders, shareholders, employees suppliers and customers. These groups are probable to

How to calculate cost of capital?, To calculate the Cost of Capital, we wil...

To calculate the Cost of Capital, we will use the Weighted Average Cost of Capital (WACC) formula             WACC = (E/V) X R E + (D/V) X R D X (1 - T C ) where

Calculate the total present value of the tax shield, Nortel is considering ...

Nortel is considering the purchase of a new  call routing system.  The system will cost $50M to purchase, an additional $7M to install, and will last for 30 years.  The CCA rate as

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