FRA Settlement Calculator Excel Template
FRA Settlement 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
Professional Excel template to calculate FRA cash settlements with live formulas. Supports Pay Fixed and Receive Fixed positions.
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 Forward Rate Agreement cash settlements instantly with this professional FRA Settlement Calculator Excel template. Perfect for treasury analysts, derivatives traders, risk managers, and finance students who need to compute FRA payoffs for interest rate hedging or derivatives pricing.
What You Can Calculate
This template computes all components of the FRA settlement formula:
- Settlement Amount - The cash payment exchanged at the FRA start date, discounted to present value
- Rate Differential - The difference between the reference rate and contracted FRA rate
- Interest Difference - The undiscounted interest differential before present value adjustment
- Discount Factor - The present value factor applied to the interest difference
- Day Fraction - The contract period expressed as a fraction of the year
Required Inputs
Enter these values to calculate your FRA settlement:
- Position Type - Select Pay Fixed (profits when rates rise) or Receive Fixed (profits when rates fall)
- Notional Principal - The face value of the underlying loan agreement
- FRA Rate - The fixed rate agreed upon in the FRA contract
- Reference Rate - The actual market rate at settlement (SOFR, EURIBOR, etc.)
- Contract Period - Number of days in the FRA period
- Day Count Basis - Choose Actual/360 (money market standard) or Actual/365
Methodology
The template uses the standard FRA settlement formula: Settlement = NP x [(R - FRA) x (days/DCC)] / [1 + R x (days/DCC)]. Settlement is discounted because the payment occurs at the start of the FRA period, not at maturity. The discount factor converts the future interest differential to present value using the reference rate.
Assumptions & Limitations
- Settlement occurs at the beginning of the FRA period (advance settlement)
- Discounting uses the reference rate observed at settlement date
- Supports Actual/360 and Actual/365 day count conventions
- No credit risk or counterparty adjustments included
Frequently Asked Questions
Yes. The template uses live Excel formulas, so you can duplicate the Calculator sheet to compare different FRA scenarios side-by-side - for example, different notional amounts, contract periods, or rate assumptions.
Use the Position Type dropdown at the top of the Calculator sheet. Selecting 'Receive Fixed' automatically flips the settlement sign - you'll receive payment when rates fall below the FRA rate instead of when they rise.
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.
