Interest Rate Swap-Derivative Pricing in Excel

Follow us on LinkedIn

An interest rate swap (IRS) is a financial derivative instrument that involves an exchange of a fixed interest rate for a floating interest rate.  More specifically,

An interest rate swap’s (IRS’s) effective description is a derivative contract, agreed between two counterparties, which specifies the nature of an exchange of payments benchmarked against an interest rate index. The most common IRS is a fixed for floating swap, whereby one party will make payments to the other based on an initially agreed fixed rate of interest, to receive back payments based on a floating interest rate index. Each of these series of payments is termed a ‘leg’, so a typical IRS has both a fixed and a floating leg. The floating index is commonly an interbank offered rate (IBOR) of specific tenor in the appropriate currency of the IRS, for example LIBOR in USD, GBP, EURIBOR in EUR or STIBOR in SEK. To completely determine any IRS a number of parameters must be specified for each leg; the notional principal amount (or varying notional schedule), the start and end dates and date scheduling, the fixed rate, the chosen floating interest rate index tenor, and day count conventions for interest calculations. Read more

swap valuation excel

The above description refers to a plain vanilla interest rate swap. However, interest rate swaps can come in many different flavors. These include, (but are not limited to)

Interest rate swaps are often used to hedge the fluctuation in the interest rate. To value an interest rate swap, fixed and floating legs are priced separately using the discounted cash flow approach.

Below is an example of a hypothetical plain vanilla interest rate swap

Maturity: 5 years

Notional: 10 Million EUR

Fixed rate: 3.5%

Floating rate:  Euribor

The values of the fixed, floating legs and the interest rate swap are calculated using an Excel spreadsheet. Table below presents their values

Interest rate swap derivative in Excel

Related article: Interest Rate Swap-Derivative Pricing in Python

Further questions

What's your question? Ask it in the discussion forum

Have an answer to the questions below? Post it here or in the forum

LATEST NEWSUkraine's heavily armored Abrams tanks have jammers to keep drones away, but they need more protection, commander says
Ukraine's heavily armored Abrams tanks have jammers to keep drones away, but they need more protection, commander says

A Ukrainian commander praised the US-made Abrams for being better than Soviet-era tanks but said they could use more protection.

Stay up-to-date with the latest news - click here
LATEST NEWS24 top-rated products at their lowest price ever for Prime Day
24 top-rated products at their lowest price ever for Prime Day

During Amazon Prime Day, you can find top products on sale for their lowest price ever. We rounded up the best sales on our favorite products.

Stay up-to-date with the latest news - click here
LATEST NEWSReconAfrica Announces C$35 Million Underwritten Offering
ReconAfrica Announces C$35 Million Underwritten Offering

The prospectus supplement, the corresponding base shelf prospectus and any amendment thereto in connection with this offering will be accessible through SEDAR+ within two business days NOT FOR DISTRIBUTION TO U.S. NEWSWIRE SERVICES OR DISSEMINATION IN THE UNITED STATES CALGARY, Alberta, July 17, 2024 (GLOBE…

Stay up-to-date with the latest news - click here
LATEST NEWSNavy Federal Credit Union Personal Loans Review 2024
Navy Federal Credit Union Personal Loans Review 2024

Navy Federal is exclusively for military members and their families, and has low minimum loan amounts of $250. You may be able to get a lower rate elsewhere with excellent credit.

Stay up-to-date with the latest news - click here
LATEST NEWSKinder Morgan Reports Second Quarter 2024 Financial Results
Kinder Morgan Reports Second Quarter 2024 Financial Results

Approves Cash Dividend of $0.2875 Per Share ($1.15 Annualized) Earnings per Share Flat to Second Quarter 2023; Adjusted Earnings per Share Up 4% HOUSTON — Kinder Morgan, Inc.’s (NYSE: KMI) board of directors today approved a cash dividend of $0.2875 per share for the second…

Stay up-to-date with the latest news - click here

4 Comments

Leave a Reply