代写FINS5516 - International Corporate Finance Term 1, 2024代做Statistics统计

FINS5516 - International Corporate Finance

Term 1, 2024

Data Exercise Assignment

DUE: Monday 15 April 2024, 0:00 (Sydney, Australia time)

(Sunday 14 April 2024, 12pm)

Weighting

This assessment is worth 25% of your final grade for FINS5516 一 International Corporate Finance. Next to each question is the allocation of marks. There are a total of 50 marks for this assignment.

Assignment Learning Objectives

The purpose behind this assignment is to get students to:

1.   apply and assess the relevance of the International Parity Conditions and Purchasing Power Parity (PPP) Theory in a practical setting,

2.   think outside the textbook and homework questions framework,

3.   conduct their own research,

4.   using actual data and statistical methods (regression and regression analysis),

5.   explore and visualize macroeconomic data and improve their familiarity with statistical tools in Microsoft Excel.

This assignment is designed to give students an insight into how economists and analysts in industry approach the topic of exchange rate modelling.

This assignment is individual work and must be submitted as individual work only.

IT IS RECOMMENDED THAT STUDENTS WORK ON THIS ASSIGNMENT FREQUENTLY. CRAMMING AT THE LAST MOMENT IS A BAD STRATEGY.

FINS5516 - Data Exercise Assignment

The LIC will randomly assign each student one of five countries in the list below:

1.  Canada (CAD)

2.   Germany (EUR)

3.   Japan (JPY)

4.   Mexico (MXN)

5.   Thailand (THB)

Once assigned a country, the student will analyse the exchange rate eh/f comprising that country's currency in relation to that of the United States (USD). The USD is the base currency irrespective of which currency you have been allocated. Thus, if you are assigned Thailand, then you need to complete the data exercise assignment on the THB/USD exchange rate.

Download the Excel file uploaded on Moodle to see which country you have been allocated.

Section 1 - Qualitative Analysis.

You are constructing a regression model to forecast an estimate of the exchange rate. You expect changes in future exchange rates depend on a set of key macroeconomic variables:

-      the countries' real GDP growth rates

-      the inflation rate differential

-      long-term interest rate differential

Answer the following questions below. The limit for each question is 150 words.

1.1  一 What are the exchange rate systems in both countries? Are there any differences between the two countries' foreign exchange systems over the sample period? (1 mark)

1.2   一 Comment on the reputation of each country's central bank and its degree of independence. (2 marks)

1.3   一 Using the most recently available data, what are the sovereign credit ratings for the two countries you have been assigned? What might be driving these differences? What issues could this create from a MNC's perspective? (3 marks)

1.4   一 What is your assessment of the degree of political risk within both countries? Are   there any recent examples of political risk? What are possible methods for hedging against such risk? (3 marks)

Section 2 - Downloading the Data and Setting up the Excel File.

2.1   一 Using FACTSET, obtain quarterly data from 2001Q1 to 2023Q3 on:

-      The exchange rate eh/f you have been randomly assigned.

-     Economic growth rates for both countries, defined as the year-on-year % change in real GDP.

-      Inflation rates for both countries, defined as the year-on-year % change in the CPI.

-      Long-term interest rates for both countries.

2.2  一 Using the data you collected from FACTSET, calculate the following:

-     The change in exchange rates over (i) 1 quarter, (ii) 1 year, and (iii) 3 years. These

must be forward looking. Calculating a forward-looking change in the exchange rate is best illustrated by an example. Thus, for example, the one-quarter change in the

exchange rate, eh/∫, for December 2022 is:

-

-     Economic growth rates for both countries as a decimal. This is done by dividing the FACTSET value by 100.

-     The inflation rate differential as a decimal (ensure that you divide the FACTSET value by 100), which for simplicity, we define as the term currency rate (h) less the base currency rate (f).

-     The long-term interest rate differential as a decimal (ensure that you divide the

FACTSET value by 100), which for simplicity, we define as the term currency rate (h) less the base currency rate (f).

Section 3 - Data Exploration and Visualisation

Using the data you collected from FACTSET, answer the following questions (limit for each question is 100 words):

3.1  一 What is the average exchange rate over your sample period? (1 mark)

3.2  一 What is the average year-on-year percent change in real GDP for each country assigned over the entire sample period? (1 mark)

3.3  一 What is the average inflation rate for each country assigned over the entire sample period? (1 mark)

3.4  一 What is the average long-term interest rate for each country assigned over the entire sample period? (1 mark)

Analysts use charts and graphs they normally paste from a spreadsheet into a presentation to analyse and communicate insights in their everyday work. Data can be better understood and more compelling for colleagues and clients by presenting them in a visual context in a   simple and logical manner.

3.5  一 Plot the quarterly exchange rate over your sample period in a line chart. Do not use the default graph from FACTSET. You need to use the functions in Excel to complete this section and ensure it is labelled and easy to comprehend. (1 mark)

Identify a period of significant increase or decrease in the exchange rate. What factors might have contributed to such changes? (2 marks)

3.6  一 Compare the differences in GDP growth rates over the sample period for both countries in a chart of your choice and provide comments on any large differences over the period. (2 marks)

3.7  一 Plot the inflation rate and long-term interest rate for the term currency country over the sample in a chart. Repeat this for the base currency country. What does each graph show regarding the relation between these two rates? Is it consistent with the Fisher Effect? (3 marks)

Section 4 - Regression Modelling

4.1  一 Consider the following econometric structural model of the change in the exchange rate:

∆eℎ/f.t  = β0  + β1 GDP,t  + β2 GDPf,t  + β3 InfRDt  + β4IntRDt  + εt

where

∆eh/f.t  is the percentage change in the exchange rate over period t.

∆GDPt  is the annual percentage growth rate in real GDP over period t.

InfRDt  is the inflation rate differential for period t.

IntRDt  is the interest rate differential for period t.

εt  is the error term for period t.

Using linear regression, obtain the coefficient estimates for each of the 3-time horizons. You need to report for each time-horizon, ALL coefficient estimates, p-values, Adjusted R-squares, F-statistics (and p-value) in one table, so the grader is able to see your results in your written submission (rather than the Excel file). (4 marks)

4.2  一 Analyse the statistical significance of the coefficient estimates at the 5% level. You are to provide a summary/high-level analysis of the key results. Word limit: 150 words. (3 marks)

4.3  一 Consider both the p-value from the F-test (at the 5% level of significance) and the adjusted R-squared as the forecast horizon increases from 1 quarter to 3 years. Provide some commentary and discuss whether such results (across the 3 models) are consistent with PPP theory. Word limit: 150 words. (4 marks)

4.4  一 Which macroeconomic variables from the model you have estimated are considered economically important for modelling changes in the exchange rate? Are you surprised by these results? Are they consistent with PPP theory? Word limit: 150 words. (5 marks)

4.5  一 One potential issue the analyst faces when using multiple linear regression analysis is the multicollinearity of the independent variables. Verify whether or not multicollinearity exists among the independent variables. This is done by examining the correlation between each of the independent variables. Think of this as a correlation matrix (must be included in your document) which can be easily performed in Excel using the “Data Analysis” tool pack. If the independent variables are highly correlated, then the analyst is unable to isolate the effect of each independent variable on the dependent variable. Thus, analysis essentially becomes pointless. Word limit: 100 words. (3 marks)

Section 5 - Forecasting 5.1 一 Using the latest values of the key macroeconomic variables forecast the estimated change in the exchange rate:

a)   1-quarter ahead,

b)   1-year ahead

c)   3-years' ahead

Report the magnitude of the forecasts for each regression model in no more than  two sentences. Provide brief commentary (no more than one sentence) as to whether the currency you have been assigned is forecast to depreciate or appreciate against the USD over each forecast horizon. (3 marks)

5.2  一 Do you think that the structural  model (Equation  1) is a useful model for modelling changes in the exchange rate? What are some of its limitations? Irrespective of your answer, what  other  independent  variable would  you  include  in  Equation  1?  Provide  at  least  one economic reason for that variable's inclusion. You should also provide commentary indicating what relationship this variable has with the change in the exchange rate (that is, the dependent variable). Word limit: 150 words. (3 marks)

Additional Information

Note 1: Grammar, Spelling, Punctuation and Style.

1.   Four marks out of the 50  marks will be allocated to grammar, spelling, and overall professionality of the responses and ensuring that all data and calculations in the Excel file are expressed to 3 decimal places. You need to ensure that your work is polished and contains  NO errors.  Remember you are presenting your work. When you are working professionally, the market expects high quality output.

2.   If you use sources in your answers, ensure that you formally cite them. The style of referencing is for you to decide.

3.   Plagiarism is not tolerated. Your answers must be written by you and only you. Turnitin has a similarity indicator that reports a percentage similarity score. Submissions with similarity scores should not be greater than 15% if they are written in your own words.

Turnitin includes the cover sheet and your references list in its calculation of its similarity score. However, the grader will be able to filter this out and see the percentage similarity score based only on the student's written responses.

Note 2: Data Exercise Assignment Submissions and Responses.

1.   Students will only  be permitted to submit their data exercise assignment ONCE in Turnitin. There are NO multiple submission options permitted. What is submitted first will be graded.

2.   There is NO grace period for any submissions.

3.   Lengthy responses to questions will result in only the first 150 words of each part (or whatever the word limit is for that section) being graded.

4.   If a student submits their data exercise assignment on an exchange rate other than the exchange  rate they were  assigned, then they  have  not followed  instructions. The maximum grade a student will then obtain is 60% for this assessment.

5.   If a student submits their data exercise assignment via the incorrect Turnitin submission link, then 1 mark will be deducted.

6.  You must type your answers and submit as a PDF document via Turnitin. Ensure that the cover sheet  is attached with your submission. See  Moodle for cover sheet. A submission without the cover sheet will result in 1 mark being deducted. If your submission is not submitted in PDF format, 1 mark will be deducted.

7.   Submit your Excel file with the calculations. Failure to submit the Excel file will result in a deduction of 5 marks.

8.   The School of Banking and Finance's policy stipulates late submissions will attract a 5% penalty  per  day  following  the  assignment  due  date  (weekend  days  included). A submission made one week (that is, 7 days) after the specified due date will result in a grade of 0.

The LIC reserves the right to add to this list in light of changing conditions. Any changes made will be communicated with students as an announcement via the Moodle webpage.





热门主题

课程名

mktg2509 csci 2600 38170 lng302 csse3010 phas3226 77938 arch1162 engn4536/engn6536 acx5903 comp151101 phl245 cse12 comp9312 stat3016/6016 phas0038 comp2140 6qqmb312 xjco3011 rest0005 ematm0051 5qqmn219 lubs5062m eee8155 cege0100 eap033 artd1109 mat246 etc3430 ecmm462 mis102 inft6800 ddes9903 comp6521 comp9517 comp3331/9331 comp4337 comp6008 comp9414 bu.231.790.81 man00150m csb352h math1041 eengm4100 isys1002 08 6057cem mktg3504 mthm036 mtrx1701 mth3241 eeee3086 cmp-7038b cmp-7000a ints4010 econ2151 infs5710 fins5516 fin3309 fins5510 gsoe9340 math2007 math2036 soee5010 mark3088 infs3605 elec9714 comp2271 ma214 comp2211 infs3604 600426 sit254 acct3091 bbt405 msin0116 com107/com113 mark5826 sit120 comp9021 eco2101 eeen40700 cs253 ece3114 ecmm447 chns3000 math377 itd102 comp9444 comp(2041|9044) econ0060 econ7230 mgt001371 ecs-323 cs6250 mgdi60012 mdia2012 comm221001 comm5000 ma1008 engl642 econ241 com333 math367 mis201 nbs-7041x meek16104 econ2003 comm1190 mbas902 comp-1027 dpst1091 comp7315 eppd1033 m06 ee3025 msci231 bb113/bbs1063 fc709 comp3425 comp9417 econ42915 cb9101 math1102e chme0017 fc307 mkt60104 5522usst litr1-uc6201.200 ee1102 cosc2803 math39512 omp9727 int2067/int5051 bsb151 mgt253 fc021 babs2202 mis2002s phya21 18-213 cege0012 mdia1002 math38032 mech5125 07 cisc102 mgx3110 cs240 11175 fin3020s eco3420 ictten622 comp9727 cpt111 de114102d mgm320h5s bafi1019 math21112 efim20036 mn-3503 fins5568 110.807 bcpm000028 info6030 bma0092 bcpm0054 math20212 ce335 cs365 cenv6141 ftec5580 math2010 ec3450 comm1170 ecmt1010 csci-ua.0480-003 econ12-200 ib3960 ectb60h3f cs247—assignment tk3163 ics3u ib3j80 comp20008 comp9334 eppd1063 acct2343 cct109 isys1055/3412 math350-real math2014 eec180 stat141b econ2101 msinm014/msing014/msing014b fit2004 comp643 bu1002 cm2030
联系我们
EMail: 99515681@qq.com
QQ: 99515681
留学生作业帮-留学生的知心伴侣!
工作时间:08:00-21:00
python代写
微信客服:codinghelp
站长地图