For Mike, Martin and Leanne. From the CRM debtor ledger, payments to 2026-11-17. Rates locked for 2026-Q3 on 2026-11-05. Provision = share of the money financed (sale minus deposit) that we do not expect to collect.
Applied to $6,211,447 financed that is $3,594,868 not expected to be collected. $311,649 of that has already been credited on these sales (refunds, discounts, write-offs), so it is already off the balance. The allowance to book against today’s balance of $5,168,537 is $3,283,219.
| City | Provision | Financed | Not collected $ | Credits already posted | Allowance to book | Mike’s P&L $ | Elena $ |
|---|---|---|---|---|---|---|---|
| Florida incl. Orlando | 57% | $1,588,719 | $911,654 | −$80,817 | $830,838 | $792,210 | $750,622 |
| Texas Dallas + Houston | 61% | $1,658,940 | $1,012,352 | −$111,525 | $900,827 | $913,765 | $875,232 |
| Boston | 55% | $746,545 | $409,724 | −$34,150 | $375,574 | $362,099 | $321,372 |
| Chicago | 59% | $759,036 | $447,503 | −$17,180 | $430,323 | $417,689 | $402,421 |
| New York | 57% | $837,938 | $476,072 | −$58,477 | $417,594 | $448,404 | $424,160 |
| Nashville | 54% | $620,269 | $337,563 | −$9,500 | $328,063 | $341,372 | $317,577 |
| TOTAL | 58% | $6,211,447 | $3,594,868 | −$311,649 | $3,283,219 | $3,275,538 | $3,091,384 |
| Deposit % of sale | Florida | Texas | Boston | Chicago | New York | Nashville | All cities |
|---|---|---|---|---|---|---|---|
| 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 more | 26% | 28% | 24% | 29% | 25% | 22% | 26% |
Rebuilt as it would have been set at each past quarter-end and compared with what those sales have not collected by today: from 2023 on it lands within 1.8 points every quarter. In 2022 it was 3–17 points too low, because the rates then came from 2019–2020 sales, before the economy turned. That is why the rates are re-set every quarter and not left alone.
Full workings, every table and the check: https://reports.iconicbyai.com/bad-debt-provision