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
Get step-by-step solutions from verified subject matter experts
