Question: Now, using the real exchange rate values provided in the excel file, calculate a new series of nominal exchange rate following a general model of

 Now, using the real exchange rate values provided in the excelfile, calculate a new series of nominal exchange rate following a "general

Now, using the real exchange rate values provided in the excel file, calculate a new series of nominal exchange rate following a "general model of exchange rates. Create a time series plot including the actual nominal exchange rate and the exchange rate you calculated using general model of exchange rates by putting year on the horizontal axis and exchange rates on the vertical axis. What do you observe? Which method do you think do a better job in explaining the variations in actual USD/GBP nominal exchange rates? Explain. E_usd/gbp -> actual nominal exchange rate between US dollar and Great Britain pound P_uk -> United Kingdom price level P_us -> US price level q_usd/gbp -> real exchange rate between US dollar and Great Britain pound E_usd/g year bp 1980 1.5044 1981 1.3101 1982 1.1312 1983 0.9810 1984 0.8651 1985 0.8396 1986 0.9498 1987 1.0612 1988 1.1528 1989 1.0602 1990 1.1546 1991 1.1438 1992 1.1431 1993 0.9718 1994 0.9914 1995 1.0216 1996 1.0100 1997 1.0598 1998 1.0725 1999 1.0466 2000 0.9808 2001 0.9317 2002 0.9724 2003 1.0579 2004 1.1863 2005 1.1781 2006 1.1930 2007 1.2956 2008 1.2002 2009 1.0135 2010 1.0000 2011 1.0382 2012 1.0260 2013 1.0123 2014 1.0668 2015 0.9891 2016 0.8772 2017 0.8342 2018 0.8648 2019 0.8263 2020 0.8302 P_uk P_us 33.67 37.79 37.67 41.70 40.91 44.25 42.80 45.68 44.92 47.64 47.65 49.33 49.28 50.27 51.33 52.11 53.46 54.23 56.54 56.85 61.10 59.92 65.66 62.46 68.67 64.35 70.43 66.25 71.99 67.98 73.93 69.88 76.04 71.93 77.71 73.61 79.13 74.76 80.52 76.39 81.47 78.97 82.72 81.20 83.97 82.49 85.13 84.36 86.31 86.62 88.12 89.56 90.28 92.45 92.44 95.09 95.69 98.74 97.57 98.39 100.00 100.00 103.86 103.16 106.53 105.29 108.97 106.83 110.55 108.57 110.96 108.70 112.08 110.07 114.94 112.41 117.58 115.16 119.62 117.24 120.81 118.69 q_usd/gbp 1.319 1.234 1.064 0.933 0.841 0.828 0.917 1.018 1.109 1.056 1.130 1.185 1.181 1.037 1.043 1.033 1.026 1.133 1.107 1.117 1.092 1.008 1.018 1.042 1.137 1.132 1.148 1.223 1.113 0.958 1.000 1.051 1.062 1.046 1.096 1.035 0.895 0.851 0.875 0.847 0.837

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!