Value_Merge.Xls: When and How to Use the Model
22 Pages Posted: 14 Jun 2009
Abstract
This note describes the structure and potential applications of a "canned" spreadsheet model that values and projects pro-forma results for two merging firms. The model can be used as a course resource in a course on valuation or mergers and acquisitions. In applications at Darden, terms of students are given this model as a resource for projects in mergers and acquisitions.
Excerpt
UVA-F-1213
VALUE_MERGE.XLS:
WHEN AND HOW TO USE THE MODEL
When to Use the Model
VALUE_MERGE.XLS is a multi-purpose model, which enables users to forecast a company's financial data, value the company, and assess the earnings impact of merger scenarios. The most common application for the model will be in M&A analyses performed from the acquirer's point of view. On a macro level, key issues weighing on any acquirer's mind will be:
· What is the target company worth?
. . .
Keywords: mergers acquisitions, valuation, financial forecasting, computer modeling
Suggested Citation: Suggested Citation