Commercial Interest Rate Cap Calculator & Cash Planner

Compare the same commercial loan with and without a separately purchased interest rate cap. Enter each period’s days, loan balance and cap notional, then give two alternative paths for their shared reference index. See when settlements offset interest, how coverage changes as loan and cap amounts diverge, and what uniform index increase would recover the entered premium. The chart and CSV reconcile both cash paths using your assumptions.

Floating-rate loan

Compare loan cash with and without a rate cap

Enter an upfront premium, a shared loan and cap schedule, and two benchmark-rate paths. Trace modeled cash and the premium recovery threshold.

Choose or edit a rate-cap scenario

The same loan and cap terms apply to both paths. In each period the loan and cap use the same entered benchmark index. These are cash scenarios using an entered premium.

Compare interest, cap receipts and total cash

Net cash including cap premium. Scenario A $143,650.00. Scenario B $156,375.00.

Scenario A

Net cash with cap and premium

$143,650.00

$17,450.00 more than loan only

Loan-only interest
$126,200.00
Cap receipts and cash break-even premium
$550.00
Uniform index increase to recover premium
+122 bp

Receipts do not recover the premium within this schedule.

Scenario B

Net cash with cap and premium

$156,375.00

$125.00 less than loan only

Loan-only interest
$156,500.00
Cap receipts and cash break-even premium
$18,125.00
Uniform index increase to recover premium
No increase needed

Receipts first recover the premium in period 3.

The $18,000.00 premium is paid at day 0. The notional is positive for 270 of 360 days. The index increase raises every period’s entered index together in 1 bp steps up to a 40% index, keeping the strike and the cash terms fixed.

Edit loan and cap terms

Add this fixed margin to the loan index after its floor.

Applies only to loan interest.

The cap pays on index above this strike.

Use your entered contract quote or comparison amount.

Set periods, balances and rate paths

Enter the calendar days in each accrual period and the balances applying throughout it. Set notional to zero for periods with no cap cover. The sequence is the entered period order.

Edit 4 periods
Period 1
Period 2
Period 3
Period 4

Follow the floating rate and cumulative cash

Loan only · solidWith cap and premium · dashed

Scenario B · vertical scale $0.00 to $156,500.00. Day 0 includes the upfront premium.

Cumulative loan interest and cap-adjusted cashScenario B, period 1. Loan-only cash $39,300.00 and net with cap $55,500.00. Period data follow this chart.
Day 0Day 360

Period 1 · Scenario B

4.30% reference index · 6.55% loan coupon

$39,300.00 interest · $1,800.00 cap receipt · $37,500.00 net period cash before premium

$2,400,000.00 loan balance · $2,400,000.00 cap notional

Reconcile the cash ledger

Scenario B period and cumulative cash
PeriodDaysLoan interestCap receiptNet period cashLoan-only cumulativeWith-cap cumulative
190$39,300.00$1,800.00$37,500.00$39,300.00$55,500.00
290$41,250.00$6,875.00$34,375.00$80,550.00$89,875.00
390$41,750.00$9,450.00$32,300.00$122,300.00$122,175.00
490$34,200.00$0.00$34,200.00$156,500.00$156,375.00

Net period cash is loan interest less the cap receipt. Cumulative cash with the cap includes the upfront premium once.

Export terms and results

The CSV includes both paths, all entered terms and period cash legs, and premium recovery.

Download rate cap CSV
Selectable rate cap CSV copy

How to use this calculator

  1. Load Partial cover and expiry or Uneven periods and notionals. Enter the loan spread and index floor and the cap strike and upfront premium.
  2. Set the loan and cap Actual/360 or Actual/365 basis to match the terms you want to compare.
  3. Open the period editor. Enter days, loan balance and cap notional for each period, then enter the two annual reference-rate paths.
  4. Compare interest, receipts and cash with the cap. Inspect cash recovery or the index and strike in a selected scenario. An uncovered period has a zero cap notional.
  5. Reconcile the period ledger and export the terms and both modeled cash paths.

The Formula

The mathematical logic powering this calculation is:

Both scenarios use equal loan balances, cap notionals, period lengths and terms. Enter the scenario index for each period. Each scenario uses the same entered index on both legs. Periods use authored actual day counts, with no modeled reset lag or calendar adjustment. Loan interest accrues on the constant entered loan balance for each period. The reference rate used on the loan is max(period index, loan index floor), then the fixed loan spread is added. Interest = loan balance × (floored index + spread) × days ÷ loan year basis. The basis is either 360 or 365.
Cap receipt = cap notional × max(0, period index − strike) × days ÷ cap year basis. This leg uses the raw entered index, including a negative value if entered, and the selected cap day-count denominator. The spread and loan floor do not change the settlement. Because cap notional and loan principal can differ, a receipt can exceed that period’s loan interest. Enter zero notional for expired or uncovered intervals. Rates are entered as annual percentages and converted to decimal proportions for both cash formulas.
Both legs settle at each period end and round separately to the nearest cent, with half cents rounded up. Loan-only cash sums interest. Cash with cap = upfront premium + interest − receipts. The premium is paid at day zero and enters the comparison once. These are undiscounted nominal cash amounts. Entered loan balances already reflect any principal changes. Principal payments themselves are excluded because the two cash comparisons use the same loan.
Cap receipts are the cash break-even premium on a scenario path. Premium recovery occurs at the first period whose cumulative receipts meet or exceed the premium, or at day zero if the premium is zero. The uniform index increase is the smallest nonnegative whole basis-point increase applied to every period index that produces enough total rounded receipts, holding strike and other terms fixed. The calculation stops at the highest common increase whose resulting indexes remain no higher than 40%. If no notional is protected or the allowable increase cannot recover the premium, the result explains that limit.
Use 1 to 48 periods, each 1 to 366 days, and USD balances and premium of $0 to $100,000,000 per field. The index and cap strike accept −10% to 40%. The loan index floor and spread accept 0% to 40%. Dollar amounts and rates accept up to two decimal places.
The Richmond Fed’s Instruments of the Money Market describes periodic rate-cap settlements on a notional and illustrates Actual/360 cash. NCUA’s guidance discusses matching rate, notional and settlement terms to the exposure. This worksheet models accrued and settled cash under the entered terms. It does not price a cap, forecast rates, apply a contractual benchmark methodology, discount settlements or assess counterparty risk.

Worked Example

If you input:

  • Loan and cap day-count basis: Actual/360 on both legs
  • Loan spread and index floor: 2.25% spread and 0% floor
  • Cap strike and upfront premium: 4.00% strike and $18,000 premium
  • Four 90-day loan balances: $2,400,000 / $2,200,000 / $2,000,000 / $1,800,000
  • Cap notionals: $2,400,000 / $2,200,000 / $1,800,000 / $0
  • Scenario A indexes: 3.75% / 4.10% / 3.90% / 3.20%
  • Scenario B indexes: 4.30% / 5.25% / 6.10% / 5.35%

Result:

Scenario A pays $126,200 loan interest and receives $550 from the cap. With the $18,000 premium, net cash is $143,650, which is $17,450 more than loan only. A uniform increase of 122 basis points would recover its premium under the entered terms. Scenario B pays $156,500 loan interest and receives $18,125 across the first three periods, recovering the premium in period 3. Net cash is $156,375, or $125 less than loan only. The fourth period receives no payment because cap notional is zero.

Frequently Asked Questions

Does the strike cap my entire loan rate?

The cap settlement responds to the raw reference index relative to the strike. The loan spread and index floor remain in the loan interest calculation. The cap coverage amount and basis can also differ from the loan.

Why can the cap pay after loan principal is reduced?

The settlement depends on the entered cap notional rather than loan balance. Enter the remaining cap notional for that period. A separately purchased cap can still have exposure when the loan balance has fallen.

What changes when the cap expires?

Set notional to zero after the last covered period. The loan still accrues interest on its balance and entered index even when cap receipts stop.

How do you calculate the cash break-even premium?

Sum the cap receipts across the scenario. Paying that amount upfront leaves the same undiscounted total cash as the loan alone. The timing of payments can still differ.

Is the uniform index increase a rate prediction?

It is a sensitivity calculation. Every entered index in one path moves by the same whole number of basis points until the modeled receipts cover the premium, if feasible within the range.

Can I model different benchmark indexes for the cap and loan?

Use this worksheet when the same entered index applies to both legs over each aligned period. Separate settlement schedules or a cap tied to a different index require additional analysis.

Similar Calculators