Compound’s borrowing base for Ryerson Holding Corporation’s asset-based revolver comes to $1,755.3 million at September 30, 2026. After $1,014.0 million of loans and $7.0 million of letters of credit, excess availability is $734.3 million, against the $777 million the company reports in its 10-Q. None of the three flags in the request trips in the base case, and the springing fixed charge coverage test is not in effect.
The $42.7 million shortfall is the useful result. The model holds inventory at an 80% net orderly liquidation value, an analyst assumption, because no appraisal is public. Solving for the NOLV that reproduces the company’s own reported availability gives 83.7%, with every other input held at the base case. That figure is the model’s inference under its eligibility assumptions, and the field exam and appraisal would confirm or replace it.
You are on the underwriting team of an asset-based lender or a credit fund looking at a revolver to a metals distributor. You need eligible collateral by category, the inventory value an appraisal is likely to support, and how far availability sits above the level where the fixed charge test and cash dominion spring. We asked Compound to build that borrowing base on a real borrower from public filings. It ran on November 19, 2026 and returned one Excel workbook of seven sheets and a short written answer.
What the workbook shows:
- The facility. Amendment No. 7, filed on February 13, 2026, raised commitments to $1,800 million. Advance rates are 90% of eligible receivables and 85% of the NOLV of eligible inventory.
- Receivables. $1,020.7 million gross becomes $931.4 million eligible, 91.3% of gross, and $838.3 million of availability.
- Inventory. $1,510.6 million at current cost becomes $1,367.8 million eligible and $930.1 million of availability at an 80% NOLV.
- The springing trigger. $175.5 million in the base case, leaving $558.8 million of headroom. The trailing four-quarter FCCR is 2.42x against a 1.00x minimum.
- The downside. Excess availability falls to $200.0 million and only the dilution flag trips. The borrowing base covers loans and letters of credit 1.20x, and stops covering them below a 42.7% NOLV.
The facility and collateral figures come from Ryerson’s filings on SEC EDGAR: the 10-Q for the quarter ended September 30, 2026, the amended credit agreement, the 10-K for fiscal 2025 and two earnings releases. Quarterly sales, cost of sales, receivables and inventories for the eight-quarter trends come from Compound’s company financial data. The Sources sheet notes that no web search was needed. Every other input is marked “Analyst assumption” with a reason.
“I am underwriting an asset-based revolving loan and want the borrowing base built on a real borrower. From SEC EDGAR, pick one U.S. public retailer, wholesaler or distributor with an asset-based revolving credit facility whose credit agreement is filed as an exhibit and whose latest 10-Q gives receivables, inventory and the facility's availability. From the credit agreement, take the advance rates on eligible receivables and inventory, the eligibility criteria, the reserves the agent may set, the springing fixed charge coverage trigger and the cash dominion trigger. Build the borrowing base at the latest quarter end: gross receivables less each ineligible category, such as receivables past 90 days, cross-aged accounts, concentrations and foreign accounts, then times the advance rate; inventory at cost less ineligibles, valued at an assumed net orderly liquidation value percentage, then times the advance rate; less reserves; then availability and excess availability after outstanding loans and letters of credit. Compare the result with the availability the company reports. Add receivables dilution, days sales outstanding and inventory turns for the last eight quarters, the springing covenant test, and a sensitivity of availability to the liquidation value percentage and dilution. Flag excess availability below the springing trigger, dilution above 5%, and a borrowing base below the facility's outstanding balance in the downside. Use the stored public data wherever it has the figure, and web search only for what it lacks. Put every input on an Assumptions sheet with one column that says where it came from: a cited source, or "analyst assumption" for a figure I would set myself, with the reason for the value you chose. Every output must be a live formula that traces back to the Assumptions sheet. Add a Sources sheet listing each data source, what it gave and its date. Deliver one Excel workbook and a short summary of the result, the flags, and what I would need from the borrower's field exam and appraisal to firm it up. Cite every sourced figure.”
That is the request as we sent it, without its closing line, which asks that no name or email be put in the workbook.
Choosing the borrower and reading the credit agreement
Compound chose Ryerson, an industrial metals distributor whose amended credit agreement is filed as an exhibit on EDGAR and whose 10-Q reports loans, letters of credit and availability under the revolver at quarter end. Every advance rate, eligibility test, reserve and trigger in the model is cited to a clause of that agreement.
The test date is September 30, 2026, from the 10-Q filed on October 28, 2026, whose Note 7 gives $1,014 million of revolving loans, $7 million of letters of credit and $777 million of availability.
| B | C | D | |
|---|---|---|---|
| 5 | Input | Unit | Value |
| 16 | Advance rate on Net Amount of Eligible Accounts | % | 90.0% |
| 17 | Advance rate on NOLV of eligible inventory | % | 85.0% |
| 18 | Advance rate on Qualified Cash | % | 100.0% |
| 19 | Ineligible: unpaid more than this many days from invoice | days | 90 |
| 20 | Ineligible: unpaid more than this many days past due date | days | 60 |
| 25 | Cross-age test (share of a debtor's accounts ineligible) | % | 50.0% |
| 26 | Concentration limit (share of Eligible Accounts) | % | 25.0% |
| 31 | Dilution reserve threshold (12-month dilution) | % | 2.5% |
| 33 | Springing FCCR and cash dominion trigger: share of Line Cap | % | 10.0% |
| 34 | Springing FCCR and cash dominion trigger: fixed floor | $M | 80.0 |
| 36 | Minimum Consolidated FCCR when tested | x | 1.00x |
| 37 | Cash dominion: business days below trigger to start | days | 5 |
Two baskets keep accounts of 91 to 120 days eligible: $35 million owed by investment grade debtors and $30 million owed by others. Debtors outside the U.S. and Canada are out unless an L/C or up to $4 million of credit insurance backs them.
The trigger is the greater of 10% of the Line Cap and a fixed floor, which Amendment No. 7 raised from $60 million to $80 million. Below it, the 1.00x fixed charge coverage covenant is tested on the trailing four quarters. The same level starts cash dominion after 5 business days below it, and dominion ends after 30 consecutive days at or above it. Reserves include a dilution reserve on 12-month dilution above 2.5%, landlord reserves, and anything the agent sets in its Permitted Discretion.
The facility has one feature that matters for the eligibility work: the Mexico and China subsidiaries are not borrowers or guarantors. Their receivables and inventory sit on the consolidated balance sheet and come out of the base first.
Eligible receivables: from the balance sheet to the Net Amount
Gross receivables of $1,020.7 million become $931.4 million of eligible accounts and $838.3 million of availability at the 90% advance rate. The public filings give the balance and the allowance; every ineligible category except the allowance and the rebate accruals is an analyst rate on the credit parties’ receivables.
| B | C | D | |
|---|---|---|---|
| 5 | Base case | Downside | |
| 17 | Receivables, net of provisions | 1,017.5 | 1,017.5 |
| 18 | (+) Provisions against receivables | 3.2 | 3.2 |
| 19 | Gross receivables at balance sheet value | 1,020.7 | 1,020.7 |
| 20 | (-) Decline in receivable values | - | (153.1) |
| 21 | Gross receivables in scenario | 1,020.7 | 867.6 |
| 22 | (-) Receivables of non-borrower subsidiaries (Mexico, China) | (26.9) | (22.9) |
| 23 | Credit-party gross receivables | 993.8 | 844.7 |
| 24 | (-) Aged over 120 days from invoice | (9.9) | (12.7) |
| 25 | (-) 91-120 days above investment grade basket | - | - |
| 26 | (-) 91-120 days above other-debtor basket | - | - |
| 27 | (-) Cross-aged accounts | (5.0) | (6.3) |
| 28 | (-) Debtors outside U.S. and Canada, net of insured carve-out | (9.9) | (12.7) |
| 29 | (-) Contra accounts | (5.0) | (6.3) |
| 30 | (-) Allowance, disputes and chargebacks | (8.2) | (9.5) |
| 31 | (-) Affiliate, government, bill-and-hold and other | (5.0) | (6.3) |
| 32 | Total ineligible receivables | (43.0) | (53.9) |
| 33 | Receivables after ineligibles | 950.8 | 790.8 |
| 34 | (-) Rebates, discounts, returns and credits | (19.4) | (19.4) |
| 35 | (-) Concentration above limit | - | - |
| 36 | Eligible receivables ($M) | 931.4 | 771.4 |
| 37 | Eligible share of gross receivables | 91.3% | 88.9% |
| 38 | Advance rate | 90.0% | 90.0% |
| 39 | Receivables availability ($M) | 838.3 | 694.3 |
The model adds the $3.2 million allowance back to the net balance to reach gross receivables, then takes out $26.9 million for the Mexico and China subsidiaries. The 10-Q gives only a combined figure for sales originated outside the U.S., $143.5 million in the quarter against $2,034.3 million in the U.S., so Compound set Canada at 60% of foreign sales, a placeholder its note says to replace “with entity-level balances from the borrowing base certificate.”
The ineligible rates on the remaining $993.8 million are analyst assumptions: 1% aged beyond 120 days, 0.5% cross-aged, 1% owed by debtors outside the U.S. and Canada, 0.5% contra accounts, 0.5% disputes and chargebacks on top of the allowance, and 0.5% for affiliate, government and bill-and-hold accounts. The 91-120 day bucket, set at 3%, fits inside both baskets, so it costs nothing. The contra rate has a reason specific to metals: mills and scrap buyers are both customers and suppliers.
Two deductions are sourced. The Net Amount deduction for rebates, discounts and returns is set at the $19.4 million contract liability balance in the 10-Q. The concentration test uses the 10-K’s statement that no customer exceeds 6% of sales, well under the 25% limit, so no concentration deduction applies. Total ineligibles are $43.0 million, or 4.3% of credit-party gross receivables (our arithmetic), and the eligible share of gross receivables is 91.3%.
Eligible inventory at NOLV, and the reserves
Inventory at current cost of $1,510.6 million becomes $1,367.8 million eligible. At an 80% NOLV and the 85% advance rate it gives $930.1 million of availability. Reserves total $13.1 million in the base case.
| B | C | D | |
|---|---|---|---|
| 5 | Base case | Downside | |
| 42 | Inventories, balance sheet (LIFO) | 1,302.6 | 1,302.6 |
| 43 | (+) LIFO reserve | 208.0 | 208.0 |
| 44 | Inventory Value at current cost | 1,510.6 | 1,510.6 |
| 45 | (-) Decline in inventory Value | - | (302.1) |
| 46 | Inventory Value in scenario | 1,510.6 | 1,208.5 |
| 47 | (-) Inventory of non-borrower subsidiaries (Mexico, China) | (39.8) | (31.9) |
| 48 | Credit-party inventory | 1,470.8 | 1,176.6 |
| 49 | (-) Supplies and maintenance parts | (7.4) | (8.8) |
| 50 | (-) Slow-moving (50% of slow-moving Value) | (44.1) | (52.9) |
| 51 | (-) Non-conforming metal | (14.7) | (17.6) |
| 52 | (-) Third-party sites without waiver | (22.1) | (26.5) |
| 53 | (-) In-transit and consigned above caps | (7.4) | (8.8) |
| 54 | (-) Tolling, prepaid and vendor credits | (7.4) | (8.8) |
| 55 | Total ineligible inventory | (103.0) | (123.5) |
| 56 | Eligible inventory at Value ($M) | 1,367.8 | 1,053.1 |
| 57 | NOLV % of Value | 80.0% | 65.0% |
| 58 | Eligible inventory at NOLV | 1,094.3 | 684.5 |
| 59 | Advance rate on NOLV | 85.0% | 85.0% |
| 60 | Inventory availability ($M) | 930.1 | 581.8 |
| 61 | Effective advance rate on eligible Value | 68.0% | 55.3% |
| 70 | Dilution reserve | - | 27.0 |
| 71 | Landlord reserve | 3.1 | 3.1 |
| 72 | Canadian priority payables reserve | 5.0 | 5.0 |
| 73 | Bank product reserve | 5.0 | 5.0 |
| 74 | Other Permitted Discretion reserves | - | 15.0 |
| 75 | Total reserves ($M) | 13.1 | 55.1 |
Ryerson carries most of its inventory on LIFO at $1,302.6 million, and the 10-Q discloses a $208.0 million excess of current cost over that value. The agreement values inventory at the perpetual inventory system’s value, which sits before the LIFO adjustment, so Compound added the reserve back and left a switch on the Assumptions sheet to run on book value instead. At an 80% NOLV and the 85% advance rate, the add-back is worth about $141.4 million of availability before ineligibles (our arithmetic), which makes it the largest single judgment on the inventory side after the NOLV itself.
The ineligible categories are again analyst rates on credit-party inventory: 0.5% supplies and maintenance parts, 6% slow-moving stock of which the agreement excludes half, 1% non-conforming metal, 1.5% at outside processors or warehouses without a lien waiver, 0.5% in-transit and consigned stock above the agreement’s $5 million and $10 million caps, and 0.5% tolling, prepaid inventory and vendor credits. The $103.0 million total is 7.0% of credit-party inventory (our arithmetic).
The NOLV is where the inventory side stands or falls. Compound’s note sets the base at 80% “for prime carbon, stainless and aluminum products that trade in liquid secondary markets” and the downside at 65% “for forced sales into falling prices,” and says to replace both with the Qualified Appraisal. Each point of NOLV is worth $11.6 million of availability (our arithmetic).
The base-case reserves are a $3.1 million landlord reserve (fiscal 2025 operating lease expense of $49.5 million, times an assumed 25% share at sites without a waiver, times three months), $5 million for Canadian priority payables and $5 million for bank products. No dilution reserve applies at the 2.0% base-case dilution, which is below the 2.5% threshold. No Qualified Cash is counted, because none is disclosed and part of the $40.5 million of cash sits with the non-borrower subsidiaries.
Excess availability against the springing trigger
Receivables and inventory availability, less reserves, give a borrowing base of $1,755.3 million, below the $1,800 million of commitments, so the borrowing base is the Line Cap. Excess availability is $734.3 million, 41.8% of the Line Cap, and $558.8 million above the springing trigger.
From collateral availability to excess availability, base case
September 30, 2026, US$ millions. The borrowing base is $1,755.3 million after reserves
Compound's Borrowing Base tab, availability block. Loans and letters of credit: Ryerson's Form 10-Q for the quarter ended September 30, 2026, Note 7.
| B | C | D | |
|---|---|---|---|
| 5 | Base case | Downside | |
| 78 | Receivables availability | 838.3 | 694.3 |
| 79 | (+) Inventory availability | 930.1 | 581.8 |
| 80 | (+) Qualified Cash availability | - | - |
| 81 | (-) Reserves | (13.1) | (55.1) |
| 82 | Borrowing base ($M) | 1,755.3 | 1,221.0 |
| 83 | Aggregate commitments | 1,800.0 | 1,800.0 |
| 84 | Line Cap (lesser of borrowing base and commitments) | 1,755.3 | 1,221.0 |
| 85 | (-) Revolving loans outstanding | (1,014.0) | (1,014.0) |
| 86 | (-) Letters of credit outstanding | (7.0) | (7.0) |
| 87 | Excess availability ($M) | 734.3 | 200.0 |
| 88 | Excess availability % of Line Cap | 41.8% | 16.4% |
| 89 | Borrowing base less loans and LCs | 734.3 | 200.0 |
| 90 | Borrowing base coverage of loans and LCs | 1.72x | 1.20x |
| 93 | Springing FCCR and cash dominion trigger | 175.5 | 122.1 |
| 94 | Headroom over springing trigger | 558.8 | 77.9 |
The trigger formula takes the greater of 10% of the Line Cap and the $80 million floor. At this Line Cap the percentage test governs, so the trigger moves with the collateral: it is $175.5 million in the base case and $122.1 million in the downside. A floor that low only binds below a Line Cap of $800 million (our arithmetic).
The Covenant sheet also tests the agreement’s other triggers: weekly borrowing base certificates ($219.4 million in the base case), an extra field exam and appraisal below $130 million, and monthly agings below $195 million. None is in effect at the reported, base or downside figures.
Backing the appraisal NOLV out of reported availability
The company reports $777 million of availability, which with $1,021 million of loans and letters of credit puts its Line Cap at $1,798.0 million. Holding every other base-case input, the NOLV that reproduces that Line Cap is 83.7%. That is the number to test in the appraisal.
| B | C | |
|---|---|---|
| 99 | Availability reported by the company | 777.0 |
| 100 | Modeled excess availability | 734.3 |
| 101 | Variance: modeled less reported | (42.7) |
| 102 | Variance % of reported | (5.5%) |
| 103 | Line Cap implied by reported figures | 1,798.0 |
| 104 | Modeled Line Cap | 1,755.3 |
| 105 | NOLV % that reproduces the reported Line Cap | 83.7% |
The formula in C105 treats inventory as the one unknown. It subtracts the model’s receivables availability from the reported Line Cap, adds back the reserves, and divides what is left by eligible inventory times the 85% advance rate. The result, 83.7%, is 3.7 points above the model’s 80% (our arithmetic), and those 3.7 points at $11.6 million each account for the $42.7 million gap.
Compound’s answer puts it in one line: “The key number to confirm is whether NOLV clears the roughly 84% needed to match reported availability. My base case uses 80%.”
NOLV % of inventory value: the model's cases against the reported and breakeven levels
NOLV as a share of eligible inventory at current cost. The breakeven is where the borrowing base equals loans and letters of credit
Compound's Summary tab, rows 22 and 30, and Borrowing Base tab, cell C105.
The 83.7% absorbs every difference between the model and the company’s actual certificate. If the field exam finds fewer aged or cross-aged receivables than the model assumes, or the agent carries smaller reserves, the true NOLV is lower than 83.7%. If the borrowing base certificate excludes more than the model does, it is higher. The reported figure also sits $2 million under the $1,800 million of commitments (our arithmetic), so a borrowing base any larger would have been capped and the back-out would show nothing. Read as a range, the company’s certificate is consistent with an appraisal somewhat above the model’s 80% on current cost, and the appraisal is what settles it.
Dilution, DSO and inventory turns over eight quarters
DSO ran between 38.4 and 43.0 days except in the first quarter of 2026, inventory turns between 4.6x and 5.7x, and reported availability stayed between $291.3 million and $597.2 million above the springing trigger. The public dilution proxy never exceeds 0.13% of sales in a quarter, and Compound’s answer says why that understates true dilution.
| B | D | E | F | G | H | I | J | K | |
|---|---|---|---|---|---|---|---|---|---|
| 5 | Quarter ended | 12/31/2024 | 3/31/2025 | 6/30/2025 | 9/30/2025 | 12/31/2025 | 3/31/2026 | 6/30/2026 | 9/30/2026 |
| 12 | Days sales outstanding (days) | 38.9 | 41.8 | 41.5 | 41.3 | 38.4 | 48.7 | 42.1 | 43.0 |
| 13 | Inventory turns, annualized (x) | 4.7x | 5.7x | 5.7x | 5.6x | 5.7x | 4.6x | 5.5x | 5.5x |
| 17 | Provision for allowances, claims and doubtful accounts | (0.6) | 1.4 | 0.6 | 0.5 | - | 2.1 | 1.1 | 1.7 |
| 18 | Dilution proxy: provision % of net sales | (0.06%) | 0.12% | 0.05% | 0.04% | - | 0.13% | 0.05% | 0.08% |
| 19 | Dilution proxy, trailing four quarters | n.a. | n.a. | n.a. | 0.04% | 0.05% | 0.06% | 0.06% | 0.07% |
| 26 | Availability reported by the company | 376.0 | 409.0 | 407.0 | 443.0 | 428.0 | 545.0 | 668.0 | 777.0 |
| 27 | Line Cap implied (loans + LCs + availability) | 847.0 | 910.0 | 919.5 | 944.5 | 892.2 | 1,466.0 | 1,637.0 | 1,798.0 |
| 30 | Springing FCCR and cash dominion trigger | 84.7 | 91.0 | 92.0 | 94.5 | 89.2 | 146.6 | 163.7 | 179.8 |
| 31 | Headroom over springing trigger | 291.3 | 318.0 | 315.1 | 348.6 | 338.8 | 398.4 | 504.3 | 597.2 |
The first quarter of 2026 is distorted by the Olympic Steel merger on February 13, 2026. Its balances sit on the March 31 balance sheet against about seven weeks of its sales, so DSO reads 48.7 days and turns 4.6x that quarter. On the most recent quarter, DSO is 43.0 days and turns are 5.5x on LIFO inventory.
The dilution line needs to be read for what it is. The filings disclose a provision for allowances, claims and doubtful accounts in the cash flow statement, and Compound divides the quarterly provision by net sales. The trailing four-quarter figure is 0.07%. The fourth quarter of 2024 shows a negative provision, a reversal derived from the full-year and nine-month figures. Compound’s answer states the limit directly: “It understates true dilution because credit memos are netted out of reported sales.” The model therefore underwrites 2.0% in the base case, above the proxy and below the 2.5% reserve threshold, and leaves the real number to the field exam.
Reported availability against the springing trigger, by quarter
US$ millions at quarter end. The trigger is the greater of 10% of the implied Line Cap and the fixed floor
Compound's Trends tab, rows 26 and 30. Availability, loans and letters of credit: Ryerson's Forms 10-Q and 10-K for each quarter.
Loans and letters of credit used between 52.0% and 62.8% of the Line Cap over the eight quarters, with the merger quarter the high.
The springing FCCR test
On the trailing four quarters to September 30, 2026, the consolidated fixed charge coverage ratio is 2.42x: $233.2 million of EBITDA less unfinanced capex over $96.2 million of fixed charges. It is not being tested, because availability is far above the trigger, and EBITDA could fall 45.1% before the ratio reached 1.00x.
| B | C | D | E | F | |
|---|---|---|---|---|---|
| 5 | 9M Sep-26 | FY Dec-25 | 9M Sep-25 | TTM Sep-26 | |
| 7 | Adjusted EBITDA, excluding LIFO expense | 283.4 | 138.5 | 118.1 | 303.8 |
| 8 | (-) Capital expenditures | (49.8) | (51.5) | (30.7) | (70.6) |
| 9 | (-) Unfinanced capital expenditures | (70.6) | |||
| 10 | EBITDA less unfinanced capex ($M) | 233.2 | |||
| 11 | Cash interest paid | (37.9) | (41.2) | (30.5) | (48.6) |
| 12 | Scheduled principal (finance lease payments) | (4.7) | (6.0) | (4.4) | (6.3) |
| 13 | Cash income taxes paid | (5.1) | (5.7) | (4.8) | (6.0) |
| 14 | Dividends paid | (29.2) | (24.1) | (18.0) | (35.3) |
| 15 | Fixed charges ($M) | (96.2) | |||
| 16 | Consolidated FCCR (x) | 2.42x | |||
| 17 | Minimum FCCR when tested | 1.00x | |||
| 18 | Cushion over minimum | 1.42x | |||
| 19 | EBITDA decline absorbed before FCCR reaches minimum | 45.1% |
Adjusted EBITDA excluding LIFO expense is $303.8 million on a trailing basis, from the third quarter 2026 and fourth quarter 2025 earnings releases. Two choices make the ratio conservative, and both are labeled as analyst assumptions. All $70.6 million of capex is treated as unfinanced, because the borrower has no term debt and funds capex from cash flow and the revolver. All $35.3 million of dividends counts as a fixed charge, though the covenant counts only those paid under one restricted payments basket, which the filings do not identify.
The trailing figure takes no pro forma credit for Olympic Steel before the merger, so it understates the combined company’s run rate.
The downside and the sensitivity grids
The downside cuts receivables 15% and inventory value 20%, raises every ineligible rate by half, sets NOLV at 65% and dilution at 6%, and adds $15 million of agent reserves. Excess availability falls to $200.0 million, $77.9 million above a trigger of $122.1 million. Only the dilution flag trips, and it trips because the downside sets dilution at 6.0%.
The borrowing base falls to $1,221.0 million, still 1.20x loans and letters of credit held at their September 30 level. Inventory takes most of the cut: its availability falls from $930.1 million to $581.8 million, as the lower value, the higher ineligibles and the lower NOLV compound to a 55.3% effective advance rate. Receivables availability falls from $838.3 million to $694.3 million. The 6.0% dilution brings a $27.0 million dilution reserve on top of the $15 million of discretionary reserves.
The dilution flag is a test of the input: no measured dilution comes near 5%, and the downside sets 6% to see what the reserve costs.
| B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|
| 36 | NOLV % \ Dilution | 1% | 2% | 3% | 4% | 5% | 6% | 7% | 8% |
| 37 | 60% | 182.3 | 182.3 | 178.4 | 170.7 | 163.0 | 155.3 | 147.6 | 139.8 |
| 38 | 65% | 227.0 | 227.0 | 223.2 | 215.5 | 207.7 | 200.0 | 192.3 | 184.6 |
| 39 | 70% | 271.8 | 271.8 | 267.9 | 260.2 | 252.5 | 244.8 | 237.1 | 229.4 |
| 40 | 75% | 316.5 | 316.5 | 312.7 | 305.0 | 297.3 | 289.5 | 281.8 | 274.1 |
| 41 | 80% | 361.3 | 361.3 | 357.4 | 349.7 | 342.0 | 334.3 | 326.6 | 318.9 |
| 42 | 85% | 406.1 | 406.1 | 402.2 | 394.5 | 386.8 | 379.1 | 371.3 | 363.6 |
| 43 | 90% | 450.8 | 450.8 | 447.0 | 439.2 | 431.5 | 423.8 | 416.1 | 408.4 |
The tightest cell in the grid, 60% NOLV with 8% dilution, still leaves the borrowing base $139.8 million above loans and letters of credit. On downside collateral the cushion runs out only below a 42.7% NOLV. On base-case collateral it would take an NOLV of 16.8%.
The dilution columns move little because dilution enters through the reserve only above 2.5%: the 1% and 2% columns are identical, and each point beyond that costs about $9.3 million on base-case eligible receivables (our arithmetic). The NOLV rows do the work. On base-case collateral, grid 1 of the same sheet shows excess availability capped at $779.0 million from an 85% NOLV upward, where the borrowing base passes the $1,800 million of commitments and the commitments set the Line Cap.
What the public filings cannot tell you
A 10-Q and a credit agreement give the balances, the terms and the reported availability. Every eligibility rate, the NOLV and the true dilution come from the field exam and the appraisal. Compound’s answer lists what each needs to provide, and each item replaces a specific assumption in the model.
From the field exam:
- Receivables agings by invoice date and due date for each entity, JT Ryerson, Olympic Steel and Ryerson Canada. These replace the aged, cross-aged and foreign-debtor rates and size the $35 million and $30 million baskets.
- 12 months of credit memos, returns, price adjustments, rebates and write-offs against gross billings. This measures true dilution and replaces the 2.0% assumption.
- Customer and vendor matching for contra accounts, a top-debtor and concentration list, and any credit insurance.
- Receivables and inventory for the credit parties against the Mexico and China subsidiaries. This replaces the 60% Canada share of foreign sales.
- A reconciliation of the perpetual inventory system to the general ledger, the LIFO reserve, and the purchase accounting adjustments on Olympic Steel inventory. This settles the $208.0 million add-back.
- Third-party processor, warehouse and leased locations with their lien waiver status; rent; in-transit and consigned stock; Canadian priority payables; bank product exposure; and deposit account control agreements for Qualified Cash.
From the appraisal:
- NOLV by product line and by location, across carbon flat, plate, long, stainless, aluminum, alloy, nickel and red metals. The agreement allows a separate NOLV for Olympic Steel.
- The recovery on processed and fabricated items, slow-moving stock and non-prime metal, with the price deck and liquidation costs behind the NOLV.
Our view
The build is the one we would want to start from, and its most useful number is one the company never discloses. We would keep the structure, take the 83.7% as the figure the appraisal has to defend, and spend the field exam on dilution and on the entity split.
The collateral clears its tests by a wide margin under the model’s assumptions. Excess availability is 41.8% of the Line Cap, the FCCR would pass at 2.42x if it were tested, and even the downside leaves $77.9 million of headroom over the trigger. The 42.7% downside breakeven NOLV is the strongest single line: it sits more than 20 points below the model’s own downside NOLV (our arithmetic). These are the model’s results under its assumptions, not a view on Ryerson’s credit.
The other side is that the cushion depends on inventory more than receivables. At the model’s 80%, inventory provides $930.1 million of availability, more than receivables do. Metals prices move both the value and the NOLV in the same direction, which is why the downside cuts inventory availability by more than a third (our arithmetic). The trends also cover only eight quarters of a business that doubled in size with a merger in the middle, so the combined borrower has only three quarter-ends of history.
Three findings would change our view: an appraisal NOLV well below the 83.7% the reported availability implies, measured dilution near the 2.5% reserve threshold, and a larger share of collateral in the non-borrower subsidiaries than the 60% Canada assumption allows. From here the work is a credit agreement analysis of the full eligibility definitions and a covenant compliance calculation on the borrower’s own certificate.
Ryerson ABL borrowing base model (Excel)Compound’s workbook from this run: a Summary with the flags, an Assumptions sheet with a source or reason beside every input, the Borrowing Base build for the base case and the downside, eight quarters of Trends, the springing Covenant test, four Sensitivity grids and Sources.Download · FreeFAQ
How is an ABL borrowing base calculated?
Take gross receivables, remove each ineligible category, and apply the receivables advance rate. Take inventory at cost, remove ineligible stock, value the rest at the appraised NOLV and apply the inventory advance rate. Add any qualified cash, subtract reserves, and cap the result at the commitments. In this model that gives a $1,755.3 million borrowing base and $734.3 million of excess availability after loans and letters of credit.
Can you back out the appraisal NOLV from reported availability?
Approximately. Add loans and letters of credit to the reported availability to get the Line Cap, subtract receivables availability, add back reserves, and divide by eligible inventory times the advance rate. Here that gives 83.7%, but the figure absorbs every difference in eligibility and reserves between the model and the borrower’s certificate, so it is a range to test in the appraisal.
Why does the public dilution proxy understate receivables dilution?
The provision for allowances and claims in the cash flow statement captures only part of the credits against receivables. Credit memos, price adjustments and returns are netted out of reported sales, so they never show in the ratio. Ryerson’s proxy is 0.07% on a trailing basis, and the model underwrites 2.0% until the field exam measures dilution against gross billings.
When does a springing fixed charge coverage covenant apply?
Only when availability falls below a trigger set in the agreement, here the greater of 10% of the Line Cap and $80 million. Above it the ratio is reported but not tested. Ryerson’s trailing ratio is 2.42x against a 1.00x minimum, with $558.8 million of headroom over the trigger in the base case.
Should ABL inventory be valued at LIFO cost or current cost?
Follow the credit agreement’s definition of inventory value. Ryerson’s agreement uses the perpetual inventory system’s value, before the LIFO adjustment, so the model adds the $208.0 million LIFO reserve back to book value. A switch on the Assumptions sheet runs the base on LIFO book value instead.





