At a low bid the county pays the same $4,182.94 whether the owner redeems in month 2 or month 24. Only the clock changes, and the IRR falls from 20.34 per cent to 2.25.
Certificate C-0412, won at a bid of 0.25 per cent, pays $4,182.94 whenever it is redeemed. Redeemed in month 2 that is 20.34 per cent a year; in month 6, 8.26; in month 7, 7.19, below an 8 per cent hurdle; in month 12, 4.36. The certificate stops clearing the hurdle after month 6 and stops beating a 4 per cent Treasury bill after month 13. The cause is the 5 per cent minimum charge: it fixes the payoff for every bid up to a crossover month of 60 divided by the bid, so a low bid is a bet on speed and on nothing else.
Chapters 2 and 3 of the book take one certificate from face amount to yield and show that the rate is not the yield. This article asks the question that follows: how long can the owner take? Every figure comes from C-0412 and Calder County’s rules as the book sets them, and each one is recalculated below from the formulas.
| Item | Value |
|---|---|
| Face amount of C-0412 | $3,983.75 |
| Fee paid with the face on sale day | $10.00 |
| Paid by the investor in month 0 | $3,993.75 |
| Minimum charge, 5 per cent of the face | $199.19 |
| Payoff at the minimum (face plus minimum) | $4,182.94 |
| Interest at the bid | simple, bid ÷ 12 a month |
| Payment lag | 1 month |
| Hurdle and Treasury bill | 8% and 4% |
The payoff is the face plus the larger of interest at the bid and the minimum:
Payoff = face × (1 + MAX(bid × m ÷ 12, 5%)). In Excel: =B2*(1+MAX(B3*B4/12,0.05)), with face in B2, bid in B3 and the redemption month in B4.
At a 0.25 per cent bid, interest for 2 months is 0.04 per cent of the face, nothing beside the 5 per cent minimum, so the payoff is 3,983.75 × 1.05 = $4,182.94. At 24 months it is 0.50 per cent, still nothing. The payoff does not move.
Interest at the bid overtakes the minimum when bid × m ÷ 12 reaches 5 per cent, that is at m = 12 × 5% ÷ bid. With the bid in per cent, m = 60 ÷ bid. In Excel: =12*0.05/B3.
| Bid | Crossover month | Last whole month at the minimum | IRR if redeemed in month 12 |
|---|---|---|---|
| 0.25% | 240.00 | 240 | 4.36% |
| 0.50% | 120.00 | 120 | 4.36% |
| 1.00% | 60.00 | 60 | 4.36% |
| 2.50% | 24.00 | 24 | 4.36% |
| 5.00% | 12.00 | 12 | 4.36% |
| 9.00% | 6.67 | 6 | 8.03% |
| 18.00% | 3.33 | 3 | 16.24% |
Bids from 0.25 to 5 per cent give the same month-12 IRR to the hundredth, because they pay the same dollars on the same dates. The first bid that changes the answer in month 12 is the 9 per cent one, whose crossover at month 6.67 falls before the redemption.
The investor puts in $3,993.75 in month 0 and receives the payoff in month m + 1. The monthly rate that equates the two, compounded to a year, is (payoff ÷ 3,993.75)12 ÷ (m + 1) − 1. In Excel: =(payoff/(B2+10))^(12/(B4+1))-1.
For month 6 at a 0.25 per cent bid: 4,182.94 ÷ 3,993.75 = 1.04737; received in month 7, that is 1.0473712/7 = 1.0826, an IRR of 8.26 per cent. For month 2 the exponent is 12/3 = 4, and 1.047374 = 1.2034.
| Redeemed in month | Bid 0.25% to 2.5% | Bid 5% | Bid 9% | Bid 18% |
|---|---|---|---|---|
| 1 | 32.01% | 32.01% | 32.01% | 32.01% |
| 2 | 20.34% | 20.34% | 20.34% | 20.34% |
| 3 | 14.90% | 14.90% | 14.90% | 14.90% |
| 4 | 11.75% | 11.75% | 11.75% | 14.32% |
| 6 | 8.26% | 8.26% | 8.26% | 15.42% |
| 12 | 4.36% | 4.36% | 8.03% | 16.24% |
| 24 | 2.25% | 4.56% | 8.14% | 15.76% |
Read the columns together. Through month 3 the four bids are indistinguishable, because even 18 per cent has earned only 4.5 per cent of the face by then. After the crossover the 18 per cent column recovers and holds near 15 to 16 per cent, since interest keeps accruing; the 9 per cent column settles near 8. The low-bid columns have nothing to recover with: the payoff is fixed and the denominator, time, keeps growing.
The 18 per cent column never shows 18. At month 12 it reads 16.24: with no fee and no lag the same payoff would earn 18.00, the fee alone takes it to 17.70, the lag alone to 16.51, and both to 16.24.
A 0.25 per cent bid earns the payoff ratio 4,182.94 ÷ 3,993.75 = 1.04737 and then only time acts on it. It matches a target rate h when 1.04737 = (1 + h)(m + 1) ÷ 12, so m + 1 = 12 × ln(1.04737) ÷ ln(1 + h).
| Target | Money back after (m + 1) | Last month of redemption that clears it |
|---|---|---|
| 8% hurdle | 7.22 months | month 6 (8.26%); month 7 gives 7.19% |
| 4% Treasury bill | 14.16 months | month 13 (4.05%); month 14 gives 3.77% |
So a certificate won at the bottom of the auction has about six months to be redeemed, and the investor does not choose them. The month-by-month series around the line is 11.75 (month 4), 9.70 (5), 8.26 (6), 7.19 (7).
The 5 per cent minimum turns a low bid into a pure bet on the redemption date: 20.34 per cent in month 2, 8.26 in month 6, 4.36 in month 12, all from the same $4,182.94. Before bidding low, divide 60 by the bid to find the crossover and check how many months of the county’s own redemption record fall before it. On this certificate a low bid stops earning 8 per cent after month 6. For how far down the bid can go class by class, see How low can you bid on a tax lien certificate and still earn 8 per cent?
The figures above are in Calder_Certificate_Yield.xlsx. Yellow cells with blue type are inputs; the Certificate sheet gives the face amount and the $4,182.94 payoff, and the Yield_Grid sheet gives the IRR a year for every bid and redemption month. Change the minimum charge, the fee or the payment lag on the Inputs sheet and the grid follows. The Decomposition sheet separates what the lag and the $10 fee cost on a one-year hold.
Free Excel template: tax lien certificate yield calculator.
At month 60 divided by the bid in per cent: 24 at a 2.5 per cent bid, 12 at 5, 6.67 at 9 and 3.33 at 18. Until then the county pays the greater of that interest and 5 per cent of the face, so a bid below the crossover changes nothing. At 0.25 per cent the crossover is month 240.
Because interest at 18 per cent for three months is 4.5 per cent of the face, still under the 5 per cent minimum. Certificate C-0412 pays $4,182.94 at any bid from 0.25 to 18, and the IRR is 14.90 per cent for all of them.
Until month 6: redeemed in month 6 it earns 8.26 per cent a year, in month 7 it earns 7.19. It beats a 4 per cent Treasury bill through month 13 (4.05 per cent) and not in month 14 (3.77).
Every figure above is a live formula in the free companion files for The Tax Lien Investor, which also hold the Calder County redemption record, premium bidding with its break-even premiums, the sixty-certificate stress test and a Wexley County tax deed. Each worked workbook ends with a checks sheet setting the printed figure beside the computed one. 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 →