Merger-model-sample-biws-jobsearchdigest.xls.xlsx
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Merger-model-sample-biws-jobsearchdigest.xls.xlsx as PDF for free.
More details
- Words: 480
- Pages: 7
Merger Model
This sample model is provided compliments of Breaking Into Wall Street and JobSearchDige
If you feel you need to further develop your modeling skills, you might consider the complete Breaking Into Wall Street Financial Modeling Course The full course includes: * Over 60 hours of video training. * Completely online and self paced modules. * Excel tutorials covering: Accounting, Valuation, and Merger/LBO Modeling. * Advanced Modeling covers topics such as: book vs. cash taxes, Section 382 NOLs, and LBO with 7 debt tranches and 5 transaction scenarios. * And you get FREE lifetime updates and support! Here's to improving your financial skills! David Kochanek Publisher, JobSearchDigest.com
Street and JobSearchDigest.com
ght consider the complete
tion 382 NOLs,
Get the Entire Breaking Into Wall Street Financial Modeling Course Merger Model - Intel Corporation and McAfee, Inc. ($ in Millions Except Per Share Amounts) Transaction Assumptions Buyer Name: Announcement Date: Assumed Close Date:
Intel Corporation 8/19/2010 12/31/2010
% Cash: % Debt: % Stock: Foregone Cash Interest Rate:
33.3% 33.3% 33.3% 4.0%
Seller Name: Premium to Seller's Share Price: Per Share Purchase Price: Purchase Price:
McAfee, Inc.
Cash Used: Debt Issued: New Shares Issued: Debt Interest Rate:
Intel Corporation - Financial Profile Prior to Merger
McAfee, Inc. - Financial Profile Prior to Merger
Share Price: Shares Outstanding (MM): Market Cap: Effective Tax Rate:
Share Price: Shares Outstanding (MM): Market Cap: Effective Tax Rate:
$19.59 5,711.0 $111,878 31%
Buyer - Income Statement
Revenue: Cost of Goods Sold: Gross Profit:
Seller - Income Statement
Projected Years 12/31/2011 12/31/2012 $47,450 $48,667 $16,331 $17,995 $31,119 $30,672
Revenue: Cost of Goods Sold: Gross Profit:
Projected Years 12/31/2011 $2,205 $496 $1,709
Operating Expenses:
$13,000
$13,100
Operating Expenses:
Operating Income: Interest Income / (Expense Pre-Tax Income: Income Taxes:
$18,119 $150 $18,269 $5,663
$17,572 $200 $17,772 $5,509
Operating Income: Interest Income / (Expense Pre-Tax Income: Income Taxes:
$578 $5 $583 $140
Net Income:
$12,606
$12,263
Net Income:
$443
$2.18
$2.10
Earnings Per Share (EPS):
$2.88
Earnings Per Share (EPS):
$1,131
Shares Outstanding:
5,786.0
5,832.0
Combined Income Statement, Post-Merger
Combined Revenue: Cost of Goods Sold: Gross Profit:
Projected Years 12/31/2011 12/31/2012 $49,655 $51,048 $16,827 $18,531 $32,828 $32,518
Operating Expenses:
$14,131
$14,322
Operating Income: Interest Income / (Expens Foregone Interest on Cash Interest Paid on New Debt Pre-Tax Income: Income Tax Provision:
$18,697 $155 ($101) ($228) $18,523 $5,742
$18,196 $205 ($101) ($228) $18,072 $5,602
Net Income:
$12,781
$12,469
Earnings Per Share (EPS): Shares Outstanding:
$2.16 5,915.3
$2.09 5,961.3
Accretion / Dilution: Accretion / Dilution %:
($0.02) (0.8%)
($0.01) (0.5%)
Shares Outstanding:
154.0
deling Course
McAfee, Inc. 60.4% $48.00 $7,600 $2,533 $2,533 129.3 9.0%
rofile Prior to Merger $29.93 158.3 $4,739 24%
Projected Years 12/31/2012 $2,381 $536 $1,846 $1,222 $624 $5 $629 $151 $478 $3.10
154.0
Get the Entire Breaking Into Wall Street Financial Modeling Course Company Filings: Intel 10-Q McAfee 10-Q
Share Price Information from Google Finance: McAfee, Inc Intel Corporation, Inc.
This sample model is provided compliments of Breaking Into Wall Street and JobSearchDige
If you feel you need to further develop your modeling skills, you might consider the complete Breaking Into Wall Street Financial Modeling Course The full course includes: * Over 60 hours of video training. * Completely online and self paced modules. * Excel tutorials covering: Accounting, Valuation, and Merger/LBO Modeling. * Advanced Modeling covers topics such as: book vs. cash taxes, Section 382 NOLs, and LBO with 7 debt tranches and 5 transaction scenarios. * And you get FREE lifetime updates and support! Here's to improving your financial skills! David Kochanek Publisher, JobSearchDigest.com
Street and JobSearchDigest.com
ght consider the complete
tion 382 NOLs,
Get the Entire Breaking Into Wall Street Financial Modeling Course Merger Model - Intel Corporation and McAfee, Inc. ($ in Millions Except Per Share Amounts) Transaction Assumptions Buyer Name: Announcement Date: Assumed Close Date:
Intel Corporation 8/19/2010 12/31/2010
% Cash: % Debt: % Stock: Foregone Cash Interest Rate:
33.3% 33.3% 33.3% 4.0%
Seller Name: Premium to Seller's Share Price: Per Share Purchase Price: Purchase Price:
McAfee, Inc.
Cash Used: Debt Issued: New Shares Issued: Debt Interest Rate:
Intel Corporation - Financial Profile Prior to Merger
McAfee, Inc. - Financial Profile Prior to Merger
Share Price: Shares Outstanding (MM): Market Cap: Effective Tax Rate:
Share Price: Shares Outstanding (MM): Market Cap: Effective Tax Rate:
$19.59 5,711.0 $111,878 31%
Buyer - Income Statement
Revenue: Cost of Goods Sold: Gross Profit:
Seller - Income Statement
Projected Years 12/31/2011 12/31/2012 $47,450 $48,667 $16,331 $17,995 $31,119 $30,672
Revenue: Cost of Goods Sold: Gross Profit:
Projected Years 12/31/2011 $2,205 $496 $1,709
Operating Expenses:
$13,000
$13,100
Operating Expenses:
Operating Income: Interest Income / (Expense Pre-Tax Income: Income Taxes:
$18,119 $150 $18,269 $5,663
$17,572 $200 $17,772 $5,509
Operating Income: Interest Income / (Expense Pre-Tax Income: Income Taxes:
$578 $5 $583 $140
Net Income:
$12,606
$12,263
Net Income:
$443
$2.18
$2.10
Earnings Per Share (EPS):
$2.88
Earnings Per Share (EPS):
$1,131
Shares Outstanding:
5,786.0
5,832.0
Combined Income Statement, Post-Merger
Combined Revenue: Cost of Goods Sold: Gross Profit:
Projected Years 12/31/2011 12/31/2012 $49,655 $51,048 $16,827 $18,531 $32,828 $32,518
Operating Expenses:
$14,131
$14,322
Operating Income: Interest Income / (Expens Foregone Interest on Cash Interest Paid on New Debt Pre-Tax Income: Income Tax Provision:
$18,697 $155 ($101) ($228) $18,523 $5,742
$18,196 $205 ($101) ($228) $18,072 $5,602
Net Income:
$12,781
$12,469
Earnings Per Share (EPS): Shares Outstanding:
$2.16 5,915.3
$2.09 5,961.3
Accretion / Dilution: Accretion / Dilution %:
($0.02) (0.8%)
($0.01) (0.5%)
Shares Outstanding:
154.0
deling Course
McAfee, Inc. 60.4% $48.00 $7,600 $2,533 $2,533 129.3 9.0%
rofile Prior to Merger $29.93 158.3 $4,739 24%
Projected Years 12/31/2012 $2,381 $536 $1,846 $1,222 $624 $5 $629 $151 $478 $3.10
154.0
Get the Entire Breaking Into Wall Street Financial Modeling Course Company Filings: Intel 10-Q McAfee 10-Q
Share Price Information from Google Finance: McAfee, Inc Intel Corporation, Inc.
More Documents from "CCerberus24"
Ccalc.xlsx
May 2020 2
