Household funnel
data/cohort_funnel.js Open the file as written
// 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;
}