Control Premium Calculator Excel Template
Control Premium Calculator Excel Template
Interactive Excel Financial Model
Download, customize, and integrate into your own analysis
What's Included
- Interactive financial model with live Excel formulas
- All formulas visible and fully editable
- Professional formatting with color-coded inputs & outputs
- Formula reference sheet with variable definitions
- Step-by-step instructions sheet
- Compatible with Microsoft Excel 2016 and later
Download Template
Price range: $0.00 through $20.00
Calculate M&A control premiums, deal equity value, and enterprise value. Interactive Excel template with live formulas.
Online Calculator vs Excel Template
| Feature | Online | Excel |
|---|---|---|
| Instant use — no download | ✓ | — |
| Works offline | — | ✓ |
| Customize formulas & layout | — | ✓ |
| Save & share with colleagues | — | ✓ |
| Integrate into your own models | — | ✓ |
| Print-ready formatting | — | ✓ |
About This Template
Calculate control premiums for M&A transactions with this interactive Excel template. Instantly compute the premium percentage, premium value, and transaction enterprise value by entering deal price, unaffected share price, diluted shares, and net debt.
What You Can Calculate
This template delivers five key outputs for transaction analysis:
- Control Premium (%) - The percentage premium over unaffected market price, with automatic flagging for unusual values
- Premium Value ($M) - Dollar value of the control premium paid
- Unaffected Equity Value - Pre-announcement market capitalization
- Deal Equity Value - Total equity consideration in the transaction
- Deal Enterprise Value - Implied EV including net debt
Required Inputs
Enter four values to run the analysis:
- Unaffected Share Price - Target's pre-announcement trading price (typically 30-day VWAP)
- Deal Price per Share - The acquisition offer price
- Diluted Shares Outstanding - Fully diluted share count in millions
- Net Debt - Total debt minus cash (negative for net cash positions)
Methodology
The control premium is calculated as (Deal Price - Unaffected Price) / Unaffected Price, expressed as a percentage. According to Rosenbaum & Pearl's "Investment Banking," typical public company acquisition premiums range from 25-35%. This template flags premiums outside the 20-40% normal range and warns on negative or very high (>60%) values.
Assumptions & Limitations
- Simplified enterprise value calculation - does not include preferred stock, minority interest, or convertibles
- Net debt treated as static with no working capital adjustments
- Does not model synergies, accretion/dilution, or tax impacts
Frequently Asked Questions
This template lets you quickly model different deal scenarios by adjusting the offer price, share count, and net debt. Run sensitivity analysis on premium levels, compare multiple potential deal structures, and save your work for presentations or deal committee memos.
Yes - enter historical deal terms to calculate implied control premiums for comparable transactions. Build a database of precedent premiums by saving multiple copies, then reference these benchmarks when evaluating new deal offers.
Four inputs: the target's unaffected share price (pre-announcement trading price), the proposed deal price per share, diluted shares outstanding, and net debt. All are typically available in public filings, merger proxies, or equity research.
A fully interactive financial model with live Excel formulas, an Instructions sheet with usage guide, and a Formula Reference sheet with variable definitions and model assumptions. All formulas are visible and editable.
Microsoft Excel 2016 or later. The template uses standard Excel formulas only — no macros, VBA, or add-ins required.
Yes. All cells are fully editable. You can modify any formula, add your own calculations, change formatting, or integrate the model into your existing spreadsheets.
The online calculator runs in your browser for quick calculations. This Excel template gives you a portable, offline financial model you can customize, save, share with colleagues, and integrate into your own analysis.
This template is provided for educational and personal use. You may use it in your own professional analysis and presentations. Redistribution or resale of the template itself is not permitted.
You can re-download the latest version from your account or by requesting a new download link. Free downloads are limited to 5 per email address per month.
