Interest Rate Floor Calculator

Enter Floor Assumptions

Use this form for floating-rate agreements, hedging checks, scenario testing, and quick premium comparisons.

Notional amount

Floor strike rate (%)

Observed floating rate (%)

Forward rate for pricing (%)

Accrual days

Day-count basis

Number of periods

Discount rate (%)

Time to reset (years)

Time to payment (years)

Rate volatility (%)

Spread or margin (%)

Formula Used

Accrual Factor = Accrual Days ÷ Day-Count Basis

Protected Reference Rate = max(Observed Rate, Floor Rate)

Rate Shortfall = max(Floor Rate − Observed Rate, 0)

Floorlet Payoff per Period = Notional × Accrual Factor × Rate Shortfall

Gross Protection = Floorlet Payoff per Period × Number of Periods

Present Value = Gross Protection × [1 ÷ (1 + Discount Rate × Time to Payment)]

Theoretical Floorlet Premium uses the Black floorlet approximation:

d1 = [ln(F ÷ K) + 0.5 × σ² × T] ÷ (σ × √T)

d2 = d1 − σ × √T

Premium = Notional × Accrual Factor × DF × [K × N(−d2) − F × N(−d1)]

How to Use This Calculator

Enter the notional amount covered by the floor.
Provide the minimum floor strike rate you want protected.
Enter the observed floating rate for current payoff testing.
Add the forward rate for option-style pricing estimates.
Set accrual days, day-count basis, number of periods, and times.
Enter discount rate, rate volatility, and any spread or margin.
Click Calculate Floor Value to view results above the form.
Use the export buttons to save the summary as CSV or PDF.

Example Data Table

Scenario	Notional	Floor Rate	Observed Rate	Accrual	Periods	Floorlet Payoff	Present Value
Moderate shortfall	$1,000,000	4.00%	3.20%	90/360	4	$2,000.00	$7,619.05
No floor trigger	$1,000,000	4.00%	4.70%	90/360	4	$0.00	$0.00
Large shortfall	$1,000,000	4.00%	2.50%	90/360	4	$3,750.00	$14,285.71

FAQs

1. What does an interest rate floor do?

It sets a minimum reference rate for a floating-rate cashflow. When the observed rate drops below the floor, the contract creates compensation equal to the shortfall times notional and accrual.

2. Why does the calculator ask for both observed and forward rates?

Observed rate drives the immediate deterministic payoff. Forward rate supports theoretical pricing, because option-style models estimate value from expected future rates rather than only today’s realized fixing.

3. What is the accrual factor?

The accrual factor converts annual rates into period-specific cashflows. A 90-day quarter on a 360-day basis becomes 0.25, which scales the rate shortfall into the proper payment amount.

4. Why is there a discount rate input?

Future protection payments are worth less today. The discount rate converts gross future protection into present value, helping you compare expected benefits with option premium or financing decisions.

5. What does volatility change?

Higher volatility usually increases theoretical option value. More uncertainty means a greater chance that future rates finish below the floor, which can make the floorlet premium larger.

6. What is the difference between floor payoff and premium?

Payoff measures protection from a realized or assumed low rate. Premium is the modeled cost of obtaining that protection before the rate outcome is known, often using an option-pricing framework.

7. Can this calculator help compare multiple periods?

Yes. It scales one period’s floorlet payoff and theoretical premium across the chosen number of periods, giving a quick estimate of total protection and overall net benefit.

8. When should I treat the results as estimates only?

Use caution when markets are stressed, curves are non-flat, or the contract has special conventions. Professional valuation may require curve bootstrapping, volatility surfaces, settlement rules, and credit adjustments.