Q1 calculate the discrete monthly rates of returns using

Reference no: EM13380946

Q1. Calculate the discrete monthly rates of returns. Using the monthly returns, calculate the arithmetic mean monthly return and the geometric mean monthly return of each series for the overall period. Convert the mean returns to annualised returns.

Q2. Calculate the variances and standard deviations of the monthly returns of each series. Annualise the variances and standard deviations

Q3. Calculate the covariances of the monthly returns between each pair, and the corresponding correlation coefficients.

Q4. Based on the annualised returns and variances calculated, compute the rates of return and the variances of two- country equally weighted portfolios and the three-country equally weighted portfolio you can form from the three country indices. Make use of your knowledge of matrix algebra for your calculations.

Q5. Determine the optimal asset allocation to make across the three stock markets, by computing and examining the efficient portfolio frontier and the minimum variance portfolio

Q6. Interpret and comment on the results in (a) above, how do they compare with your results for the portfolios examined in Part 2? Comment on your observations.

Attachment:- Data.xlsx

Reference no: EM13380946

Questions Cloud

Laptop plc is planning on setting up a laptop repair centre : laptop plc. is planning on setting up a laptop repair centre. they estimate thatthe required investment will be

1 explain the process of financial planning used to : 1. explain the process of financial planning used to estimate asset investment requirements for a corporation. explain

Question 1james and john can afford to invest 6000 annually : question 1.james and john can afford to invest 6000 annually in a fund that earns 3 compounded annually.nbspnbspnbspa

Barbow enterprises inc is considering an expansion in their : barbow enterprises inc. is considering an expansion in their operations. one of the first items they want to examine is

Q1 calculate the discrete monthly rates of returns using : q1. calculate the discrete monthly rates of returns. using the monthly returns calculate the arithmetic mean monthly

21st century cat is a film producing company which is : 21st century cat is a film producing company which is contemplating the productionof a new film. they estimate thatthe

Kingsley products ltd is using a model 400 shaping machine : kingsley products ltd. is using a model 400 shaping machine to make one of its products. the company is expectingnbsp

Jane stevens is 30 years old and she is reviewing her : jane stevens is 30 years old and she is reviewing her retirement plans. she currently has 20000 in a retirement

You have been asked to write a financial risk brief report : you have been asked to write a financial risk brief report for first national banks senior management. your work should

User Account

All Pages