Tabellab
Corporate Finance & Valuation Advanced

Interest Rate Swaps: Pricing, Valuation, DV01 & Hedging

Swap cash flows and day counts, bootstrapping discount factors, forward rates, the par swap rate, mark-to-market, DV01 and hedging a floating-rate loan with a swap or a cap: 8 hands-on labs on an illustrative single curve. Educational only, not investment advice.

8 lessons 8 labs 2.2 h Certificate

The first lesson is free โ€” no account needed.

About this course

An interest rate swaps course that prices, values and hedges plain-vanilla swaps for one fictional company, Corvane, on an illustrative single curve in a spreadsheet, for treasury and corporate finance staff, risk analysts, bank trainees and finance students. You lay out the fixed and floating legs of a pay-fixed swap with day count fractions and net settlements, bootstrap discount factors from par swap rates and turn them into zero rates, read forward rates and a forward-starting swap off the curve, price the par swap rate with SUMPRODUCT and value an off-market quote, mark a swap to market after rates rise, bump the curve by one basis point for the DV01, run a SOFR loan and its hedge through eight quarters, and compare a swap with an interest rate cap across six rate scenarios in a chart. Illustrative rates, educational only, not investment advice. The first lab is free.

Lessons

  1. Swap Cash Flows: Fixed vs Floating Legs & Day CountsLab15 minFree
  2. Bootstrapping Discount Factors from Par Swap RatesLab18 min Pro
  3. Forward Rates and Forward Swap Rates from Discount FactorsLab15 min Pro
  4. The Par Swap Rate with SUMPRODUCTLab15 min Pro
  5. Marking a Swap to Market after Rates MoveLab15 min Pro
  6. DV01 and PV01: Bumping the Curve by 1 bpLab18 min Pro
  7. Hedging a Floating-Rate Loan: Net Cost & Hedge EffectivenessLab18 min Pro
  8. Swap vs Interest Rate Cap: Cost Scenarios & BreakevenLab15 min Pro