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 US 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 each year and that the exchange rate is the amount of New Zealand dollar per US dollar on December 31 each year. The exchange rate was NZS19094/5 on January 1, 2000. Fill out columns 4 - 7 and compute the total collar 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 ON S Profit Year 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 wzs(%) 659 6.76 4.97 6.00 594 673 734 8.09 9 16 5.16 653 6.03 2.47 1.48 149 3.13 487 5 36 4.25 203 SZ 22605 2 4021 19123 1.5236 13851 1.4688 14188 1 3000 17118 1.3748 NS- 0.06 0.731 250 4.52 445 360 247 2731 491 18 39 6.26 -20 39 -20.33 -909 6.041 -3.40 -8.37 31 68 -19.69 (4) -(5) -1833 -553 2289 2485 1354 2441 5.87 11.10 26 77 2282 3.13