Formula: MAX(status priority across 7 tests)
Base EXCEPTION → stress EXCEPTION = EXCEPTIONStress Lab · live deterministic downside
Apply a named downside case or adjust five pressure points directly.
Downside controls
Formula: MAX(status priority across 7 tests)
Base EXCEPTION → stress EXCEPTION = EXCEPTIONRank ascending normalized cushion; active hard stops first
(0.956× − 1.050×) ÷ 1.050× = −8.93% of thresholdStressed liquidity after downside − base liquidity
$3,600,000 − $3,600,000 = $0Stressed permanent proceeds − full-commitment payoff
$11,895,785 − $12,440,639 = -$544,854Total available bridge term − planned exit month after delay
36 − 29 = 7.00 monthsRanked constraint path
Active hard stops rank first; all other constraints sort by ascending normalized cushion to the governing threshold.
Base case already below policy.
(Stressed coverage − policy minimum) ÷ policy minimum(0.956× − 1.050×) ÷ 1.050× = −8.93% of thresholdMitigation: Increase supportable permanent proceeds, reduce the payoff through sponsor paydown, or improve NOI / permanent financing terms.Shows proximity to the nearest configured refinance, LTV, or liquidity hard stop.
MIN(refinance hard-stop margin, LTV hard-stop margin, liquidity hard-stop margin)MIN(6.24%, 19.52%, 478.75%) = +6.24% of thresholdMitigation: Do not advance the recommendation path until the hard stop is cured through structure, paydown, verified performance, or revised exposure.Measures remaining collateral-value cushion before the stabilized-LTV maximum fails.
(Policy maximum − stressed LTV) ÷ policy maximum(70.00% − 64.38%) ÷ 70.00% = +8.02% of thresholdMitigation: Reduce commitment or payoff, add equity, improve durable NOI, or demonstrate supportable value at a conservative exit cap.Measures remaining cash-flow cushion before committed debt yield falls below policy.
(Stressed debt yield − policy minimum) ÷ policy minimum(8.93% − 8.00%) ÷ 8.00% = +11.63% of thresholdMitigation: Verify rents and expenses, require operating milestones, or reduce the commitment until stressed NOI supports the minimum.Measures how much of the budgeted contingency remains before overruns become sponsor-funded.
IF contingency = 0 → 0% capacity; ELSE (contingency − gross overrun) ÷ contingency(280000 − 140000) ÷ 280000 = +50.00% of thresholdMitigation: Rebid and de-scope where prudent, enforce draw and cost-to-complete controls, and require sponsor-funded excess costs.Measures remaining sponsor liquidity after overruns and delay beyond available reserves.
(Liquidity / commitment after downside − policy minimum) ÷ policy minimum(28.94% − 10.00%) ÷ 10.00% = +189.37% of thresholdMitigation: Verify additional liquidity, add qualified support, reduce downside exposure, or require fresh equity before further advances.Reverse underwriting
Shows how much calculated stabilized NOI can decline before committed debt yield reaches the illustrative minimum.
Minimum debt yield × full commitment
8.00% × $12,440,639 = $995,2511 − required NOI ÷ base calculated stabilized NOI
1 − $995,251 ÷ $1,169,520 = 14.90%Shows the maximum exit cap rate that keeps the full commitment inside the illustrative stabilized-LTV maximum.
Maximum stabilized LTV × base stabilized NOI ÷ full commitment
70.00% × $1,169,520 ÷ $12,440,639 = 6.58%(Maximum exit cap − base exit cap) × 10,000
(6.58% − 5.50%) × 10,000 = +108.1 bpsSeparates contingency-only capacity from additional sponsor-funded capacity before the liquidity policy minimum fails.
Capex contingency ÷ renovation budget
$280,000 ÷ $2,800,000 = 10.00%(Post-close liquidity − required liquidity) ÷ renovation budget
($3,600,000 − $1,244,064 = $2,355,936) ÷ $2,800,000 = 84.14%(Contingency + liquidity above policy minimum) ÷ renovation budget
($280,000 + $2,355,936) ÷ $2,800,000 = 94.14%Shows how many months the interest reserve covers at the locked full-commitment balance before excess delay becomes sponsor-funded.
Full commitment × bridge rate ÷ 12
$12,440,639 × 9.50% ÷ 12 = $98,488Interest reserve ÷ monthly interest at full commitment
$800,000 ÷ $98,488 = 8.12 monthsBase case already below policy.
Minimum refinance coverage × full-commitment payoff
1.050× × $12,440,639 = $13,062,671Bounded binary solve where NOI ÷ (minimum DSCR × mortgage constant(rate, amortization)) = target proceeds, subject to maximum-LTV proceeds
Solve rate using $1,169,520 NOI, 1.20× DSCR, 30-year amortization, and $13,062,671 target proceeds = 6.34%(Maximum permanent rate − base permanent rate) × 10,000
(6.34% − 6.50%) × 10,000 = −15.7 bpsBase / Stress / Change
Source lineage · active decision state
114 ÷ 114 = 100%Every Juniper Ridge input carries a field-level source label and provenance note.
Stress inputs and centralized thresholds remain separate from calculated outputs.
Credit, policy, stress, breakpoint, and recommendation outputs are generated by the central engines with formula, values, and result.
0 PUBLIC transaction facts are used in the active case.
COUNT(active inputs where source type = PUBLIC): COUNT(PUBLIC inputs) = 0