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 NEWSBiogen’s QALSODY® (tofersen), the First Therapy to Treat Rare, Genetic Form of ALS, Received Positive Opinion from CHMP
Biogen’s QALSODY® (tofersen), the First Therapy to Treat Rare, Genetic Form of ALS, Received Positive Opinion from CHMP

SOD1-ALS is a devastating, uniformly fatal, and ultra-rare genetic form of ALS affecting less than 1,000 people in Europe1 With QALSODY, Biogen has advanced the role of neurofilament in the development of new medicines for ALS, with the potential to accelerate further discovery in the…

Stay up-to-date with the latest news - click here
LATEST NEWSTanzanian Parliamentary Committee Lauds Barrick’s Work at North Mara
Tanzanian Parliamentary Committee Lauds Barrick’s Work at North Mara

DAR ES SALAAM, Tanzania, Feb. 23, 2024 (GLOBE NEWSWIRE) — Tanzania’s Parliamentary Standing Committee for Energy and Minerals has commended Barrick Gold Corporation (NYSE:GOLD) (TSX:ABX) for the significant turnaround at the North Mara gold mine and its improved relations with the community. Members of Parliament…

Stay up-to-date with the latest news - click here
LATEST NEWSOnex Reports Fourth Quarter and Full Year 2023 Results
Onex Reports Fourth Quarter and Full Year 2023 Results

All amounts in U.S. dollars unless otherwise stated TORONTO, Feb. 23, 2024 (GLOBE NEWSWIRE) — Onex Corporation (TSX: ONEX) today announced its financial results for the fourth quarter and year ended December 31, 2023. “Onex delivered solid overall performance in 2023, driven by good investment…

Stay up-to-date with the latest news - click here
LATEST NEWSPlug and Uline Expand Partnership to Supply Hydrogen and Fuel Cells at Four Additional Sites
Plug and Uline Expand Partnership to Supply Hydrogen and Fuel Cells at Four Additional Sites

8-year partnership and $20,000,000 expansion underscores Uline’s commitment to Plug’s hydrogen and fuel cell solutions, significantly enhancing efficiency of operations LATHAM, N.Y., Feb. 23, 2024 (GLOBE NEWSWIRE) — Plug Power Inc. (NASDAQ: PLUG), a global leader in comprehensive hydrogen solutions for the green hydrogen economy,…

Stay up-to-date with the latest news - click here
LATEST NEWSCorporate emissions: don’t just take their word for it
Corporate emissions: don’t just take their word for it

Also in today’s newsletter, brighter weather ahead for offshore wind and a closer look at ESG bond funds

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

4 Comments

Leave a Reply