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.
Acquisition overview
Full year · both businesses for 12 months · USD millions
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.
Financial comparison
Annual and closing-year views · USD millions unless noted.
| Measure | Buyer annual | Target historical | Combined full year | Closing 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.
| Measure | Reference | Current | ChangeCurrent − reference |
|---|
Changed assumptions
| Assumption | Reference | Current |
|---|
Change = current minus reference. Figures are rounded for display; downloads preserve calculation precision. The reference is included when you save or download this case.
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.
| Month | Target included? | Revenue | Modeled EBITDA | New debt interest |
|---|
Purchase multiple → equity funding
Debt stays fixed. Synergies do not change purchase price.
| Purchase multiple | Equity funding ($M) |
|---|
Savings realization → leverage
Purchase price and debt stay fixed. EBITDA changes.
| Realization | Full-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.