1. Use the data in the AT&T-NCR spreadsheet. For each company, the spreadsheet shows the daily return for AT&T, NCR

1. Use the data in the AT&T-NCR spreadsheet. For each company, the spreadsheet shows the daily

return for AT&T, NCR, S&P500, and the Market Index with value-weighted returns.

For each company, estimate the equation for Normal Returns by running the following simple

regression (also known as the Market Model) with daily returns:

RAT&T = a + b RM

2. For each company, estimate two Normal Returns equations by using S&P500 and the Value

Weighted Index.

3. Use these Normal Returns equations to calculate Abnormal Returns on each Event Day during

AT&T’s takeover bids for NCR. The event dates are described in Table 1 (Report Date) of the

paper “An Analysis of Value Destruction in AT&T’s Acquisition of NCR”, Journal of Financial

Economics 39 (1995), by Lys and Vincent.

Abnormal Return on an Event Date = Actual Return – Normal Return

4. Summarize your results (including Regression output and Abnormal Returns) for both firms and

compare to the numbers in the paper by Lys and Vincent