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 chapters, we have included a test bank of over 300 questions and answers for classroom and other instructional use. The test bank can be accessed by instructors in Microsoft Word format at www.wiley.com/go/investmentbanking. The test bank is also available in interactive format to facilitate online testing. The website includes the following files:
• Chapter 1_Comparable Companies Analysis_Q&A.doc
• Chapter 2_Precedent Transactions Analysis_Q&A.doc
• Chapter 3_Discounted Cash Flow Analysis_Q&A.doc
• Chapter 4_Leveraged Buyouts_Q&A.doc
• Chapter 5_Leveraged Buyout Analysis_Q&A.doc
• Chapter 6_M&A Sale Process_Q&A.doc
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset