Question: I do not know the steps to start/finish the below problem, if you could help me out it would be greatly appreciated! Carry trade was

I do not know the steps to start/finish the below problem, if you could help me out it would be greatly appreciated!

Carry trade was mostly done by borrowing in Japan and lending in England due to the depreciated nature of the Yen at the time, coupled with high interest rates in England and a very appreciated Pound. Use the data in the spreadsheet to decide if you can also arbitrage between New Zealand and Japan. Suppose you borrow 1,000,000 [JPY] and lend in New Zealand at three months. Answer by interpreting a histogram with the frequency of gains/losses when arbitraging, use interest rate parity. Include histogram and frequency table in your answer.

Frequency: Monthly
observation_date japan yield (%) New Zealand yield (%) jpy/usd usd/nzd jpy /nzd e0 (jpy/nzd) e1 (jpy/nzd) e1/e0 (1+rh)/(1+rf)
1973-01-01 4.1530 7.88 301.7882 1.2016 362.62
1973-02-01 4.1530 8.38 278.4206 1.2718 354.09
1973-03-01 4.9140 8.75 261.9014 1.3441 352.01
1973-04-01 4.9140 9 265.4914 1.3410 356.04
1973-05-01 4.9140 9 264.6505 1.3426 355.31
1973-06-01 5.4250 9.13 264.4981 1.3393 354.24
1973-07-01 5.5490 9.41 264.5538 1.3685 362.04
1973-08-01 5.5490 10 265.2200 1.3682 362.88
1973-09-01 5.5490 11.25 265.4747 1.4592 387.37
1973-10-01 5.8030 12.38 266.3348 1.4900 396.84
1973-11-01 5.8030 13.75 278.2625 1.4776 411.16
1973-12-01 5.8030 12.75 280.1775 1.4506 406.44
1974-01-01 6.8250 11 298.1336 1.4140 421.55
1974-02-01 6.8250 9.75 291.0872 1.4090 410.15
1974-03-01 6.8250 9.88 282.1648 1.4488 408.81
1974-04-01 6.8250 11 277.7741 1.4661 407.25
1974-05-01 6.8250 9.25 278.9664 1.4748 411.41
1974-06-01 6.8250 8.25 282.9700 1.4685 415.54
1974-07-01 6.8250 8 290.9800 1.4666 426.75
1974-08-01 6.8250 7 302.2836 1.4540 439.52
1974-09-01 6.8250 7.13 299.0840 1.4148 423.14
1974-10-01 6.8250 7.63 299.3645 1.3178 394.49
1974-11-01 6.8250 7.25 300.0750 1.3169 395.16
1974-12-01 6.8250 7.13 300.4114 1.3241 397.77
1975-01-01 6.8250 7.18 299.6845 1.3338 399.73
1975-02-01 6.8250 6.25 291.6583 1.3496 393.61
1975-03-01 6.8250 7.38 287.9486 1.3598 391.54
1975-04-01 6.8250 8.25 292.1968 1.3429 392.40
1975-05-01 6.3140 8.13 291.4305 1.3336 388.66
1975-06-01 6.3140 7.75 293.4662 1.3271 389.45
1975-07-01 6.3140 7.25 296.3741 1.2931 383.25
1975-08-01 6.0590 8.4 297.9762 1.1241 334.96
1975-09-01 6.0590 8.45 299.9090 1.0696 320.78
1975-10-01 5.6770 9.75 302.3364 1.0601 320.50
1975-11-01 5.6770 9.63 302.5453 1.0596 320.56
1975-12-01 5.6770 9.25 305.6700 1.0507 321.17
1976-01-01 5.6770 10.38 304.6357 1.0525 320.64
1976-02-01 5.6770 12 301.5944 1.0536 317.77
1976-03-01 5.6770 13.13 300.5183 1.0402 312.59
1976-04-01 5.6770 15 299.1086 1.0166 304.07
1976-05-01 5.6770 14.5 299.0040 1.0037 300.12
1976-06-01 5.6770 14.63 299.1909 0.9901 296.24
1976-07-01 5.6770 13.5 294.6410 0.9981 294.07
1976-08-01 5.6770 14.3 290.6259 1.0055 292.24
1976-09-01 5.6770 15.63 287.3610 1.0035 288.37
1976-10-01 5.6770 14.25 291.1890 0.9754 284.03
1976-11-01 5.6770 13.75 295.1653 0.9645 284.69
1976-12-01 5.6770 12.13 294.7017 0.9289 273.75
1977-01-01 5.6770 11.5 291.0524 0.9594 279.23
1977-02-01 5.6770 11.5 285.0221 0.9618 274.13

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 Finance Questions!