Pinnacle Oilfield Services · PNOS
DEMO DATAUNDERWRITING ASSUMPTIONHOLDReturn analysis — Senior Secured Notes 8.00%
HYPOTHETICAL INVESTMENT TERMSUNDERWRITING ASSUMPTION| Base Case | Downside | Severe Downside | Expected | |
|---|---|---|---|---|
| Outcome | Performing | Performing | Default (FY2029E) | |
| Face value (legal claim) | $100.0M | $100.0M | $100.0M | |
| Purchase price → cash investment | 101.5 → $102.0M | 101.5 → $102.0M | 101.5 → $102.0M | |
| Cash interest received | $24.0M | $24.0M | $32.0M | |
| Exit price (performing) / recovery proceeds (default) | 100.0 → $100.0M | 90.0 → $90.0M | $102.0M | |
| Capital gain / (loss) vs purchase price | ($1.5M) | ($11.5M) | $0.5M | |
| Total cash proceeds | $124.0M | $114.0M | $134.0M | |
| Valuation recovery % · loss given default | 100% · 0% | 100% · 0% | 100% · 0% | |
| Absolute profit | $22.0M | $12.0M | $32.0M | |
| MOIC | 1.22x | 1.12x | 1.31x | 1.20x |
| IRR (annual periods) | 7.2% | 4.1% | 6.5% | 6.2% |
| IRR (contractual timing, 1x/yr coupons) | 7.2% | 4.1% | 6.5% | 6.2% |
| Scenario probability | 55% | 30% | 15% | |
| Required return (hurdle IRR) → status | FAIL 12% | FAIL 12% | FAIL 12% | FAIL |
Expected column = IRR of the probability-weighted cash flows (6.2%), not the average of scenario IRRs (6.2%); 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 Case | Downside | Severe Downside |
|---|---|---|---|
| 93.5 | 10.4% | 7.2% | 8.5% |
| 97.5 | 8.8% | 5.6% | 7.5% |
| 101.5 | 7.2% | 4.1% | 6.5% |
| 105.5 | 5.8% | 2.6% | 5.5% |
| 109.5 | 4.4% | 1.3% | 4.6% |
Sensitivity 2 — Exit / recovery value (% of face) vs IRR
| Proceeds (% of face) | Base Case | Downside | Severe Downside |
|---|---|---|---|
| 20.0 | -28.1% | -28.1% | -16.8% |
| 40.0 | -16.0% | -16.0% | -8.4% |
| 60.0 | -6.9% | -6.9% | -2.5% |
| 80.0 | 0.7% | 0.7% | 2.2% |
| 100.0 | 7.2% | 7.2% | 6.1% |
Sensitivity 3 — EBITDA margin shift vs IRR (full model re-run)
| EBITDA margin shift | Base Case | Downside | Severe Downside |
|---|---|---|---|
| -4.0 pts | 7.2% | 4.1% | 3.2% |
| -2.0 pts | 7.2% | 4.1% | 5.8% |
| +0.0 pts | 7.2% | 4.1% | 6.5% |
| +2.0 pts | 7.2% | 4.1% | 6.5% |
| +4.0 pts | 7.2% | 4.1% | 6.5% |
Sensitivity 4 — Revenue growth shift vs IRR (full model re-run)
| Revenue growth shift | Base Case | Downside | Severe Downside |
|---|---|---|---|
| -10.0 pts | 7.2% | 6.5% | 6.5% |
| -5.0 pts | 7.2% | 4.1% | 6.5% |
| +0.0 pts | 7.2% | 4.1% | 6.5% |
| +5.0 pts | 7.2% | 4.1% | 6.5% |
| +10.0 pts | 7.2% | 4.1% | 6.5% |
Sensitivity 5 — Interest rate (SOFR) shift vs IRR (full model re-run)
| SOFR shift | Base Case | Downside | Severe Downside |
|---|---|---|---|
| -1.0 pts | 7.2% | 4.1% | 6.5% |
| -0.5 pts | 7.2% | 4.1% | 6.5% |
| +0.0 pts | 7.2% | 4.1% | 6.5% |
| +1.0 pts | 7.2% | 4.1% | 6.5% |
| +2.0 pts | 7.2% | 4.1% | 6.5% |
Sensitivity 6 — Distressed valuation multiple shift vs target-tranche recovery %
| Multiple shift (x EBITDA) | Base Case | Downside | Severe Downside |
|---|---|---|---|
| -2.0x | 100.0% | 100.0% | 100.0% |
| -1.0x | 100.0% | 100.0% | 100.0% |
| +0.0x | 100.0% | 100.0% | 100.0% |
| +1.0x | 100.0% | 100.0% | 100.0% |
| +2.0x | 100.0% | 100.0% | 100.0% |
Sensitivity 7 — Recovery / exit value (% of face) vs MOIC
| Proceeds (% of face) | Base Case | Downside | Severe Downside |
|---|---|---|---|
| 20.0 | 0.43x | 0.43x | 0.51x |
| 40.0 | 0.63x | 0.63x | 0.71x |
| 60.0 | 0.82x | 0.82x | 0.90x |
| 80.0 | 1.02x | 1.02x | 1.10x |
| 100.0 | 1.22x | 1.22x | 1.29x |
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)) | $102.0M |
| Current yield (coupon ÷ price) | 7.9% |
| Cash interest received | $24.0M |
| Exit / recovery proceeds | $100.0M |
| Capital gain / (loss) vs purchase price | ($1.5M) |
| Total cash proceeds | $124.0M |
| Absolute profit | $22.0M |
| MOIC | 1.22x |
| IRR | 7.2% |