Investment Banking Analyst Track · Live Deal Execution
Live Deal Execution
Live M&A / accretion-dilution merger model
The merger model combines two operating models and analyzes the pro-forma impact of a deal on the acquirer's earnings per share. The build: combine the acquirer's and target's income statements (adjusted for purchase-accounting items, the fair-value step-up of assets and the amortization of identifiable intangibles), add synergies (phased in over time, net of integration costs), account for the financing (interest on new debt for a cash deal, or new shares for a stock deal), and compute pro-forma EPS versus the acquirer's standalone EPS to determine accretion or dilution. The model must also show the sources & uses of funds, the goodwill and intangible creation from the purchase price, and, in a full version, the balance-sheet impact (combined balance sheet, goodwill, financing). The live version is more rigorous than the interview version: it includes purchase-accounting amortization, a phased synergy ramp, and a sensitivity on financing mix and purchase price. This is the technical centerpiece of any M&A engagement and the model most closely associated with the analyst's craft.
Why this matters
The merger model is the defining deliverable of M&A work and a skill that transfers directly to private equity and corporate development, the most common IB exits.
Building the combined pro forma model
A live accretion/dilution model links the acquirer's and target's full standalone operating models into a combined pro forma entity, not just the simplified interview version, incorporating the actual financing structure (specific debt terms, exact share issuance if stock is used), a real purchase price allocation once available, and detailed synergy phase-in assumptions rather than a single flat synergy number. The build typically starts from each company's own three-statement model, then layers in deal-specific adjustments (new interest expense, incremental D&A from the step-up, foregone interest income on cash used) to arrive at pro forma combined figures.
Because this model is used to actually advise on deal structure and financing choices, it's typically built to flex easily across multiple scenarios, different consideration mixes, different synergy assumptions, so bankers can show a client the accretion/dilution outcome under several structuring alternatives side by side.
Modeling synergy phase-in realistically
Unlike the simplified interview version, a live model typically phases synergies in gradually over several years rather than assuming they're fully realized from day one, cost synergies might ramp to full run-rate over 12-24 months as integration actually happens, while revenue synergies (already treated with more skepticism, per the synergies lesson) are often modeled even more conservatively or excluded from the base case entirely. This phase-in schedule directly affects the near-term accretion/dilution picture, which is often what boards and public markets focus on most.
A credible synergy phase-in schedule is typically built with input from the business teams actually responsible for executing the integration, not assumed unilaterally by the deal team, since an unrealistic phase-in schedule undermines the credibility of the entire analysis if questioned by a skeptical board member or analyst.
Presenting the analysis to a board or client
The final output for a board or client typically isn't a single accretion/dilution number but a clear before-and-after comparison across several years, alongside the key sensitivities (what happens to the outcome if synergies are only half-realized, or if the financing mix shifts), giving decision-makers a clear view of both the base case and the downside risk to that base case. Being able to walk a client through exactly which assumptions are driving the result, and to speak confidently to what happens if a specific assumption proves wrong, is what turns the model from a spreadsheet exercise into something a board can actually use to make a decision.
This presentation skill connects directly to the pitchbook and formatting lessons: even a rigorously built model has limited value if it can't be communicated clearly and defensibly to a non-technical audience in the room.
Worked example
Acquirer (100M shares, $2.00 EPS) buys Target for $500M, funded 50% cash (debt at 6%) and 50% stock. The model: combine the two income statements, add $10M of synergies phasing in over two years, subtract $30M of incremental intangible amortization from the PPA, subtract after-tax interest on the new $250M debt, and add the ~6.25M new shares (at a $40 acquirer price). Pro-forma EPS emerges at, say, $2.15, accretive, and the model shows a sensitivity grid varying the financing mix and synergies to show at what point the deal turns dilutive.
Practice
Build a full merger model for a hypothetical or real deal, including PPA, synergies, and a financing-mix sensitivity, and be able to explain every line.
Strong vs. weak answers
Weak: a naive 'add the two companies' model missing PPA, synergies, and financing. Strong: a complete merger model with purchase accounting, phased synergies, financing impact, and a clear sensitivity presentation.
Common failure modes
- Ignoring purchase-accounting amortization.
- Forgetting the financing cost or the new shares.
- Not phasing synergies or netting integration costs.
Resources
- BIWS / Wall Street Prep, M&A modeling course — The full merger-model build, including PPA, synergies, financing, and sensitivity.
- Rosenbaum & Pearl, Investment Banking — The merger consequences analysis and accretion/dilution methodology.
Expert signals
The analyst who stands out handles the PPA and synergy phase-in correctly, presents the accretion/dilution sensitivity cleanly, and separates accounting accretion from economic value creation.
Confidence
high
Sources
- BIWS/Wall Street Prep
- Rosenbaum & Pearl (Wiley)
Live LBO model (sponsor coverage / sell-side)
The live LBO model is the paper LBO realized as a full, integrated spreadsheet, and it is the centerpiece of sponsor coverage, sell-side assignments to PE buyers, and leveraged-finance work. The build: sources & uses (purchase price, fees, financing structure, equity check), a full operating model of the target, a debt schedule with the layered capital structure (revolver, term loans, bonds, mezzanine), a cash sweep (excess cash flow pays down debt), and the exit and returns (exit EBITDA, exit multiple, equity value, MOIC, IRR to the sponsor). The key mechanics beyond the paper LBO: the cash sweep and mandatory vs optional debt repayment, the interest calculation across debt layers, the fee and OID (original issue discount) treatment, and the returns waterfall. The analyst must also build in the sponsor's perspective, the returns sensitivity to purchase price, leverage, exit multiple, and hold period. This model is the direct bridge to the private-equity job, and fluency here is what makes an analyst attractive in on-cycle PE recruiting.
Why this matters
The LBO model is the most transferable and highest-value modeling skill an IB analyst develops, and it is the exact skill tested in PE interviews and used daily in the buy-side job.
Building an LBO in a sponsor-coverage or sell-side context
A live LBO model is built for one of two typical purposes: helping a private equity sponsor client evaluate a potential acquisition (sponsor coverage), or, on a sell-side process, building an LBO to understand what a financial sponsor could realistically pay for the target being sold, used to gauge the likely competitiveness of financial buyers against strategic buyers in an auction. In either case, the model needs to reflect realistic, defensible financing assumptions (current leverage market conditions, real debt pricing) rather than the simplified assumptions used in an interview paper LBO.
On a sell-side process specifically, understanding what a sponsor could plausibly pay, bounded by debt capacity and a sponsor's required return, helps the advisory team calibrate expectations for the overall process and identify where financial buyers are likely to land relative to strategic bidders.
Building a full, multi-tranche debt schedule
Unlike a simplified paper LBO, a live model typically includes a full debt schedule across multiple tranches (revolver, term loan, potentially subordinated debt), each with its own interest rate, amortization schedule, and paydown priority (a cash flow waterfall determining which tranche gets paid down first with excess free cash flow). This schedule needs to correctly handle a revolver that draws down in periods of cash shortfall and repays in periods of surplus, and mandatory versus optional (cash sweep) amortization for the term loan.
Getting this schedule right, and correctly linking it to the rest of the model's circularity (interest expense depending on debt balances, which depend on cash flow, which depends on interest expense), is one of the more technically demanding pieces of a full LBO build, and it's where the circularity-handling techniques from the three-statement modeling lesson become directly essential rather than optional.
Returns output and sensitivity
The final output of a live LBO model presents the sponsor's projected returns (IRR and MOIC) under the base case, alongside sensitivity tables flexing the key value drivers, entry multiple, exit multiple, leverage level, EBITDA growth, so a client or internal team can see how sensitive the return profile is to each assumption. This output is what actually drives the investment decision (or, on a sell-side process, the team's read on likely sponsor appetite), which is why it needs to be built on defensible, current market assumptions rather than aggressive or generic ones.
A well-built live LBO model also typically includes a downside case explicitly, confirming the deal still generates an acceptable (if reduced) return, or at minimum avoids a covenant breach, under a reasonably adverse scenario, mirroring the debt-capacity stress-testing covered in the interview-level leverage lesson, but built with real numbers for a real decision.
Worked example
A sponsor buys a company for $600M (7× EBITDA), funded with $400M of debt (a $350M term loan at SOFR+3%, a $50M revolver) and $200M of equity plus $20M of fees. The model sweeps annual free cash flow to pay down the term loan, computes interest on each layer, and at exit in year 5 applies an 8× multiple to grown EBITDA of $110M → $880M EV, less remaining debt of ~$250M → $630M equity → 3.2× MOIC and ~26% IRR on the $200M check. A sensitivity grid shows returns across entry/exit multiples and leverage levels.
Practice
Build a full LBO from scratch for a real company, with a layered debt schedule and cash sweep, and run a full returns sensitivity.
Strong vs. weak answers
Weak: a paper-LBO-level model missing the debt schedule and cash sweep. Strong: a full integrated LBO with a layered debt schedule, cash sweep, fee treatment, and a returns sensitivity.
Common failure modes
- No cash sweep or incorrect debt paydown mechanics.
- Mishandling the layered capital structure and interest.
- Omitting fees and OID, which skew the equity check and returns.
Resources
- BIWS / Wall Street Prep, LBO modeling course — The full LBO build with the debt schedule, cash sweep, and returns sensitivity.
- Rosenbaum & Pearl, Investment Banking — The LBO chapter's treatment of the financing structure and return drivers.
Expert signals
The analyst who stands out builds a clean LBO with a correct cash sweep and layered debt, and can speak to the returns sensitivity like a PE associate.
Confidence
high
Sources
- BIWS/Wall Street Prep
- Rosenbaum & Pearl (Wiley)
Due diligence: data rooms, VDRs, and document requests
Due diligence is the confirmatory work of a live deal, the process of verifying everything the seller has represented by examining documents, data, and management answers. The analyst's role is heavy and concrete: help build and manage the virtual data room (VDR, a secure online repository of the company's documents), populate it with the hundreds of documents buyers will request (financials, contracts, customer data, legal, HR, IP), respond to or route document requests, track which items are outstanding, and support the Q&A log. The skill is process discipline: maintaining the document index, ensuring nothing sensitive leaks, versioning documents, and keeping the VDR organized so buyers' counsel and the deal team can find what they need. Analysts also build the 'data pack', the standard set of schedules (revenue by customer/product, employee lists, contract summaries) that underpin the CIM's claims. The work is unglamorous but it is the operational backbone of a deal, and an analyst who runs a clean VDR is trusted with more responsibility.
Why this matters
Due diligence is where deals are actually made or broken, and running a clean, organized data room is a core analyst responsibility that tests exactly the process discipline the job rewards.
Data rooms and VDRs
A virtual data room (VDR) is a secure, access-controlled online repository where a seller uploads the documents a buyer needs to review during due diligence, financial statements, contracts, corporate records, HR and legal documents, organized into a structured folder index. Analysts are typically heavily involved in building and organizing the data room on a sell-side process (working with the client to gather and upload documents in a logical structure) and in navigating it efficiently on a buy-side process (finding specific documents quickly to answer diligence questions under time pressure).
Access to the data room is usually granted in stages as a process progresses, a smaller group of serious, later-round bidders often gets deeper access than the initial broad outreach group, and tracking who has access to what, and when, is itself an operationally important part of managing a competitive process fairly.
Managing document requests
As buyers review the data room, they submit follow-up document requests and questions, sometimes hundreds over the course of a process, which need to be logged, routed to the right person (client management, legal counsel, the deal team) for a response, and tracked to closure. Analysts frequently own this request log directly: a single missed or badly delayed request can slow diligence, frustrate a buyer, or in the worst case cause a bidder to lose confidence in the process.
Organizing and triaging these requests efficiently, grouping similar questions, flagging which need client input versus which the deal team can answer directly, prioritizing anything time-sensitive, is exactly the kind of high-volume, detail-intensive workstream management that becomes a core analyst skill on any live deal.
Spotting and escalating diligence issues
Part of managing a diligence process well is recognizing when a document request or a buyer's specific line of questioning signals a real concern (a legal dispute, a customer concentration risk, an accounting irregularity) rather than routine due diligence, and escalating that promptly to senior deal team members rather than treating every request identically. A diligence issue caught and addressed early, with a prepared, credible response, is far less damaging to a deal than one that surfaces unexpectedly late in a process, closer to signing.
This pattern-recognition skill develops with deal exposure over time, but the underlying habit worth building early is simply flagging anything that seems unusual or repeatedly asked-about up the chain rather than assuming it's not significant, a junior analyst's job here is to surface, not necessarily to independently judge, whether something is a real red flag.
Worked example
On a sell-side process, the analyst sets up the VDR, uploads a standard document set (three years of financials, top customer contracts, employee census, cap table, tax filings), assigns permissions by bidder stage, logs every document request, and maintains the 'open items' tracker that the deal team reviews weekly. When a bidder asks for a customer-concentration breakdown, the analyst pulls the data, formats it, clears it with the company, and uploads it, and notes in the tracker that it's been provided to all bidders equally (a fairness requirement).
Practice
If possible, assist on a live process or a case competition that involves a data room; otherwise, study a VDR's folder taxonomy and the standard document checklist for an M&A sell-side.
Strong vs. weak answers
Weak: a disorganized VDR with no index and untracked requests. Strong: a clean, permissioned, versioned data room with a live request tracker and equal-disclosure discipline.
Common failure modes
- Providing information to one bidder but not others (a fairness/regulatory issue).
- Losing track of outstanding requests.
- Uploading uncleaned or unversioned documents that confuse reviewers.
Resources
- Intralinks / Datasite / Merrill, VDR platforms — The VDR platforms used in live deals; their documentation and best-practice guides cover the mechanics of running a data room.
- Rosenbaum & Pearl, Investment Banking — Context on the sell-side process and where due diligence sits in the deal timeline.
Expert signals
The analyst who stands out runs a data room so organized that a reviewer can find any document in seconds, and maintains perfect equal-disclosure discipline.
Confidence
high
Sources
- VDR platform docs (Intralinks/Datasite)
- practitioner norms
CIM and management presentations
The confidential information memorandum (CIM) is the detailed document, often 50–100+ pages, that tells the company's full story to buyers who have signed NDAs: the business overview, market and competitive position, growth strategy, financials (historical and projected), management, and the investment thesis. The management presentation is the in-person (or video) pitch the company's management gives to prospective buyers, supported by a slide deck the bankers help build. The analyst's role is substantial: drafting sections of the CIM, building the financial exhibits (historical trends, projections, unit economics), ensuring every number in the document ties to the underlying model and data, and building the management presentation. The craft is translating the company's operations into a coherent, credible investment story, backed by airtight, footnoted numbers. The CIM is the single most important document in the process, it is how buyers form their initial valuation, and its credibility rests entirely on the accuracy and coherence of its numbers.
Why this matters
The CIM is the centerpiece of a sell-side process and the analyst's most visible writing product; building it well is a core craft skill and a significant part of the first two years.
CIM structure and content
The Confidential Information Memorandum is the detailed marketing document shared with buyers who've signed an NDA, going substantially deeper than the teaser: full business description, historical and projected financials, management team overview, industry and competitive positioning, and investment highlights, typically 30-80+ pages, depending on the business's complexity. Building a CIM is often one of the largest single deliverables an analyst works on early in a process, requiring synthesizing information from management, financial data, and independent research into a cohesive, persuasive, and accurate document.
Unlike a teaser, a CIM identifies the company by name and includes real, detailed financials, meaning its accuracy is scrutinized far more heavily by sophisticated buyers, and any error or inconsistency discovered here damages the deal's credibility more seriously than an equivalent mistake in an earlier-stage document.
Management presentations
Later in a process, serious buyers typically attend a management presentation, a meeting (or series of meetings) where the target's management team presents the business directly and takes questions, giving buyers a chance to assess management quality and probe details beyond what's in the CIM. Analysts support this heavily behind the scenes: building the presentation materials, coaching or prepping management on likely questions alongside senior bankers, and often attending to take notes on buyer questions and reactions for the deal team's internal debrief afterward.
The quality of a management presentation can meaningfully influence a buyer's final bid, a confident, well-prepared management team that handles tough questions credibly builds real buyer conviction, which is part of why the deal team invests real preparation time coaching management ahead of these sessions rather than treating them as a formality.
Keeping the CIM consistent with everything else
Every figure in the CIM needs to tie out exactly to the teaser, the data room financials, and whatever management ultimately presents, any inconsistency discovered by a buyer across these documents raises immediate, damaging questions about the seller's credibility and the reliability of the numbers generally. As a live process evolves (updated financials, revised projections), keeping every downstream document synchronized with the latest, correct figures is a genuine and recurring operational challenge, and it's a responsibility analysts typically own closely.
This consistency requirement is the CIM-specific version of the broader error-checking and attention-to-detail discipline covered elsewhere, the stakes are simply higher here, since a CIM inconsistency is discovered by a buyer actively trying to find reasons to negotiate the price down, not by an internal reviewer trying to help.
Worked example
For a company with a strong installed base and a services growth story, the analyst builds the CIM's financial section: a 5-year revenue bridge (installed base growth × attach rate × pricing), margin trend exhibits, and a normalized-EBITDA schedule that adds back one-time items with footnotes. Every exhibit ties to the model. The management presentation distills this into 30 slides that management will walk through, with the analyst ensuring the numbers match the CIM exactly.
Practice
Take a public company and write a five-page CIM-style summary (business, market, growth, financials, thesis), with every number tied to the 10-K.
Strong vs. weak answers
Weak: a CIM with narrative disconnected from the numbers, or exhibits that don't tie to the model. Strong: a coherent story where every claim is backed by a footnoted number that traces to the underlying data.
Common failure modes
- Numbers in the CIM that don't reconcile to the model.
- A story that overclaims relative to the data (a credibility killer).
- Inconsistent figures between the CIM and the management presentation.
Resources
- Rosenbaum & Pearl, Investment Banking — The CIM's role in the process and the financial exhibits it contains.
- Mergers & Inquisitions, CIM guide — Practical structure of a CIM and how analysts build the financial section.
Expert signals
The analyst who stands out produces a CIM where the narrative and numbers are one coherent story, every figure ties to the model, and the investment thesis is credible and specific.
Confidence
high
Sources
- Rosenbaum & Pearl (Wiley)
- M&I
- practitioner norms
Deal documents: engagement letters, NDAs, purchase agreements
A live deal runs on a stack of legal documents, and while lawyers draft them, the analyst must understand what each one does and where the deal's economics and process terms live. The key documents: the engagement letter (the contract between the bank and its client, defining the scope of the mandate and the fee, often a success fee, a retainer, or a mix); the confidentiality agreement / NDA (what each party can and cannot disclose); the letter of intent / term sheet (the preliminary, mostly non-binding deal terms); the definitive purchase agreement (the binding contract, for a stock or asset purchase, containing price, representations and warranties, indemnities, and closing conditions); and the ancillary documents (escrow, employment agreements for management). The analyst's involvement is typically in the financial terms, the purchase-price mechanics (closing adjustments, earnouts, escrows), the working-capital adjustment, and the fee structure in the engagement letter. Understanding these documents matters because the deal's value is defined in them, and the analyst who can read them is more useful than one who only models.
Why this matters
The purchase agreement and engagement letter are where the deal's economics are actually set; understanding them separates an analyst who executes deals from one who only builds models.
Engagement letters
An engagement letter is the contract between the bank and its client, formalizing the advisory relationship at the very start of a mandate, scope of work, fee structure (typically a retainer plus a success fee contingent on closing, sometimes with a tiered structure), and terms like exclusivity and duration. While primarily a legal and business-development document handled by senior bankers, analysts should understand its structure since it defines exactly what the deal team is being paid to deliver, and the fee mechanics behind it explain why the entire team is oriented so heavily around actually reaching a closed transaction.
Understanding the engagement letter also clarifies deal economics more broadly, since success fees are typically the largest component, a deal that doesn't close, even after substantial work, generates far less revenue for the bank than one that does, which is part of the underlying pressure behind execution timelines.
NDAs (non-disclosure agreements)
A non-disclosure agreement is signed by any potential buyer before receiving confidential information (the CIM, data room access), legally binding them not to disclose or misuse the target's confidential information, and typically including standstill provisions restricting the buyer from taking certain actions (like approaching the company directly outside the process, or acquiring stock in a public target) for a defined period. Analysts are often responsible for tracking which buyers have signed NDAs and coordinating with legal counsel on any requested modifications to standard NDA language.
NDA execution is a genuine process gate: a buyer generally can't receive the CIM or data room access until their NDA is fully signed, so delays here directly delay a specific buyer's ability to participate meaningfully in the process, another reason tracking and follow-up discipline matters operationally, not just as paperwork.
Purchase agreements
The purchase agreement (a stock purchase agreement or asset purchase agreement, depending on deal structure) is the definitive legal document governing the actual transaction, price, structure, representations and warranties, covenants, closing conditions, and indemnification terms, negotiated primarily by legal counsel on both sides but with real, active banker involvement on the business and commercial terms (price adjustments, earnouts, key conditions) throughout the negotiation.
Analysts typically aren't drafting legal language themselves, but are expected to understand the document's structure and key business terms well enough to support the deal team through negotiation, tracking open issues, summarizing changes between drafts for internal discussion, and understanding how specific terms (like a working capital adjustment mechanism) connect back to the financial modeling work done earlier in the process.
Worked example
A purchase agreement might specify: price of $500M in cash, subject to a working-capital adjustment (a target level, with a true-up after closing), $25M in escrow for indemnification claims, and a $15M earnout tied to hitting a revenue milestone. The analyst builds the funds-flow that shows exactly how much cash reaches the seller at closing versus over time, and models the earnout scenarios. Reading the engagement letter, the analyst confirms the fee is a 1.5% success fee on enterprise value, paid at closing.
Practice
Read a real merger agreement's purchase-price section and model the actual cash to the seller (price, adjustments, escrow, earnout) under two scenarios.
Strong vs. weak answers
Weak: no familiarity with the deal documents and their economic terms. Strong: can read a purchase agreement's price mechanics (adjustments, escrows, earnouts) and model the actual cash flows of a deal.
Common failure modes
- Treating the headline price as the actual cash the seller receives (ignoring adjustments/escrows/earnouts).
- Not understanding the engagement-letter fee structure.
- Confusing the LOI (mostly non-binding) with the definitive agreement (binding).
Resources
- SEC EDGAR, merger agreements (8-K / proxies) — Read real purchase agreements and their price mechanics, escrows, and earnouts.
- Rosenbaum & Pearl, Investment Banking — Context on the deal documents and where the economics live.
Expert signals
The analyst who stands out understands the funds flow (who gets what, when) and can explain how the working-capital adjustment and escrow affect the seller's real proceeds.
Confidence
high
Sources
- SEC EDGAR (merger agreements)
- Rosenbaum & Pearl (Wiley)
Pathweys