What acquisition price, sources and uses, and sponsor economics create a credible transaction case?
Model profile
Valuation, LBO and Merger Suite
Value a buyer and a target, test what a financial sponsor could pay for either, and see what the acquisition does to the buyer's earnings, balance sheet and credit. Each company gets its own adjusted history, scenario-driven projection, DCF and buy-out; the combination brings them together with your offer, financing, synergies and purchase accounting.
Decision scope
Questions this model helps you examine
How do operating projections, cash generation, and debt paydown support the proposed capital structure?
How do exit timing, exit multiples, and downside cases affect sponsor returns and value per share?
Model capabilities
What this model includes
The profile below is generated from the same catalogue and workspace definitions used by the application.
- Reported years adjusted for non-recurring items, with margins, growth and credit statistics
- Six-year projections from growth, margin, reinvestment and working-capital drivers, with named scenarios
- Three balanced statements, a revolver held to minimum cash and interest on average balances solved each year
- Trading statistics, and a DCF by exit multiple and perpetuity growth with value grids
- A sponsor buy-out of each company: sources and uses, goodwill, debt paydown, IRR, MOIC and the highest price at a target return
- The acquisition: cash and stock mix, new debt sized to balance, goodwill, synergies, lost revenue and integration costs
- Pro forma statements, EPS accretion, synergies needed to break even, credit statistics and contribution analysis
- Accretion grids by price and stock mix, an offer premium analysis and buy-out return grids, with 20 model checks
- A prefilled Excel template per company: fill it in, upload it and review every change before it is applied
- AI reading of up to six years of reports, interim results, debt facilities, shares, options, owners and consensus, and of the deal documents, on your own AI key
- Web search for market data on any supported AI provider, each figure with its date and source and applied only when you tick it, and AI commentary on each run
Build the case
Inputs and workspaces
- Deal termsOffer, closing date, consideration, funding, debt tranches, purchase accounting, synergies and analytics.
- Acquirer assumptionsMarket data, tax and payout, interim results, existing financing and maturities, DCF and buy-out tranches.
- Acquirer statementsReported years and balance sheets, projection drivers, consensus, owners, options and scenarios.
- Target assumptionsMarket data, tax and payout, interim results, existing financing and maturities, DCF and buy-out tranches.
- Target statementsReported years and balance sheets, projection drivers, consensus, owners, options and scenarios.
Review the result
Outputs and analysis
- EPS accretion, year 1Pro forma vs standalone
- EPS accretion, year 2Pro forma vs standalone
- Cash EPS accretion, year 1Excludes deal amortization
- Synergies to break even, year 1Additional pre-tax
- Offer premiumTo current price
- Enterprise valueMillions
- EV / LTM EBITDAAt the offer
- Target holders' ownershipPro forma diluted
- 4 additional metrics in the workspace
- Accretion and pro forma statementsDetailed schedules
- Transaction, valuation and buy-outsDetailed schedules
Designed for review
Who this model is for
- Private-equity sponsors and corporate development teams
- Investment and financial analysts
- Transaction advisers
- Investment committees and lenders
Governed evidence
The review trail stays with the result.
Each completed calculation preserves the model version, saved inputs, reporting-currency snapshot, immutable run, and result fingerprint used for its reports.
- Version-controlled calculation logic
- Saved assumptions and scenarios
- Immutable calculation runs
- Reporting context preserved in exports
Ready to explore the case?