// Equity Flow: the serviceable cohort, built up from cited public inputs // (EQUITY_FLOW_FIXES.md, section 5). scripts/build_site.js renders this as a // table on the investor and about pages and replaces every population figure // in copy with computeFunnel().byKey values. // // Filters are applied in sequence. No public source publishes the joint // distribution of note rate, equity, and householder age, so the shares are // multiplied as if independent (section 5.2). The correlation evidence runs // the other way: FHFA WP 24-03 finds the deepest rate discounts among ages 40 // to 59 and among high-value homes, and ICE (Aug 2024) finds sub-4% first-lien // rates concentrated among borrowers with the most tappable equity, so the // independence assumption modestly understates the intersection. import { CONFIG } from '../model/config.js'; export const FUNNEL = Object.freeze({ as_of: '2026-10-15', // ACS 2024 1-year, table B25081 (Mortgage Status), United States. // B25081_002E units with a mortgage, contract to purchase, or similar debt: // 51,697,973, of which B25081_008E home equity loan without a primary // mortgage: 1,382,656. The funnel starts from units with a primary mortgage. owner_occupied_total: 86635506, with_mortgage_or_similar: 51697973, home_equity_loan_only: 1382656, // Freddie Mac PMMS, 30-year fixed, week of 2026-10-15: 7.40%. The screen is // "note rate 2 or more points below the current 30-year fixed", so the // threshold is market_rate_30y - 0.02 = 5.40%. market_rate_30y: CONFIG.market_rate_30y, rate_threshold: CONFIG.market_rate_30y - 0.02, // FHFA National Mortgage Database, Outstanding Residential Mortgage // Statistics, 2026Q2 (released 2026-09-30), national, all mortgages, // count-weighted shares by note rate: below 3% 19.2, 3 to 4% 29.9, 4 to 5% // 16.5, 5 to 6% 12.0, 6% and up 22.5. Below 5%: 65.6%. The 5.40% threshold // falls inside the 5 to 6% bucket; it is interpolated linearly // (0.4 x 12.0 = 4.8 points). rate_share_below_5: 0.656, rate_bucket_5_to_6: 0.120, // Equity at or above 40% (CLTV 60% or less). No source publishes exactly // this cut. Two published bounds bracket it: // upper: FHFA NMDB 2026Q2, share of mortgages with mark-to-market LTV of // 60% or less, first lien only, count-weighted: 74.1%. // lower: ATTOM Q2 2026 Home Equity and Underwater Report, "equity-rich" // (combined LTV 50% or less): 41.1%. // The funnel uses the midpoint of the two bounds and states both. equity_share_upper: 0.741, equity_share_lower: 0.411, // ACS 2024 1-year, table B25027 (Mortgage Status by Age of Householder), // United States, units with a mortgage: 45 to 54: 11,479,730; 55 to 59: // 5,361,654; 60 to 64: 5,235,744; total with a mortgage 51,697,973. Ages 60 // and 61 are taken as two fifths of the 60 to 64 bucket. age_with_mortgage_total: 51697973, age_45_54: 11479730, age_55_59: 5361654, age_60_64: 5235744 }); export function computeFunnel(f = FUNNEL) { const withFirstMortgage = f.with_mortgage_or_similar - f.home_equity_loan_only; const inBucket = (f.rate_threshold - 0.05) / 0.01; const rateShare = f.rate_share_below_5 + Math.max(0, Math.min(1, inBucket)) * f.rate_bucket_5_to_6; const equityShare = (f.equity_share_upper + f.equity_share_lower) / 2; const age4561 = f.age_45_54 + f.age_55_59 + f.age_60_64 * 2 / 5; const age5561 = f.age_55_59 + f.age_60_64 * 2 / 5; const ageShare4561 = age4561 / f.age_with_mortgage_total; const ageShare5561 = age5561 / f.age_with_mortgage_total; const steps = []; let n = withFirstMortgage; steps.push({ key: 'first_mortgage', label: 'Owner-occupied households with a first mortgage', share: null, households: n, sources: ['acs-b25081'], status: 'Cited (ACS 2024 1-year)' }); n *= rateShare; steps.push({ key: 'rate_lock', label: `Note rate 2+ points below the current 30-year fixed (${(f.market_rate_30y * 100).toFixed(2)}%, so ${(f.rate_threshold * 100).toFixed(2)}% or lower)`, share: rateShare, households: n, sources: ['nmdb', 'pmms'], status: 'Cited; 5.40% point interpolated inside the 5 to 6% bucket' }); n *= equityShare; steps.push({ key: 'equity', label: 'Equity of 40% or more (CLTV 60% or less), midpoint of the published bounds', share: equityShare, households: n, sources: ['nmdb', 'attom-equity'], status: 'Bounded: 74.1% (FHFA, first-lien LTV) to 41.1% (ATTOM, CLTV 50%)' }); const beforeAge = n; n = beforeAge * ageShare4561; steps.push({ key: 'age_45_61', label: 'Householder aged 45 to 61', share: ageShare4561, households: n, sources: ['acs-b25027'], status: 'Cited; ages 60 and 61 as two fifths of the 60 to 64 bucket' }); steps.push({ key: 'age_55_61', label: 'Launch cohort: householder aged 55 to 61', share: ageShare5561, households: beforeAge * ageShare5561, sources: ['acs-b25027'], status: 'Cited; same interpolation' }); const low = withFirstMortgage * rateShare * f.equity_share_lower * ageShare4561; const high = withFirstMortgage * rateShare * f.equity_share_upper * ageShare4561; const byKey = Object.fromEntries(steps.map(s => [s.key, s])); const note = `Filters apply in sequence from the top row. Shares are multiplied as if independent because no public source publishes the joint distribution of note rate, equity, and age; the published evidence (FHFA working paper 24-03, ICE Mortgage Monitor Aug 2024) shows the deepest rate discounts among ages 40 to 59 and among high-equity borrowers, so independence modestly understates the intersection. The equity step is the midpoint of two published bounds; using the bounds themselves gives ${(low / 1e6).toFixed(1)}M to ${(high / 1e6).toFixed(1)}M households aged 45 to 61. No published source supports the eighteen-million headline this site once used, so that figure appears nowhere on it.`; return { steps, byKey, withFirstMortgage, rateShare, equityShare, ageShare4561, ageShare5561, range: { low, high }, note }; } // Section 5.3: stop and report if the computed cohort leaves 4M to 10M. export function assertFunnelInRange(f = computeFunnel()) { const n = f.byKey.age_45_61.households; if (n < 4e6 || n > 10e6) throw new Error(`cohort 45 to 61 is ${(n / 1e6).toFixed(2)}M, outside 4M to 10M: stop and report`); return n; }