Free calculators

Defeasance calculator

What it costs to defease a fixed-rate conduit loan: the treasury portfolio that pays every remaining payment and the balloon, plus fees, less the balance released. Free, in the browser, no sign-up.

Defeasance cost is the price of a portfolio of treasuries that pays every remaining loan payment and the balloon on its due date, plus fees, less the balance it releases. With the defaults below, a $50.0M loan at 5.25 per cent on a 30-year amortisation, defeased after 48 of its 120 months with treasuries at 3.90 per cent, the portfolio costs 50,213,873 against a balance of 46,944,121: 3,444,752 with fees, 7.34 per cent of the balance.

Calculate

Results, updated as you type. The defaults reproduce the worked case.
ResultValue
Monthly payment276,102
Balance at defeasance46,944,121
Balloon at maturity40,974,140
Months remaining72
Monthly rate equivalent to the treasury yield0.3224%
Treasury portfolio cost50,213,873
Premium over the balance3,269,752
Defeasance cost with fees3,444,752
Cost with fees, % of balance7.34%
Cheque to free the property50,388,873

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

Using this for a real deal?

The formula

Portfolio cost = Σ payment / (1 + m)t + balloon / (1 + m)k, for t = 1 to k months remaining

Defeasance cost = portfolio cost + fees − balance released

m = (1 + treasury/2)1/6 − 1 converts a semi-annual bond-equivalent yield to a monthly rate. In Excel: =PV(m,72,-276102,-40974140).

How it works

The loan is not repaid: the property is released from the mortgage and replaced as collateral by government securities, and a successor borrower takes over the payments. The bondholders receive exactly the cash flows they were promised, so the cost depends on treasury yields. The calculator assumes a flat treasury curve; the consultant buys actual securities maturing just before each payment date, which costs slightly more, so treat the figure as a floor.

Most of the premium sits in the balloon, discounted for the whole remaining term. Each 10 basis points of treasury yield is worth about $243,000 on the default loan: defeasance is a rate trade, and choosing the date is choosing the yield.

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 defeasance cost calculated?

Price a portfolio of treasuries that pays every remaining monthly payment and the balloon, add the fees, and subtract the loan balance it releases. On the default $50.0M loan the portfolio costs 50,213,873, the balance is 46,944,121 and the cost with 175,000 of fees is 3,444,752.

Why does defeasance cost more when treasury yields are low?

Because the portfolio must replace payments at the loan rate with securities paying less. The lower the treasury yield, the more the portfolio costs. When treasury yields exceed the loan rate, the portfolio can cost less than the balance.

Defeasance or yield maintenance?

The loan agreement decides: most conduit loans allow one or the other. Price the other with the yield maintenance calculator.

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 →