Abstract
In a currency carry trade, an investor borrows money in a low interest rate currency and invests in a high interest rate currency. The trade is profitable if the future exchange rate does not adjust to the interest rate differential. After downloading exchange rate data, a Monte Carlo simulation of a carry trade is performed in Excel based on a normal distribution and the data’s mean and standard deviation. A bootstrapping carry trade simulation exercise is also generated by randomly selecting observations from the historical data. In contrast to the Monte Carlo simulation, the bootstrapping exercise preserves the skewness within the historical data. A carry trade simulation can generate student interest and strengthen student understanding of Excel modeling, Investments, International Finance, and Statistics. The assignment can also be used to illustrate uncovered interest rate parity and forward rate bias.
Recommended Citation
(2024)
"Monte Carlo and Bootstrapping Carry Trade Simulations in Excel,"
Journal of Economics and Finance Education: Vol. 23:
Iss.
1, Article 7.
Available at:
https://scholarship.rollins.edu/jefe/vol23/iss1/7
