Required:

Suppose you conduct currency carry trade by borrowing $$1$ million at the start of each year and investing in the New Zealand dollar for one year. One$-$year interest rates and the exchange rate between the U$.$S$.$ dollar $($$$)$ and New Zealand dollar $($NZ$$)$ are provided below for the period $2000-2009.$ Note that interest rates are one$-$year interbank rates on January $1^{st}$ each year, and that the exchange rate is the amount of New Zealand dollar per U$.$S$.$ dollar on December $31$ each year. The exchange rate was NZ $$\frac{1\mathrm{.}9088}{\text{\$}}$ on January $1,2000.$ Fill out columns $(4)-(7)$ and compute the total dollar profits from this carry trade over the ten$-$year period. Also, assess the validity of uncovered interest rate parity based on your solution of this problem. You are encouraged to use the Excel spreadsheet software to tackle this problem.

Note: Negative value should be entered with a minus sign. Enter profit value answers in dollars, rather than in millions of dollars. Do not round intermediate calculations. Round interest rate spread, rate of appreciation, and difference between the two to $2$ decimal places. Round profit values to nearest dollar value.

$\backslash$table$[[$Year$,i_{NZS}(\%),i_{\text{\$}}(\%),S_{NZ\frac{\text{\$}}{\text{\$}}},i_{NZ\text{\$}}-i_{\text{\$}},e_{N\frac{Z}{S}},(4)-(5),$$ Profit$],[2000,6\mathrm{.}53,6\mathrm{.}50,2\mathrm{.}2599,0\mathrm{.}03,,,],[2001,6\mathrm{.}70,6\mathrm{.}00,2\mathrm{.}4015,0\mathrm{.}70,6\mathrm{.}27,-5\mathrm{.}57,],[2002,4\mathrm{.}91,2\mathrm{.}44,1\mathrm{.}9117,2\mathrm{.}47,-20\mathrm{.}40,22\mathrm{.}87,],[2003,5\mathrm{.}94,1\mathrm{.}45,1\mathrm{.}5230,4\mathrm{.}49,-20\mathrm{.}33,24\mathrm{.}82,],[2004,5\mathrm{.}88,1\mathrm{.}46,1\mathrm{.}3845,4\mathrm{.}42,,,],[2005,6\mathrm{.}67,3\mathrm{.}10,1\mathrm{.}4682,3\mathrm{.}57,6\mathrm{.}05,-2\mathrm{.}48,],[2006,7\mathrm{.}28,4\mathrm{.}84,1\mathrm{.}4182,2\mathrm{.}44,,,],[2007,8\mathrm{.}03,5\mathrm{.}33,1\mathrm{.}2994,2\mathrm{.}70,-8\mathrm{.}38,11\mathrm{.}08,],[2008,9\mathrm{.}10,4\mathrm{.}22,1\mathrm{.}7112,4\mathrm{.}88,31\mathrm{.}69,-26\mathrm{.}81,],[2009,5\mathrm{.}10,2\mathrm{.}00,1\mathrm{.}3742,3\mathrm{.}10,-19\mathrm{.}69,22\mathrm{.}79,]]$