Financial Analysis

Data Sources
Please note: Most of the data that you need I made it available in the Moodle. I uploaded the excel files in the assignment folder on the Moodle
“Data_Assignment”, and a copy of the same data in the Teaching Materials Folder “Data- Assignment”.
Websites
1) International Monetary Fund (IMF): https://data.imf.org/?sk=4c514d48-b6ba-49ed-8ab9-52b0c1a0179b&sId=1409151240976
Interest rates of all countries
https://data.imf.org/regular.aspx?key=61545855
Consumer Price Index of all countries
https://data.imf.org/regular.aspx?key=63087884
Industrial Production Index of all countries
https://data.imf.org/regular.aspx?key=63087884
Gross domestic product (GDP)
Exchange rates by country
https://data.imf.org/regular.aspx?key=61545850
Trade of goods by country
https://data.imf.org/regular.aspx?key=61545859
2) World Bank
https://data.worldbank.org/indicator
GDP growth (annual %)- All countries
https://data.worldbank.org/indicator/BX.KLT.DINV.CD.WD?view=chart
GDP per capita growth (annual %)- All countries
https://data.worldbank.org/indicator/NY.GDP.PCAP.KD.ZG
GDP per capita (current US$)- All countriesLet the excel do the calculation for all periods.
We do the same for other currencies: Euro, GBP, …etc using that currency spot rates and interest rates.
All the time the spot exchange rates, and the forward exchange rates are expressed in dollars per one unit of the foreign currency.
Next
After you’ve done with the data, apply the data to one or more of the principles that we learned in this course such as:
1- IRP
2- PPP
3- Regression to forecast exchange rate
4- forward premium and discount
5- Arbitrage trading using forward/futures contracts
6- Foreign trade and exchange rate
7-….
…….
Make brief analysis in excel and/or graphs and submit in the designated folder “Assignment – Final version”