Share:

Bad debt provision: what we actually collect on financed sales

Of every dollar financed (sale minus deposit), how much comes in over time, split by the deposit taken up front, by year sold, kids v adults and city, and the provision that follows. As at 2026-11-17 (newest payment on the CRM schedules). 62,267 agreements since 2019.

Provision on Q3 2026 (Jul–Sep) financed
$3,594,868 57.9%
Mike's P&L calculated bad debt
$3,275,538 52.7%
Difference
+$319,330
Collected by month 12, 2024 v 2025
45.1% → 40.3%
Provision by deposit
66% under 15% · 27% 50%+

Provision rate by deposit % of sale

Collection has mostly stopped by about month 24. The rate starts from what 2024 sales have collected to date (the latest year that has mostly played out; it ties to the “Collected to date” column elsewhere on this page), then takes off the slip 2025 shows against 2024 at month 12 in the same band. Provision = 100% minus what we expect to collect. Applied to the money financed in Q3 2026 (Jul–Sep).

Deposit % of sale2024 collected to date2024 by m122025 by m12Slip (pts)Expect to collectProvisionQ3 2026 (Jul–Sep) financedProvision $
Under 15%37.3%32.9%29.6%−3.334.0%66%$3,746,402$2,477,675 60.3% of Q3
15–20%50.6%45.6%42.0%−3.647.0%53%$838,134$447,441 13.5% of Q3
20–30%57.3%52.5%48.7%−3.853.5%47%$1,109,430$507,588 17.9% of Q3
30–50%69.6%65.4%61.3%−4.165.5%34%$316,498$109,050 5.1% of Q3
50% or more79.2%76.9%71.0%−5.973.3%27%$200,984$53,114 3.2% of Q3
TOTAL57.9%$6,211,447$3,594,868

60% of the money financed in Q3 2026 (Jul–Sep) had a deposit under 15% of the sale, the band that loses the most. That is why a flat 50–55% comes out low. 2025 sales are still young, so if they keep slipping after month 12 these rates are too kind; re-check once 2025 reaches month 18–24.

What to book against today’s balance

The provision above is everything not expected to be collected of the money financed, credits included. Q3 2026 (Jul–Sep) sales already carry $311,649 of credits, which are already off the balance. The allowance to book against today’s balance of $5,168,537 is $3,283,219 (63.5% of it). Elena’s per-contract sheet, which works on the balance the same way, comes to $3,091,384.

The same rates on recent quarters

Quarter soldAgreementsFinancedDeposit under 15%Provision %Provision $
Q1 20252,800$5,908,07040.5%54.4%$3,214,585
Q2 20252,797$5,956,75443.0%54.7%$3,256,631
Q3 20252,738$5,611,08747.0%55.6%$3,122,093
Q4 20252,638$5,503,82951.7%56.4%$3,105,654
Q1 20262,782$6,341,61059.1%57.8%$3,666,812
Q2 20262,835$6,334,16157.4%57.3%$3,631,107
Q3 20262,766$6,211,44760.3%57.9%$3,594,868

The provision % moves with the deposit mix: a quarter with more low-deposit sales needs a bigger provision on the same rates.

With and without Monterey

Money Monterey collects on accounts we send them is keyed back into the CRM as “Paid to Monterey”, so the rates above count it as collected. It is 0.94% of the money financed to date in the under-15% band. Counting only what we collect ourselves, the Q3 2026 (Jul–Sep) provision is $3,649,392 (58.8%) instead of $3,594,868: $54,524 more.

Deposit % of sale2024 collected to dateof which MontereyWithout MontereyProvision with MontereyWithout MontereyQ3 2026 (Jul–Sep) $ withQ3 2026 (Jul–Sep) $ withoutDifference
Under 15%37.3%0.94%36.4%66%67%$2,477,675$2,511,078+$33,403
15–20%50.6%1.19%49.4%53%54%$447,441$454,492+$7,050
20–30%57.3%0.99%56.3%47%47%$507,588$517,511+$9,924
30–50%69.6%0.78%68.8%34%35%$109,050$111,514+$2,464
50% or more79.2%0.23%79.0%27%27%$53,114$54,797+$1,683
TOTAL57.9%58.8%$3,594,868$3,649,392+$54,524

Whether “Paid to Monterey” is what they collected before or after their fee is not known. If it is before the fee, the “with Monterey” figures count Monterey’s cut as ours, and the true provision sits a little above the “with” column. The rate used above stays the “with” one.

Q3 2026 (Jul–Sep): by city, against Mike’s P&L

Mike’s figure is a flat rate per city times “Total financed”. Ours applies the deposit-band rates to each agreement, adjusted for how well that city collects (below). Financed totals are shown side by side as the check that both count the same money. Only $9,699 was actually written off in the Q3 books.

CityFinanced (CRM)Financed (Mike)Deposit under 15%Mike rateMike $Our rateOur $Difference
Florida$1,588,719$1,584,41959%50.0%$792,21057.4%$911,654+$119,445
Texas$1,658,940$1,661,39065%55.0%$913,76561.0%$1,012,352+$98,588
Boston$746,545$746,59556%48.5%$362,09954.9%$409,724+$47,625
Chicago$759,036$759,43553%55.0%$417,68959.0%$447,503+$29,814
New York$837,938$838,13861%53.5%$448,40456.8%$476,072+$27,668
Nashville$620,269$620,67662%55.0%$341,37254.4%$337,563−$3,809
TOTAL$6,211,447$6,210,65360%52.7%$3,275,53857.9%$3,594,868+$319,330

City adjustment

Each city’s own collection against what the company deposit-band rates predict for that city’s own deposit mix. The difference is added to every band’s expected collection in that city, so a city that has always collected better than its mix gets a smaller provision, and one that collects worse gets a bigger one.

CityMeasured onAgreementsActually collectedBand rates predict for its mixAdjustment (pts)Provision Under 15%Provision 15–20%Provision 20–30%Provision 30–50%Provision 50% or more
Florida2024 sales, to date1,32953.2%53.3%−0.166%53%47%34%27%
Texas2024 sales, to date3,17349.4%51.5%−2.268%55%49%36%29%
Boston2024 sales, to date1,22259.5%57.3%+2.264%51%45%32%25%
Chicago2025 sales at month 1241739.7%41.8%−2.168%55%49%36%29%
New York2024 sales, to date3,05650.0%49.2%+0.865%52%46%33%26%
Nashville2024 sales, to date45053.3%49.1%+4.262%49%43%30%23%

Florida includes Orlando (Mike’s Florida LLC covers both; Orlando is too young to measure on its own); Texas is Dallas + Houston. Chicago has no 2024 sales, so it is measured at month 12 on 2025 sales against the 2025 band rates at month 12.

Each city’s own collection, 2024 and 2025 sales

GroupAgreementsFinancedm1m3m6m9m12m18m24m36m48Collected to dateof which MontereyCredited / written offStill owed
Florida · 20241,329$2.65M4.416.530.140.648.251.652.653.2%1.31%9.9%37.0%
Florida · 20251,440$3.29M2.414.127.037.744.548.547.3%0.20%7.5%45.2%
Texas · 20243,173$6.17M3.615.428.538.544.648.149.549.4%0.98%7.7%42.9%
Texas · 20253,356$7.22M3.113.023.131.436.640.438.8%0.26%5.5%55.7%
Boston · 20241,222$2.20M5.220.536.948.455.358.759.859.5%0.72%9.1%31.4%
Boston · 20251,326$2.47M3.615.630.241.849.150.552.4%0.46%6.2%41.5%
Chicago · 2025589$1.21M1.712.125.235.039.742.0%0.25%4.1%53.8%
New York · 20243,056$6.34M3.714.828.038.545.348.949.850.0%0.99%8.4%41.6%
New York · 20252,848$5.95M3.212.923.832.738.744.241.3%0.42%6.7%52.0%
Nashville · 2024450$0.88M3.717.232.943.749.852.352.353.3%0.74%5.5%41.3%
Nashville · 20251,414$2.84M3.413.925.535.041.045.342.9%0.22%5.2%51.9%

Is it getting better or worse?

Worse. By month 12, 2025 sales had collected 40.3% of the money financed, against 45.1% for 2024: down 4.8 points. On 2024’s deposit mix 2025 would read 43.1%, so 2.7 points is the mix (more sales on small deposits) and 2.0 points is people paying less in the same band.

By year sold

GroupAgreementsFinancedm1m3m6m9m12m18m24m36m48Collected to dateof which MontereyCredited / written offStill owed
20192,463$3.32M14.630.844.251.155.558.259.359.859.859.9%0.07%14.9%25.2%
20203,048$5.63M14.531.144.951.254.556.657.257.658.058.3%0.77%18.7%23.1%
20217,321$17.57M9.723.535.041.144.446.747.347.747.948.1%1.24%27.3%24.6%
20228,148$19.90M8.520.930.836.640.041.742.142.442.542.6%1.11%32.4%25.1%
20239,641$20.47M7.620.131.438.543.346.046.546.446.9%1.03%24.0%29.1%
202411,042$21.30M4.015.728.838.745.148.549.249.6%0.99%8.4%42.0%
202510,973$22.98M3.013.525.034.440.344.642.8%0.31%6.1%51.1%
20269,631$21.52M2.812.022.334.118.9%0.02%4.7%76.4%

By half-year, 2023 on

GroupAgreementsFinancedm1m3m6m9m12m18m24m36m48Collected to dateof which MontereyCredited / written offStill owed
2023 H14,676$10.70M8.621.131.437.642.044.344.945.345.4%1.05%27.0%27.7%
2023 H24,965$9.77M6.418.931.439.544.847.848.348.048.6%1.00%20.7%30.7%
2024 H15,707$11.06M4.415.728.037.544.348.148.749.2%1.03%9.1%41.8%
2024 H25,335$10.24M3.615.729.840.145.949.050.050.2%0.95%7.7%42.2%
2025 H15,597$11.86M3.314.125.334.640.544.644.4%0.47%7.1%48.4%
2025 H25,376$11.11M2.812.824.834.140.141.0%0.14%4.9%54.1%
2026 H15,617$12.68M3.012.222.334.126.0%0.03%4.9%69.1%
2026 H24,014$8.84M2.311.48.7%0.00%4.4%86.9%

Faded cells: fewer than three-quarters of that group’s money has reached that age yet, so the figure rests on its oldest sales only. The fall at month 6 is bigger than at month 12 partly because plans got longer (more 12-payment plans, smaller instalments), which spreads the same money out; compare years at month 12 or later.

2026 so far v the same months of earlier years

Every cell compares the same calendar months at the same age. At m1 that is every 2026 month that has had a full month since it ended; by m9 only the oldest months qualify, and the earlier years are cut to those same months. The row “on 2025’s deposit mix” is 2026 re-weighted to last year’s deposit bands: the gap between it and 2026 is the deposit mix, the gap between it and 2025 is people paying differently.

Sold inm1m3m6m9
20244.015.527.236.1
20253.113.826.640.9
20262.912.122.435.4
2026 on 2025’s deposit mix3.112.823.938.0
2026 v 2025 (points)-0.2-1.7-4.2-5.5
Months countedJan–SepJan–JulJan–AprJan

Adults only (kids taken out of every year)

Sold inm1m3m6m9
2024 adults4.015.527.236.1
2025 adults3.113.826.640.9
2026 adults2.812.122.435.3

By deposit band, 2025 v 2026

Sold inm1m3m6m9
Under 15% · 20252.410.219.130.2
Under 15% · 20262.39.918.228.6
15–20% · 20252.914.027.445.5
15–20% · 20262.311.522.633.5
20–30% · 20253.416.031.443.6
20–30% · 20264.015.829.044.7
30–50% · 20256.023.841.162.9
30–50% · 20265.018.634.058.6
50% or more · 20257.727.550.668.5
50% or more · 20266.322.141.268.8

Provision on Jan–Oct sales, same deposit-band rates

YearAgreementsFinancedDeposit under 15%Provision %Provision $
20249,489$18,042,90228.0%52.1%$9,401,590
20259,231$19,277,32743.5%54.9%$10,586,592
20269,229$20,676,45058.3%57.5%$11,891,638

The last 4 months (Jul–Oct 2026) v the same 4 months before

The newest sales, so only the early stages exist: m1 counts the months that have had a full month since they ended, m3 only the oldest. The months used are in the bottom row of the first table.

Sold inm1m3
20243.314.2
20252.712.0
20262.611.6
2026 on 2025’s deposit mix2.912.9
2026 v 2025 (points)-0.2-0.5
Months countedJul–SepJul

Adults only (kids taken out of every year)

Sold inm1m3
2024 adults3.314.2
2025 adults2.712.0
2026 adults2.311.0

By deposit band, 2025 v 2026

Sold inm1m3
Under 15% · 20252.29.1
Under 15% · 20261.89.4
15–20% · 20252.311.9
15–20% · 20262.09.5
20–30% · 20253.113.5
20–30% · 20264.617.5
30–50% · 20255.321.8
30–50% · 20264.119.8
50% or more · 20256.926.7
50% or more · 20266.823.4

Provision on Jul–Oct sales, same deposit-band rates

YearAgreementsFinancedDeposit under 15%Provision %Provision $
20243,782$6,987,53927.3%52.0%$3,634,604
20253,634$7,412,50346.3%55.5%$4,115,376
20263,612$8,000,67958.5%57.4%$4,593,719

Deposit % of sale: sales from 2022 to 2024

The bigger the deposit as a share of the sale, the more of the rest gets paid. The deposit is chosen by the customer, so it marks who could pay; it sorts a sale into its group for the provision, but asking for a bigger deposit does not by itself buy the better rate.

GroupAgreementsFinancedm1m3m6m9m12m18m24m36m48Collected to dateof which MontereyCredited / written offStill owed
Under 10%264$0.82M6.711.714.817.519.320.120.521.122.420.6%0.10%59.4%20.0%
10–15%10,952$30.18M4.614.423.629.934.036.537.137.536.837.5%1.02%26.8%35.6%
15–20%4,944$9.27M5.817.829.838.443.646.647.146.744.347.8%1.24%17.7%34.5%
20–30%8,856$16.86M7.822.336.746.652.755.756.258.255.756.7%1.07%13.6%29.7%
30–50%2,408$3.02M14.033.449.858.564.266.367.067.066.467.1%0.82%13.9%19.0%
50% or more1,407$1.51M25.251.264.771.274.174.974.774.873.475.8%0.91%11.8%12.5%

Same bands, year by year (m6 / m12 / m24)

Deposit % of sale2022 m62022 m122022 m242023 m62023 m122023 m242024 m62024 m122024 m242025 m62025 m122025 m242026 m62026 m122026 m24
Under 15%24.433.535.824.134.738.020.031.935.718.629.617.8
15–20%30.941.343.733.045.949.727.043.647.526.142.022.7
20–30%44.554.155.940.655.658.932.150.954.930.248.729.3
30–50%57.765.266.252.965.868.142.562.166.338.161.333.1
50% or more69.271.971.966.976.277.458.874.074.746.271.041.5

Share of the money financed in each band

Year soldUnder 15%15–20%20–30%30–50%50% or moreFinanced
202264.7%12.6%16.8%3.5%2.4%$19.90M
202357.8%13.4%21.0%5.4%2.5%$20.47M
202429.6%18.9%43.3%5.8%2.5%$21.30M
202545.4%17.5%29.5%4.8%2.8%$22.98M
202658.4%13.4%19.4%5.4%3.5%$21.52M

Under-15% deposits went from about a third of the money financed in 2024 to well over half in 2026. That drift alone lowers what the book collects, even if nobody in a band pays any worse.

Kids v adults

Kids only became a real line of sales in 2026-04; the oldest kids agreement is 8 months old. So there is no lifetime figure for kids yet. Compared with adults sold in the same months, at the same age:

GroupAgreementsFinancedm1m3m6m9m12m18m24m36m48Collected to dateof which MontereyCredited / written offStill owed
Kids (sold 2026-04 on)1,881$4.50M3.012.120.813.4%0.00%5.2%81.5%
Adults, same months4,947$10.62M2.411.019.713.9%0.00%4.6%81.5%

Within each deposit band

GroupAgreementsFinancedm1m3m6m9m12m18m24m36m48Collected to dateof which MontereyCredited / written offStill owed
Kids · Under 15%831$2.46M1.99.215.510.2%0.00%4.4%85.4%
Adults · Under 15%2,296$6.32M1.98.815.011.0%0.00%4.6%84.4%
Kids · 15–20%279$0.55M1.911.327.713.2%0.00%4.7%82.0%
Adults · 15–20%876$1.48M2.311.421.914.9%0.00%4.1%81.0%
Kids · 20–30%455$1.04M5.516.622.417.7%0.00%6.8%75.4%
Adults · 20–30%1,102$1.90M2.914.827.518.2%0.00%4.2%77.6%
Kids · 30–50%161$0.25M3.116.519.2%0.00%4.7%76.1%
Adults · 30–50%402$0.59M3.716.825.520.6%0.00%6.9%72.5%
Kids · 50% or more155$0.21M5.624.122.8%0.00%7.2%69.9%
Adults · 50% or more271$0.35M6.021.640.726.6%0.00%5.4%68.0%

Kids = the lead code (KIDSXP/KIDSX/KDX/KPX/KX, optional R, …KIDS, …3AB), same rule as /collection-curve. On this basis (share of the money financed) kids and adults are level so far; /collection-curve shows kids ahead because it measures the whole sale including the deposit. Use the same deposit-band rates for kids until they reach month 12.

Plan length: sales from 2022 to 2024

Shorter plans collect more of the balance. Plan length moves with deposit and sale size, so it is shown for context, not as a separate provision group.

GroupAgreementsFinancedm1m3m6m9m12m18m24m36m48Collected to dateof which MontereyCredited / written offStill owed
1 payment1,725$2.61M30.642.547.049.350.751.351.751.349.551.9%0.96%22.8%25.3%
2–66,404$9.60M11.532.445.849.550.851.652.051.348.352.3%1.07%21.9%25.9%
7–1010,224$23.28M4.415.928.938.944.046.346.944.241.747.5%1.13%17.7%34.9%
11–1210,252$25.61M4.414.024.131.838.141.842.240.437.842.9%0.97%24.1%33.0%
13+226$0.58M8.119.030.136.841.043.944.145.151.344.8%0.69%25.1%30.1%

Monterey: what it adds

Accounts sent to Monterey stop being billed in Square, so Monterey money is not in the Square recurring (back-end) figures. It reaches this page only through the CRM, where it is keyed as “Paid to Monterey” (counted in collected) and Monterey settlements, bankruptcies and write-offs (counted in credited / written off). Accounts placed with Monterey that have not paid stay in still owed. All told, Monterey has brought in $980,183, 1.74% of everything collected on finance. 18,371 agreements are placed, owing $32.87M of the $54.55M still owed.

By year sold

Year soldAgreementsFinancedPaid to Monterey (% of financed)Monterey credits (% of financed)Placed with Monterey (% of agreements)Placed and still owed (% of still owed)
20192,463$3.32M$2,223 0.07%$2,380 0.07%29 1.2%$0.02M 1.8%
20203,048$5.63M$43,238 0.77%$22,983 0.41%531 17.4%$0.86M 66.5%
20217,321$17.57M$217,047 1.24%$43,281 0.25%1,853 25.3%$3.79M 87.6%
20228,148$19.90M$221,601 1.11%$54,698 0.27%2,299 28.2%$4.65M 93.1%
20239,641$20.47M$210,325 1.03%$39,852 0.19%3,414 35.4%$5.76M 96.7%
202411,042$21.30M$211,340 0.99%$34,552 0.16%5,559 50.3%$8.75M 97.9%
202510,973$22.98M$70,998 0.31%$24,476 0.11%4,201 38.3%$7.86M 66.9%
20269,631$21.52M$3,412 0.02%$3,550 0.02%485 5.0%$1.18M 7.2%

Recent years show little because accounts reach Monterey a year or more after the sale, and Monterey takes time to collect.

By month, 2025 on

MonthPaid to Monterey (keyed that month)Monterey creditsAccounts placed
2026-11 part month$0$7,22813
2026-10$21,410$9,230365
2026-09$30,447$16,195462
2026-08$27,838$6,482365
2026-07$29,495$2,101354
2026-06$35,895$4,665284
2026-05$30,440$2,697263
2026-04$13,252$11,780233
2026-03$24,428$3,638176
2026-02$22,621$2,780165
2026-01$17,731$745473
2025-12$18,974$1,598538
2025-11$12,574$4,465468
2025-10$10,223$1,894525
2025-09$19,937$0518
2025-08$28,016$7,250397
2025-07$23,826$7,960500
2025-06$27,988$1,785443
2025-05$19,427$3,019513
2025-04$17,659$6,303424
2025-03$31,319$6,071497
2025-02$11,077$8,801377
2025-01$17,658$1,975460

“Keyed that month” is the date the payment was entered in the CRM, which can lag the date Monterey took the money. Placements are the CRM collections flag’s date. Whether “Paid to Monterey” is before or after Monterey’s fee is not known.

What a deal is really worth, by the deposit taken on the day: 2024 sales

Worth = the deposit taken on the day plus everything collected on the finance since (to date, Monterey included). 2024 is the latest year whose sales have mostly played out, so these are real money, not a forecast. “Collected later per $1 of deposit” is how much more came in for every dollar taken on the day.

By deposit as a % of the sale

Deposit on the dayDealsAvg saleAvg depositAvg financedAvg collected sinceWorth per dealWorth as % of saleNever collected per dealCollected later per $1 of deposit
Under 10%38$2,395$65$2,330$274$33914.1%$2,056$4.21
10–15%2,874$2,452$292$2,160$788$1,08044.0%$1,372$2.69
15–20%2,012$2,388$388$2,000$967$1,35556.7%$1,033$2.49
20–30%4,675$2,534$562$1,972$1,098$1,66065.5%$874$1.95
30–50%951$2,019$730$1,289$857$1,58778.6%$432$1.17
50% or more492$2,405$1,324$1,081$823$2,14789.3%$258$0.62
TOTAL financed deals11,042$2,435$507$1,929$958$1,46460.1%$971$1.89

By deposit in dollars

Deposit on the dayDealsAvg saleAvg depositAvg financedAvg collected sinceWorth per dealWorth as % of saleNever collected per dealCollected later per $1 of deposit
Under $100617$461$61$400$147$20845.2%$252$2.40
$100–2492,246$905$152$753$310$46151.0%$444$2.04
$250–4993,867$2,514$368$2,146$896$1,26450.3%$1,251$2.43
$500–9993,031$3,318$690$2,628$1,421$2,11163.6%$1,208$2.06
$1,000–1,9991,068$3,712$1,166$2,546$1,624$2,79075.2%$922$1.39
$2,000 or more213$3,894$2,150$1,745$1,322$3,47289.1%$423$0.62
TOTAL financed deals11,042$2,435$507$1,929$958$1,46460.1%$971$1.89

The deposit is chosen by the customer, so a big deposit marks someone who could pay; asking for a bigger deposit does not by itself make the rest come in. 2024 sales are still paying a little, so worth will creep up slightly. Groups under 30 deals are left out.

Is a deal worth less than it used to be? Worth by month 12, % of sale

The same measure at the same age (deposit plus collected within 12 months of the shoot), so younger years can be compared fairly.

Deposit % of sale20222023202420252026
Under 10%24.1%21.4%13.8%
10–15%42.0%43.0%40.2%38.0%
15–20%50.8%54.7%52.7%51.4%
20–30%65.3%66.0%61.8%60.3%
30–50%77.9%78.1%75.8%75.3%
50% or more87.5%89.4%88.3%86.7%
TOTAL50.6%53.9%56.5%52.0%

Faded: fewer than three-quarters of that group’s money has reached month 12 yet. Blank: under 30 deals.

Elena’s bad debt calculation against ours: Q3 2026 (Jul–Sep)

Elena: $3,233,987. Ours (deposit-band rates): $3,594,868. Mike’s P&L: $3,275,538. The methods differ in what the rate is applied to. Elena applies her rate to the balance still owed, so money already paid since the sale (up to four months of instalments) is taken out first. Ours applies a rate to the whole amount financed, and that rate already allows for those early payments. To compare like with like, both are shown as a % of the money financed.

GroupFinanced (CRM)Still owed today (CRM)Balance Elena usedElena rate (on balance)Elena $ (% of financed)Ours $ (% of financed)Ours v Elena
Studio 1 (Florida)$562,399$461,027$488,04556.8%$277,061 49.3%$315,871 56.2%+$38,810
Orlando$1,026,320$855,565$911,29554.7%$498,557 48.6%$595,783 58.1%+$97,226
Dallas$682,735$565,234$593,05167.7%$401,745 58.8%$397,662 58.2%−$4,083
Houston$976,205$812,327$853,44062.1%$529,782 54.3%$614,690 63.0%+$84,908
Boston$746,545$612,529$648,71352.1%$338,253 45.3%$409,724 54.9%+$71,471
Chicago$759,036$642,178$668,00460.2%$402,421 53.0%$447,503 59.0%+$45,082
New York$837,938$690,454$713,45864.2%$457,766 54.6%$476,072 56.8%+$18,306
Nashville$620,269$529,222$562,85158.3%$328,403 52.9%$337,563 54.4%+$9,160
TOTAL$6,211,447$5,168,537$5,438,85759.5%$3,233,987 52.1%$3,594,868 57.9%+$360,881

By month sold

GroupFinanced (CRM)Still owed today (CRM)Balance Elena usedElena rate (on balance)Elena $ (% of financed)Ours $ (% of financed)Ours v Elena
Jul 2026$2,246,882$1,783,921$1,859,37762.7%$1,166,409 51.9%$1,315,579 58.6%+$149,171
Aug 2026$2,187,800$1,812,864$1,908,92359.3%$1,132,335 51.8%$1,260,084 57.6%+$127,749
Sep 2026$1,776,766$1,571,752$1,670,55856.0%$935,243 52.6%$1,019,204 57.4%+$83,961
TOTAL$6,211,447$5,168,537$5,438,85759.5%$3,233,987 52.1%$3,594,868 57.9%+$360,881

Every city and month

GroupFinanced (CRM)Still owed today (CRM)Balance Elena usedElena rate (on balance)Elena $ (% of financed)Ours $ (% of financed)Ours v Elena
Studio 1 · Jul$233,920$187,011$194,82859.7%$116,312 49.7%$131,647 56.3%+$15,335
Studio 1 · Aug$164,130$133,692$139,73059.9%$83,698 51.0%$90,736 55.3%+$7,037
Studio 1 · Sep$164,349$140,324$153,48750.2%$77,051 46.9%$93,489 56.9%+$16,438
Orlando · Jul$375,560$297,386$312,60057.1%$178,495 47.5%$223,826 59.6%+$45,331
Orlando · Aug$390,288$320,932$345,65755.7%$192,531 49.3%$221,241 56.7%+$28,710
Orlando · Sep$260,472$237,247$253,03750.4%$127,531 49.0%$150,716 57.9%+$23,186
Dallas · Jul$246,552$180,900$189,80667.1%$127,360 51.7%$143,688 58.3%+$16,328
Dallas · Aug$216,217$187,407$195,72670.0%$137,008 63.4%$125,681 58.1%−$11,327
Dallas · Sep$219,967$196,928$207,51866.2%$137,377 62.5%$128,294 58.3%−$9,083
Houston · Jul$337,955$268,483$285,85567.6%$193,238 57.2%$217,001 64.2%+$23,764
Houston · Aug$326,810$263,515$278,07559.6%$165,732 50.7%$208,275 63.7%+$42,543
Houston · Sep$311,440$280,330$289,51159.0%$170,811 54.8%$189,413 60.8%+$18,602
Boston · Jul$266,800$208,821$219,31660.0%$131,589 49.3%$150,761 56.5%+$19,172
Boston · Aug$292,260$238,266$253,55151.2%$129,818 44.4%$155,971 53.4%+$26,153
Boston · Sep$187,485$165,442$175,84743.7%$76,845 41.0%$102,991 54.9%+$26,146
Chicago · Jul$248,314$200,293$203,07863.5%$128,955 51.9%$149,717 60.3%+$20,762
Chicago · Aug$275,147$230,651$237,75457.5%$136,709 49.7%$158,295 57.5%+$21,586
Chicago · Sep$235,575$211,234$227,17260.2%$136,758 58.1%$139,492 59.2%+$2,734
New York · Jul$329,892$271,712$274,60066.6%$182,884 55.4%$186,325 56.5%+$3,441
New York · Aug$309,363$255,473$264,96464.3%$170,372 55.1%$180,328 58.3%+$9,957
New York · Sep$198,683$163,270$173,89460.1%$104,511 52.6%$109,418 55.1%+$4,908
Nashville · Jul$207,889$169,317$179,29460.0%$107,576 51.7%$112,615 54.2%+$5,039
Nashville · Aug$213,585$182,928$193,46660.2%$116,466 54.5%$119,557 56.0%+$3,091
Nashville · Sep$198,795$176,978$190,09154.9%$104,360 52.5%$105,391 53.0%+$1,031
TOTAL$6,211,447$5,168,537$5,438,85759.5%$3,233,987 52.1%$3,594,868 57.9%+$360,881

Balance Elena used = her loss divided by her rate. Compare it with still owed today from the CRM: where they match, she used the same balances; where hers is higher, she took the balance at an earlier date. Her figures are typed in from her doc, not re-read each day.

Locked quarter-end rates

The page rebuilds every day, so the live rates move a little each time. The books need one rate per quarter. On the first build after a quarter ends, the rates are locked for that quarter and its sales are provisioned at them from then on. Sales in the quarter still running use the live rates until it closes. How often: new sales are provisioned every month at the current rates; the rates are re-set every quarter-end; the base year moves on once a year, when the next year’s sales have mostly reached month 24.

QuarterLocked onPayments toBased onFinancedProvision (locked)Provision $At today’s live rates
2026-Q32026-11-052026-11-042024 less 2025 slip$6,211,44757.9%$3,594,86858.0%

Rates locked for 2026-Q3: by city and deposit on the day

Deposit % of saleFloridaTexasBostonChicagoNew YorkNashvilleNo city (e.g. Atlanta)
Under 15%66%68%64%69%65%62%66%
15–20%53%55%51%56%52%49%53%
20–30%46%48%44%49%45%42%46%
30–50%34%36%32%37%33%30%34%
50% or more26%28%24%29%25%22%26%

Locks are kept in data/bad_debt_rates_locked.json in the repository and are never rewritten by the daily build. The first lock (2026-Q3) was set on 2026-11-05, after that quarter ended, from the rates on that day.

Check against what actually happened

For each past quarter: the rates this method would have set at that quarter-end, using only payments made by then, applied to that quarter’s sales, against what those sales have not collected by today. Close to zero means the method gets it right. Plus means it set aside more than was lost; minus means less.

Quarter soldAgreementsFinancedRates based onProvision thenNot collected by todayof which still owedAvg months since saleProvision v outcome (pts)
2022-Q11,575$4.19M2019 less 2020 slip$1,909,492 45.6%$2,325,606 55.5%23.4%57−9.9
2022-Q21,315$3.54M2019 less 2020 slip$1,615,548 45.7%$2,209,447 62.4%24.2%54−16.8
2022-Q31,403$3.66M2019 less 2020 slip$1,683,605 46.0%$2,128,895 58.1%21.9%51−12.2
2022-Q41,284$3.16M2020 less 2021 slip$1,674,771 53.0%$1,777,419 56.3%24.3%48−3.3
2023-Q11,696$4.20M2020 less 2021 slip$2,236,109 53.3%$2,310,752 55.0%24.8%45−1.8
2023-Q21,795$4.19M2020 less 2021 slip$2,229,358 53.2%$2,228,605 53.2%28.0%42+0.0
2023-Q31,982$4.09M2020 less 2021 slip$1,999,993 48.9%$2,039,008 49.8%27.2%39−1.0
2023-Q41,999$3.94M2021 less 2022 slip$1,984,579 50.4%$1,991,879 50.6%32.1%36−0.2
2024-Q12,268$4.43M2021 less 2022 slip$2,077,355 46.9%$2,141,865 48.3%37.9%33−1.5
2024-Q22,186$4.32M2021 less 2022 slip$2,081,211 48.2%$2,029,707 47.0%39.2%30+1.2
2024-Q32,403$4.59M2022 less 2023 slip$2,230,429 48.6%$2,196,398 47.8%39.8%27+0.7
2024-Q42,373$4.90M2022 less 2023 slip$2,520,710 51.5%$2,466,121 50.4%43.2%24+1.1

By city, all those quarters together

CityFinancedProvision thenNot collected by todayProvision v outcome (pts)
Florida$7.72M$3,646,591 47.2%$3,810,137 49.3%−2.1
Texas$12.53M$6,313,973 50.4%$6,415,235 51.2%−0.8
Boston$3.40M$1,377,078 40.5%$1,317,707 38.8%+1.7
New York$24.67M$12,434,525 50.4%$13,891,049 56.3%−5.9
Nashville$0.88M$470,994 53.5%$411,575 46.7%+6.7

“Not collected by today” includes money still owed, some of which will still come in, so the final loss will be a little lower than shown, most of all for the youngest quarters. Six P&L cities only. Check on the rebuild: at today’s date it lands 0.0 points above the live rates on Q3 2026 (Jul–Sep) sales (it uses the payment schedule for collected-to-date, the live rates use the ledger).

How it’s worked out