Want FREE Templates on Digital Transformation? Download our FREE compilation of 50+ slides. This is an exclusive promotion being run on LinkedIn.

Mergers & Acquisitions Price Multiple Analyzer   Excel template (XLS)

Mergers & Acquisitions Price Multiple Analyzer (Excel template (XLS)) Preview Image Mergers & Acquisitions Price Multiple Analyzer (Excel template (XLS)) Preview Image
Arrow   Unlock all preview images:   Login Register

Mergers & Acquisitions Price Multiple Analyzer (Excel XLS)

File Type: Excel template (XLS)


Add to Cart


Immediate digital download upon purchase.
Lifetime document updates included with purchase.
Fully editable & customizable XLS document.
Trusted by over 10,000+ organizations.


This product (Mergers & Acquisitions Price Multiple Analyzer) is an Excel template (XLS), which you can download immediately upon purchase.

M&A Price Multiple Analyzer helps Acquirers quickly and accurately analyze the post-transaction effect of an acquisition on EPS and P/E based on different financing scenarios

The tool includes the following worksheets:
•  A detail instruction
•  Deal data input (allowing for different accounting method)
•  Acquirer/Acquiree financial data input
•  Price multiple summary (pro forma earnings growth, EPS, P/E, P/B multiples etc.)
•  Cost of debt/capital calculation
•  Debt financed deal analysis
•  Equity financed deal analysis
•  Post-transaction P/E analysis
•  Offer price analyzer
•  EPS break-even time analyzer
•  Various chart/graph of the output in 7 worksheets

This is a powerful tool for M&A practitioners, CEOs, CFOs, venture capitalists, and private equity fund managers.
To use the Price Multiples Analyzer, the Acquirer must simply input the Target and its financial information into the Deal & Earnings Data Input Worksheets. The Tool will then automatically develop a summary of the effect on earnings, EPS, and P/E based on different financing and accounting method scenarios.

Got a question about the product? Email us at support@flevy.com or ask the author directly by using the "Ask the Author a Question" form. If you cannot view the preview above this document description, go here to view the large preview instead.

Source: Best Practices in M&A (Mergers & Acquisitions) Excel: Mergers & Acquisitions Price Multiple Analyzer Excel (XLS) Spreadsheet, Documents & Files


Add to Cart


File Type: Excel xls (XLS)
File Size: 406.5 KB


Author: Documents & Files
Additional documents from author: 130

Ask the Author a Question

Must be logged in

Did you know?
The average daily rate of a McKinsey consultant is $6,625 (not including expenses). The average price of a Flevy document is $65.
Bundle and save! You can save up to % with bundles!

View bundle(s)

Trusted by over 10,000+ Client Organizations
Since 2012, we have provided best practices to over 10,000 businesses and organizations of all sizes, from startups and small businesses to the Fortune 100, in over 130 countries.
AT&T GE Cisco Intel IBM Coke Dell Toyota HP Nike Samsung Microsoft Astrazeneca JP Morgan KPMG Walgreens Walmart 3M Kaiser Oracle SAP Google E&Y Volvo Bosch Merck Fedex Shell Amgen Eli Lilly Roche AIG Abbott Amazon PwC T-Mobile Broadcom Bayer Pearson Titleist ConEd Pfizer NTT Data Schwab

Read Customer Testimonials

Save with Bundles

This document is available as part of the following discounted bundle(s):

Save %!
Mergers and Acquisitions Toolkit

This bundle contains 7 total documents. See all the documents to the right.


Add Bundle & Save

Customers Also Bought These Documents

Document Bundle
$219.00 Bundle of 7 Documents

Customers Also Like These Documents

Related Management Topics

M&A (Mergers & Acquisitions) Valuation Growth Strategy Valuation Model Example Cost of Quality Porter's Five Forces Integrated Financial Model Alliances Target Operating Model Due Diligence Change Management Deal Structuring Financial Modeling Cost Reduction Assessment Business Case Development Quality Management & Assurance Poka Yoke Lean Management/Enterprise Strategy Development Breakout Strategy Vision Statement Financial Analysis

Download our FREE Strategy & Transformation Framework Templates

Download our free compilation of 50+ Strategy & Transformation slides and templates. Frameworks include McKinsey 7-S, Balanced Scorecard, Disruptive Innovation, BCG Curve, and many more.