The Par Swap Rate with SUMPRODUCT
This lesson is part of the course
In this lesson
You price a 3-year semi-annual swap: the annuity with SUMPRODUCT, the floating leg, the par rate and the value of a dealer's off-market quote.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- Swap Cash Flows: Fixed vs Floating Legs & Day Counts Locked
- Bootstrapping Discount Factors from Par Swap Rates Locked
- Forward Rates and Forward Swap Rates from Discount Factors Locked
- The Par Swap Rate with SUMPRODUCT Locked
- Marking a Swap to Market after Rates Move Locked
- DV01 and PV01: Bumping the Curve by 1 bp Locked
- Hedging a Floating-Rate Loan: Net Cost & Hedge Effectiveness Locked
- Swap vs Interest Rate Cap: Cost Scenarios & Breakeven Locked