The following discussion illustrates a project that is well suited to the capabilities of an independent consultant in the Umbrex Private Equity Practice. This is an illustrative example. Umbrex consultants adapt their methodology, timeline, and deliverables to the specific needs of each client.
1) Client Situation
The client operated across a multi-product private equity platform and required support with LBO Underwriting And Returns Modeling in the context of Private Equity. Stakeholders included Mega/Large-Cap Private Equity Buyout Firms underwriting carve-outs and public-to-private opportunities at pace, Mid-Market & Lower Mid-Market Private Equity Sponsors building buy-and-build platforms and structured equity solutions, Growth Equity Investors (Private Equity) exploring minority and structured preferred opportunities with downside protection, Private Equity Operating Partners & Value Creation Teams pressure-testing value creation plan assumptions, and PE-Owned Portfolio Companies supporting sell-side and refinancing processes. The diagnostic we conducted highlighted gaps that constrained conviction on leverage, free cash flow durability, and exit valuation under multiple macro paths:
- Unstructured base case and incomplete downside framing
- Management cases were prepared at a high level with EBITDA bridges but without a fully integrated three-statement model linking EBITDA to unlevered/levered free cash flow (FCF). Downside cases were scenario headlines rather than parameterized drivers (volume, price, mix, COGS inflation, working capital, capex, FX).
- Debt sizing and covenant headroom not calibrated to lender appetite
- Indicative term sheets lacked translation into period-by-period leverage trajectory, cash sweep dynamics, and RCF use/availability. Maintenance covenants (net leverage, interest coverage, FCCR) were not measured against modeled stress cases; covenant cure mechanisms and basket capacities were not mapped.
- Interest rate and base-rate volatility not captured
- Floating-rate exposure, floors, and SOFR forward curves were not embedded. Interest sensitivity and hedging strategies (swaps, caps) had not been evaluated against rate scenarios or lender constraints.
- Purchase accounting, PF adjustments, and separation costs underdeveloped
- Carve-out transition service agreements (TSAs), stranded cost removal, and one-time/semi-recurring separation costs were not consistently reflected. Purchase price allocation (PPA), step-up amortization, and deferred financing fee amortization were missing.
- Working capital and capex intensity uncertain
- Normalized working capital pegs by seasonality and revenue mix were unsettled. Capex classification (maintenance vs. growth) and efficiency levers were not benchmarked; FCF conversion varied materially across cases.
- Equity structuring and MIP (management incentive plan) not translated to sponsor returns
- Rollover equity, co-invest, preferred or structured tranches, earn-outs, and MIP pools were not simulated across exit outcomes. Waterfall mechanics, PIK, and cash pay preferences needed quantification.
- Exit valuation and deleveraging paths not reconciled
- EV/EBITDA exit multiples were assumed without triangulation to public comps, precedent transactions, and sponsor case positioning; deleveraging and cash accumulation paths were not reconciled to exit windows and covenant headroom.
- Underperforming KPIs
- Weak cash conversion (DSO/DPO/DIO drift) in historicals; rising interest burden vs. hedging posture; inventory build in the base case; thin covenant cushions in quarters with seasonally low EBITDA; limited visibility to lender diligence asks and data requirements; and misalignment between operating plan cadence and debt service schedules.
2) Project Objective
The primary objective focused on building an integrated leveraged buyout model with debt capacity sizing, covenant and liquidity headroom, period-by-period free cash flow, and exit scenarios—running sensitivities to underwrite IRR/MOIC and downside protection consistent with lender appetite and the sponsor’s risk-return target.
Secondary objectives included:
- Quantifying sources and uses with fees and leakage, including rollover equity, MIP, preferred and holdco structures, and debt OID/fees, with pro forma ownership and governance implications.
- Embedding a transparent driver tree for revenue, margin, working capital, capex, and overhead/separation costs linked to commercial and operational diligence.
- Sizing and optimizing capital structure across senior, unitranche, second lien, mezzanine, and RCF, with calibrated amortization, cash sweeps, baskets, and intercreditor constraints.
- Modeling interest rate scenarios (spot vs. forwards, floors, caps/swaps) with interest sensitivity and hedging economics.
- Measuring maintenance covenant headroom (net leverage, interest coverage, FCCR) and liquidity (RCF availability, minimum cash) across base/downside and execution risks.
- Constructing exit cases (5–7x or bespoke segment multiples) with deleveraging paths, cash accumulation, and equity waterfall to sponsor, MIP, and rollover under multiple windows.
- Preparing an underwriting casebook and lender pack: assumptions, sensitivities, covenant model, and Q&A-ready evidence.
3) Methodology and Approach
Workstream 1: Data Reconciliation and Baseline Build
We created a clean, reconciled starting point grounded in historical reality.
- Activities we conducted:
- Reconciled historical financials (three to five years) to the GL and auditor reports; tied revenue and COGS to product/region mix where available; normalized for one-offs (COVID, strikes, discontinued operations).
- Built a monthly-to-quarterly model spine reflecting seasonality, backlog conversion, and supply constraints; aligned accounting policies (rev rec, lease accounting, capitalization thresholds).
- Mapped working capital drivers: DSO, DPO, DIO by segment; reconciled cash flow statement to balance sheet movements; validated cash taxes and interest timing.
- Tools/frameworks used: data reconciliation workbook, accounting policy crosswalk, monthly seasonality index, WC bridge template.
- Stakeholders involved: target CFO/controller, sponsor finance lead, financial diligence advisor.
Workstream 2: Sources & Uses, Purchase Accounting, and Pro Forma Adjustments
We quantified the transaction perimeter and its financial consequences.
- Activities we conducted:
- Prepared detailed sources & uses including rollover equity, sponsor equity, co-invest, debt tranches (RCF, TLA/TLB/unitranche, second lien, mezz), preferred/holdco, OID, fees (underwriting, legal, advisor), and leakage (working capital true-up, cash to seller, taxes).
- Modeled PPA: identifiable intangibles, goodwill, step-up amortization, deferred tax impacts; capitalized financing fees with straight-line/amortized methods per lender specs.
- Embedded pro forma adjustments: carve-out TSAs, stranded cost removal, synergy and dis-synergy timing, separation one-time/semi-recurring costs, management changes, and MIP accruals.
- Tools/frameworks used: sources & uses model, PPA calculator, PF adjustments register, TSA cost schedule.
- Stakeholders involved: sponsor deal team, transaction services, legal counsel (SPA/TSA), audit/tax advisors.
Workstream 3: Operating Case and Value Creation Translation
We linked diligence insight to the model via parameterized drivers.
- Activities we conducted:
- Constructed revenue drivers by segment: volume, price, mix, retention (for subscription-like revenue), and new logo cadence; tied to pipeline conversion and capacity models from commercial diligence.
- Built cost stacks: material/labor/overhead, SG&A by function; parameterized procurement, pricing, footprint, and productivity levers from operational diligence with phased ramp and execution risk haircuts.
- Differentiated maintenance vs. growth capex; reflected working capital improvements (inventory turns, terms renegotiation) with lag and sustainability assumptions; embedded FX for relevant entities with hedging toggles.
- Tools/frameworks used: driver tree map, lever ramp profiles, WC improvement playbook, FX/hedging module.
- Stakeholders involved: operating partners, commercial/operational diligence teams, target management.
Workstream 4: Capital Structure Design and Debt Capacity
We calibrated leverage, amortization, and liquidity to lender appetite and cash generation.
- Activities we conducted:
- Sized debt tranches versus EBITDA, FCF, asset base, and lender feedback; evaluated unitranche vs. split capital structures; set amortization schedules, call premiums, and mandatory sweep mechanics.
- Modeled RCF usage/availability with borrowing base (if applicable), cash traps, springing covenants, and minimum liquidity policies; simulated cash sweep priorities and prepayment penalties.
- Benchmarked leverage and pricing vs. market comps; iterated with debt advisors on feasible structures and covenant packages.
- Tools/frameworks used: debt sizing tool, sweep and waterfall logic, RCF availability model, market comps dashboard.
- Stakeholders involved: debt advisor/leveraged finance bankers, sponsor financing team, prospective lenders.
Workstream 5: Interest Rate, Base-Rate, and Hedging Scenarios
We quantified rate risk and hedging economics across realistic paths.
- Activities we conducted:
- Embedded base-rate curves (SOFR/EURIBOR) with floors and spreads by tranche; included OID amortization and non-cash PIK toggles for subordinated debt; captured day-count conventions.
- Modeled hedging options (caps/swaps) with premiums, accounting treatments, and covenant/credit agreement constraints; analyzed pay-fixed vs. cap trade-offs under forward curves and stress cases.
- Prepared interest sensitivity tables showing IRR/MOIC impact by ±100–300 bps shifts and by floor changes.
- Tools/frameworks used: rate curve loader, hedging economics module, interest sensitivity dashboard.
- Stakeholders involved: treasury advisors, lenders, sponsor risk committee.
Workstream 6: Covenants, Liquidity, and Headroom Analytics
We translated legal terms into operational guardrails.
- Activities we conducted:
- Modeled maintenance covenants: total/net leverage, interest coverage, FCCR, and springing tests; assessed cushions quarter-by-quarter under base/downside and one-off stress (customer loss, supply shock, price pushback).
- Built liquidity tracker: minimum cash, RCF availability, letters of credit, and blocked cash under cash dominion; linked to working capital seasonality and capex spikes.
- Mapped baskets and ratio debt capacity to planned add-ons/dividends; tested portability/acquisition caps vs. buy-and-build strategy.
- Tools/frameworks used: covenant calculator, liquidity dashboard, baskets/ratio debt tracker.
- Stakeholders involved: legal counsel (credit docs), lenders, sponsor financing team.
Workstream 7: Equity Structure, Waterfall, and MIP Design Implications
We clarified sponsor and management outcomes across exit paths.
- Activities we conducted:
- Structured equity: sponsor/co-invest, rollover equity, preferred or holdco instruments (cash/PIK), earn-outs/contingent consideration; modeled priority of distributions and IRR hurdles.
- Designed a flexible MIP module: options/profits interests with vesting and performance hurdles; simulated dilution and payouts under exit cases; incorporated leaver provisions and refresh pools.
- Produced sponsor and management waterfalls by exit timing and multiple, including tax assumptions and carried interest mechanics where relevant.
- Tools/frameworks used: equity waterfall engine, MIP simulator, tax sensitivity worksheets.
- Stakeholders involved: sponsor HR/comp team, legal/tax advisors, target management.
Workstream 8: Valuation and Exit Scenarios
We triangulated exit multiples and timing to portfolio strategy and market comps.
- Activities we conducted:
- Benchmarked public trading comps and precedent transactions by micro-segment; adjusted for growth/margin/scale and private v. public valuation deltas.
- Built exit cases at multiple ranges and timing (year 3/4/5/6), including add-on synergies and multiple arbitrage assumptions; reconciled deleveraging and cash accumulation to expected lender and buyer preferences.
- Prepared DCF cross-checks and implied exit multiple analysis from target IRR pathways to test reasonableness.
- Tools/frameworks used: comps and transactions database, exit timing matrix, implied multiple/IRR bridge.
- Stakeholders involved: investment committee members, valuation advisors, operating partners.
Workstream 9: Sensitivities, Tornado Charts, and Downside Protection
We quantified what matters most for returns and covenant safety.
- Activities we conducted:
- Ran univariate and multivariate sensitivities on price/volume/mix, gross margin, SG&A efficiency, working capital turns, capex, FX, base rates, and exit multiple; visualized IRR/MOIC impacts via tornado charts and heat maps.
- Constructed harsh but plausible downside: loss of top-3 customer, commodity spike with delayed pass-through, add-on slippage, TSA extension costs; validated covenant and liquidity headroom; identified mitigations (pricing, cost actions, capex deferral).
- Summarized “five things that move the deal” for IC and lender dialogues; highlighted early warning KPIs and triggers.
- Tools/frameworks used: sensitivity engine, tornado/heat map visualizations, early-warning KPI pack.
- Stakeholders involved: deal team, operating partners, lenders, IC chair.
Workstream 10: Underwriting Casebook, Lender Pack, and IC Readout
We packaged the model and narrative for efficient decisions and financing.
- Activities we conducted:
- Prepared an underwriting casebook: base/upside/downside cases, sources & uses, capital structure, covenants/liquidity, returns, and sensitivities with clear assumptions and version control.
- Built lender model and term sheet requests: covenant proposals, baskets, permitted add-on capacity, hedging approach; prepared Q&A-ready schedules (WC seasonality, capex, TSA/separation).
- Presented an IC deck: thesis, risks/mitigations, returns bridges (MOIC/IRR by lever, multiple, growth, and FCF), and decision topics (equity check, hedging, MIP).
- Tools/frameworks used: fully auditable Excel model with scenario manager, lender schedules, IC deck templates, version-controlled assumptions log.
- Stakeholders involved: investment committee, sponsor financing team, debt advisors, operating partners.
4) Data Request
We requested datasets and artifacts required to build the LBO model, calibrate operating drivers, and align with financing realities. Typical horizons covered 36–60 months historical and current plan/forecast versions.
- Financials and operations:
- Audited financials and monthly management accounts; revenue/COGS/OpEx by product/region/channel; headcount and labor cost; backlog, bookings, cancellations; FX exposure by entity.
- Working capital and capex:
- AR/AP aging by customer/supplier, inventory by SKU/class and turns; DSO/DPO/DIO history and policies; capex by project with maintenance/growth split and ROI assumptions.
- Contracts and pricing:
- Top-50 customer contracts (terms, escalators, indexation, rebates); price lists and discount matrices; supplier contracts and commodity indices; TSAs and carve-out/separation cost estimates.
- Debt and financing:
- Existing debt schedules; proposed term sheets (pricing, amortization, covenants, baskets, RCF details, LC); OID/fees; historical and projected base rates; hedging policies and any current derivatives.
- Tax and legal:
- Tax returns and effective rate drivers; NOLs/limitations; legal entity chart and target structure (asset vs. stock, cross-border); anticipated PPA and step-up considerations.
- Value creation levers:
- Commercial and operational diligence findings; synergy/dis-synergy estimates; procurement and footprint actions; pricing initiatives; IT and integration programs.
- Valuation references:
- Public comps and precedent transactions; banker decks; fairness opinions (if any); management business plan and bottoms-up account plans.
- Other:
- Insurance coverage (key policies); environmental or regulatory remediation estimates; litigation reserves; HR/MIP proposals and rollover intentions.
Common data pitfalls included inconsistent SKU and customer hierarchies, revenue recognized net vs. gross without clear policy notes, discount data at header rather than line level, incomplete TSA scopes, capex misclassified, AR/AP aging not reconciling to GL, lack of visibility to seasonality, and term sheets missing baskets/definitions. We established a data dictionary, PF adjustment register, and reconciliation rules before underwriting.
5) Questions for Client
- What hold period and target return thresholds (gross/net IRR, MOIC) govern underwriting for this fund and strategy?
- What leverage appetite and capital structure preferences (unitranche vs. split, second lien/mezz, preferred) should we prioritize with lenders?
- Which value creation levers are thesis-critical (pricing, procurement, footprint, mix, add-ons) and what execution risk haircut is acceptable?
- What exit multiple and timing ranges are credible given comps, strategy, and integration cadence; how should we treat multiple expansion/decline?
- What hedging posture (swaps, caps) is acceptable; what rate and FX scenarios should be used for sensitivity?
- What covenant and liquidity guardrails are non-negotiable (minimum cushions, revolver availability, springing tests)?
- How should MIP be structured (pool size, instrument, vesting/hurdles); what rollover expectations exist for management and sellers?
- What TSA and separation assumptions should be applied; how will stranded costs and dis-synergies be managed and timed?
- Are add-on M&A and synergies required to meet underwriting returns; what basket/ratio debt capacity must be reserved?
- What tax structure is preferred (step-up, cross-border implications, NOL use), and what constraints exist?
- What early warning KPIs should trigger management action post-close (DSO/DPO/DIO, commodity pass-through lag, backlog slippage)?
- What lender universe and process/timeline should be assumed; what diligence asks must the model anticipate?
6) Interview Guide for Subject Matter Experts
Sponsor Deal Team / Investment Lead
- Which thesis pillars drive returns; where must the model reflect conviction vs. prudence?
- What comparable cases inform leverage, covenants, and exit timing; where did mistakes occur historically?
- What IC questions are likely on sensitivities and downside protection?
Target CFO / Controller
- What accounting policies (rev rec, capitalization, lease treatment) affect comparability; where are one-offs?
- How do working capital dynamics vary by season and segment; what improvements are realistic?
- What maintenance vs. growth capex is necessary; what ROI evidence exists?
Debt Advisor / Prospective Lenders
- What leverage and covenant packages are feasible; how do lenders view this sector’s volatility and FCF conversion?
- What hedging, baskets, and add-on capacity will face resistance; what liquidity minimums are market?
- What diligence artifacts will be required for credit approval (customer concentration, WC, TSA)?
Commercial Diligence Lead
- What volume/price/mix and share assumptions anchor the base case; where should we stress?
- What backlog conversion and pipeline quality metrics support near-term revenue; where are risks?
- What exit multiple and timing logic flow from the market/comp set?
Operational Diligence / Procurement / Footprint
- What COGS and SG&A improvements are executable within year 1–2; what investment or timing gates exist?
- What execution haircuts should be applied to productivity and procurement savings?
- What separation/IT/TSAs affect timing and cost?
Tax and Legal Advisors
- What structure optimizes step-up and cash taxes; where do cross-border constraints arise?
- How should PPA and deferred taxes be reflected; any Section 382 or other NOL limitations?
- What covenants and baskets require negotiation for planned add-on strategy?
Treasury / Risk Management
- What rate/FX hedging instruments and tenors are practical; what are the accounting and covenant implications?
- How should cash management, RCF usage, and minimum liquidity policies be set?
Human Capital / MIP Design
- What MIP structure aligns management with target returns; what vesting and hurdles fit the value creation roadmap?
- What retention or refresh considerations should be priced?
7) Timeline
We executed a 12–14 week plan tailored to LBO Underwriting & Returns Modeling within Investment Diligence & Underwriting.
- Weeks 1–2: Baseline & Reconciliation
- Collected historicals; reconciled to GL; established monthly spine and seasonality; aligned accounting policies; built initial sources & uses and PF adjustments register.
- Decision Gate A: Approved baseline model, reconciliation, and PF adjustments scope.
- Weeks 3–4: Operating Drivers & Value Creation Translation
- Integrated commercial/operational diligence; parameterized revenue and cost drivers; set WC and capex assumptions; drafted separation/TSA cost curve.
- Decision Gate B: Validated base case drivers; agreed lever haircuts and timing.
- Weeks 5–6: Capital Structure, Debt Capacity & Interest Scenarios
- Sized debt tranches; embedded amortization and sweep mechanics; loaded base-rate curves/floors; evaluated hedging; began covenant framework.
- Decision Gate C: Ratified capital structure and preliminary lender asks.
- Weeks 7–8: Covenants, Liquidity & Equity Waterfall
- Modeled maintenance covenants and baskets; built liquidity tracker; implemented equity waterfall and MIP module; iterated rate/FX sensitivities.
- Decision Gate D: Approved covenant targets and equity structure options.
- Weeks 9–10: Exit Scenarios & Sensitivity Engine
- Triangulated exit multiples; modeled exit timing windows; ran tornado/heat maps; finalized downside protection and mitigation levers; prepared lender/IC exhibits.
- Decision Gate E: Confirmed underwriting case and ranges; aligned lender pack outline.
- Weeks 11–12: Underwriting Casebook, Lender Pack & IC Readout
- Compiled casebook with cases, covenants, liquidity, and returns; produced lender schedules and Q&A datasets; delivered IC deck and assumptions log; executed model audit review.
- Decision Gate F: Authorized financing outreach or term sheet negotiations; captured confirmatory diligence list.
- Weeks 13–14 (optional): Confirmatory & Documentation Support
- Supported lender diligence; responded to IC/lender Q&A; updated model for term sheet revisions; prepared SPA/TSA economics exhibits; transitioned model to portfolio value creation planning.
Critical path items included data reconciliation and policy alignment, translation of diligence to driver assumptions, lender-calibrated capital structure, covenant and liquidity headroom analytics, interest/FX hedging analysis, and exit multiple/timing triangulation.
8) Deliverables
- Integrated LBO Model (Auditable)
- Three-statement engine with monthly/quarterly granularity; sources & uses; capital structure; PF adjustments; WC/capex modules; tax; interest sensitivity; hedging; covenant and liquidity dashboards; equity waterfall and MIP.
- Underwriting Casebook
- Base/upside/downside cases; levered/unlevered FCF; deleveraging paths; returns bridges (IRR/MOIC attribution to multiple, leverage, and operating delta); tornado/heat maps; assumptions log with version control.
- Debt Capacity & Covenant Memo
- Capital structure rationale; lender comps; headroom analysis for leverage/coverage/FCCR; liquidity policy; baskets and ratio debt capacity; hedging posture and rationale.
- Lender Pack & Q&A Schedules
- WC seasonality, capex plan, TSA/separation cost timelines, customer concentration and backlog schedules, sensitivity tables, and covenant calculators aligned to proposed terms.
- Exit Scenarios & Valuation Cross-Checks
- Trading/transaction comps; DCF cross-check; exit timing matrix with implied multiples; buyer universe considerations; multiple arbitrage and add-on synergy overlays.
- SPA/TSA Economics & PF Adjustment Register
- One-time/semi-recurring costs, stranded cost program, synergy/dis-synergy timing; purchase accounting summary; WC peg analysis; tax structure notes.
- MIP & Rollover Analysis
- Pool design options; vesting/hurdles; sponsor/management waterfalls across exits; dilution analysis; tax considerations.
- IC Deck & Executive Summary
- Thesis tree; key risks/mitigations; underwriting cases and ranges; returns attribution; decisive sensitivities; proposed capital structure and lender plan; decisions required.
- Model Audit & Documentation
- Cell-by-cell audit log, checks, and error traps; user guide; change log; input assumptions dictionary; scenario manager instructions.
9) Industry Insights
- Private credit dynamics are redefining leverage and covenants
- Unitranche and club deals can offer higher leverage and speed but often carry tighter liquidity expectations and bespoke covenants. Maintenance versus incurrence-light packages alter downside protection; underwriting should quantify both headroom and cure options.
- Base-rate volatility requires explicit interest policy
- SOFR floors and forward curves materially impact coverage in year one; caps/swaps economics should be modeled against lender limitations and hold period duration. Rate risk can dominate early returns for cash-light assets.
- Cash conversion is often the decisive returns driver
- Working capital turns and maintenance capex discipline determine deleveraging paths. Diligence must reconcile policy to practice by segment and seasonality; WC pegs and TSA mechanics influence day-one liquidity.
- Carve-outs demand credible separation economics
- TSAs and stranded cost removal timelines can make or break covenants in early quarters. Semi-recurring “one-time” costs should be tightly defined; add buffer for vendor and IT dependencies.
- Multiple expansion cannot be the plan
- Exit case credibility stems from growth, mix, and operational upgrades, not just market re-rating. Scenario analysis should constrain exit multiples to comp- and performance-justified ranges with implied-multiple cross-checks.
- MIP design influences execution
- Well-calibrated MIP pools and hurdles align management to FCF and deleveraging milestones; modeling should show dilution and payout fairness across base/downside to avoid misaligned incentives.
- Buy-and-build requires basket foresight
- Ratio debt/incurrence capacity and acquisition baskets must accommodate a realistic add-on cadence. Underwriting should reserve baskets and model post-closing flexibility; lenders will ask for pro forma covenant math.
- FX and commodity pass-through lags are frequent surprises
- Global platforms face translation and transaction exposure; pass-through clauses and pricing cadence dictate margin resilience. Rate/FX modules and price-cost lag modeling reduce downside surprise risk.
- What “good” looks like
- An auditable, driver-based LBO model with reconciled historicals; calibrated capital structure and hedging; covenant and liquidity headroom under credible downside; exit scenarios triangulated to comps; transparent returns attribution; and a lender-ready narrative with clear mitigations and early warning KPIs.
- Near-term watch points
- Private credit capacity and pricing shifts; base-rate and inflation persistence; supply-chain normalization impacting inventory; regulatory or antitrust headwinds for add-ons; and IT/separation execution risks. Quarterly refresh of sensitivities and headroom maintains underwriting discipline between signing and close.
Implications for clients we served included enabling Mega/Large-Cap Private Equity Buyout Firms to move with speed and discipline on complex carve-outs and public-to-privates, supporting Mid-Market & Lower Mid-Market Private Equity Sponsors to structure resilient capital stacks and credible base cases, equipping Growth Equity Investors (Private Equity) to evaluate structured alternatives and downside protection, guiding Private Equity Operating Partners & Value Creation Teams to translate diligence to executable FCF levers, and providing PE-Owned Portfolio Companies clarity on PF adjustments, TSA economics, and MIP design impacts ahead of process or refinancing.