Free calculators

Yield maintenance calculator

The prepayment premium on a fixed-rate commercial mortgage: the present value, at the treasury yield, of the interest the lender loses, with the minimum. Free, in the browser, no sign-up.

Yield maintenance is the present value, at the treasury yield, of the monthly gap between the note rate and that yield over the remaining term, subject to a minimum premium. With the defaults below, a $40.0M interest-only loan at 6.25 per cent with 72 months left and a 4.00 per cent treasury, the premium is $4,793,808, 11.98 per cent of the balance. Change any input and the figures update.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Monthly interest differential75,000.00
Annuity factor63.92
Calculated premium4,793,808
Yield maintenance premium (with the minimum)4,793,808
Premium, % of balance11.98%
Payoff before accrued interest44,793,808

Runs in your browser: nothing you type is sent anywhere.

Using this for a real deal?

The formula

Yield maintenance = MAX(balance × (note − treasury) / 12 × [1 − (1 + r/12)−n] / (r/12), minimum)

r is the treasury yield, plus any spread the loan agreement adds to the discount rate; n is the months to maturity.

In Excel: =MAX(PV(4%/12,72,-40000000*(6.25%-4%)/12),1%*40000000)

How it works

The lender loses the difference between the note rate and what it can earn by reinvesting the prepaid balance in treasuries for the rest of the term. The calculator discounts that monthly differential at the treasury yield and compares it with the minimum, usually 1 per cent of the balance. It assumes an interest-only loan with monthly payments and a flat treasury yield; for an amortising loan, the differential falls with the balance and the premium is a little lower.

The two common shortcuts are both wrong: multiplying the differential by the years left gives $5,400,000 here, and discounting at the note rate $4,493,398. Read the definition clause of the loan agreement for the treasury, the spread and the minimum.

Go further with the worked example, step by step, the free Excel template and the companion files for How to Read a Real Estate Loan Agreement.

Embed this calculator

Free to embed on your website, blog or intranet, with no sign-up and no tracking. Copy the code below and paste it into any HTML block; the calculator resizes itself to fit.

Preview the embedded version

Questions people ask

How is yield maintenance calculated?

As the present value, at the treasury yield, of the monthly interest differential between the note rate and the treasury over the remaining term, with a minimum of often 1 per cent of the balance. On $40.0M at 6.25 per cent against 4.00 per cent with 72 months left, it is $4,793,808.

Why is yield maintenance so high when rates fall?

A lower treasury yield widens the gap the lender loses and lowers the rate it is discounted at, so the premium rises on both counts. At a 3.00 per cent treasury the same loan would cost about 17.8 per cent of the balance.

Is yield maintenance the same as defeasance?

No. Yield maintenance repays the loan with a premium; defeasance keeps the loan in place and substitutes treasuries as collateral. With a flat treasury curve the costs converge. Use the defeasance calculator for the second.

The book behind this calculator

This calculator comes from How to Read a Real Estate Loan Agreement by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.

Get the book on Amazon → DRM-free PDF edition, $19.99

If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review.

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

All free calculators → · Free Excel templates →