Interest rate swaps are derivatives which enable the participants to swap different cash flows. Often a fixed cash flow is swapped for a floating rate cash flow. At the onset, the cash flows from the interest rate swap is set such that the net value of the swap is zero. However, as interest rates change, the value of the swap changes as well. We show a thorough example in Excel of how to set up a swap and how to value it.
