Business Commons^™

Interest Rate Parity In Excel, Tom Arnold, Bonnie Buchanan

Finance Faculty Publications

This paper develops interest rate parity in a framework that is easily implemented in Excel. The student can either be given the paper to see how the code is developed using the intuition of the interest rate parity framework or the student can be taught the interest rate parity framework and develop the Excel code as an assignment. Using either teaching method or the other exercises suggested in the paper, the student is able to understand how traders exploit violations of interest parity and become more comfortable with basic concepts, such as direct quotes and indirect quotes.