MAF760 – International Finance
Trimester 3, 2015
The total mark of this assignment is 100, which comprises 30% of the assessment of this unit.
Due date: 5pm Friday 15 January 2016
• This is a group assignment consisting of only 2 students. Clearly mention the name and student ID of two students and as well as the tutor(s) name on the Faculty standardized assignment cover sheet.
• Only one assignment per group needs to be submitted online on Cloud Deakin.
• The electronic copy of the assignment has to be uploaded to CloudDeakin by the due date. If you experience any problem in uploading the document, please contact the DSO help line on 1800 721 720 or go to the website at: http://www.deakin.edu.au/its/servicedesk/
• Late assignments will lose marks at the rate of 10% of the overall mark per day.
• You are to hand in a (word) document that lists the number and part of each question (e.g.
a., b.(I.)) followed by your answer. Do not repeat the question. Verbose and overly long answer of a question is not appreciated. Use size 11 font.
• Make sure that your assignment is well presented. Provide the appropriate Excel output and graphs into your assignment report. Make sure that all your graphs and tables are clearly labelled.
• Contact a staff member if you have any further queries regarding the assignment.
Foreign exchange rate distribution, and forecasting
You are recently employed as financial analysts to advice on the trading strategy for investing in Aussie dollar in the major Investment bank in Australia. You have been trained the importance of foreign exchange rate forecasting stems from the fact that the outcome of the bank’s decision taken now is contingent upon the value of the exchange rate prevailing sometime in the future, which you aim to forecast with utmost accuracy.
The bank’s decisions pertain to a variety of activities, including speculation, hedging, investment, financing, pricing and strategic planning. Your forecast also feeds in the Technical Analysis and Mechanical Trading Rules Department of the bank which reports buy and sell signals.
Your first assignment is to perform a thorough analysis using the foreign exchange rate between Australian and the US, S(USD/AUD). You note that the exchange rate is expressed in indirect quotation from the Australian perspective. Using your skills, knowledge, training, and experience perform the following tasks:
a. Obtain continuously compounded daily returns of S(USD/AUD) exchange rate. Draw a histogram and comment on the graph. (6 marks)
b. Calculate the mean and the standard deviation of daily returns and obtain the percentage of the values that are within
I. one standard deviation of the mean,
II. two standard deviations of the mean, and
III. three standard deviations of the mean. (10 marks)
c. Based on part b, do you think that the distribution of the daily returns have a thicker tail than the Normal distribution. (4 marks)
d. What are the probabilities of the following moves by S(USD/AUD) the next day?
I. AUD will appreciate
II. AUD will depreciate
e. Test whether the average return on S(USD/AUD) of the last 30 days is significantly different from zero at the 5% level of significance. (5 marks)
f. Simulate returns using the sample size, mean, and standard deviation of S(USD/AUD).
Assume normality for the returns data. (5 marks)
g. Draw a histogram and compare it with the corresponding histogram in part a. above.
What differences do you observe? (5 marks)
h. Estimate the following models for USD/AUD returns leaving out the last one week data:
I. 𝑟𝑟𝑡𝑡 = 𝜇𝜇 + 𝜀𝜀𝑡𝑡, Random Walk Model (RWM)
II. 𝑟𝑟𝑡𝑡 = 𝜇𝜇 + 𝜌𝜌𝑟𝑟𝑡𝑡-1 + 𝜀𝜀𝑡𝑡, Autoregressive of order 1 (AR(1)) model
Note: Use last 100 trading days’ data. (10 marks)
i. Compute the forecast of S(USD/AUD) from the above models in the hold out period. (10 marks)
j. Calculate MAE, MSE, RMSE of the forecasts made in part i. above and report the best model for the forecast. (10 marks)
k. Compute composite forecast of the exchange rate from AR(1) and log(𝑆𝑆𝑡𝑡) = 𝜇𝜇 + 𝛽𝛽𝛽𝛽 +
𝜀𝜀𝑡𝑡, where 𝑆𝑆𝑡𝑡 is S(USD/AUD). Estimate weights from regression. (10 marks)
l. Highlight an international finance issue that you would like to do the research on in future if you get an opportunity whether in a research department of a major invest bank or in PhD studies. Please limit the write-up to two A4 pages with minimum font size of
11. (10 marks)
m. Using last 100 days USD/AUD data, calculate one day 1%VaR of USD1 million invested in AUD using historical and parametric approaches. (5 marks)
n. Video presentation. (Not more than 5 minutes) (5 marks)
I. Highlight what you have learned from the assignment II. Mention who contributed what.
Data source: http://www.rba.gov.au/statistics/historical-data.html#exchange-rates. The sample period is beginning January 2003 to date.
Hints: Continuously compounded returns are defined as the ratio of log(et/et-1)*100, where e is the exchange rate. In part b, you can use the “SUMPRODUCT( )” function in Excel to look for the observations that are within certain range.
Use Microsoft Excel for computations.
--------------------END OF ASSIGNMENT------------------