# Stage 4 Quant Model — RESULTS Generated by `equity_flow_model.py` per `ASSUMPTIONS.md`. Branch P (pause operates) governs negative-HPA cells unless marked Branch N. Positive-HPA cells are branch-invariant. All figures single-deal, gross, pre-tax, pre-fund-fees (see assumptions 17, 21). ## Table 1 — Investor gross IRR (annualized) | HPA \ Hold | 1y | 2y | 3y | 5y | 7y | 10y | 12y | 15y | 20y | 25y | 30y | |---|---|---|---|---|---|---|---|---|---|---|---| | **-3%** | n/a | 149.9% | 65.7% | 31.4% | 20.6% | 13.6% | 11.1% | 8.7% | 6.4% | 5.0% | 4.2% | | **-2%** | n/a | 149.9% | 65.7% | 31.4% | 20.6% | 13.6% | 11.1% | 8.7% | 6.4% | 5.0% | 4.2% | | **-1%** | n/a | 149.9% | 65.7% | 31.4% | 20.6% | 13.6% | 11.1% | 8.7% | 6.4% | 5.0% | 4.2% | | **+0%** | 73.5% | 11.1% | 4.5% | 1.5% | 0.8% | 0.4% | 0.3% | 0.2% | 0.2% | 0.1% | 0.1% | | **+1%** | 119.6% | 21.9% | 10.9% | 5.1% | 3.3% | 2.5% | 2.4% | 2.3% | 2.3% | 2.3% | 2.4% | | **+2%** | 172.9% | 32.8% | 17.1% | 8.6% | 5.8% | 4.6% | 4.4% | 4.2% | 4.2% | 4.2% | 4.3% | | **+3%** | 234.3% | 43.5% | 23.2% | 12.0% | 8.2% | 6.6% | 6.3% | 6.0% | 5.9% | 5.9% | 5.9% | | **+4%** | 305.0% | 54.2% | 29.1% | 15.2% | 10.5% | 8.6% | 8.1% | 7.8% | 7.6% | 7.4% | 7.3% | | **+5%** | 386.4% | 64.9% | 34.9% | 18.4% | 12.8% | 10.5% | 9.9% | 9.5% | 9.1% | 8.9% | 8.7% | | **+6%** | 480.4% | 75.5% | 40.5% | 21.5% | 15.1% | 12.3% | 11.6% | 11.1% | 10.6% | 10.3% | 10.0% | | **+7%** | 589.7% | 86.1% | 46.1% | 24.6% | 17.3% | 14.2% | 13.3% | 12.6% | 12.0% | 11.6% | 11.3% | | **+8%** | 718.1% | 96.6% | 51.5% | 27.5% | 19.5% | 16.0% | 15.0% | 14.2% | 13.4% | 12.9% | 12.5% | ## Table 2 — Investor multiple on gross disbursed (incl. fee) | HPA \ Hold | 1y | 2y | 3y | 5y | 7y | 10y | 12y | 15y | 20y | 25y | 30y | |---|---|---|---|---|---|---|---|---|---|---|---| | **-3%** | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | | **-2%** | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | | **-1%** | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | 1.70x | | **+0%** | 1.18x | 1.09x | 1.06x | 1.03x | 1.02x | 1.02x | 1.02x | 1.02x | 1.02x | 1.02x | 1.02x | | **+1%** | 1.26x | 1.17x | 1.15x | 1.12x | 1.11x | 1.17x | 1.21x | 1.29x | 1.44x | 1.63x | 1.85x | | **+2%** | 1.35x | 1.26x | 1.24x | 1.22x | 1.21x | 1.33x | 1.42x | 1.59x | 1.94x | 2.39x | 2.96x | | **+3%** | 1.44x | 1.35x | 1.33x | 1.31x | 1.31x | 1.50x | 1.66x | 1.94x | 2.54x | 3.36x | 4.42x | | **+4%** | 1.52x | 1.44x | 1.42x | 1.41x | 1.42x | 1.69x | 1.92x | 2.34x | 3.27x | 4.58x | 6.37x | | **+5%** | 1.61x | 1.53x | 1.51x | 1.51x | 1.53x | 1.90x | 2.21x | 2.79x | 4.14x | 6.11x | 8.93x | | **+6%** | 1.70x | 1.62x | 1.61x | 1.62x | 1.65x | 2.12x | 2.53x | 3.31x | 5.19x | 8.05x | 12.32x | | **+7%** | 1.78x | 1.72x | 1.71x | 1.73x | 1.78x | 2.37x | 2.89x | 3.90x | 6.43x | 10.47x | 16.77x | | **+8%** | 1.87x | 1.81x | 1.81x | 1.85x | 1.91x | 2.63x | 3.28x | 4.58x | 7.93x | 13.50x | 22.60x | ## Table 3 — Homeowner APR-equivalent (effective cost of cash received) | HPA \ Hold | 1y | 2y | 3y | 5y | 7y | 10y | 12y | 15y | 20y | 25y | 30y | |---|---|---|---|---|---|---|---|---|---|---|---| | **-3%** | 397.9% | 99.0% | 54.9% | 28.8% | 19.5% | 13.1% | 10.8% | 8.5% | 6.3% | 5.0% | 4.1% | | **-2%** | 397.9% | 99.0% | 54.9% | 28.8% | 19.5% | 13.1% | 10.8% | 8.5% | 6.3% | 5.0% | 4.1% | | **-1%** | 397.9% | 99.0% | 54.9% | 28.8% | 19.5% | 13.1% | 10.8% | 8.5% | 6.3% | 5.0% | 4.1% | | **+0%** | 64.8% | 10.9% | 4.4% | 1.5% | 0.8% | 0.4% | 0.3% | 0.2% | 0.2% | 0.1% | 0.1% | | **+1%** | 102.3% | 21.5% | 10.8% | 5.1% | 3.3% | 2.5% | 2.4% | 2.3% | 2.3% | 2.3% | 2.4% | | **+2%** | 143.4% | 32.1% | 17.0% | 8.6% | 5.8% | 4.6% | 4.4% | 4.2% | 4.2% | 4.2% | 4.2% | | **+3%** | 187.8% | 42.5% | 23.0% | 11.9% | 8.2% | 6.6% | 6.3% | 6.0% | 5.9% | 5.9% | 5.9% | | **+4%** | 235.5% | 52.9% | 28.8% | 15.2% | 10.5% | 8.6% | 8.1% | 7.8% | 7.6% | 7.4% | 7.3% | | **+5%** | 286.4% | 63.2% | 34.5% | 18.4% | 12.8% | 10.5% | 9.9% | 9.5% | 9.1% | 8.9% | 8.7% | | **+6%** | 340.4% | 73.4% | 40.1% | 21.5% | 15.1% | 12.3% | 11.6% | 11.1% | 10.6% | 10.3% | 10.0% | | **+7%** | 397.4% | 83.5% | 45.6% | 24.5% | 17.3% | 14.1% | 13.3% | 12.6% | 12.0% | 11.6% | 11.3% | | **+8%** | 457.3% | 93.6% | 51.0% | 27.5% | 19.4% | 15.9% | 15.0% | 14.2% | 13.4% | 12.9% | 12.5% | ## Table 4 — Homeowner net dollar cost (settlement minus net cash received) | HPA \ Hold | 1y | 2y | 3y | 5y | 7y | 10y | 12y | 15y | 20y | 25y | 30y | |---|---|---|---|---|---|---|---|---|---|---|---| | **-3%** | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | | **-2%** | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | | **-1%** | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | | **+0%** | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | $3.1K | | **+1%** | $4.7K | $6.3K | $7.9K | $11.1K | $14.4K | $21.5K | $26.9K | $36.3K | $55.4K | $79.1K | $107.5K | | **+2%** | $6.3K | $9.5K | $12.7K | $19.4K | $26.4K | $41.5K | $53.4K | $74.5K | $118.6K | $175.3K | $246.6K | | **+3%** | $7.8K | $12.7K | $17.6K | $28.0K | $39.1K | $63.3K | $83.0K | $118.2K | $194.6K | $297.1K | $431.3K | | **+4%** | $9.4K | $15.9K | $22.7K | $37.0K | $52.5K | $87.2K | $115.8K | $168.3K | $286.0K | $450.8K | $676.2K | | **+5%** | $11.0K | $19.2K | $27.8K | $46.3K | $66.8K | $113.2K | $152.4K | $225.7K | $395.8K | $644.5K | $999.7K | | **+6%** | $12.5K | $22.5K | $33.0K | $56.0K | $81.8K | $141.5K | $192.9K | $291.2K | $527.3K | $887.8K | $1.43M | | **+7%** | $14.1K | $25.8K | $38.3K | $66.0K | $97.8K | $172.4K | $237.9K | $366.0K | $684.7K | $1.19M | $1.99M | | **+8%** | $15.7K | $29.2K | $43.7K | $76.5K | $114.7K | $206.0K | $287.8K | $451.2K | $872.6K | $1.57M | $2.72M | ## Table 5 — EF settlement minus HELOC payoff (positive = EF costs more at exit) | HPA \ Hold | 1y | 2y | 3y | 5y | 7y | 10y | 12y | 15y | 20y | 25y | 30y | |---|---|---|---|---|---|---|---|---|---|---|---| | **-3%** | $3.1K | $2.9K | $2.8K | $2.5K | $2.1K | $1.4K | $0.8K | $-0.2K | $-2.7K | $-6.5K | $-12.3K | | **-2%** | $3.1K | $2.9K | $2.8K | $2.5K | $2.1K | $1.4K | $0.8K | $-0.2K | $-2.7K | $-6.5K | $-12.3K | | **-1%** | $3.1K | $2.9K | $2.8K | $2.5K | $2.1K | $1.4K | $0.8K | $-0.2K | $-2.7K | $-6.5K | $-12.3K | | **+0%** | $2.7K | $0.6K | $-3.2K | $-16.9K | $-39.7K | $-87.7K | $-127.1K | $-200.3K | $-372.4K | $-635.3K | $-1.04M | | **+1%** | $4.2K | $3.7K | $1.5K | $-8.9K | $-28.5K | $-69.4K | $-103.3K | $-167.1K | $-320.1K | $-559.4K | $-932.3K | | **+2%** | $5.8K | $6.9K | $6.3K | $-0.6K | $-16.5K | $-49.4K | $-76.8K | $-129.0K | $-257.0K | $-463.1K | $-793.3K | | **+3%** | $7.4K | $10.1K | $11.2K | $8.0K | $-3.8K | $-27.5K | $-47.3K | $-85.3K | $-181.0K | $-341.3K | $-608.5K | | **+4%** | $8.9K | $13.3K | $16.3K | $16.9K | $9.6K | $-3.6K | $-14.4K | $-35.2K | $-89.5K | $-187.6K | $-363.6K | | **+5%** | $10.5K | $16.6K | $21.4K | $26.3K | $23.9K | $22.4K | $22.1K | $22.2K | $20.2K | $6.1K | $-40.1K | | **+6%** | $12.0K | $19.9K | $26.6K | $35.9K | $39.0K | $50.7K | $62.7K | $87.7K | $151.8K | $249.4K | $386.4K | | **+7%** | $13.6K | $23.2K | $31.9K | $46.0K | $54.9K | $81.6K | $107.7K | $162.5K | $309.1K | $554.6K | $947.0K | | **+8%** | $15.2K | $26.6K | $37.3K | $56.4K | $71.8K | $115.1K | $157.5K | $247.7K | $497.0K | $936.5K | $1.68M | ## Table 6 — Cash-out refi extra-interest benchmark (cost of same cash via refi, destroying the 3.5% lock) | HPA \ Hold | 1y | 2y | 3y | 5y | 7y | 10y | 12y | 15y | 20y | 25y | 30y | |---|---|---|---|---|---|---|---|---|---|---|---| | **-3%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **-2%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **-1%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+0%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+1%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+2%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+3%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+4%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+5%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+6%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+7%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | | **+8%** | $20.8K | $41.5K | $62.1K | $102.8K | $142.7K | $200.8K | $238.0K | $290.7K | $367.0K | $421.9K | $443.9K | _Extra interest vs. keeping the old loan, on a $472.9K refi at 7.0%._ ## Summary A — Where the customer does worse than the obvious alternative - **Worse than a matched-draw 8.5% HELOC:** 81 cells. Per-HPA pattern (longest hold at which EF still costs more than the HELOC): - -3% HPA: worse through 12y - -2% HPA: worse through 12y - -1% HPA: worse through 12y - +0% HPA: worse through 2y - +1% HPA: worse through 3y - +2% HPA: worse through 3y - +3% HPA: worse through 5y - +4% HPA: worse through 7y - +5% HPA: worse through 25y - +6% HPA: worse through 30y (all holds) - +7% HPA: worse through 30y (all holds) - +8% HPA: worse through 30y (all holds) Worst dollar cells: - +8% HPA, 30y hold: EF costs $1.68M more than the HELOC (APR-eq 12.5%) - +7% HPA, 30y hold: EF costs $947.0K more than the HELOC (APR-eq 11.3%) - +8% HPA, 25y hold: EF costs $936.5K more than the HELOC (APR-eq 12.9%) - +7% HPA, 25y hold: EF costs $554.6K more than the HELOC (APR-eq 11.6%) - +8% HPA, 20y hold: EF costs $497.0K more than the HELOC (APR-eq 13.4%) - +6% HPA, 30y hold: EF costs $386.4K more than the HELOC (APR-eq 10.0%) - **Cheaper than the HELOC:** long holds at low-to-trend HPA — the cells where the fund earns below its cost of capital (the pricing-identity: consumer-fair cells are fund-unfair cells and vice versa; investor crossexam Dispute 3). - **Economically indefensible vs. doing nothing (>15% APR-eq):** 48 cells, concentrated in holds ≤ 3 years at HPA ≥ +3% — exits driven by the life events (job loss, divorce, death) the marketing says the product accommodates: - +8% HPA, 1y hold: 457.3% - -3% HPA, 1y hold: 397.9% - -2% HPA, 1y hold: 397.9% - -1% HPA, 1y hold: 397.9% - +7% HPA, 1y hold: 397.4% - +6% HPA, 1y hold: 340.4% - **Cash-out refi comparison:** the refi benchmark (Table 6) is more expensive than EF in most long-hold cells — the rate-lock-destruction premise is real — but for holds ≤ 5 years the refi's extra interest is smaller than EF's cost in appreciating markets. ## Summary B — Where investor returns go negative or sub-hurdle - **Negative gross IRR cells (Branch P):** 0. With the pause operating, deployment freezes at ~$4.5K in declining markets, so the non-recourse cap never bites on this grid; deeper drawdowns (stress table) are where sale-exit principal losses live. Note the paused-deal IRRs are dominated by the $3,150 fee charged on PROJECTED disbursements against only $4,500 deployed — an artifact the spec's fee mechanics create (investor A15). - **Positive but below the 8% hurdle:** 43 cells. Full list by row: - -3% HPA: 20y 6.4%, 25y 5.0%, 30y 4.2% - -2% HPA: 20y 6.4%, 25y 5.0%, 30y 4.2% - -1% HPA: 20y 6.4%, 25y 5.0%, 30y 4.2% - +0% HPA: 3y 4.5%, 5y 1.5%, 7y 0.8%, 10y 0.4%, 12y 0.3%, 15y 0.2%, 20y 0.2%, 25y 0.1%, 30y 0.1% - +1% HPA: 5y 5.1%, 7y 3.3%, 10y 2.5%, 12y 2.4%, 15y 2.3%, 20y 2.3%, 25y 2.3%, 30y 2.4% - +2% HPA: 7y 5.8%, 10y 4.6%, 12y 4.4%, 15y 4.2%, 20y 4.2%, 25y 4.2%, 30y 4.3% - +3% HPA: 10y 6.6%, 12y 6.3%, 15y 6.0%, 20y 5.9%, 25y 5.9%, 30y 5.9% - +4% HPA: 15y 7.8%, 20y 7.6%, 25y 7.4%, 30y 7.3% At trend HPA (+3%): year-7 exit 8.2% gross, decaying to 5.9% by year 25. The marketed ~11% requires above-trend HPA AND the year-7 exit the underwriting selects against. ### Branch N (pause inoperative — spec §20 behavior): negative-HPA rows | HPA \ Hold | 1y | 2y | 3y | 5y | 7y | 10y | |---|---|---|---|---|---|---| | **-3%** | 73.5% / 1.18x | 11.1% / 1.09x | 4.5% / 1.06x | 1.5% / 1.03x | 0.8% / 1.02x | 0.4% / 1.02x | | **-2%** | 73.5% / 1.18x | 11.1% / 1.09x | 4.5% / 1.06x | 1.5% / 1.03x | 0.8% / 1.02x | 0.4% / 1.02x | | **-1%** | 73.5% / 1.18x | 11.1% / 1.09x | 4.5% / 1.06x | 1.5% / 1.03x | 0.8% / 1.02x | 0.4% / 1.02x | _Branch N shows the loss profile if disbursements continue through_ _declines (as the spec's own §20 example assumes): 0% nominal IRR for_ _years (capital returned, no gain), turning negative only where the_ _escrow cap binds at deep drawdowns — see the stress table._ ## Stress table — fully deployed vintage, sale at drawdown from enrollment | Drawdown | Sale price | Escrow avail. | Claim | Recovery on $126K | |---|---|---|---|---| | -10% | $562.5K | $225.5K | $126.0K | 1.00x | | -20% | $500.0K | $167.3K | $126.0K | 1.00x | | -27% | $456.2K | $126.7K | $126.0K | 1.00x | | -30% | $437.5K | $109.2K | $126.0K | 0.87x | | -35% | $406.2K | $80.2K | $126.0K | 0.64x | | -45% | $343.8K | $22.0K | $126.0K | 0.17x | _Reproduces the Stage 2 concession arithmetic: breakeven drawdown ≈_ _−27% from enrollment; at sand-state severity (−45%) a SALE exit_ _recovers ≈ 0.17x — an 83% principal loss with no foreclosure needed_ _(actuarial crossexam R1)._ ## Key single-cell reconciliations - Base case (+5%, 7y): investor IRR 12.8% incl. the t=0 fee, multiple 1.53x — consistent with the spec's ~11%/1.50x (11.7% ex-fee, investor B2; the fee adds ~1pp at deal level, but is double-promised to platform opex). - Trend HPA (+3%, 7y): 8.2% gross incl. fee (7.2% ex-fee, investor B2) — at/below the 8% hurdle before any fund fees, servicing, pause drag, or credit losses; the claimed 11% is an above-trend-HPA artifact. - Ultra-long hold (+5%, 25y): homeowner pays $767.3K on $122.8K received (APR-eq 8.9%); investor multiple 6.11x but IRR only 8.9% — the ratchet grows the multiple, not the IRR (actuarial 5.1). - Spec §21 analogue (+3%, 25y): settlement $420.0K, share 43%, homeowner APR-eq 5.9%, investor IRR 5.9%. END OF RESULTS