You are a fund manager of an investment bank in the UK. You are planning to construct a portfolio using the following currencies: JPY/GBP and SGD/GBP. You wish to examine and critically evaluate the performance of these currencies from 1 May 2019 to 2 May 2020. For this purpose, you are required to conduct some analyses and write a 3000-word report.
PART A (40%)
- UseBank of England, Yahoo! Finance and any other websites that offer historical spot foreign exchange data to extract the daily closing currency values from 1 May 2019 to 2 May 2020.
- Calculate the following:
(a) The daily rate of returns for each of the currencies.Visually examine the performance of the value of the currency and the daily rate of returns for each of the currencies by showing the data on graphs or charts as appropriate.
(b) The mean returns for each of the currencies.
(c) The variance and standard deviation of returns for each of the currencies.
(d) The covariance of returns between each pair of the currencies.
(e) The correlation coefficients of returns between each pair of the currencies
- Based on your results from (a) to (e) and any further analysis you may wish to do, compare and comment the risk and return patterns and characteristics for each of the currencies. Your comments should draw on materials and theories you have learnt in this module. Relate the performance of the currencies to relevant events (e.g. economic, financial or political events) that took place during this period and discuss how they hadinfluenced the performance for each of the currencies. You must give bibliographic references to the sources of your information.
PART B (40%)
This section requires you to construct an equally weighted portfolio of the currencies selected above.
- Calculate the following:
(a) The daily rate of returns ofthe portfolio. Visually examine the performance of the returnsfor the portfolio and each of the currencies by showing the data on graphs or charts as appropriate.
(b) The mean, variance and the standard deviation of the portfolio returns.
(c) The covariance and correlation coefficients of returns between each currency and the portfolio.
(d) The coefficient of variation of returns for each currency and the portfolio.
- Based on your results from (a) to (d),examine and compare the performance of your equally weighted portfolio returns with those of the individual currencies. Comment on your observations, relating to the portfolio theory, and discuss the benefits of diversification across these currencies. You may also apply the portfolio evaluation techniques to evaluate critically the performance of your portfolio with those of the individual currencies.
PART C (20%)
This section requires you to draw a conclusion of the portfolio construction and analysis above.
From the viewpoint of a fund manager who wishes to determine whether the currencies that you examined are worth investing in, how useful is the portfolio analysis that you carried out? What limitations do you see in your analysis and results? What further analysis would you wish to carry out?
- There are THREEsections on the assessment. You must attempt all sections. The total mark for all sections is 100 marks.
- You must show all appropriate working using EXCEL and present allspreadsheets as an Appendix in the report. There must be a clear reference made to the content of your work.
- The report can only be completed by you. An assignment feedback form must be attached at the front page after the cover sheet of your report. A copy of the assignment feedback form can be downloaded from:
- The University takes unfair practice seriously. Unfair practice can take many different forms. Plagiarism is only one example. The University defines plagiarism as using without acknowledgement another person’s words or ideas and submitting them for assessment as though it were one’s own work, for instance by copying, translating from one language to another or unacknowledged paraphrasing. Further information on plagiarism can be found in:
The other examples of unfair practice are collusion and fabrication of data. The University defines collusion as when work that has been undertaken by or with others is submitted and passed off as solely as the work of one person. This also applies where the work of one candidate is submitted in the name of another. Where this is done with the knowledge of the originator both parties can be considered to be at fault. Fabrication of data can be defined as making false claims to have carried out experiments, observations, interviews or other forms of data collection and analysis, or acting dishonestly in any other way.
Unfair Practice is regulated under the Academic Handbook that are explained in:
- The report must be submitted as a single Word file. It must be uploaded to the Moodle onthe date and time to be specified by the School.
All sources of references cited in the text should be acknowledged (preferably using Harvard style of referencing). Paper size is A4 with margin in all directions of 2.54cm and font size 12. Line spacing may be single or 1.5 times. Format of the report:
- Section Heading
i. The numbering of headings will be in Arabic numerals.
ii. Headings will be located at the left margin.
iii. Headings may be in capitals or a combination of upper and lower case (i.e. Capitalise the First Letter of Main Words).
- Table /Figure Heading
i. Tables /Figures must be numbered (e.g. Figure 1 or Table 1).
ii. Every table /figure will have a title.
iii. The title will be located at the left margin.
iv. The title may be in capitals or a combination of upper and lower case (i.e. Capitalise the First Letter of Main Words.
The report (including text, formulas, all tables and diagrams; excluding cover page, content page and list of references) must not exceed 3000 words. A word count must be stated at the end of your report. Anything beyond this will be ignored in the assessment process.
GUIDANCE ON ASSESSMENT MARKING
The postgraduate general band descriptors for guidance on assessment marking can be found in: