PowerPoint Presentation
Dr Aziz Hayat
Department of Finance
Deakin University
‹#›
1
. Normal rule of thum
Solution:
within 1 SD of the mean (For normal dist. ~ 68% of returns obs.) -> high Kurtosis
Within 2 SD of the mean (For normal dist. ~ 95% of returns obs.)
Within 3 SD of the mean (For normal dist. ~ 99.7% of returns obs.) -> high Kurtosis
‹#›
. Returns and Sumproduct function in Excel
Calculate continuously compounded returns and the number of observations of the returns in the following ranges using sumproduct function
XXXXXXXXXXSolution: See Excel
Mean -1SD
Mean +1SD
Mean - 2SD
Mean + 2SD
Mean - 3SD
Mean + 3SD
‹#›
c. Random number from Normal distribution: Return distribution
Draw 1000 random numbers from normal distribution with mean= 1% and SD=0.1%.
Solution: In the assignment, use n=size of the returns data, mean=sample mean of the returns data, SD= standard deviation of the returns data.
Method1: Using Data Analysis tool-pack in Excel
Method2: Using µ+σz(0,1) = µ+σNORM.S.INV(Rand())
‹#›
Histogram for Distribution shape
Draw histogram from simulated data done in previous slide.
Solution:
See Excel.
‹#›
d. Try it
‹#›
e. Hypothesis testing
Ho: µ =0 (mean return to be zero)
H1: µ > 0, (mean return to be positive)
Until part e. you can get done within a week time. The next two week lectures will cover part f. and g. of the assignment.
Due to technical nature and that the assignment is to be done individually, the assignment is not that big. Hopefully, you will agree with it once you finished the assignment.
‹#›
Report submitted in word document will be marked.
Please submit a report in word document and not the Excel workings.
You can take picture of Excel workings where necessary to present in the report. For e.g.
XXXXXXXXXXand are calculated in Excel as follows. Note rows are hidden to due space limit.
Report shall contain enough information so the reader can replicate what you have shown.
‹#›
MAF384 – FINANCIAL MODELLING
MAF760 – International Finance
Trimester 1, 2019
ASSIGNMENT 1
The total mark of this assignment is 100, which comprises 20% of the assessment for this
unit.
Due date: 11:59 pm AEST 7 April 2019
Submission Instructions:
• This is an individual assignment.
• Only one assignment per student needs to be submitted online in 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 IT Service
Desk between Monday to Friday 8am-8pm or Weekends 11am-5pm or CALL Internal
phones: 888, Geelong XXXXXXXXXX, Melbourne XXXXXXXXXX, Wa
nambool XXXXXXXXXX
3888 Off-campus XXXXXXXXXXor International XXXXXXXXXX
Write-up instructions:
• 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. Use size 11 font.
• Make sure that your assignment is well presented. Provide the appropriate Excel output
and graphs in 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.
http:
www.deakin.edu.au/its/servicedesk/index.php
http:
www.deakin.edu.au/its/servicedesk/index.php
Foreign exchange rate distribution, and forecasting
You have recently been employed as a financial analyst to advise on the trading strategy for
investing in the Australian dollar in a major Investment bank in Australia. You have been trained
in the importance of foreign exchange rate forecasting stemming 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 into 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 the indirect
quotation from the Australian perspective. Using your skills, knowledge, training, and experience
perform the following tasks:
a. Draw continuously compounded returns of S(USD/AUD) graphically which can extract
information on the distributional characteristics of the returns. What kind of distribution
features you find.
. Using 68–95–99.7 normal rule of thumb, provide evidence that the distribution of the
eturns of S(USD/AUD) is different from the normal.
c. Compare artificially (normally) created returns data with that of the actual returns with a
valid graphical presentation. What characteristics of the returns do you look for to gauge
differences in the two returns?
d. What is your assessment for the directional move of S(USD/AUD) the next day based on
your intuition and then based on a valid statistic?
e. How would you convince your team to advise the client on whether to invest or not to
invest in S(USD/AUD) for the next 30 days? Your argument must be based on an
acceptable hypothesis testing procedure.
f. What can you say about the efficiency of the FX market? Base your discussion on the
following task:
• Estimate the following models for S(USD/AUD):
i. ???? = ?? + ????, Random Walk Model (RWDM)
ii. ???? = ?? + ??????−1 + ????, Autoregressive of order 1 (AR(1)) model
Note: Use last 100 trading days’ data: first 90 observations for estimation window
and the last 10 observations for the holdout period.
• Compute the individual forecasts and composite forecasts of S(USD/AUD) from
the above models in the holdout period. Use regression method for weights in
composite forecasts. Present the forecasting accuracy measures of MAE, MSE,
and RMSE for forecasts. Report the best model for the forecast.
g. Perform a risk assessment analysis for the next 100 days for the USD1 million invested in
AUD in terms of 1% VaR with historical, parametric, and simulated methods. What are
the risk implications for your investments on a daily basis?
h. Video presentation. (Not more than 2 minutes)
• What implications do you draw about the International Finance’s key variable
exchange rate for its distributional characteristics and its market efficiency?
Data source: http:
www.
a.gov.au/statistics/historical-data.html#exchange-rates. The
sample period is beginning in January 2003 to cu
ent. The data frequency is daily.
Marking rule: Refer to the marking ru
ic for details on how this assessment will be marked
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.
XXXXXXXXXXEND OF ASSIGNMENT------------------
http:
www.
a.gov.au/statistics/historical-data.html#exchange-rates