How To Calculate Interest Rate Parity In Excel

Wondering how to calculate interest rate parity in Excel? According to interest rate parity, the difference between the forward exchange rate of two currencies and the spot exchange rate is equivalent to the difference between the two country's interest rates. To calculate interest rate parity in Excel, you must start with the proper formula.  It is possible to approximate the calculation of a forward exchange rate between two currencies, if you have the current exchange rate and nominal interest rates of both currencies. The following steps can allow you to calculate interest rate parity in Excel.

To calculate interest rate parity in Excel, you will need:

  • Microsoft Excel
  • Current interest rates of two unique currencies
  • The current spot exchange rate between the two currencies
  1. Set the spot exchange rate between a pair of currencies. To calculate interest rate parity in Excel, you must know the exchange rate between two currencies. This number reflects how many units of a second currency can be purchased in the first currency.
  2. Set the nominal risk-free interest rate for the first currency. The number should be reflected as a percentage, or as a decimal between zero and one.
  3. Set the nominal risk-free interest rate in the second currency. Also a percentage or a decimal between zero and one. Without the interest rates of two currencies, you will not be able to calculate interest rate parity in Excel.
  4. Insert the formula for forward exchange rate. To calculate interest rate parity in Excel in this example, the formula to approximate a forward exchange rate is F1*((1+F3)/(1+F2)), where F1 is the spot exchange rate, and F2 is the interest rate of the first currency and F3 is the interest rate of the second currency.

 

 

What Others Are Reading Right Now.

  • 13 Things to Look Forward to in Your 30s

    You’ve probably been told that your 20s will be the best years of your life. As someone in their 30s, I can tell you honestly that nothing could be further from the truth. Here are ...

  • Speakeasy

    Acting, comedy and strong spirits converge in Speakeasy. When host Paul F. Tompkins interviews entertainers—Key and Peele, Alison Brie, Rob Delaney, Zach Galifianakis—about all sor ...

  • Follow Channel

    Remember when Seahawks cornerback Richard Sherman made all that noise—and news—before the Super Bowl? We had the story long before the season even started, trailing him all over Se ...