Suppose you conduct currency carry trade by borrowing $1,000,000 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 20002009. Note that interest rates are one-year interbank rates on January 1 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$1.9128/$ on January 1, 2000. Fill out columns 4 7 and compute the total dollar profit from this carry trade over the 10-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.

Year nz$(%) i$(%) SNZ$1$ NZ$ - is enz$1$ (4) (5) $ Profit 2000 6.93 6.70 2.2639 2001 7.10 6.20 2.4055 2002 5.31 2.64 1.9157 2003 6.34 1.65 1.5270 2004 6.28 1.66 1.3885 2005 7.07 3.30 1.4722 2006 7.68 5.04 1.4222 2007 8.43 5.53 1.3034 2008 9.50 4.42 1.7152 2009 5.50 2.20 1.3782 Year nz$(%) i$(%) SNZ$1$ NZ$ - is enz$1$ (4) (5) $ Profit 2000 6.93 6.70 2.2639 2001 7.10 6.20 2.4055 2002 5.31 2.64 1.9157 2003 6.34 1.65 1.5270 2004 6.28 1.66 1.3885 2005 7.07 3.30 1.4722 2006 7.68 5.04 1.4222 2007 8.43 5.53 1.3034 2008 9.50 4.42 1.7152 2009 5.50 2.20 1.3782