Make-Whole Calculator
Estimate a make-whole or yield maintenance prepayment for a fixed-rate loan or bond in USD, GBP or EUR, using a standard convention or your own.
The Make-Whole Calculator estimates what a borrower pays to prepay a fixed-rate loan or bond under a make-whole or yield maintenance clause.
Open it from the sidebar under Loan Payment → Make-Whole (marked Preview), or search for "yield maintenance". The page prices a default loan as soon as it opens.
1. Choose the Currency and Convention
Currency (USD, GBP or EUR) filters Convention and picks its default. Each convention fills in the discount basis and spread:
CMBS Yield Maintenance (USD default)
US Treasuries
Single rate at matching tenor
Remaining maturity
0
Rate-differential, floored
US PP Make-Whole
US Treasuries
Single rate at matching tenor
Weighted-average life
50
Greater of par or PV
USD Public Corporate MW
US Treasuries
Full curve
Not used
15
Greater of par or PV
USD Mid-swaps PP
USD Mid-swaps (SOFR)
Single rate at matching tenor
Remaining maturity
50
Greater of par or PV
Spens (GBP default)
UK Gilts
Single rate at matching tenor
Remaining maturity
0
Greater of par or PV
GBP Mid-swaps PP
GBP Mid-swaps (SONIA)
Single rate at matching tenor
Remaining maturity
50
Greater of par or PV
EUR EMTN Make-Whole (EUR default)
German Bunds
Full curve
Not used
50
Greater of par or PV
EUR Mid-swaps PP
EUR Mid-swaps (ESTR)
Single rate at matching tenor
Remaining maturity
50
Greater of par or PV
Custom
Unchanged
Unchanged
Unchanged
Unchanged
Greater of par or PV
Spread (bps) is the reinvestment spread. Editing it keeps the convention.
2. Check the Discount Basis
The Discount basis panel shows Discount curve, Discount rate and, for a single rate, Tenor reference. Changing any of them switches the convention to Custom.
For a single rate, Override rate manually replaces the curve rate with yours. On UK Gilts the field is Reference Gilt GRY (manual override).
3. Enter the Loan
Loan Principal (default 10,000,000), Coupon (%) (5.75), Day Count (Actual/360, 30/360, Actual/365 or Act/Act ICMA), First Payment Date (3 years ago), Prepayment Date (today) and Maturity Date (10 years after the first payment).
Amortisation Type is Bullet (default), Amortising (with Amortisation Term (months) and an optional Monthly Payment) or Custom schedule. A custom schedule replaces the dates and term: paste Start Date, End Date and Opening Balance from Excel, one row per period. Each row starts where the last ended, balances only fall, and the last balance is repaid on its end date. Ambiguous dates such as 03/04/2027 are read day first. A preview with Principal Repaid flags problem rows.
Under CMBS Yield Maintenance, Floor (% of balance) sets the minimum premium (1% by default).
Advanced options has Valuation Date (a past day's closing curve) and Curve Shock (bps). Click Calculate Make-Whole.
4. Read the Result

The headline is Total payoff at prepayment. Under it is the curve rate used, before the spread, or a note that the full curve was used.
Costs
Outstanding Balance, Accrued Interest, Make-Whole Amount (includes principal), Total Payoff, Present value of remaining payments, Floor Amount, Premium over Floor (not for CMBS), DV01
Loan
Prepayment Date, Premium as % of Balance, Remaining Payments, Next Payment Date, Maturity Date, Floor
Market data
Valuation Date, Curve Data Updated, Reinvestment Spread
Accrued Interest and Total Payoff show only between payment dates.
Below: Prepayment Burndown (quarterly later dates, up to 2 years), Payment Discounting Breakdown (each payment's Discount Rate, Reinvestment Rate, Discount Factor and Present Value) and the currency's government curve, also shown for mid-swaps. Download PDF report saves the estimate.
How It Is Calculated
Payments are discounted to the prepayment date at the rate plus spread. A single rate is read at the remaining maturity or WAL (Σ years × principal ÷ Σ principal): Treasuries and mid-swaps interpolate between quoted tenors; Gilts and Bunds use the zero curve. Full curve discounts each payment at its own zero rate.
CMBS Yield Maintenance: premium = max(Σ max(coupon − rate, 0) ÷ 12 × period opening balance × DF, floor × balance). Make-Whole Amount = balance + premium.
Other conventions: Total Payoff = max(balance + accrued, PV). Make-Whole Amount = Total Payoff − accrued.
DV01 is the premium's change for a 1bp rise in the curve. Totals exclude third-party fees.
Related
Defeasance Calculator: US loan defeasance with Treasuries
Government Bond Curves: how the government curves are built
Last updated
Was this helpful?

