Click main image to view in full screen.
M&A EXCEL DESCRIPTION
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.
The M&A Price Multiple Analyzer provides a comprehensive breakdown of company financials and market data, enabling users to input detailed metrics for both the acquirer and target. The tool calculates price multiples, projected earnings, and EPS growth, offering a clear picture of the financial impact of the acquisition. Users can easily navigate through various worksheets to analyze different financing scenarios, including debt and equity financing, ensuring they have all the necessary data to make informed decisions.
Moreover, the tool includes a variety of charts and graphs that visually represent the data, making it easier to interpret complex financial information. From EPS projections to earnings breakdowns, these visual aids help users quickly grasp the potential outcomes of different deal structures. The inclusion of a graph directory ensures that all relevant visual data is easily accessible, further enhancing the usability of the tool for busy executives.
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 Excel: Mergers & Acquisitions Price Multiple Analyzer Excel (XLS) Spreadsheet, Documents & Files
