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.
| Result | Value |
|---|---|
| Monthly payment | 276,102 |
| Balance at defeasance | 46,944,121 |
| Balloon at maturity | 40,974,140 |
| Months remaining | 72 |
| Monthly rate equivalent to the treasury yield | 0.3224% |
| Treasury portfolio cost | 50,213,873 |
| Premium over the balance | 3,269,752 |
| Defeasance cost with fees | 3,444,752 |
| Cost with fees, % of balance | 7.34% |
| Cheque to free the property | 50,388,873 |
Runs in your browser: nothing you type is sent anywhere.
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).
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.
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.
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.
The loan agreement decides: most conduit loans allow one or the other. Price the other with the yield maintenance 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 →