Data room / Run 1, stages 3 to 5: scenarios, model, verdict

Model results

Model, 3,082 words, about 13 min to read

run-1/models/RESULTS.md Open the file as written

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