The Par Swap Rate with SUMPRODUCT
This lesson is part of the subscription
The first lesson of every course is free. A subscription unlocks all lessons, labs, exams and certificates.
Or start the free course: Excel for Finance
Lessons in this course
- Swap Cash Flows: Fixed vs Floating Legs & Day CountsFree
- Bootstrapping Discount Factors from Par Swap Rates Pro
- Forward Rates and Forward Swap Rates from Discount Factors Pro
- The Par Swap Rate with SUMPRODUCT Pro
- Marking a Swap to Market after Rates Move Pro
- DV01 and PV01: Bumping the Curve by 1 bp Pro
- Hedging a Floating-Rate Loan: Net Cost & Hedge Effectiveness Pro
- Swap vs Interest Rate Cap: Cost Scenarios & Breakeven Pro