Acquisition finance

Acquisition pro forma builder

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

Northstar Services Group · fictional acquisition example. A $200M buyer acquires a $50M target. Dataset: northstar-acquisition-2027-v1. Period: illustrative 12-month year; the default closes on July 1. Inputs do not transfer to the other finance examples.

Not saved. Edits remain in this tab until you save in this browser or download a backup.

JSON backups preserve all inputs and the comparison reference; restoring recalculates results. CSV exports are results reports, not restorable backups. Save or restore a case ↓

Part of Seth Sokoloff’s finance examples. Explore the acquisition reporting case study or CFO engagement options.

Illustrative example · fictional figures

Acquisition overview

Full year · both businesses for 12 months · USD millions

Combined revenue$250.00MFull-year combined view
Modeled EBITDA$52.75MIncludes $1.50M adjustments and $1.25M synergies
Target enterprise value$80.50M7.0× adjusted target EBITDA
Equity funding required$32.50MExisting buyer cash retained

EBITDA bridge

Historical earnings → adjustments → assumed savings · USD millions

Scroll horizontally to see the full bridge.

Funding at close

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

Assumptions

Money in USD millions: 1.5 = $1,500,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.

Compare cases

Set the current assumptions as a reference, then edit inputs or load an example. Both annual and closing-year results are compared. The reference stays fixed until you replace or clear it.

Save or restore a case

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

Monthly contributions and sensitivity checks

Closing-year monthly schedule

Combined buyer and target results. Buyer results are included in every month.

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.

RealizationFull-year EBITDA ($M)Gross debt / full-year 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 →

From an acquisition case to management reporting

See how Seth integrated five acquisitions into management and sponsor reporting in the Galloway case study. That professional engagement is separate from this fictional Northstar model.

From diligence to execution

Before relying on adjusted earnings, organize the supporting evidence with the QoE readiness checklist. After closing, use the acquisition finance integration planner to assign owners and milestones for reporting, cash controls, and the first close. These separate tools do not share or import this model’s inputs.