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

Caselet, 1.How would you judge the potential profit of Bajaj Electronics on...

1.How would you judge the potential profit of Bajaj Electronics on the first year of sales to Booth Plastics and give your views to increase the profit? 2. Suggestion regarding C

What are the motives of holding cash, Q. What are the Motives of Holding Ca...

Q. What are the Motives of Holding Cash? Motives of Holding Cash: - In every business assets are kept for the reason that they generate profit. But cash is an asset which doesn

Fiancial management, Ashok is to receive an amount of Rs. 15,00,000 from hi...

Ashok is to receive an amount of Rs. 15,00,000 from his relative after 3 years. He wants to buy a house for which he wants the money to be paid now. His relative had already invest

Role of banks in international trade transactions, Question 1 Internationa...

Question 1 International trade is the economic interaction among different nations involving the exchange of goods and services. Discuss the role of Banks in International Trade T

Find out the current stock price, Great Pumpkin Farms just paid a dividend ...

Great Pumpkin Farms just paid a dividend of $3.50 on its stock. The growth rate in dividends is expected to be a constant 5 percent per year indefinitely.  Investors require a 16 p

Dividend policy, DIVIDEND POLICY Dividends provide the portion of a fi...

DIVIDEND POLICY Dividends provide the portion of a firm's net earnings which are paid out to the shareholders. the objective of financial management of maximizing the share

Return on investment , Return on Investment (ROI) In accounting it is a...

Return on Investment (ROI) In accounting it is a measure of the earning power of an industries asset. A high return on investments is desirable. ROI is widely described as net

Describes net income approach to capital structure, Q. Describes Net Income...

Q. Describes Net Income Approach to Capital Structure? Net Income Approach: - As-per to the Net Income Approach as suggested by Durand the capital structure decision is applica

Explain capital in a money market or capital market, Question 1: (a) Ad...

Question 1: (a) Advise a risk averse individual whether to invest his capital in a money market or capital market. Justify your answer. (b) Explain five types of Money marke

Define terms proprietorship partnership and corporations, Briefly define th...

Briefly define the terms proprietorship , partnership , and corporation . A proprietorship is a business possessed by one person. Two or more people who unite together to

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