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 |
| 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