From CIM to One-Tab Screening Model: A Step-by-Step IB Playbook

One-Tab CIM Model: Fast, Disciplined Deal Screening

A Confidential Information Memorandum is the seller’s marketing deck for a business: the story, the stats, and the hopes, not an audit. A one-tab screening model is a single-sheet spreadsheet that turns that deck into cash, coverage, and valuation math you can test in hours. It exists to make a fast, informed call: proceed, park, or pass.

Sellers lean into ambition, bankers widen buyer lists and push price, and management teams emphasize strategy, wins, and normalized earnings. Credit minds care about downside and interest coverage. The one-tab model neutralizes narrative bias by converting claims into parameters that either move cash or do not. It sets a narrow range of plausible outcomes and highlights the two or three variables that decide value and feasibility. That is the payoff: speed with discipline.

Guardrails that keep the screen compliant and clean

Treat the CIM as material non-public information. Log access, wall-cross as required, and keep the file with the deal team. Do not mix MNPI with public models until controls are in place. Track the provenance of every input. Add a tie-out panel with CIM page references. Keep Q&A, redlines, and versions in a shared workspace with permissions and an immutable audit trail.

48-hour build plan that produces decision-grade outputs

Work to a short, owner-led timeline so you can brief Investment Committee without rework. Assign a deal captain and a model owner on Day 0 when the CIM lands and the NDA is countersigned. Save a versioned template and open a tie-out log. In the first six hours, read the CIM at speed to map segments, drivers, concentrations, seasonality, backlog, pricing, cost structure, capital intensity, working capital, leases and debt, legal exposures, and supplier risk. Flag footnotes and inconsistencies.

Between hours 6 and 12, build the one-tab model. Input historicals and the seller’s base case. Normalize accounting and EBITDA. Build drivers, working capital, capex, leases, debt, tax, free cash flow, metrics, valuation, and sensitivities. Set upside, base, and downside assumptions. By hours 12 to 18, draft the banker Q&A to convert assumptions into facts. Ask for revenue bridges, churn, backlog rollforward, cohort and pricing data, working capital detail, capex split, concentration, contracts, and the EBITDA definition expected for the purchase agreement. On Day 1, huddle with IC to present outputs, kill tests, and gaps, and decide to advance, pause for specific data, or pass.

Blueprint: what goes into a strong one-tab

Keep it to one visible sheet with no hidden rows. Use a left-to-right layout: inputs and assumptions; income statement bridge; working capital and capex; leases and debt; tax and cash flow; metrics; valuation; sensitivities; tie-outs. Favor simple math you can audit in a meeting.

Inputs and assumptions that anchor the model

Historical actuals: At least three years and TTM. Capture revenue by segment, gross margin, opex by function, D&A, non-recurring items, stock-based comp, and adjustments.
Seller forecast: As provided. Separate pro forma changes like acquisitions, initiatives, and cost saves from core run-rate.
Toggles: IFRS vs US GAAP, lease treatment, price vs volume, inflation pass-through, FX, gross and net revenue retention, bookings, unit economics, and seasonality.

Income statement bridge that converts narrative to drivers

Revenue: Anchor drivers to price, volume, retention, and new logos or cohorts. Constrain growth to what industry context and pipeline math can support. For software, model ARR, gross retention, and net expansion. For manufacturing, link to throughput and price indexes. For services, tie hourly rate, utilization, and headcount.
Gross margin: Link to input costs, mix, and any claimed efficiency gains. If the CIM shows step-ups from vendor switches or insourcing, model timing and ramp and haircut execution in downside.
Operating expenses: Split into S&M, G&A, and R&D or tech. Apply operating leverage only where capacity is demonstrated. Treat public company costs and carve-out stand-up costs explicitly, not buried in a plug.
EBITDA: Compute both unadjusted and adjusted. Track adjustments with clear labels and durations, and add toggles to align covenant EBITDA and valuation EBITDA.

Working capital and capex that respect the cash cycle

Working capital: Build DSO, DIO, and DPO. Assume no structural improvement without a documented program. Where seasonality matters, use quarterly peaks. Services with negative working capital need sensitivity to billing slippage.
Capex: Split maintenance and growth. Anchor maintenance to depreciation with judgment on asset life. Tie growth capex to the share of growth that needs capacity. Capitalized software belongs in capex.

Leases, debt, and interest that reflect real obligations

Leases: Under IFRS 16 and ASC 842, operating leases are capitalized. Show lease-adjusted leverage and coverage for credit, and keep an unadjusted lens for equity comps. Reflect lease cash outflows and align definitions with your credit box.
Debt: Map existing debt by tranche, rate type, amortization, and covenants. Build a simple financing case to test feasibility, including revolver availability, springing covenants, baskets, and mandatory prepayment triggers. Keep a visible debt schedule.
Interest: Compute cash interest on average balances with a forward curve or flat rate plus margin. Include commitment and ticking fees where relevant. Keep math transparent and avoid circularity.

Tax and cash flow that tie to decision metrics

Tax: Use a blended statutory rate by jurisdiction. If NOLs are disclosed, link utilization to taxable income. A single effective rate is fine if labeled.
Cash flow: Show unlevered and levered free cash flow. If the CIM signals minimum cash, use it. Waterfall: EBITDA minus capex minus change in working capital minus cash interest minus cash taxes equals free cash flow.

Metrics, valuation, and sensitivities you can defend

Credit metrics: Gross or net leverage, cash interest coverage, and fixed charge coverage for lease-heavy businesses. Label definitions.
Equity metrics: EV or EBITDA multiples, unlevered IRR on entry or exit multiple bands, and free cash flow yield. For credit, show debt service capacity and covenant headroom.
Sensitivities: At minimum, growth vs margin and margin vs capex. For credit, EBITDA vs interest rate and EBITDA vs working capital volatility. If useful, run a quick sensitivity analysis grid to test the story’s break points.

A tiny numerical walk-through

Consider a business with 100 million revenue, 40 percent gross margin, and 15 million opex. EBITDA is 25 million. Maintenance capex is 5 million, growth capex 3 million, and working capital uses 2 million on growth. At a 25 percent tax on EBIT and 5.3 million cash interest on 65 million average debt, levered free cash flow is 6.7 million. Net leverage sits around 2.6x and interest coverage depends on your EBITDA definition and lease treatment. This is enough to test feasibility and isolate the drivers that matter.

Accounting normalizations that move outcomes

Revenue recognition: Watch bill-and-hold, multi-element arrangements, or term license vs SaaS. If growth rests on cut-off or backlog release, haircut it in downside.
Adjusted EBITDA: Keep separate toggles for non-recurring items, policy adjustments, and run-rate cost saves. Apply a realization factor unless contracts or executed steps support timing. Treat pro forma combinations or carve-out dis-synergies explicitly.
Stock-based comp: Count it for valuation unless IC says otherwise. Track GAAP vs cash.
Leases: Align EBITDA to include lease expense for unadjusted comps and keep a lease-adjusted view for credit.
Purchase accounting: Exclude step-up amortization from EBITDA but keep it in EBIT if peers do the same. Match lender definitions for credit metrics.

Transaction mechanics to test early

Build a simple sources and uses to test capital needs: purchase price, cash to seller, rollover equity, transaction and financing fees, and any assumed or refinanced debt. Sanity-check fee rates. Amortize financing fees in a simple way to approximate cash interest and label the approximation. This step avoids IOI math that collapses under a realistic fee load.

Focused information requests and kill tests

Send a one-page ask that replaces assumptions with files. Prioritize revenue bridges and cohort data, supplier concentration and pass-through mechanics, headcount and comp grids, AR and inventory agings, maintenance vs growth capex, lease schedules, debt agreements, and change-of-control or MFN terms. For reliability, request materials used in the last quality-of-earnings work; see a quick overview of what often matters most in a quality of earnings report.

Revenue quality: If top-5 concentration exceeds your threshold without long-term contracts, only proceed with credible mitigation.
Unit economics: If contribution margin per unit is negative absent heroic allocations and CAC payback exceeds your hold period, step back unless it is a turnaround.
Working capital: If the model needs DSO compression without enforceable terms or system changes, set it to zero in base.
Capex intensity: If coverage only works by holding maintenance below depreciation for years, assume underinvestment and probe asset condition and regulation.
Lease and debt load: If lease-adjusted leverage or fixed charges miss your box in downside, do not rely on cures.
Carve-out feasibility: If stand-up costs, TSA duration, and ERP separation lack scope and dates, add a real buffer or walk.
Regulated exposure: In healthcare, fintech, and defense, do not underwrite approvals you cannot verify before signing.

Reporting nuances and modeling discipline

Lease accounting capitalizes operating leases and lifts EBITDA, so present both unadjusted and lease-adjusted metrics. Keep non-GAAP measures consistent across scenarios and aligned to lender definitions when available. With IFRS changes to subtotals, align any presented operating income with your EBITDA logic. In carve-outs, treat allocations skeptically and model the stand-alone P&L.

Keep formulas simple and auditable. Do not iterate debt unless necessary. Color code: blue inputs, black formulas, green links within the sheet. Do not link across tabs. Add error checks like sources equal uses, TTM reconciliations, EBITDA bridge consistency, and sign controls. Save snapshots of base, upside, and downside. A partner should be able to change three cells and see the impact without breaking the file.

Decision outputs ICs can grasp in one page

Deal overview: Target, sector, geography, revenue scale, growth, and margins.
Thesis: How the business wins, what drives cash, and where you have edge.
Key outputs: EBITDA, unlevered free cash flow, leverage, coverage, and EV or EBITDA range.
Sensitivities: What breaks and by how much.
Gaps and asks: Data you need within a week.
Recommendation: Proceed, hold for data, or pass.

Sector notes that shape your base case

Software: ARR quality rules. Model gross and net retention, cohorts, and logo churn. Treat services as a separate, lower-margin pool.
Industrials: Tie margin to input prices and throughput. Working capital swings matter and seasonality is real.
Healthcare services: Payer mix, rate updates, and labor drive outcomes. Model wage inflation and staffing normalization with care. Licensing risk is binary; verify.
Consumer: Price elasticity and mix shape margin. Track traffic, conversion, and ticket. Inventory quality and shrink bite cash.
Business services: Utilization, rates, and productivity set the path. WIP financing can be the pinch point.

Credit-first variant and certainty requests

When credit is the lens, downside and covenants take priority. Model minimum liquidity, revolver usage, springing tests, and a credible stress case. Track mandatory amortization and excess cash flow sweeps. For unitranche, include PIK toggles and cash-pay thresholds. Compute covenant headroom at close and under stress. For ABL, include borrowing base availability and ineligibles and apply concentration haircuts. Ask for the covenant EBITDA definition and historical compliance certificates, 24 months of monthly revenue, gross margin, and EBITDA, AR and inventory agings, top customer and supplier exposures and any past dues, seasonality curves and minimum liquidity history, lease schedules, and service obligations that behave like debt.

Edge cases and a pragmatic implementation path

Apply extra skepticism to roll-ups with pending deals, heavy carve-outs with vague systems separation, policy changes mid-forecast, FX or inflation pass-through without documented indexation, backlog spikes, and quarter-end stuffing. For each, haircut, cap, or exclude until the data proves out.

In Week 0, complete the screen and Q&A. If advancing, schedule management and flag early issues to tax, accounting, and legal. In Weeks 1 to 2, update the one-tab with incoming data. If greenlit, port assumptions into a standard three-statement model or credit model while preserving the one-tab as the speed file. In Weeks 2 to 4, align with financing sources on definitions and covenants. Pre-IOI or LOI, export the one-page summary with updated metrics and risks. Use the one-tab to run quick sensitivities while negotiating.

Closeout hygiene and what good looks like

Archive the work: index, versions, Q&A, users, and immutable audit logs. Create a hash of the final package. Apply your retention schedule. When the vendor relationship ends, obtain deletion plus a destruction certificate. Legal holds override deletion.

A strong one-tab is auditable, comparable across deals, and focused on cash and coverage. It elevates a short list of decisive uncertainties and frames them in numbers the team can debate. Most of all, it lets you change a handful of assumptions in real time and see the range of outcomes. That is how you keep speed without sacrificing judgment.

Fresh angle: a 10-minute smell test

Before you build, apply three quick rules of thumb to triage effort. First, if top-5 customer concentration is above 40 percent without firm terms, treat the base case as downside. Second, if maintenance capex is below 50 percent of depreciation for three years, assume hidden reinvestment. Third, if DSO exceeds 75 days alongside double-digit growth, model a working capital drag. These checks take minutes and prevent false certainty later.

Key Takeaway

A one-tab CIM screening model turns ambition into auditable math. By standardizing inputs, isolating the two or three drivers that move cash, and making covenant and valuation logic transparent, you can move fast without being sold a story. Build once, decide quickly, and carry the same sheet forward as your single source of truth.