Spreadsheet: jeff_dasovich__14057__OAT Valuation 0416
Sheet: OAT Balance Sheet

DOLLARS IN MILLIONS (EXCEPT PER SHARE DATA) |  |  |  |  |  |  | DOLLARS IN MILLIONS (EXCEPT PER SHARE DATA)
 |  |  |  |  |  |  |  |  | OAT YEAR OVER YEAR PERCENTAGE CHANGE
ASSETS |  |  |  |  |  |  | ASSETS
CURRENT ASSETS: | 2000-12-31 00:00:00 | 1999-12-31 00:00:00 | 1998-12-31 00:00:00 | 1997-12-31 00:00:00 | 1996-12-31 00:00:00 |  | CURRENT ASSETS: | 2000-12-31 00:00:00 | 1999-12-31 00:00:00 | 1998-12-31 00:00:00 | 1997-12-31 00:00:00 | 1996-12-31 00:00:00 | Average
Cash and cash equivalents................................. | 174.3 | 282.9 | 326.6 | 84.2 | 110.5 |  | Cash and cash equivalents.................................
Marketable securities..................................... | 0.3 | 0.3 | 27.5 |  |  |  | Marketable securities.....................................
Trade accounts receivable -- net of allowances............ | 298 | 254.3 | 283.4 | 305.7 | 294.9 |  | Trade accounts receivable -- net of allowances............
Inventories: |  |  |  |  |  |  | Inventories:
Finished goods......................................... | 213.9 | 186.6 | 189.1 | 172.6 | 181.8 |  | Finished goods.........................................
Raw materials.......................................... | 39 | 50 | 48.4 | 59 | 62.1 |  | Raw materials..........................................
Packaging materials and supplies....................... | 34.5 | 29.6 | 23.9 | 24.5 | 31 |  | Packaging materials and supplies.......................
Total inventories.................................... | 287.4 | 266.2 | 261.4 | 256.1 | 274.9 |  | Total inventories....................................
Other current assets...................................... | 253.7 | 193 | 216.1 | 487 | 209.4 |  | Other current assets......................................
TOTAL CURRENT ASSETS.............................. | 1013.7 | 996.7 | 1115 | 1133 | 889.7 |  | TOTAL CURRENT ASSETS..............................
PROPERTY, PLANT AND EQUIPMENT: |  |  |  |  |  |  | PROPERTY, PLANT AND EQUIPMENT:
Land...................................................... | 27.1 | 28.2 | 24.1 | 29.1 | 29.6 |  | Land......................................................
Buildings and improvements................................ | 430.6 | 407.6 | 390.2 | 417.2 | 389.5 |  | Buildings and improvements................................
Machinery and equipment................................... | 1469.9 | 1416.1 | 1404.5 | 1466.8 | 1524.2 |  | Machinery and equipment...................................
Property, plant and equipment............................. | 1927.6 | 1851.9 | 1818.8 | 1913.1 | 1943.3 |  | Property, plant and equipment.............................
Less: Accumulated depreciation............................ | 807.6 | 745.2 | 748.6 | 748.4 | 742.6 |  | Less: Accumulated depreciation............................
PROPERTY -- NET........................................ | 1120 | 1106.7 | 1070.2 | 1164.7 | 1200.7 |  | PROPERTY -- NET........................................
INTANGIBLE ASSETS -- NET OF AMORTIZATION.................... | 229.2 | 236.9 | 245.7 | 350.5 | 2237.2 |  | INTANGIBLE ASSETS -- NET OF AMORTIZATION....................
OTHER ASSETS................................................ | 55.9 | 55.9 | 79.4 | 48.8 | 66.8 |  | OTHER ASSETS................................................
TOTAL ASSETS...................................... | 2418.8 | 2396.2 | 2510.3 | 2697 | 4394.4 |  | TOTAL ASSETS......................................
LIABILITIES AND SHAREHOLDERS' EQUITY |  |  |  |  |  |  | LIABILITIES AND SHAREHOLDERS' EQUITY
CURRENT LIABILITIES: |  |  |  |  |  |  | CURRENT LIABILITIES:
Short-term debt........................................... | 81.6 | 73.3 | 41.3 | 61 | 517 |  | Short-term debt...........................................
Current portion of long-term debt......................... | 48 | 81.2 | 95.2 | 108.4 | 51.1 |  | Current portion of long-term debt.........................
Trade accounts payable.................................... | 212.3 | 213.6 | 168.4 | 191.3 | 210.2 |  | Trade accounts payable....................................
Accrued payroll, benefits and bonus....................... | 135.9 | 139.1 | 131.4 | 132.3 | 111.3 |  | Accrued payroll, benefits and bonus.......................
Accrued advertising and merchandising..................... | 126.7 | 138.7 | 125.6 | 123 | 130.2 |  | Accrued advertising and merchandising.....................
Income taxes payable...................................... | 15.6 | 40.1 | 63.7 | 73.8 | 42.4 |  | Income taxes payable......................................
Other accrued liabilities................................. | 240.3 | 252.3 | 383.5 | 255.9 | 292.5 |  | Other accrued liabilities.................................
TOTAL CURRENT LIABILITIES......................... | 860.4 | 938.3 | 1009.1 | 945.7 | 1354.7 |  | TOTAL CURRENT LIABILITIES.........................
LONG-TERM DEBT.............................................. | 664.1 | 715 | 795.1 | 887.6 | 993.5 |  | LONG-TERM DEBT..............................................
OTHER LIABILITIES........................................... | 518 | 523.1 | 533.4 | 578.9 | 558.9 |  | OTHER LIABILITIES...........................................
Deferred Income Taxes |  |  |  | 36.3 | 238.4 |  | Deferred Income Taxes
PREFERRED STOCK, SERIES B, no par value, authorized |  |  |  |  |  |  | PREFERRED STOCK, SERIES B, no par value, authorized
1,750,000 shares; issued 1,282,051 of 5.46 cumulative |  |  |  |  |  |  | 1,750,000 shares; issued 1,282,051 of 5.46 cumulative
convertible shares (liquidating preference of 78 per share | 100 | 100 | 100 | 100 | 100 |  | convertible shares (liquidating preference of 78 per share
DEFERRED COMPENSATION....................................... | -27.2 | -38.5 | -48.4 | -57.2 | -64.9 |  | DEFERRED COMPENSATION.......................................
TREASURY PREFERRED STOCK, at cost, 441,469 and 366,069 |  |  |  |  |  |  | TREASURY PREFERRED STOCK, at cost, 441,469 and 366,069
shares, respectively...................................... | -51.2 | -39 | -29.9 | -22.3 | -16.1 |  | shares, respectively......................................
COMMON SHAREHOLDERS' EQUITY: |  |  |  |  |  |  | COMMON SHAREHOLDERS' EQUITY:
Common stock, 5 par value, authorized 400 million |  |  |  |  |  |  | Common stock, 5 par value, authorized 400 million
shares................................................. | 840 | 840 | 840 | 840 | 840 |  | shares.................................................
Additional paid-in capital................................ | 136.4 | 100.7 | 78.9 | 29 | -- |  | Additional paid-in capital................................
Reinvested earnings....................................... | 1061.7 | 854.6 | 555.8 | 431 | 1521.3 |  | Reinvested earnings.......................................
Accumulated other comprehensive income (Cumulative translation adjustment) | -111.3 | -95.1 | -80.1 | -82.4 | -68.2 |  | Accumulated other comprehensive income (Cumulative translation adjustment)
Deferred compensation..................................... | -21.2 | -45.5 | -67.6 | -91 | -103.4 |  | Deferred compensation.....................................
Treasury common stock, at cost............................ | -1550.9 | -1457.4 | -1176 | -898.6 | -959.8 |  | Treasury common stock, at cost............................
TOTAL COMMON SHAREHOLDERS' EQUITY.................... | 354.7 | 197.3 | 151 | 228 | 1229.9 |  | TOTAL COMMON SHAREHOLDERS' EQUITY....................
TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY........ | 2418.8 | 2396.2 | 2510.3 | 2697 | 4394.4 |  | TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY........
DOLLARS IN MILLIONS (EXCEPT PER SHARE DATA) |  | COMMON-SIZE BALANCE STATEMENT |  |  |  |  | DOLLARS IN MILLIONS (EXCEPT PER SHARE DATA) |  |  |  |  | ASSUMPTIONS
 |  | (% of total operating revenue) |  |  |  |  |  | forecast | forecast | forecast | forecast | forecast | forecast | forecast | forecast | forecast | forecast
ASSETS | 2000-12-31 00:00:00 | 1999-12-31 00:00:00 | 1998-12-31 00:00:00 | 1997-12-31 00:00:00 | 1996-12-31 00:00:00 |  | ASSETS | 2001
CURRENT ASSETS: |  |  |  |  |  | Average | CURRENT ASSETS:
Cash and cash equivalents................................. |  |  |  |  |  |  | Cash and cash equivalents................................. | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928 | 0.03457647292203928
Marketable securities..................................... |  |  |  |  |  |  | Marketable securities..................................... | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05 | 5.951200158698671e-05
Trade accounts receivable -- net of allowances............ |  |  |  |  |  |  | Trade accounts receivable -- net of allowances............ | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013 | 0.05911525490974013
Inventories: |  |  |  |  |  |  | Inventories: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Finished goods......................................... |  |  |  |  |  |  | Finished goods......................................... | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153 | 0.04243205713152153
Raw materials.......................................... |  |  |  |  |  |  | Raw materials.......................................... | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273 | 0.007736560206308273
Packaging materials and supplies....................... |  |  |  |  |  |  | Packaging materials and supplies....................... | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472 | 0.006843880182503472
Total inventories.................................... |  |  |  |  |  |  | Total inventories.................................... | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326 | 0.05701249752033326
Other current assets...................................... |  |  |  |  |  |  | Other current assets...................................... | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842 | 0.05032731600872842
TOTAL CURRENT ASSETS.............................. |  |  |  |  |  |  | TOTAL CURRENT ASSETS.............................. | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281 | 0.2010910533624281
PROPERTY, PLANT AND EQUIPMENT: |  |  |  |  |  |  | PROPERTY, PLANT AND EQUIPMENT: | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Land...................................................... |  |  |  |  |  |  | Land...................................................... | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133 | 0.005375917476691133
Buildings and improvements................................ |  |  |  |  |  |  | Buildings and improvements................................ | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826 | 0.08541955961118826
Machinery and equipment................................... |  |  |  |  |  |  | Machinery and equipment................................... | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726 | 0.2915889704423726
Property, plant and equipment............................. |  |  |  |  |  |  | Property, plant and equipment............................. | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519 | 0.3823844475302519
Less: Accumulated depreciation............................ |  |  |  |  |  |  | Less: Accumulated depreciation............................ | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682 | 0.1602063082721682
PROPERTY -- NET........................................ |  |  |  |  |  |  | PROPERTY -- NET........................................ | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837 | 0.2221781392580837
INTANGIBLE ASSETS -- NET OF AMORTIZATION.................... |  |  |  |  |  |  | INTANGIBLE ASSETS -- NET OF AMORTIZATION.................... | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784 | 0.04546716921245784
OTHER ASSETS................................................ |  |  |  |  |  |  | OTHER ASSETS................................................ | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186 | 0.01108906962904186
TOTAL ASSETS...................................... |  |  |  |  |  |  | TOTAL ASSETS...................................... | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116
LIABILITIES AND SHAREHOLDERS' EQUITY |  |  |  |  |  |  | LIABILITIES AND SHAREHOLDERS' EQUITY | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
CURRENT LIABILITIES: |  |  |  |  |  |  | CURRENT LIABILITIES:
Short-term debt........................................... |  |  |  |  |  |  | Short-term debt........................................... | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038 | 0.01618726443166038
Current portion of long-term debt......................... |  |  |  |  |  |  | Current portion of long-term debt......................... | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874 | 0.009521920253917874
Trade accounts payable.................................... |  |  |  |  |  |  | Trade accounts payable.................................... | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426 | 0.04211465978972426
Accrued payroll, benefits and bonus....................... |  |  |  |  |  |  | Accrued payroll, benefits and bonus....................... | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498 | 0.02695893671890498
Accrued advertising and merchandising..................... |  |  |  |  |  |  | Accrued advertising and merchandising..................... | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072 | 0.02513390200357072
Income taxes payable...................................... |  |  |  |  |  |  | Income taxes payable...................................... | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309 | 0.003094624082523309
Other accrued liabilities................................. |  |  |  |  |  |  | Other accrued liabilities................................. | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636 | 0.04766911327117636
TOTAL CURRENT LIABILITIES......................... |  |  |  |  |  |  | TOTAL CURRENT LIABILITIES......................... | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779 | 0.1706804205514779
LONG-TERM DEBT.............................................. |  |  |  |  |  |  | LONG-TERM DEBT.............................................. | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263 | 0.1317397341797263
OTHER LIABILITIES........................................... |  |  |  |  |  |  | OTHER LIABILITIES........................................... | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637 | 0.1027573894068637
Deferred Income Taxes |  |  |  |  |  |  | Deferred Income Taxes
PREFERRED STOCK, SERIES B, no par value, authorized |  |  |  |  |  |  | PREFERRED STOCK, SERIES B, no par value, authorized
1,750,000 shares; issued 1,282,051 of 5.46 cumulative |  |  |  |  |  |  | 1,750,000 shares; issued 1,282,051 of 5.46 cumulative
convertible shares (liquidating preference of 78 per share |  |  |  |  |  |  | convertible shares (liquidating preference of 78 per share | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289 | 0.0198373338623289
DEFERRED COMPENSATION....................................... |  |  |  |  |  |  | DEFERRED COMPENSATION....................................... | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461 | -0.005395754810553461
TREASURY PREFERRED STOCK, at cost, 441,469 and 366,069 |  |  |  |  |  |  | TREASURY PREFERRED STOCK, at cost, 441,469 and 366,069
shares, respectively...................................... |  |  |  |  |  |  | shares, respectively...................................... | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124 | -0.0101567149375124
COMMON SHAREHOLDERS' EQUITY: |  |  |  |  |  |  | COMMON SHAREHOLDERS' EQUITY:
Common stock, 5 par value, authorized 400 million |  |  |  |  |  |  | Common stock, 5 par value, authorized 400 million
shares................................................. |  |  |  |  |  |  | shares................................................. | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628 | 0.1666336044435628
Additional paid-in capital................................ |  |  |  |  |  |  | Additional paid-in capital................................ | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663 | 0.02705812338821663
Reinvested earnings....................................... |  |  |  |  |  |  | Reinvested earnings....................................... | 0.210612973616346 | 0.210612973616346 | 0.210612973616346 | 0.210612973616346 | 0.210612973616346 | 0.210612973616346 | 0.210612973616346 | 0.210612973616346 | 0.210612973616346 | 0.210612973616346
Accumulated other comprehensive income (Cumulative translation adjustment) |  |  |  |  |  |  | Accumulated other comprehensive income (Cumulative translation adjustment) | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207 | -0.02207895258877207
Deferred compensation..................................... |  |  |  |  |  |  | Deferred compensation..................................... | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728 | -0.004205514778813728
Treasury common stock, at cost............................ |  |  |  |  |  |  | Treasury common stock, at cost............................ | -0.307657210870859 | -0.307657210870859 | -0.307657210870859 | -0.307657210870859 | -0.307657210870859 | -0.307657210870859 | -0.307657210870859 | -0.307657210870859 | -0.307657210870859 | -0.307657210870859
TOTAL COMMON SHAREHOLDERS' EQUITY.................... |  |  |  |  |  |  | TOTAL COMMON SHAREHOLDERS' EQUITY.................... | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062 | 0.07036302320968062
TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY........ |  |  |  |  |  |  | TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY........ | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116 | 0.4798254314620116