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.
| Result | Value |
|---|---|
| Monthly interest differential | 75,000.00 |
| Annuity factor | 63.92 |
| Calculated premium | 4,793,808 |
| Yield maintenance premium (with the minimum) | 4,793,808 |
| Premium, % of balance | 11.98% |
| Payoff before accrued interest | 44,793,808 |
Runs in your browser: nothing you type is sent anywhere.
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)
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.
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.
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.
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.
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 →