Spreadsheet: jeff_dasovich__14053__quaker financials
Sheet: Financials

Balance Sheet Statement ($ [NAME])
Fiscal Year End | 2000-12-01 00:00:00 | 1999-12-01 00:00:00 | 1998-12-01 00:00:00 | 1997-12-01 00:00:00
Assets
Cash & Equivalent | 174.3 | 282.9 | 326.6 | 84.2
Receivables | 298 | 254.3 | 283.4 | 305.7
Inventories | 287.4 | 266.2 | 261.4 | 256.1
Other Cur Assets | 254 | 193.3 | 243.6 | 487
Total Cur Assets | 1013.7 | 996.7 | 1115 | 1133
Gr Fixed Assets | 1927.6 | 1851.9 | 1818.8 | 1913.1
Accum Depr & Depl | 807.6 | 745.2 | 748.6 | 748.4
Net Fixed Assets | 1120 | 1106.7 | 1070.2 | 1164.7
Intangibles | 229.2 | 236.9 | 245.7 | 350.5
Oth Non-Cur Asset | 55.9 | 55.9 | 79.4 | 48.8
Tot Non-Cur Asset | 1405.1 | 1399.5 | 1395.3 | 1564
Total Assets | 2418.8 | 2396.2 | 2510.3 | 2697
Liabilities
Accounts Payable | 212.3 | 213.6 | 168.4 | 191.3
Short-Term Debt | 129.6 | 154.5 | 136.5 | 169.4
Other Cur Liab | 518.5 | 570.2 | 704.2 | 585
Total [NAME] | 860.4 | 938.3 | 1009.1 | 945.7
Long-Term Debt | 664.1 | 715 | 795.1 | 887.6
Defer Inc Taxes | 0 | 0 | 0 | 36.3
[NAME] | 518 | 523.1 | 533.4 | 521.7
Minority Interest | 0 | 0 | 0 | 0
[NAME] | 1182.1 | 1238.1 | 1328.5 | 1445.6
Total Liabilities | 2042.5 | 2176.4 | 2337.6 | 2391.3
Preferred Equity | 100 | 100 | 21.7 | 77.7
Common Equity | 276.3 | 119.8 | 151 | 228
[NAME] | 1061.7 | 854.6 | 555.8 | 431
Total Equity | 376.3 | 219.8 | 172.7 | 305.7
Tot Liab & Stk Eq | 2418.8 | 2396.2 | 2510.3 | 2697
Cash Flow | 489.4 | 574.4 | 412.5 | -773
Working Capital | 153.3 | 58.4 | 105.9 | 187.3
Free Cash Flo | 83.4 | 252.5 | 149.1 | 114.9
Free Cash Flo P/S | 0 | 0 | 0 | 0
Invested Capital | 1040.4 | 934.8 | 967.8 | 1193.3
Com Shr Out(000) | 131933 | 131936 | 135323 | 138813
[NAME] Out(000) | 1282 | 916 | 979 | 1037
[NAME] Shr(000) | 0 | 0 | 0 | 0
Treasury Shr(000) | 36409 | 36409 | 32656 | 29166
Inventory Method | or More Methods | or More Methods | or More Methods | or More Methods
Income Statement ($ [NAME])
Fiscal Year End | 2000-12-01 00:00:00 | 1999-12-01 00:00:00 | 1998-12-01 00:00:00 | 1997-12-01 00:00:00
Revenues/Sales | 5041 | 4725.2 | 4842.5 | 5015.7
Cost of Sales | 2155.3 | 2013 | 2241.9 | 2403.5
Gr Oper Profit | 2885.7 | 2712.2 | 2600.6 | 2612.2
S, G & A Expenses | 1968.8 | 1904.1 | 1872.5 | 1938.9
Other Taxes | 0 | 0 | 0 | 0
[NAME] bef [NAME] | 916.9 | 808.1 | 728.1 | 673.3
Deprec & Amort | 133 | 123.8 | 132.5 | 161.4
Oper Inc aft Depr | 783.9 | 684.3 | 595.6 | 511.9
Other Income, Net | 3.7 | -6.4 | 0.9 | -1490.4
[NAME] for Int | 605.1 | 680.2 | 466.2 | -978.5
Interest Expense | 54 | 61.9 | 69.6 | 85.8
Minority Interest | 0 | 0 | 0 | 0
Pretax Income | 551.1 | 618.3 | 396.6 | -1064.3
Income Taxes | 190.5 | 163.3 | 112.1 | -133.4
Net Inc Cont Ops | 360.6 | 455 | 284.5 | -930.9
Net Inc Disc Ops | 0 | 0 | 0 | 0
Net Inc Tot Ops | 360.6 | 455 | 284.5 | -930.9
Special Inc/Chrg | -182.5 | 2.3 | -128.5 | 0
Normalized Income | 543.1 | 452.7 | 413 | -930.9
Extra Inc (Loss) | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0
Inc Tax Loss Cfwd | 0 | 0 | 0 | 0
[NAME] (Loss) | 0 | 0 | 0 | 0
Total Net Income | 360.6 | 455 | 284.5 | -930.9
Preferred Div | 4.2 | 4.4 | 4.5 | 3.5
Net Inc Avail Com | 356.4 | 450.6 | 280 | -934.4
Basic EPS Cont Ops | 2.71 | 3.36 | 2.04 | -6.8
Basic [NAME] | 0 | 0 | 0 | 0
Basic EPS Tot Ops | 2.71 | 3.36 | 2.04 | -6.8
Basic EPS Ex Inc | 0 | 0 | 0 | 0
Basic EPS CAE | 0 | 0 | 0 | 0
Basic EPS TLC | 0 | 0 | 0 | 0
Basic EPS Oth Gain | 0 | 0 | 0 | 0
EPS fr Net Income | 2.71 | 3.36 | 2.04 | -6.8
Prim Nor Net Inc | 4.08 | 3.34 | 2.96 | -6.8
Dil EPS Cont Ops | 2.61 | 3.23 | 1.97 | -6.8
Dil [NAME] | 0 | 0 | 0 | 0
Dil EPS Total Ops | 2.61 | 3.23 | 1.97 | -6.8
Dil EPS Extra Inc | 0 | 0 | 0 | 0
Dil EPS CAE | 0 | 0 | 0 | 0
Dil EPS TLC | 0 | 0 | 0 | 0
Dil EPS Oth Gains | 0 | 0 | 0 | 0
Dil EPS Net Inc | 2.61 | 3.23 | 1.97 | -6.8
Dil Normal Inc | 3.93 | 3.21 | 2.86 | -6.8
Domestic Sales | 3871.7 | 3633.9 | 3605.8 | 3756.1
Foreign Sales | 1169.3 | 1091.3 | 1236.7 | 992.3
Statement of Cash Flow ($ [NAME])
Fiscal Year End | 2000-12-01 00:00:00 | 1999-12-01 00:00:00 | 1998-12-01 00:00:00 | 1997-12-01 00:00:00
Net Income | 360.6 | 455 | 284.5 | -930.9
Deprec & Amort | 133 | 123.8 | 132.5 | 161.4
Deferred Inc Tax | 19.8 | 14.2 | -31.1 | -12
Oper Gains (Loss) | 189.2 | 12.3 | 113 | 1298.7
Extra Gain (Loss) | 0 | 0 | 0 | 0
Oth Non-Cash Item | 58.8 | 63.4 | 0 | 43.2
Chg Receivables | -50 | 14.8 | 5.6 | -61
Chg Inventories | -24.8 | -15.3 | -32.8 | -24.5
Chg Oth Cur Asset | -63.2 | 20.3 | -15.1 | -11.6
[NAME] | 2 | 49.7 | -20 | -3.2
Chg Oth Cur Liab | -102.9 | -107.1 | 76.9 | 29.9
Net Cash Cont Ops | 522.5 | 631.1 | 513.5 | 490
Net Cash Disc Ops | 0 | 0 | 0 | 0
Net Cash fr Ops | 522.5 | 631.1 | 513.5 | 490
Sale P,P & Equip | 6.4 | 28.1 | 273.6 | 300
Sale ST Invest | 418.8 | 219 | 143.1 | 0
Purch P,P & Equip | -285.6 | -222.4 | -204.7 | -215.7
Purch ST Invest | -414.1 | -185.1 | -165.5 | 0
Oth Inv Chg, Net | 0 | 0 | 240 | 0
Net Cash fr Inv | -274.5 | -160.4 | 286.5 | 84.3
Issuance of Debt | 11.6 | 35.4 | 1.9 | 8.3
Issuance [NAME] | 131.1 | 82.6 | 112 | 121.2
Repay LT Debt | -86.6 | -95.8 | -125.9 | -507.3
[NAME] | -254.2 | -382.3 | -384.9 | -56.2
Payment Cash Div | -153.5 | -156.2 | -159.7 | -159.4
Oth [NAME], Net | 0 | 0 | 0 | 0
Net Cash fr Fin | -351.6 | -516.3 | -556.6 | -593.4
Eff Exch Rate Chg | -5 | 1.9 | -1 | -7.2
Net Chg Cash & Eq | -108.6 | -43.7 | 242.4 | -26.3
Cash Begin Period | 282.9 | 326.6 | 84.2 | 110.5
Key Financial Ratios
Fiscal Year End | 2000-12-01 00:00:00 | 1999-12-01 00:00:00 | 1998-12-01 00:00:00 | 1997-12-01 00:00:00
Book Value P/S | 2.09 | 0.91 | 1.12 | 1.64
Price/Book Val(%) | 4659 | 7212 | 5313 | 3216
Debt/Equity(%) | 240 | 597 | 527 | 389
LT Debt % Inv [NAME] | 63.8 | 76.5 | 82.2 | 74.4
LT [NAME] | 32.5 | 32.9 | 34 | 37.1
Dbt % Tot Assets | 84.4 | 90.8 | 93.1 | 88.7
[NAME] | 0.5 | 0.6 | 0.6 | 0.4
Current Ratio | 1.2 | 1.1 | 1.1 | 1.2
Revenue/Assets(%) | 210 | 200 | 190 | 190
Price/Revenue(%) | 255 | 183 | 166 | 146
Cash % Revenue | 3.5 | 6 | 6.7 | 1.7
Pre-Tax Mgn(%) | 10.9 | 13.1 | 8.2 | -21.2
Post-Tax Mgn(%) | 7.2 | 9.6 | 5.9 | -18.6
Eff Tax Rate(%) | 34.6 | 26.4 | 28.3 | 12.5
Asset Turnover | 2.1 | 1.9 | 1.9 | 1.4
Receivable Turn | 18.3 | 17.6 | 16.4 | 16.7
[NAME] | 7.8 | 7.6 | 8.7 | 9.1
Ret on Equity(%) | 130.5 | 379.8 | 188.4 | NE
Ret Invest Cap(%) | 34.7 | 48.7 | 29.4 | -78
Ret on Assets(%) | 14.9 | 19 | 11.3 | -34.5