A tax lien certificate pays its stated rate only while it is outstanding. Redeemed money waits for the next auction, and the reserve never leaves cash. The portfolio yield is the weighted result.
A $500,000 account bids 85% of its capital, $425,000, at 16% a year. The certificates are redeemed after seven months on average, and the cash then waits for the next auction at 4%. The 15% reserve stays in cash all year. Interest on the certificates is $39,667, interest on idle cash is $10,083, and the account earns $49,750, 9.95% of capital. The 16% headline overstates the portfolio by 6.05 points. To earn 12% on the whole account at this pace, the headline would have to be 20.1%.
| Item | Value |
|---|---|
| Capital | $500,000 |
| Share bid at auction | 85% |
| Interest rate on the certificates, simple, annual | 16.0% |
| Average time to redemption | 7 months |
| Return on idle cash | 4.0% |
Foreclosure losses, fees and subsequent taxes are ignored so that the effect of idle time stands alone. Interest accrues only while a certificate is outstanding; after redemption the money comes back and earns the cash rate until the next auction.
Interest = capital bid × rate × months outstanding ÷ 12
Capital bid = 500,000 × 85% = $425,000. Interest = 425,000 × 16% × 7 ÷ 12 = $39,667. On the money bid, that is 9.33% for the year: the 16% is earned for 7 months out of 12.
Two pools of cash earn the cash rate. The redeemed money waits 12 − 7 = 5 months: 425,000 × 4% × 5 ÷ 12 = $7,083. The reserve of 500,000 − 425,000 = $75,000 stays in cash for the whole year: 75,000 × 4% = $3,000.
Portfolio yield = (certificate interest + cash interest) ÷ capital
Excel: =(C2*D2*E2/12+C2*(12-E2)/12*F2+(B2-C2)*F2)/B2
(39,667 + 7,083 + 3,000) ÷ 500,000 = 49,750 ÷ 500,000 = 9.95%. The certificate rate of 16% turns into 9.95% for three reasons in this order: seven months out of twelve, 15% of capital never bid, and cash that earns 4% in between. Only $39,667 of the $49,750, 80%, is certificate interest.
| Time to redemption | Certificate interest, $ | Cash interest, $ | Total, $ | Portfolio yield |
|---|---|---|---|---|
| 3 months | 17,000 | 15,750 | 32,750 | 6.55% |
| 7 months | 39,667 | 10,083 | 49,750 | 9.95% |
| 12 months | 68,000 | 3,000 | 71,000 | 14.20% |
A certificate redeemed after three months turns a 16% headline into 6.55%, because most of the year is spent in cash. Holding all twelve months gives 14.20%. Fast redemption looks like a good outcome on a single certificate, with the money back quickly, but the account only earns the headline rate while the money is out.
With 100% bid and seven months to redemption, certificate interest is 500,000 × 16% × 7 ÷ 12 = $46,667 and cash interest is $8,333, a total of $55,000 or 11.00%. Deploying the 15% reserve adds 1.05 points, but leaves nothing for subsequent taxes or a second auction.
If the jurisdiction holds two auctions a year, the 85% can be bid twice for a four-month average holding each time. Interest on certificates is 2 × 425,000 × 16% × 4 ÷ 12 = $45,333; idle cash interest is $5,667 plus $3,000 on the reserve. The account earns $54,000, 10.80%, 0.85 points more than with one auction, even though each certificate is held for less time.
Free Excel template: tax lien certificate yield calculator.
The certificate pays its rate only while it is outstanding and only on the money bid. Redeemed cash waits for the next auction and a reserve stays in cash, both earning far less. Here 16% on the certificates became 9.95% on the account.
Add the interest on the certificates (amount bid x rate x months outstanding / 12) and the interest on idle cash, then divide by total capital. With $500,000, 85% bid at 16% for seven months and 4% on cash, the result is 9.95%.
It lowers it, if the money cannot be redeployed quickly. A three-month redemption gives 6.55% on the account against 14.20% for twelve months, because the account sits in cash for the rest of the year.
The free companion files for The Tax Lien Investor rebuild a fictional county auction, the bid-down, redemption timing, subsequent taxes and the portfolio return in live formulas. The account in this article is invented and is not in them. No account and no email address.
Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: real estate investing, finance and fund management → · All 1908 articles →