Case-Polaroid_Corporation%2C1996

Case-Polaroid_Corporation%2C1996 - POLAROID.XLS This...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
POLAROID.XLS Please note: Revised: 6/98. Copyright (C) 1998, by the University of Virginia Darden School Foundation. This spreadsheet supports STUDENT analysis of the case, "Polaroid Corporation, 1996" (UVA -F- 1181, v. 1.6 ). This is a working model. Assumptions / Inputs presented can be changed to vary the results. Please press F9 to recalculate results after changing assumptions. This model contains an intentional circularity. To resolve this circularity, please set Excel to recalculate the model a number of times (20 to 50). See TOOLS/OPTIONS/CALCULATION, and check ITERATION.
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Exh. 1 Page 2 1995 1994 1993 1992 1991 1990 1989 1988 1987 1986 Selected Income Statement Information Net Sales U.S. $1,019.0 $1,160.3 $1,178.8 $1,145.7 $1,113.6 $1,058.3 $1,091.8 $1,048.3 $1,009.3 $964.3 International 1,217.9 1,152.2 1,066.1 1,006.6 957.0 913.4 812.9 814.6 754.6 664.9 Total 2,236.9 2,312.5 2,244.9 2,152.3 2,070.6 1,971.7 1,904.7 1,862.9 1,763.9 1,629.2 Operating Expenses 2,147.7 2,112.2 2,059.5 1,938.5 1,824.0 1,687.4 1,600.5 1,689.1 1,610.1 1,493.5 Profit from Opns. Before Restructuring Exp. 89.2 200.3 185.4 213.8 246.6 284.3 304.2 173.8 153.8 135.7 Restructuring Expense 247.0 0.0 44.0 0.0 0.0 0.0 40.5 151.9 0.0 0.0 Interest Expense 52.1 46.6 47.9 58.5 58.4 81.3 86.2 29.0 15.0 18.6 Net Earnings -140.2 117.2 -51.3 99.0 683.7 151.0 145.0 -22.6 125.2 108.2 Common Shares, End of Year (000s) 45,533 45,998 46,806 46,668 48,919 50,070 52,110 71,635 61,918 61,918 Common Shares Repurchased (000s) 1,218 941 0 2,258 1,151 2,040 19,525 0 0 0 Repurchase Outlay ($ millions) $40.2 $30.6 $0.0 $63.4 $30.6 $55.6 $950.6 $0.0 $0.0 $0.0 Common Shares Issued (000s) 753 133 138 7 0 0 0 9,717 0 0 Earnings Per Share -$3.09 $2.49 -$1.10 $2.06 $12.54 $2.20 $1.96 -$0.34 $2.02 $1.75 Dividend Per Share $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.60 $0.50 Selected Balance Sheet Information Working Capital $738.5 $886.8 $833.6
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 8

Case-Polaroid_Corporation%2C1996 - POLAROID.XLS This...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online