Mergers & Acquisitions Price Multiple Analyzer (Excel XLS)

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.