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.
Copyright © 2022 The Authors.
Please note that downloads of the article are for private/personal use only.
Arnold, Tom, C. Mitchell Conover, and Joseph Farizo. "Monte Carlo and Bootstrapping Carry Trade Simulations in Excel," University of Richmond Robins School of Business, (2022): 1-18.
Click below to download supplemental content.FX-SIMULATION-PAPER-UPDATE-JF.xlsx (198 kB)