Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Foundations Of Real Estate Financial Modelling

Authors: Roger Staiger

2nd Edition

1138046183, 978-1138046184

More Books

Students also viewed these Finance questions

Question

Describe new developments in the design of pay structures. page 501

Answered: 1 week ago