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.
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.
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
Follow the floating rate and cumulative cash
Scenario B · vertical scale $0.00 to $156,500.00. Day 0 includes the upfront premium.
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
| Period | Days | Loan interest | Cap receipt | Net period cash | Loan-only cumulative | With-cap cumulative |
|---|---|---|---|---|---|---|
| 1 | 90 | $39,300.00 | $1,800.00 | $37,500.00 | $39,300.00 | $55,500.00 |
| 2 | 90 | $41,250.00 | $6,875.00 | $34,375.00 | $80,550.00 | $89,875.00 |
| 3 | 90 | $41,750.00 | $9,450.00 | $32,300.00 | $122,300.00 | $122,175.00 |
| 4 | 90 | $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 CSVSelectable rate cap CSV copy
How to use this calculator
- Load Partial cover and expiry or Uneven periods and notionals. Enter the loan spread and index floor and the cap strike and upfront premium.
- Set the loan and cap Actual/360 or Actual/365 basis to match the terms you want to compare.
- Open the period editor. Enter days, loan balance and cap notional for each period, then enter the two annual reference-rate paths.
- 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.
- 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
DSCR Loan Calculator
Compare DSCR loan capacity, LTV limits, interest-only payment changes and balloon repayments across property-income scenarios. Inspect schedules and export the full plan.
Business Line of Credit Calculator & Cash Flow Planner
Compare two business credit lines with the same draw and repayment schedule. Estimate interest, unused fees, funding shortfalls and cash to close.
Interest-Only Mortgage Payment Calculator
Estimate the first principal and interest payment after an interest-only period. Compare a fixed mortgage and find the reset rate that fits your P&I ceiling.
Loan Amortization Schedule Calculator
Build a payment-by-payment loan amortization schedule with extra payments and total interest savings.
Cash Conversion Cycle & Inventory Days Calculator
Calculate inventory, receivable and payable days together. Compare growth and timing scenarios, visualize operating-capital changes, weight balance snapshots and export the full analysis.
