You are a Global Fund Manager, investing in the stock markets of
Australia, Singapore, Hong Kong, Indonesia and Malaysia on behalf of your
clients. Assume you invest in the broad stock market index in each country
(through exchange listed index funds, for example).
The index values of the overall stock markets of these five countries
during the past five years are given to you on Blackboard in the Excel
spreadsheet âAssignmentData.xlsxâ. This spreadsheet shows the month-end values
of the stock market accumulation indices (which includes reinvested dividends) of
Australia (AORD), Singapore (STI), Hong Kong (HIS), Indonesia (JKSE) and Malaysia (KLSE) for the past five years.
You wish to analyse and evaluate the performances of any three of the five countries for this
period and compare their performances. For this purpose, do the following.
(a) Visually examine the performance
of the three countries you chose by showing the data on tables/graphs/charts as
appropriate.
(b) 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.
(c) Calculate the variances and
standard deviations of the monthly returns of each series. Annualise the
variances and standard deviations.
(d) Calculate the
covariances of the monthly returns between each pair, and the corresponding
correlation coefficients.
(e) Based on your results in (a) to (d) and any further analysis you choose
to do, compare and comment on the country risk return patterns, the relative performances
and correlations across the country returns. Your comments should draw on material
and theories you have learnt in this course. Relate the risk return patterns
and the performances of the markets to relevant events that took place during
this period. Draw on economic, political and market related events (global
and/or country specific) that may have impacted on the performance of each market.
Give bibliographic references to the sources of your information.





