Value_Merge.Xls: When and How to Use the Model

22 Pages Posted: 14 Jun 2009

See all articles by Robert F. Bruner

Robert F. Bruner

University of Virginia - Darden School of Business

Mark Miles

University of Virginia - Darden School of Business

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

Bruner, Robert F. and Miles, Mark, Value_Merge.Xls: When and How to Use the Model. Darden Case No. UVA-F-1213, Available at SSRN: https://ssrn.com/abstract=1418853 or http://dx.doi.org/10.2139/ssrn.1418853

Robert F. Bruner (Contact Author)

University of Virginia - Darden School of Business ( email )

P.O. Box 6550
Charlottesville, VA 22906-6550
United States

HOME PAGE: http://faculty.darden.edu/brunerb/

Mark Miles

University of Virginia - Darden School of Business

P.O. Box 6550
Charlottesville, VA 22906-6550
United States

Do you have negative results from your research you’d like to share?

Paper statistics

Downloads
172
Abstract Views
1,083
Rank
314,422
PlumX Metrics