FR EA
1011-00001 · Firm and the Company · Memoranda
borrowing-base-analysis-memo.xlsx DOCUMENT M&A / Corporate
7 / 12 ← → ✕
Contract analysis Extract to table

[sheet: Cover]

FieldValue
Document TitleBorrowing Base Analysis Memorandum — Collateral Sensitivity and Advance Rate Analysis
DateApril 8, 2022
Matter Number1011-00001
Prepared ByLisa Morrow, Working Associate, Banking & Finance / Daniel Obi, Lead Associate, Banking & Finance
Reviewed ByStephanie Okafor, Responsible Partner, Banking & Finance
Distributed ToRaymond Chu, General Counsel, Meridian Consumer Brands LLC; Patricia Delgado, CFO, Meridian Consumer Brands LLC
ReProposed $40,000,000 Asset-Based Revolving Credit Facility — Meridian Consumer Brands LLC (Borrower) / Ridgeline National Bank, N.A. (Prospective Lender)
Ridgeline Deal IDABL-2022-0417
ClassificationAttorney-Client Privileged / Attorney Work Product
Governing LawNew York
Borrower EntityMeridian Consumer Brands LLC, a Delaware limited liability company
Borrower EIN84-3291057
Borrower HQ401 West 33rd Street, Suite 1200, New York, NY 10001
Prospective LenderRidgeline National Bank, National Association, 200 Tryon Street, Charlotte, NC 28202
Lender's CounselWhitfield Ames LLP (Catherine Royce, Partner; Benjamin Nakamura, Associate)
Existing LenderGreystone Capital Finance LLC (Loan Ref: GCF-MCB-2019-1215)
Appraisal FirmBellweather Appraisal Group LLC (Lead Appraiser: Thomas Varga)
AuditorsPemberton & Locke CPAs LLP (Engagement Partner: Diane Sorrento)

[sheet: Borrower Overview]

Financial MetricValueSource / Notes
FY2021 Revenue$185,000,000Approximate; per MCB audited financials (Pemberton & Locke CPAs LLP)
FY2021 EBITDA$22,400,000Approximate; per MCB audited financials
Total Assets$142,000,000Approximate; per MCB balance sheet
Eligible Accounts Receivable (Initial)$38,000,000Per MCB aging schedule as of Jan 2022; >90-day aging threshold
Eligible Inventory at Cost (Initial)$54,000,000Per MCB inventory records as of Jan 2022
Equity SponsorBrindoval Partners Fund III, LPAcquired MCB in 2019; enterprise value ~$210,000,000
Existing First Lien Term Loan — Greystone Capital Finance LLC$75,000,000Dated December 15, 2019; maturing December 2025
Greystone Outstanding Balance (Jan 2022)$61,500,000Approximate; per MCB records
Proposed ABL Commitment$40,000,0004-year maturity; anticipated closing Q2 2022, maturing Q2 2026
Proposed Interest RateSOFR + 200 bps (25 bps SOFR floor)Step-down to SOFR + 175 bps if avg. quarterly availability > $20,000,000
Unused Line Fee37.5 bps per annumOn undrawn portion of commitment
Upfront Fee$200,000$40,000,000 × 0.50% = $200,000

[sheet: Initial Borrowing Base]

ComponentGross AmountEligibility / NOLV AdjustmentAdjusted AmountAdvance RateBorrowing Base Contribution
Eligible Accounts Receivable$38,000,000100% (>90-day aging exclusion applied)$38,000,00085%$32,300,000
Eligible Inventory (at Cost)$54,000,00070% NOLV (per Bellweather preliminary estimate)$37,800,00065%$24,570,000
Total Borrowing Base$56,870,000
Proposed Commitment$40,000,000
Excess Availability$16,870,000
Excess Availability as % of Commitment42.2%

[sheet: Revised Borrowing Base]

ComponentGross AmountEligibility / NOLV AdjustmentAdjusted AmountAdvance RateBorrowing Base Contribution
Eligible Accounts Receivable (Revised)$31,000,000100% (>60-day aging exclusion per Ridgeline revised threshold)$31,000,00085%$26,350,000
Eligible Inventory at Cost (Revised)$42,000,00070% NOLV (per Bellweather; ~$12M seasonal/slow-moving SKUs excluded)$29,400,00065%$19,110,000
Total Revised Borrowing Base$45,460,000
Proposed Commitment$40,000,000
Excess Availability$5,460,000
Excess Availability as % of Commitment13.7%

[sheet: MCB Counter-Proposal]

Component

Scenario A: MCB Counter (Original Eligibility, 75% Inv Adv Rate)

Eligible Accounts Receivable$38,000,000100% (>90-day aging threshold restored)$38,000,00085%$32,300,000
Eligible Inventory (at Cost)$54,000,00070% NOLV$37,800,00075%$28,350,000
Total Borrowing Base — Scenario A$60,650,000
Excess Availability — Scenario A$20,650,000
Excess Availability % — Scenario A51.6%

Scenario B: MCB Counter (Revised Eligibility, 75% Inv Adv Rate)

Eligible Accounts Receivable (Revised)$31,000,000100% (>60-day aging per Ridgeline)$31,000,00085%$26,350,000
Eligible Inventory at Cost (Revised)$42,000,00070% NOLV$29,400,00075%$22,050,000
Total Borrowing Base — Scenario B$48,400,000
Excess Availability — Scenario B$8,400,000
Excess Availability % — Scenario B21.0%

Scenario C: MCB Counter (Revised Inv Eligibility, 90-day AR Restored, 75% Inv Adv Rate)

Eligible Accounts Receivable$38,000,000100% (>90-day aging threshold restored)$38,000,00085%$32,300,000
Eligible Inventory at Cost (Revised)$42,000,00070% NOLV$29,400,00075%$22,050,000
Total Borrowing Base — Scenario C$54,350,000
Excess Availability — Scenario C$14,350,000
Excess Availability % — Scenario C35.9%

[sheet: Sensitivity Table — Advance Rat]

Inventory Adv Rate \ AR Adv Rate80% AR82.5% AR85% AR87.5% AR90% AR
55% Inventory$40,970,000$41,745,000$42,520,000$43,295,000$44,070,000
60% Inventory$42,440,000$43,215,000$43,990,000$44,765,000$45,540,000
65% Inventory$43,910,000$44,685,000$45,460,000$46,235,000$47,010,000
70% Inventory$45,380,000$46,155,000$46,930,000$47,705,000$48,480,000
75% Inventory$46,850,000$47,625,000$48,400,000$49,175,000$49,950,000
80% Inventory$48,320,000$49,095,000$49,870,000$50,645,000$51,420,000