In this section we demonstrate how to model a merger of two public companies in Excel. Each topic contains a spreadsheet with which you can interact within your browser to inspect cell equations and read comments, or download and open in Excel. This is a very detailed M&A model, loaded with bells and whistles and built using "best-practices" for financial modeling, that should address most of the M&A situations you may encounter. However, it is not intended as a template for modeling all M&A transactions; just like snowflakes, no two deals are alike. The topics in this section are presented in sequential order, as if you were building the model from scratch, but you are welcome to skip to any page that fulfills your particular education needs.
Below some spreadsheets, we provide Excel tips and keyboard shortcuts that highlight best practices for financial modeling or provide instruction on how to perform specific tasks within Excel. Most of these tips and shortcuts assume the user is using Excel 2003 for Windows, as most finance professionals still are. However, some tips and shortcuts are also applicable to Excel 2007.
Since our focus in this section is on modeling, we will not necessarily cover the accounting rules and regulations and theories governing each topic. For most topics, you can find more detailed background information elsewhere on this web site.
If you have ideas on how to improve this section on M&A modeling, don't hesitate to provide some feedback.comments powered by Disqus