Reference no: EM13316471
QUESTION 4: PORTFOLIO ANALYSIS
The attached file contains (Returns data S2, 2014) daily returns for twenty five securities drawnfrom the NZX50 Index for the period 26th June 2013 and 24th June 2014.
4.1 Choose any two securities at random and determine (using Excel functions) the average daily returns for each company for the 12 months along with the variance and standard deviation of these returns. Next construct an equally weighted portfolio made up of the same two securities, and determine the series of daily 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 standarddeviation - STDEVP and VARP - in the calculations).
Verify your results using the two-factor portfolio equation recalculate the average return and standard deviation of the portfolio. Explain why the portfolio standard deviation is less than the average standard deviation of individual securities.
4.2 Choosing securities at random form equally weighted portfolios of 2, 3, 5,9, 15and 24 Securities and determine the standard deviation of these portfolios. Next plot your results for 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 spread-sheet).
Attachment:- Returns data.xlsx
|
Compulsive and obsessive behavior moods and mood swings
: Which of the following is NOT a characteristic of a psychotic individua Compulsive and obsessive behavior Moods and mood swings A grossly distorted conception of reality A marked inefficiency in getting along with others and caring for oneself
|
|
Describe naturally-occurring food
: Describe a naturally-occurring food that could be used as a PRE-, DURING-, and POST- training (or competition) nutritional aid to endurance athletes whose goal is optimal performance.
|
|
Describe what happens to each type of carbohydrate
: Describe what happens to each type of carbohydrate (simple/complex) as it is consumed and processed. Your answer should contain the terms “glycemic index”, “blood insulin”, and “blood glucose”
|
|
Level of exposure to lead appears to be a reliable predictor
: The level of exposure to lead appears to be a reliable predictor of all but which of the follow The number of juvenile offenses The seriousness of juvenile offenses The number of adult offenses The seriousness of adult offenses
|
|
Verify your results using the two-factor portfolio equation
: Verify your results using the two-factor portfolio equation recalculate the average return and standard deviation of the portfolio. Explain why the portfolio standard deviation is less than the average standard deviation of individual securities.
|
|
What are fundamental techniques of scheduling
: What are the fundamental techniques of scheduling? In your opinion, which one is better than the others?
|
|
What is the laplace transform
: What is the Laplace transform of f(t) when f(t) = t2 ? s2 – 1 1/s2 – 1 2/s3 2/s2 None of the above; see Problem Work.
|
|
Laplace transform gives you the impulse response
: What would be the best reason for using the Laplace Transform as a means to solve a complex system analysis problem? (Points : 7) This is the only way to solve complex time functions. The Laplace Transform gives you the most accuracy. Algebra problem..
|
|
Analyze methods utilized for external-internal recruitment
: A hospital in your community is looking for a CLO to head the HR department to create a learning organization as the hospital moves to be a teaching facility. Analyze the methods utilized for both external and internal recruitment and determine which..
|