Articles

How much does idle cash cut the portfolio yield of a tax lien investor?

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

The assumptions

Illustrative tax lien account, one auction a year
ItemValue
Capital$500,000
Share bid at auction85%
Interest rate on the certificates, simple, annual16.0%
Average time to redemption7 months
Return on idle cash4.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.

Step 1: interest on the certificates

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.

Step 2: interest on idle cash

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.

Step 3: the portfolio yield

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.

How much the holding period matters

Account income by months to redemption, 85% deployed
Time to redemptionCertificate interest, $Cash interest, $Total, $Portfolio yield
3 months17,00015,75032,7506.55%
7 months39,66710,08349,7509.95%
12 months68,0003,00071,00014.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.

What if: the whole account is bid

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.

What if: a second auction after six months

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.

The common mistakes

Takeaway

Free Excel template: tax lien certificate yield calculator.

Questions readers ask

Why is a tax lien portfolio yield lower than the certificate rate?

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.

How do you calculate the yield of a tax lien 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%.

Does a faster redemption raise or lower the account return?

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 workbooks behind this article

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.

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 →