Swap Breakage Calculator Excel Template
Swap Breakage Calculator Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Calculate interest rate swap breakage costs for project finance refinancing. Includes per-period breakdown and bullet/amortizing support.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Calculate interest rate swap termination costs for project finance refinancing and prepayment scenarios. This Swap Breakage Calculator Excel Template provides the theoretical mark-to-market value of an interest rate swap, helping project finance professionals, bankers, and financial analysts estimate breakage costs before refinancing or early loan repayment.
What You Can Calculate
This Excel template computes key swap valuation metrics:
- Breakage Cost — The NPV of payment differences between your original fixed rate and current market rates
- Mark-to-Market Value — The theoretical value of the swap from the counterparty's perspective
- Percentage of Notional — Breakage cost expressed as a percentage of the initial swap notional
- In/Out/At-the-Money Status — Whether terminating would result in a cost or gain
The template includes a detailed per-period breakdown showing notional, payment difference, discount factor, and present value for each payment period.
Required Inputs
Enter these values to calculate your swap breakage:
- Original Fixed Swap Rate — The fixed rate in your swap agreement (typically 0-20%)
- Current Replacement Rate — Today's market swap rate for the remaining term
- Notional Structure — Bullet (constant) or Level Principal (amortizing)
- Initial Notional — The swap's notional principal amount
- Remaining Term & Frequency — Years remaining and payment frequency (annual/semi-annual/quarterly)
Methodology
The calculator uses the standard swap valuation approach from project finance practice (Yescombe, Principles of Project Finance). For each remaining period, the payment difference equals (Original Rate - Current Rate) × Notional / Frequency. Each payment difference is discounted to present value using the current market rate, then summed to produce the total breakage cost.
Assumptions & Limitations
- Assumes the Project Company is the fixed-rate payer
- Uses flat yield curve (current rate as discount rate)
- Ignores bid/offer spreads, CVA, FVA, and bank margin
- Supports Bullet and Level Principal schedules only
Frequently Asked Questions
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
