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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started