Investment Banking: Valuation, Leveraged Buyouts, and Mergers & Acquisitions

Supplemental Materials

VALUATION MODELS

The model templates (and completed versions) for the valuation methodologies discussed in this book are available in Microsoft Excel format at www.wiley.com/go/investmentbanking —password:wiley09. They will be updated for new accounting standards, as appropriate. The completed models match the input and output pages for the respective valuation methodologies. The company names and financial data in the models are completely illustrative. The website contains the following files:

 

Model Templates

• Comparable Companies_Template.xls

• Precedent Transactions_Template.xls

• DCF Analysis_Template.xls

• LBO Analysis_Template.xls

 

Completed Models

• Comparable Companies_Completed.xls

• Precedent Transactions_Completed.xls

• DCF Analysis_Completed.xls

• LBO Analysis_Completed.xls

Note: When opening the models in Microsoft Excel, please ensure that you perform the following procedure: in the main toolbar select Tools, select Options, select the “Calculation” tab, select Manual, select Iteration, and set “Maximum iterations:” to 1000 (also see Chapter 3, Exhibit 3.30). The model templates on the website are formatted with yellow shading and blue font to denote manual input cells. Black font denotes formula cells. In the text, however, gray shading is used to denote manual input cells, where possible. For Chapter 5: LBO Analysis, please reference the electronic version to view manual input and formula cells.

INSTRUCTOR TEACHING AIDS

To accompany the ...