Dashboard › Demo Universe › Orchard Foods

Orchard Foods · ORCH

DEMO DATAUNDERWRITING ASSUMPTIONHOLD

Return analysis — Subordinated Notes 8.25%

HYPOTHETICAL INVESTMENT TERMSUNDERWRITING ASSUMPTION
Face value
$100.0M
Purchase price (assumption)
94.0
Cash investment
$94.5M
Current yield
8.8%
Yield to maturity
9.7%
Base CaseDownsideSevere DownsideExpected
OutcomePerformingPerformingDefault (FY2029E)
Face value (legal claim)$100.0M$100.0M$100.0M
Purchase price → cash investment94.0 → $94.5M94.0 → $94.5M94.0 → $94.5M
Cash interest received$24.8M$24.8M$33.0M
Exit price (performing) / recovery proceeds (default)100.0 → $100.0M90.0 → $90.0M$40.1M
Capital gain / (loss) vs purchase price$6.0M($4.0M)($53.9M)
Total cash proceeds$124.8M$114.8M$73.1M
Valuation recovery % · loss given default100% · 0%100% · 0%39% · 61%
Absolute profit$30.3M$20.3M($21.4M)
MOIC1.32x1.21x0.77x1.21x
IRR (annual periods)10.5%7.3%-6.3%6.7%
IRR (contractual timing, 1x/yr coupons)10.5%7.3%-6.3%6.7%
Scenario probability55%30%15%
Required return (hurdle IRR) → statusFAIL 12%FAIL 12%FAIL 12%FAIL
Probability-weighted expected loss
15% P(default) × 61% LGD = 9.1%
Max entry price that still earns the hurdle (base case)
90.5 vs assumed 94.0
Recovery needed for MOIC 1.0x if default
61% of face

Expected column = IRR of the probability-weighted cash flows (6.7%), not the average of scenario IRRs (7.0%); IRR is non-linear. Contractual timing re-times the same coupon dollars to 1 payment(s) per year (settlement on a coupon date, no accrued interest); principal/recovery stay on annual dates. Fees: 0.5% of cost, paid at t=0. Per $100M face. Timing: coupons at period ends; default → recovery cash 1 period after the default period; performing exit at the hold period at the lesser of the scenario exit-price cap and valuation coverage at the exit multiple. Floating coupons include the scenario rate shock. Scenario weights 55% / 30% / 15%.

Sensitivity analysis — where is the risk / return attractive?

Sensitivity 1 — Purchase price vs IRR

Purchase price (% of face)Base CaseDownsideSevere Downside
86.014.1%10.8%-4.2%
90.012.2%9.0%-5.3%
94.010.5%7.3%-6.3%
98.08.8%5.7%-7.3%
102.07.3%4.1%-8.2%

Sensitivity 2 — Exit / recovery value (% of face) vs IRR

Proceeds (% of face)Base CaseDownsideSevere Downside
20.0-25.6%-25.6%-14.8%
40.0-13.3%-13.3%-6.3%
60.0-3.9%-3.9%-0.4%
80.03.8%3.8%4.3%
100.010.5%10.5%8.2%

Sensitivity 3 — EBITDA margin shift vs IRR (full model re-run)

EBITDA margin shiftBase CaseDownsideSevere Downside
-4.0 pts10.5%0.7%-45.6%
-2.0 pts10.5%7.3%-31.9%
+0.0 pts10.5%7.3%-6.3%
+2.0 pts10.5%7.3%8.6%
+4.0 pts10.5%7.3%8.6%

Sensitivity 4 — Revenue growth shift vs IRR (full model re-run)

Revenue growth shiftBase CaseDownsideSevere Downside
-10.0 pts10.5%4.6%-31.9%
-5.0 pts10.5%7.3%-31.9%
+0.0 pts10.5%7.3%-6.3%
+5.0 pts10.5%7.3%8.6%
+10.0 pts10.5%7.3%0.1%

Sensitivity 5 — Interest rate (SOFR) shift vs IRR (full model re-run)

SOFR shiftBase CaseDownsideSevere Downside
-1.0 pts10.5%7.3%-4.1%
-0.5 pts10.5%7.3%-5.2%
+0.0 pts10.5%7.3%-6.3%
+1.0 pts10.5%7.3%-8.8%
+2.0 pts10.5%7.3%-11.7%

Sensitivity 6 — Distressed valuation multiple shift vs target-tranche recovery %

Multiple shift (x EBITDA)Base CaseDownsideSevere Downside
-2.0x100.0%47.8%0.0%
-1.0x100.0%100.0%0.0%
+0.0x100.0%100.0%39.3%
+1.0x100.0%100.0%89.2%
+2.0x100.0%100.0%100.0%

Sensitivity 7 — Recovery / exit value (% of face) vs MOIC

Proceeds (% of face)Base CaseDownsideSevere Downside
20.00.47x0.47x0.56x
40.00.69x0.69x0.77x
60.00.90x0.90x0.98x
80.01.11x1.11x1.20x
100.01.32x1.32x1.41x

Green ≥ hurdle IRR (12%) · amber = positive but below hurdle · red = loss (recovery table: green = full recovery, amber ≥ 60%). Every cell is the same calculation as the Excel Sensitivities tab; margin, growth, rate and multiple tables re-run the entire model (statements → debt → default → recovery → returns).

Return calculator

Face value (legal claim)$100.0M
Cash investment (face × price × (1 + fees))$94.5M
Current yield (coupon ÷ price)8.8%
Cash interest received$24.8M
Exit / recovery proceeds$100.0M
Capital gain / (loss) vs purchase price$6.0M
Total cash proceeds$124.8M
Absolute profit$30.3M
MOIC1.32x
IRR10.5%