FM
Sign InGet Started
📊

Private Equity & M&A

LBO, merger models, deal structuring, and transaction analysis

5 groups48 models

LBO Models

Leveraged buyout, debt schedules, and returns analysis

12 models in this group

Standard LBO Model

advanced

Complete leveraged buyout with debt schedules and returns

lboleveraged buyoutprivate equity+1

Paper LBO

beginner

Quick back-of-envelope LBO for screening

paper lboquick lboscreening

Debt Schedule Model

advanced

Detailed debt tranches, covenants, and paydown

debt scheduletranchescovenants+1

LBO Returns Analysis

intermediate

IRR, MOIC, and value creation bridge

irrmoicreturns+1

Sources & Uses

intermediate

Transaction sources and uses of funds

sources usestransaction fundingcapital structure

Ability to Pay Analysis

intermediate

Maximum price a financial sponsor can pay

ability to payatpmaximum price

Value Creation Analysis

intermediate

EBITDA growth, margin expansion, multiple expansion

value creationebitda growthmultiple expansion

Add-On Acquisition Model

advanced

Bolt-on acquisition returns and synergies

add-onbolt-ontuck-in+1

Roll-Up Strategy Model

expert

Multi-acquisition consolidation strategy

roll-upconsolidationplatform strategy

Dividend Recapitalization

intermediate

Leveraged dividend recap returns analysis

dividend recapdiv recapsponsor dividend

Management Rollover Model

advanced

Management equity participation and MIP

management rollovermipsweet equity

Co-Investment Model

advanced

LP co-investment and consortium deal structure

co-investconsortiumclub deal

Merger Models

Merger accretion/dilution and pro forma analysis

10 models in this group

Merger Model

advanced

Complete merger model with accretion/dilution

merger modelaccretion dilutionm&a
📊 8 sections📐 5 assumptions

Accretion/Dilution Analysis

intermediate

EPS and cash flow accretion/dilution

accretiondilutioneps impact

Pro Forma Financials

advanced

Combined company pro forma financial statements

pro formacombined companypost-merger

Synergies Model

intermediate

Cost and revenue synergy quantification

synergiescost savingsrevenue synergies

Contribution Analysis

intermediate

Relative contribution to combined entity

contributionrelative valueexchange ratio

Exchange Ratio Analysis

intermediate

Stock-for-stock exchange ratio calculation

exchange ratiostock dealfixed vs floating

Premium Analysis

intermediate

Acquisition premium benchmarking and analysis

premiumcontrol premiumpremium paid

Mix of Consideration

intermediate

Cash vs stock consideration optimization

mix considerationcash vs stockdeal structure

AVP Model (At Various Prices)

intermediate

Accretion/dilution at various offer prices

avpvarious pricesoffer price sensitivity

Quick Merger Model

beginner

Simplified merger for deal screening

quick mergerscreeningsimple merger

Deal Structuring

Purchase price allocation, earnouts, and terms

8 models in this group

Purchase Price Allocation

advanced

Asset allocation and goodwill calculation

ppagoodwillpurchase price allocation

Earnout Model

intermediate

Contingent consideration and earnout valuation

earnoutcontingent considerationmilestone

Escrow & Holdback

beginner

Escrow release and holdback analysis

escrowholdbackindemnification

NWC Adjustment

intermediate

Working capital target and adjustment mechanism

nwcworking capital pegpurchase adjustment

Tax Structure Analysis

advanced

Asset vs stock deal tax implications

tax structureasset dealstock deal+1

Deal Financing Model

intermediate

Acquisition financing structure and sources

deal financingacquisition financingbridge loan

Staple Financing

advanced

Sell-side financing package analysis

staple financingsell-side financing

Collar Structure

advanced

Stock deal collar and pricing mechanism

collarprice protectionwalkaway

Due Diligence

Quality of earnings, synergies, and integration

9 models in this group

Quality of Earnings

advanced

EBITDA adjustments and normalized earnings

quality of earningsqofeebitda adjustments

EBITDA Normalization

intermediate

Pro forma EBITDA with add-backs and adjustments

normalizationadd-backsadjusted ebitda

Synergy Achievability

intermediate

Bottom-up synergy validation and risk assessment

synergy achievabilitysynergy riskintegration

Commercial Due Diligence

intermediate

Market, customer, and competitive analysis

commercial ddmarket analysiscustomer analysis

Operational Due Diligence

intermediate

Operations, supply chain, and efficiency review

operational ddoperations reviewefficiency

Integration Plan Model

intermediate

Day 1 readiness and 100-day integration plan

integrationday 1100-day plan

Carve-Out Analysis

advanced

Standalone cost and separation analysis

carve-outstandalone costsdis-synergies

Customer Concentration

beginner

Customer risk and revenue concentration analysis

customer concentrationcustomer risktop 10

CapEx Due Diligence

intermediate

Maintenance vs growth CapEx separation

capex ddmaintenance capexgrowth capex

Exit Planning

Exit multiples, timeline, and return scenarios

9 models in this group

Exit Analysis Model

intermediate

Exit timing, multiples, and return scenarios

exit analysisexit timingexit multiple

IPO Readiness Assessment

intermediate

Public market readiness checklist and timeline

ipo readinesspublic marketlisting

Sale Process Model

intermediate

M&A sale process timeline and milestones

sale processauctionbuyer list

Secondary Buyout Model

advanced

Sponsor-to-sponsor transaction returns

secondary buyoutsbosponsor to sponsor

Strategic vs Financial Exit

intermediate

Comparing strategic and financial buyer outcomes

strategic buyerfinancial buyerexit comparison

Partial Exit Model

intermediate

Partial sale and continuation scenarios

partial exitpartial salecontinuation

Exit Waterfall

advanced

Proceeds distribution by investor class

exit waterfalldistributioninvestor returns

Value Creation Bridge

intermediate

Entry to exit value creation attribution

value creation bridgevalue attributionentry to exit

Holding Period Analysis

intermediate

Optimal exit timing based on returns

holding periodexit timingoptimal exit

Ready to use PE & M&A models?

Access 48 PE & M&A models. Start building in the app.

Get Started