Question: 1 Instructions: Please read the data definitions in the spreadsheet. You may want to compute means, medians,and standard deviations of the data you produce. For this exercise, we will mainly work in logged rates.(https://goo.gl/Dso1ix)
Answer the following questions in 5 pages or less, plus supporting exhibits if necessary/desired.
2 Case Study Questions
1. What is the quoted currency?
2. What does one learn from the data in column I about the JPY vs. the USD over this time period?
3. In column K, Compute an estimate of the real 90 Day Euro Yen Rate. In column L, Compute an estimate of the real 90 Day Euro Dollar Rate. In column M, compute the difference in these real rate estimates (Japan minus US). Describe what you learn from these data, and what they imply for the borrowing program at BID.
4. Discuss the relationship between inflation and interest rates in each currency.
5. In column N, compute the natural logarithm of the spot exchange rate. In column O, compute the natural logarithm of the 3 month forward exchange rate. In Column P, compute the difference between the natural logarithm of the 3 month forward exchange rate and the natural logarithm of the realized spot exchange rate ln(Et+3), where Et+3 refers to the spot rate 3 months ahead. What do you learn from these data?
6. In column Q, compute the difference between the 3 month nominal interest rates in Japan and the US (Japan minus US). In column R, compute the difference between column Q, and the quarterly forward premium in column I. This is (R JPY-RUSD)-ln(F/E). What do you learn from these data?
7. In column S, compute the difference between (Japanese quarterly inflation US quarterly inflation) and (ln(Et+3)-ln(Et)). What do you learn from these data?
8. Compute the following: 3 month JPY interest rate-3 month dollar interest rate+ln(Et)-ln(Et+3). This is equivalent to (RJPY-RUSD)-ln(Et+3/Et). What do you learn from these data?
9. How should BID analyze its effective borrowing costs? Under what circumstances should BID expect to prefer borrowing in one currency rather than the other? If it were issuing the note now (at the end of the data update), what would you recommend it to do?
Information related to above question is enclosed below:
Attachment:- EF4331_casestudy01_data.rar