For Mike, Martin and Leanne · rates locked 2026-11-05 · CRM debtor ledger, payments to 2026-11-04
$3,595,750 of the $6,213,897 financed is not expected to be collected. $299,494 of that has already been credited on these sales (refunds, discounts, write-offs) and is already off the balance. Allowance to book: $3,296,256.
| City | Rate (of financed) | Financed | Not collected | Credits posted | Allowance to book | Mike's P&L | Elena |
|---|---|---|---|---|---|---|---|
| Florida (incl. Orlando) | 57% | $1,588,719 | $911,654 | −$74,292 | $837,363 | $792,210 | $750,622 |
| Texas (Dallas + Houston) | 61% | $1,661,390 | $1,013,234 | −$110,525 | $902,709 | $913,765 | $875,232 |
| Boston | 55% | $746,545 | $409,724 | −$34,150 | $375,574 | $362,099 | $321,372 |
| Chicago | 59% | $759,036 | $447,503 | −$16,550 | $430,953 | $417,689 | $402,421 |
| New York | 57% | $837,938 | $476,072 | −$55,477 | $420,594 | $448,404 | $424,160 |
| Nashville | 54% | $620,269 | $337,563 | −$8,500 | $329,063 | $341,372 | $317,577 |
| TOTAL | 58% | $6,213,897 | $3,595,750 | −$299,494 | $3,296,256 | $3,275,538 | $3,091,384 |
| Deposit as % 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% |
Full workings: https://reports.iconicbyai.com/bad-debt-provision · Web version: https://reports.iconicbyai.com/bad-debt-summary