Articles

How long can a low-bid tax lien certificate go unredeemed and still earn 8 per cent?

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.

The assumptions

ItemValue
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 bidsimple, bid ÷ 12 a month
Payment lag1 month
Hurdle and Treasury bill8% and 4%
An owner who redeems in month m pays the greater of interest at the bid for m months and the minimum; the county pays the investor one month later, in month m + 1.

Step 1: the payoff

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.

Step 2: the crossover month

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.

BidCrossover monthLast whole month at the minimumIRR if redeemed in month 12
0.25%240.002404.36%
0.50%120.001204.36%
1.00%60.00604.36%
2.50%24.00244.36%
5.00%12.00124.36%
9.00%6.6768.03%
18.00%3.33316.24%
Crossover = 60 ÷ bid. On a 24-month record every bid up to 2.5 per cent pays the minimum on every redemption; a 5 per cent bid ties it in month 12.

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.

Step 3: the IRR by redemption month

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 monthBid 0.25% to 2.5%Bid 5%Bid 9%Bid 18%
132.01%32.01%32.01%32.01%
220.34%20.34%20.34%20.34%
314.90%14.90%14.90%14.90%
411.75%11.75%11.75%14.32%
68.26%8.26%8.26%15.42%
124.36%4.36%8.03%16.24%
242.25%4.56%8.14%15.76%
Expected IRR a year of C-0412 by bid and redemption month. Fee $10, one-month lag, 5 per cent minimum.

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.

Step 4: how many months before the hurdle is lost

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).

TargetMoney back after (m + 1)Last month of redemption that clears it
8% hurdle7.22 monthsmonth 6 (8.26%); month 7 gives 7.19%
4% Treasury bill14.16 monthsmonth 13 (4.05%); month 14 gives 3.77%
In Excel: =12*LN(4182.94/3993.75)/LN(1+target), then subtract 1 for the lag.

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).

What if the county’s rules were different?

The common mistakes

Takeaway

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?

Reproducing it in the workbook

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.

Questions readers ask

At what month does the 5 per cent minimum stop applying to a tax lien certificate?

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.

Why does a tax lien certificate redeemed in month 3 earn the same at every bid?

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.

How long can a 0.25 per cent certificate stay unredeemed and still beat an 8 per cent hurdle?

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).

The workbooks behind this article

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.

Open the companion files →

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: real estate investing, finance and fund management → · All 1908 articles →