Acquisition finance

Acquisition pro forma builder

Review combined earnings, deal timing, and funding. Show historical results, adjustments, and assumed savings separately.

Illustrative example · fictional figures

Acquisition overview

Full year · both businesses for 12 months · USD millions

Combined revenue$40.00MFull-year combined view
Modeled EBITDA$8.55MIncludes $0.30M adjustments and $0.25M synergies
Target enterprise value$16.10M7.0× adjusted target EBITDA
Equity funding required$6.50MExisting buyer cash retained

EBITDA bridge

Historical earnings → adjustments → assumed savings · USD millions

Funding at close

Cash-free, debt-free purchase; existing buyer cash retained.

Assumptions

Money in USD millions: 0.3 = $300,000. Results update as you edit.

Historical annual results

Buyer

Target

Deal and financing
Earnings adjustments and savings

Purchase price uses adjusted target EBITDA before assumed savings.

Existing buyer debt and retained cash

Financial comparison

Annual and closing-year views · USD millions unless noted.

MeasureBuyer annualTarget historicalCombined full yearClosing year

Buyer results cover the full year; target contributions start at closing. Displayed results are rounded; CSV exports retain calculation precision.

Save or restore a case

Save assumptions in this browser, or download a backup to restore later. A backup includes the assumptions and calculated schedules.

Saved assumptions stay on this device and browser.

Monthly contributions and sensitivity checks

Closing-year monthly schedule

MonthTarget included?RevenueModeled EBITDANew debt interest

Purchase multiple → equity funding

Debt stays fixed. Synergies do not change purchase price.

Purchase multipleEquity funding ($M)

Savings realization → leverage

Purchase price and debt stay fixed. EBITDA changes.

RealizationEBITDA ($M)Gross debt / EBITDA

Model basis

Buyer and target earnings are allocated evenly across the year. Closing occurs on the first day of the chosen month. Deal costs are a funding use; leverage uses full-year EBITDA.

Formulas and model scope

Acquisition modeling guides

How to build an acquisition pro forma

A worked example of earnings adjustments, deal timing, purchase price, and funding.

Read the guide →

Pro forma vs. forecast

Understand the different views used in transaction analysis and operating planning.

Read the comparison →