Investment Banking Valuation, Leveraged Buyouts, and Mergers & Acquisitions Precedent Transactions Analysis - Template
JOSHUA ROSENBAUM JOSHUA PEARL
($ in millions)
List of Comparable Acquisitions Date Announced
Acquirer
Target
Transaction Type
Target Business Description
Equity Value
Enterprise Value
LTM Sales
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
1/0/1900
Acquirer
Target
NA
[to come]
-
-
-
ValueCo Corporation Precedent Transactions Analysis ($ in millions)
Enterprise Value / Date Announced
Acquirer
Target
Transaction Type
Purchase Consideration
Equity Value
Enterprise Value
LTM
Equity Value /
LTM Sales
LTM EBITDA
LTM EBIT
EBITDA Margin
LTM Net Income
Premiums Paid Days Prior to Unaffected 1 7 30
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
1/0/1900
Acquirer
Target
NA
NA
-
-
NA
NA
NA
NA
NA
NA
NA
NA
Mean Median
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
NA NA
High Low
0.0x 0.0x
0.0x 0.0x
0.0x 0.0x
0% 0%
0.0x 0.0x
0% 0%
0% 0%
0% 0%
Source: Company filings
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Acquisition of Target by Acquirer Input Page ($ in millions, except per share data)
General Information
Reported Income Statement
Tar et Ticker Fiscal Year Ending Marginal Tax Rate
Tar et TRGT Jan-00
Acquirer Ticker Fiscal Year Ending
Target Description
Sales COGS
-
Prior Stub 1/0/1900 -
Acquirer ACQR Jan-00
Gross Profit SG&A Other Expense / (Income)
-
-
-
-
Date Announced
1/0/1900
EBIT Interest Expense
-
-
-
-
Date Effective Transaction Type Purchase Consideration
1/0/1900 NA NA
Pre-tax Income Income Taxes Noncontrolling Interest Preferred Dividends
-
-
-
-
NA
NA
NA
NA
NA
NA
NA
NA
-
-
-
-
-
-
-
NA
NA
NA
Calculation of Fully Diluted Shares Outstanding
NA
-
Calculation of Equity and Enterprise Value Offer Price per Share Cash Offer Price per Share Stock Offer Price per Share Exchange Ratio Acquirer Share Price
Net Income
Effective Tax Rate -
-
Offer Price per Share Fully Diluted Shares Outstanding
Implied Equity Value
FYE 1/0/1900
[to come]
LTM 1/0/1900 -
Acquirer Description [to come]
Comments [to come]
Weighted Avg. Diluted Shares Diluted EPS
-
Adjusted Income Statement
-
Reported Gross Profit Non-recurring Items in COGS
-
Current Stub 1/0/1900 -
Adjusted Gross Profit
% mar in
Basic Shares Outstanding Plus: Shares from In-the-Money Options
-
Plus: Total Debt
-
Reported EBIT
-
-
-
-
Less: Shares Repurchased from Option Proceeds
-
Plus: Preferred Stock Plus: Noncontrolling Interest
-
Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
Net New Shares from Options Plus: Shares from Convertible Securities
-
Less: Cash and Cash Equivalents
-
Adjusted EBIT
-
-
-
-
-
% margin
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
Implied Enterprise Value
Implied Enterprise Value
Fully Diluted Shares Outstanding
-
Options/Warrants LTM Transaction Multiples
Depreciation & Amortization
EV/Sales
NA
Adjusted EBITDA
Metric EV/EBITDA Metric EV/EBIT Metric
NA NA -
% margin Reported Net Income Non-recurring Items in COGS Other Non-recurring Items
-
-
-
-
P/E Metric
NA -
Non-operating Non-rec. Items Tax Adjustment
-
-
-
-
Adjusted Net Income Premiums Paid
% margin
Transaction Announcement
NA
NA
NA
-
NA
1 Day Prior
-
7 Days Prior 30 Days Prior
-
NA NA NA
Adjusted Diluted EPS
-
-
-
-
Cash Flow Statement Data Depreciation & Amortization
% sales % sales
Period
Exercise
In-the-Money
Shares
Price
Shares
Total
-
Date Filed
Target 10-K
1/0/1900
1/0/1900
Notes
Target 10-Q Target 8-K Target DEFM14A
1/0/1900
1/0/1900 1/0/1900 1/0/1900
(1) [to come] (2) [to come] (3) [to come]
1/0/1900 1/0/1900
(4) [to come] (5) [to come]
-
-
-
-
NA
NA
NA
NA
-
-
-
-
NA
NA
NA
NA
-
-
Proceeds -
-
-
Convertible Securities Conversion Price
Amount
Capital Expenditures
Source Documents
Number of -
Premium
1 Day Prior Unaffected Share Price
Acquirer 424B Acquirer 8-K
NA
Tranche Batch 1 Batch 2 Batch 3 Batch 4 Batch 5
Conversion Ratio
New Shares
Issue 1 Issue 2
-
-
-
-
Issue 3
-
-
-
-
Issue 4 Issue 5
-
-
-
Total
-
-
Copyright © 2009 by Joshua Rosenbaum and Joshua Pearl. All rights reserved. Published by John Wiley & Sons, Inc., Hoboken, New Jersey. Published simultaneously in Canada. No part of this publication may be reproduced, stored in a retrieval system, or transmitted in any form or by any means, electronic, mechanical, photocopying, recording, scanning, or otherwise, except as permitted under Section 107 or 108 of the 1976 United States Copyright Act, without either the prior written permission of the Publisher, or authorization through payment of the appropriate per-copy fee to the Copyright Clearance Center, Inc., 222 Rosewood Drive, Danvers, MA 01923, (978) 750-8400, fax (978) 750-4470, or on the web at www.copyright.com. Requests to the Publisher for permission should be addressed to the Permissions Department, John Wiley & Sons, Inc., 111 River Street, Hoboken, NJ 07030, (201) 748-6011, fax (201) 748-6008, or online at http://www.wiley.com/go/permissions. Limit of Liability/Disclaimer of Warranty: While the publisher and author have used their best efforts in preparing this book, they make no representations or warranties with respect to the accuracy or completeness of the contents of this book and specifically disclaim any implied warranties of merchantability or fitness for a particular purpose. No warranty may be created or extended by sales representatives or written sales materials. The advice and strategies contained herein may not be suitable for your situation. You should consult with a professional where appropriate. Neither the publisher nor author shall be liable for any loss of profit or any other commercial damages, including but not limited to special, incidental, consequential, or other damages. For general information on our other products and services or for technical support, please contact our Customer Care Department within the United States at (800) 762-2974, outside the United States at (317) 572-3993 or fax (317) 572-4002. Wiley also publishes its books in a variety of electronic formats. Some content that appears in print may not be available in electronic books. For more information about Wiley products, visit our web site at www.wiley.com. Library of Congress Cataloging-in-Publication Data:
ISBN-13 978-0-470-44220-3 Printed in the United States of America 10 9 8 7 6 5 4 3 2 1
