Let 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