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

Remaining differences with us gaap, Remaining differences with US GAAP ...

Remaining differences with US GAAP IFRS 8 comprise intangible assets as part of the non-current assets. SFAS 131 only refers to tangible assets. IFRS 8 requires method

Gordon''s dividend capitalization method, formula and explanation for Gordo...

formula and explanation for Gordon''s dividend capitalization method

Define weight refer to in weighted average cost of capital, What does the “...

What does the “weight” refer to in the weighted average cost of capital? The weight considered to in weighted average cost of capital consider the portion of the total capital in

Parallel trade, Parallel T rade It is a form of countertrade th...

Parallel T rade It is a form of countertrade that involves the execution of 2 distinct and individually enforceable contracts: the first for the sale of goods by an exp

Cost of equity from new common stock, Weaver Chocolate Co. expects to gain ...

Weaver Chocolate Co. expects to gain $3.50 per share during the present year, its expected dividend payout ratio is 65%, its expected constant dividend growth rate is 6.0%, and its

Functional classification of mutual funds, Functional Classification of Mut...

Functional Classification of Mutual Funds Functional classification of Mutual Funds is based on the basic characteristics of the mutual fund schemes for subscription. Mutual Fu

Show the projected balance sheet method, Q. Show the Projected Balance Shee...

Q. Show the Projected Balance Sheet Method? Projected Balance Sheet Method: - Under this process an approximate is made of assets and liabilities for a future date and a projec

Define accumulated depreciation, What is accumulated depreciation? Depr...

What is accumulated depreciation? Depreciation is the allocation of an initial cost over time of asset. Whereas the term accumulated depreciation is the total of all the deprec

Define price ceiling make consumers better off, How can a price ceiling mak...

How can a price ceiling make consumers better off?  Under what conditions might it make them worse off? If the supply curve is completely inelastic a price ceiling will raise c

Day traders, Day Traders Day traders are basically the market markers. ...

Day Traders Day traders are basically the market markers. They create liquidity in the market by frequently buying and selling stocks throughout the day in the hope that the pr

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