The payment and balloon on an owner-financed sale, what the note would fetch from a note buyer, and the rate at which it would sell at face. Free, in the browser, no sign-up.
A seller who carries back a note gets a down payment and a stream of payments, and the stream is worth what a note buyer would pay for it. With the defaults below, a $220,000 house sold with 10 per cent down, a $198,000 note at 8 per cent amortising over 30 years with a five-year balloon pays $1,452.85 a month, with $188,238.32 due at the balloon; a buyer wanting 10 per cent net would pay $179,976.24 for it, 90.90 per cent of face. At 10.37 per cent it would sell at face.
| Result | Value |
|---|---|
| Note amount | 198,000.00 |
| Monthly payment | 1,452.85 |
| Balloon due with payment 60 | 188,238.32 |
| What a note buyer would pay today | 179,976.24 |
| As a share of the note | 90.90% |
| Discount if the note is sold | 18,023.76 |
| Note rate at which the note sells at face | 10.37% |
Runs in your browser: nothing you type is sent anywhere.
Payment = PMT(rate/12, amortisation months, −note)
Balloon = balance after the balloon payment number
Note value = PV at the buyer’s yield of the payments net of servicing, plus PV of the balloon, less the buyer’s costs
In Excel: =PV(10%/12,60,-(PMT(8%/12,360,-198000)-30),-FV(8%/12,60,PMT(8%/12,360,-198000),-198000))-1400
The rate negotiated with the buyer of the house is a price negotiation in disguise: every point below the note buyer’s yield is a discount the seller takes if the note is ever sold. Yields are annual rates compounded monthly, the convention for notes. Real note buyers ask more for thin equity, unseasoned payments and weaker borrowers.
The term matters as much as the rate. With a five-year balloon one point of rate is worth about 3.8 points of price on this note; fully amortising over 30 years, about 7.8 points. Set the balloon to 0 to see a fully amortising note.
Go further with the worked example, step by step and the companion files for The Mortgage Note Investor.
Like any amortising loan: PMT(rate / 12, months, −loan amount). $198,000 at 8 per cent over 360 months is $1,452.85 a month. A balloon does not change the payment; it makes the remaining balance due early.
The rate at which a note buyer would pay what you want for the note. With a 10 per cent buyer, $30 a month of servicing and $1,400 of costs, the default note sells at face at about 10.37 per cent.
The present value of the payments and balloon at the yield a note buyer requires, less servicing and costs: $179,976.24 for the default note, 90.90 per cent of its $198,000 face.
This calculator comes from The Mortgage Note Investor by Julian R. Sterling, which works the same case in full, with every figure in a free workbook.
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 →