Formula
Outstanding balance = Σ balance. Total funded = Σ funded. Average deal = Total funded ÷ Accounts.
Weighted gross yield = Σ funded × (factor − 1) ÷ Σ funded. Purchased amount delivered = 1 − Outstanding balance ÷ Σ funded × factor.
30+ day delinquency = Σ balance where days_past_due ≥ 30 ÷ Outstanding balance; 90+ the same with ≥ 90. Both are balance-weighted, not account counts.
Concentration = balance in the largest industry (or state) ÷ Outstanding balance. Vintage table = balance, share of balance and 30+ day share for each vintage label.
Worked examples
Example 1: the sample portfolio of eight deals
Balances: 21,000 + 12,400 + 66,000 + 9,800 + 41,000 + 3,100 + 98,000 + 19,000 = $270,300. Funded: 50,000 + 30,000 + 80,000 + 25,000 + 60,000 + 45,000 + 120,000 + 35,000 = $445,000; average deal $445,000 ÷ 8 = $55,625. Gross yield: each deal's funded × (factor − 1) is 15,000 + 10,500 + 20,000 + 10,000 + 16,800 + 14,400 + 26,400 + 13,300 = $126,400; divided by $445,000 that is 28.4 percent. Total purchased amount: $445,000 + $126,400 = $571,400; delivered 1 − 270,300 ÷ 571,400 = 52.7 percent, shown as 53 percent. Delinquency: accounts 1004 (45 days, $9,800) and 1006 (95 days, $3,100) are 30-plus, $12,900 ÷ $270,300 = 4.8 percent; only 1006 is 90-plus, $3,100 ÷ $270,300 = 1.1 percent. Both are inside the tool's warning thresholds of 8 and 3 percent and show green. Largest industry: Manufacturing, $98,000, 36 percent of balance; largest state: Ohio, the same $98,000, 36 percent, because one deal is both. Vintage table: 2026-Q2 $205,000 (76 percent, 0 percent 30-plus), 2026-Q1 $52,400 (19 percent, 0 percent), 2025-Q4 $9,800 (4 percent, 100 percent), 2025-Q3 $3,100 (1 percent, 100 percent). The older vintages are entirely delinquent, which is typical: deals that are still open long after their expected delivery are the ones that have slowed or stopped.
Example 2: the same book without the largest deal
Delete the row for 1007 (Manufacturing, Ohio, $120,000 funded at 1.22, $98,000 balance). Balance: $270,300 − $98,000 = $172,300. Funded: $325,000; average deal $325,000 ÷ 7 = $46,429. Gross yield: $126,400 − $26,400 = $100,000 ÷ $325,000 = 30.8 percent, higher because the large deal was priced lowest. Purchased amount: $571,400 − $146,400 = $425,000; delivered 1 − 172,300 ÷ 425,000 = 59.5 percent, shown as 59 percent. Delinquency: the same $12,900 over a smaller balance, 30-plus $12,900 ÷ $172,300 = 7.5 percent, close to the 8 percent warning; 90-plus $3,100 ÷ $172,300 = 1.8 percent. Largest industry becomes Medical at $66,000, 38 percent, and largest state Florida at 38 percent. One account changed every KPI by several points. That is the lesson of a small portfolio: the dashboard numbers are driven by a handful of deals, and a reader should look at the account count before trusting any percentage.
Example 3: one account crossing 30 days
Return to the full sample and change account 1002 (Trucking, Texas, $12,400 balance) from 12 days past due to 35. The 30-plus balance becomes $12,900 + $12,400 = $25,300, and 30-plus delinquency $25,300 ÷ $270,300 = 9.4 percent, above the 8 percent threshold, so the output turns amber. The 90-plus figure is unchanged at 1.1 percent. In the vintage table, 2026-Q1 now shows a 30-plus share of $12,400 ÷ $52,400 = 23.7 percent, shown as 24 percent, while 2026-Q2 stays at zero. Nothing else moves. This is the kind of change a weekly dashboard refresh exists to catch: the balance is the same, yield is the same, but one deal moving from early to serious delinquency changes the loss outlook, and the vintage view shows which funding quarter it came from. The loan delinquency rate calculator goes deeper on roll rates between buckets.